Virtuoso Open Source Edition News (2010)

Later Years

2010

2010-07-09: Announcing Virtuoso Open-Source Edition v6.1.2

New product features as of July 09, 2010, V6.1.2, include:

Database engine

Added WebID? Protocol based authentication for ODBC, JDBC, OLEDB, and ADO.NET client connections
Added support for following http redirects automatically
Added extra graph delta-engine functions with regards to diff, iteration over dictionary, and obtaining the biggest possible iri_id on given 32-/64-bit platform
Added initial support for Python Runtime hosting via bif_python_exec
Added client- and server-side Semantic Pingback APIs
Added ODBC setting WideasUTF16 to return UTF-16LE for SQLWCHAR
Fixed ODBC setting for UTF-8 when DB keeps UTF-8 in VARCHARs
Fixed ODBC SQLAllocStmt issues exposed when using QtSQL's ODBC layer
Fixed HTTP, SOAP, XML-RPC when used with proxies and reverse-proxies
Fixed Conductor UI for handling WebID? Protocol WebIDs? for ODBC/SQL session logins
Fixed handling of column default value of 0
Fixed support for BIGINT in parameter marshalling
Fixed issue with default maxmempoolsize
Fixed issue with extent map and free pages map
Fixed memory leaks
Fixed issue with freelist chain
Fixed issue with partitioned TOP ORDER BY
Updated documentation

SPARQL and RDF

Added Sponger cartridges for CSV, Etsy.com, FaceBook?, OpenGraph?, Idiomag, Tumbler, Vimeo, Wine.com, Upstream.tv, and others
Added more assertions to facets ontology
Added rdfs:label to default IFP based inference Rule
Added support for extra encodings
Added initial support for OData's Atom and JSON feed formats with regards to Linked Data Graph Serialization
Added support for gz and zip compressed CSV
Added CSV parser strict mode option
Added CSV parser lax mode
Added optimization for large descriptions on about page
Fixed EAV and SPO labeling modes consistency
Fixed add escape to CR/LF in JSON format
Fixed OData, Tesco.com, and HTML5 MicroData? cartridges
Fixed generation of unique graphs lists
Fixed use label ontology inference rules for automating extraction of geo coordinates
Fixed SPARQL handling of DISTINCT
Fixed SPARQL UNION selections
Fixed SPARQL statement with implicit GROUP BY; do not remove ORDER BY
Fixed RDFa parsing of @rel and @rev
Fixed abnormally long RDFa parsing of document with i18n URIs
Fixed support for subproperties of Inverse Functional Properties (owl:inverseFunctionalProperty)
Fixed support for loading inference rules from multiple ontology graphs
Fixed GPF in SPARUL INSERT optimization
Fixed issue with extra NULLs in HASH JOIN or GROUP BY
Enhanced iSPARQL using new internal RDF store for speed, browser fixes, and cosmetic changes

Native Providers for Jena, Sesame 2, and Sesame 3

Added support for creating ruleset
Added support for inference graph
Added support for inference and query execution
Added support for query engine interface, so Jena provider now supports the following query execution modes:
- parse and execute query via ARQ
- parse query via ARQ and execute query directly via Virtuoso (new mode)
- parse and execute query directly via Virtuoso
Added support for using Virtuosodatasource
Fixed issue with batch commit
Fixed Jena's lazy initialization when graph is created
Fixed handling of quote chars in literals
Fixed issues with variable binding
Fixed small bugs

ODS Applications

Added OpenID 2.0 login and registration
Added WebID? Protocol registration for users pages (JSP, PHP, VSP, etc.)
Added WebID? Protocol based ACLs for shared resources
Added GoodRelations? based Offers as part of Profile Manager
Added support for associating multiple X.509 certificates with a single WebID?
Added photo and audio upload for JavaScript?, VSP, PHP, and JSP pages
Added Relationship Ontology enhancements to Profile Manager
Added Client and Server support for PubSubHubbub protocol
Fixed OpenID + WebID? hybrid protocol handling; reverts back to using the same URL for both OpenID- and FOAF-based Profile Page
Fixed handing of multiple items in Alternate Subject Name slot of X.509 certificate for WebID? Protocol
Fixed GoodsRelations? integration with SIOC-based Data Spaces as part of richer Profile Data construction
Fixed VTIMEZONE component in iCalendar data representation
Fixed Profile Manager UI associated with GoodRelations? Offers
Fixed Profile Manager UI associated with identification of FavoriteThings?

2010-03-31: Announcing Virtuoso Open-Source Edition v6.1.1

New product features as of March 30, 2010, V6.1.1, include:

Database engine

Added wizard-based generation of SQL Tables from CSV imports
Added wizard-based publishing of RDF based Linked Data from CSV files
Added WebID? Protocol login for SQL clients
Added OPTIONS for HTTP server
Added support for setMaxRows in JDBC driver
Added support for JDBC Hibernate
Added support for unzip_file()
Added swap guard option
Fixed deadlock retry
Fixed memory leaks
Fixed mtx checks for checkpoint and log write
Fixed X509ClientVerify flag of 0/1/2/3 to accept self-signed or optional certificates
Fixed several issues with JDBC XA support
Fixed use sk_X509_ALGOR_* macros to support OpenSSL 1.0.0
Fixed wide character when getting procedure columns information.
Fixed remove id from hash before free structure
Fixed IN pred as iterator before index path
Fixed missing initialization in calculation of cost and cardinality
Fixed SQL codegen for NOT() retval expression
Updated documentation

SPARQL and RDF

Added OData cartridge for producing RDF-based Linked Data from OData resource collections
Added CSV cartridge for producing and deploying RDF-based Linked Data from CSV resource types
Added uStream cartridge
Added slidesix cartridge
Added optimization of sprintf_inverse(const)
Added improved version of xsl:for-each-row for both SPARQL and SQL
Added DefaultServiceMap and DefaultServiceStorage
Added immortal IRI for uname_virtrdf_ns_uri_DefaultServiceStorage
Added proper ASK support in web service endpoint
Fixed SPARQL 1.1 compatibility in result set syntax
Fixed incorrect codegen of formatter in ssg_select_known_graphs_codegen
Fixed do not encode default graph
Fixed check if datadump is gz
Fixed detection of n3 and nt formats
Fixed regex to remove default ns from XML
Fixed run microformats independent of RDFa
Fixed bug with UTF-8 encoded strings in box
Fixed allow chunked content to be read as strses
Fixed SERVICE parameter passing for basic Federated SPARQL (SPARQL-FED)
Fixed (!ask(...)) in filters
Fixed codegen for FILTER (?local = IRI(?:global)) .
Fixed codegen in LIMIT ?:global-variable and OFFSET ?:global-variable
Fixed support for positional and named parameters from exec() or similar in SPARQL, as if they where global variables of other sorts
Fixed rewriting of group patterns with filters replaced with restrictions on equivs
Fixed faster loading of inference sets from single and graph groups
Upgraded native data providers for Jena to version 2.6.2
Upgraded native data providers for Sesame to version 2.3.1
Added support for Sesame 2 HTTP repository interface
Added implemented Sesame's Inference Context interfaces (for backward chained reasoning).

ODS Applications

Added profile page improvements covering Favorite Things, GoodRelations-based Offerings (via "Seeks" and "Offers" UIs)
Added alternative registration and profile management pages (VSP, PHP, and Javascript variants) that work REST-fully with ODS engine
Added X.509 create certificate generation and export to alternative ODS profile management pages (VSP, PHP, and Javascript)
Added a++ option in user's pages
Added updates to Certificate Ontology used by WebID? Protocol
Added support for Google map v3
Added 'Import' to user pages (VSP, PHP, etc.)
Fixed Profile Management UI quirks
Fixed SIOC subscriptions
Fixed object properties in favorites
Fixed ontology APIs
Fixed use newer OAT functions
Fixed invitation problem with multiple users
Fixed typo in scovo:dimension
Fixed image preview

2010-07-09: Announcing Virtuoso Open-Source Edition v5.0.14

OpenLink Software is pleased to announce a new release of Virtuoso, Open-Source Edition, version 5.0.14.

This version includes:

Database engine

Added support for CSV import
Added WebID? Protocol login for SQL clients
Added OPTIONS for http server
Added support for setMaxRows in JDBC driver
Added support for JDBC hibernate
Added support for unzip_file ()
Added swap guard option
Fixed deadlock retry
Fixed memory leaks
Fixed mtx checks for checkpoint and log write
Fixed X509ClientVerify flag of 0/1/2/3 to accept self signed or optional certificates
Fixed several issues with JDBC XA support
Fixed use sk_X509_ALGOR_* macros to support OpenSSL 1.0.0
Fixed wide character when getting procedure columns information.
Fixed remove id from hash before free structure

SPARQL and RDF

Added support for oData
Added uStream cartridge
Added slidesix cartridge
Added support for Sesame 2 HTTP repository
Fixed incorrect codegen of formatter in ssg_select_known_graphs_codegen
Fixed do not encode default graph
Fixed check if datadump is gz
Fixed detection of n3 and nt formats
Fixed regex to remove default ns from XML
Fixed run microformats independent of rdfa
Fixed bug with UTF-8 encoded strings in box
Upgraded to Jena 2.6.2
Upgraded to Sesame 2.3.1

ODS Applications

Added user's ontologies in favorites
Added a++ option in user's pages
Added support for WebID?
Added support for Google map v3
Added Register to vsp, php etc users pages
Added X.509 create certificate to users pages
Added 'Offers', 'Seeks' etc to user pages
Added 'Import' to user pages (vsp, php etc)
Fixed UI profile
Fixed SIOC subscriptions
Fixed object properties in favorites
Fixed ontology APIs
Fixed use newer OAT functions
Fixed invitation problem with multiple users
Fixed typo in scovo:dimension
Fixed image preview

2010-02-03: Announcing Virtuoso Open-Source Edition v6.1.0

OpenLink Software is pleased to announce the official release of Virtuoso Open-Source Edition, Version 6.1.0:

***IMPORTANT NOTE*** for upgraders from pre-6.x versions: The database file format has substantially changed between VOS 5.x and VOS 6.x. To upgrade your database, you must dump all data from the VOS 5.x database and re-load it into VOS 6.x. Complete instructions may be found here.

***IMPORTANT NOTE*** for upgraders from earlier 6.x versions: The database file format has not changed, but the introduction of a newer RDF index requires you run a script to upgrade the RDF_QUAD table. Since this can be a lengthy task and take extra disk space (up to twice the space used by the original RDF_QUAD table may be required during conversion) this is not done automatically on startup. Complete instructions may be found here.

New and updated product features include:

Database engine

Added new 2+3 index scheme for RDF_QUAD table
Added new inlined string table for RDF_QUAD
Added optimizations to cost based optimizer
Added RoundRobin connection support
Removed deprecated samples/demos
Fixed align buffer to sizeof pointer to avoid crash on strict checking platforms like sparc
Fixed text of version mismatch messages
Fixed issue with XA exception, double rollback, transact timeout
Merged enhancements and fixes from V5 branch

SPARQL and RDF

Added support for owl:inverseOf, owl:SymmetricProperty, and owl:TransitiveProperty.
Added DB.DBA.BEST_LANGMATCH() and bif_langmatches_pct_http()
Added initial support for SPARQL-FED
Added initial support for SERVICE { ... };
Added support for expressions in LIMIT and OFFSET clauses
Added built-in predicate IsRef()
Added new error reporting for unsupported syntax
Added rdf box id only serialization; stays compatible with 5/6
Added support for SPARQL INSERT DATA / DELETE DATA
Added SPARQL 1.1 syntax sugar re. HAVING clause for filtering on GROUP BY

Added special code generator for optimized handling of:


SPARQL SELECT DISTINCT ?g WHERE { GRAPH ?g { ?s ?p ?o } }

Added support for HTML+RDFa representation re. output from SPARQL CONSTRUCT and DESCRIBE queries
Added support for output:maxrows
Improved SPARQL parsing and SQL codegen for negative numbers
Improved recovery of lists in DB.DBA.RDF_AUDIT_METADATA()
Fixed iSPARQL compatibility with 3rd party SPARQL endpoints
Fixed bad init in trans node if multiple inputs or step output values
Fixed redundant trailing '>' in results of TTL load when IRIs contain special chars
Fixed problem with rfc1808_expand_uri not using proper macros and allocate byte extra for strings
Fixed when different TZ is used, find offset and transform via GMT
Fixed graph-level security in cluster
Fixed redundant equalities in case of multiple OPTIONALs with same variable
Fixed BOOLEAN_OF_OBJ in case of incomplete boxes
Fixed NTRIPLES serialization of triples
Merged enhancements and fixes from V5 branch

Sponger Middleware

Added Extractor Cartridges mapping Zillow, O'Reilly, Amazon, Googlebase, BestBuy, CNET, and Crunchbase content to the GoodRelations Ontology.
Added Extractor Cartridges for Google Spreadsheet, Google Documents, Microsoft Office Docs (Excel, PowerPoint etc), OpenOffice, CSV, Text files, Disqus, Twitter, and Discogs.

ODS Applications

Added support for ckeditor
Added new popup calendar based on OAT
Added REST and Virtuoso PL based Controllers for user API
Added new API functions
Added WebID? Protocol groups
Added feed admin rights
Added Facebook registration and login
Removed deprecated rte and kupu editors
Removed support for IE 5 and 6 compatibility
Merged enhancements and fixes from V5 branch

2010-02-03: Announcing Virtuoso Open-Source Edition v5.0.13

OpenLink Software is pleased to announce a new release of Virtuoso, Open-Source Edition, version 5.0.13.

This version includes:

Database engine

Added configuration option BuffersAllocation
Added configuration option AsyncQueueMaxThreads
Added docbook-xsl-1.75.2
Added RoundRobin connection support
Removed deprecated samples/demos
Fixed copyright and license clarification
Fixed use MD5 from OpenSSL when possible
Fixed issue with XA exception, double rollback, transact timeout
Fixed issue reading last chunk in http session
Fixed use pipeline client in crawler
Fixed accept different headers in pipeline request
Fixed do not post when no post parameters
Fixed checkpoint messages in log
Fixed read after allocated memory
Fixed shortened long URLs in the crawlers view to avoid UI breakage
Fixed building with external zlib
Removed support for deprecated JDK 1.0, 1.1 and 1.2
Rebuilt JDBC drivers

SPARQL and RDF

Added initial support for SPARQL-FED
Added initial support for SERVICE { ... };
Added support for expressions in LIMIT and OFFSET clauses
Added built-in predicate IsRef()
Added new error reporting for unsupported syntax
Added rdf box id only serialization; stays compatible with 5/6
Added support for SPARQL INSERT DATA / DELETE DATA
Added support for HAVING in sparql

Added special optimizations for handling:


SPARQL SELECT DISTINCT ?g WHERE { GRAPH ?g { ?s ?p ?o } }

Added support for HTML+RDFa representation re. SPARQL CONSTRUCT and DESCRIBE query results
Added support for output:maxrows
Updated ontologies API
Updated iSPARQL application
Fixed IRI parts syntax to match SPARQL 1.0 W3C recommendation
Fixed support for XMLLiteral
Fixed bad box flags for strings for bnodes and types
Fixed replace lost filters with equivs that have no spog vars and no "good" subequivs.
Fixed cnet doublt awol:content
Fixed Googlebase query results with multiple entries
Fixed Googlebase location info
Fixed default sitemap crawling functions/pages
Fixed use SPARUL LOAD instead of SOFT
Fixed make sure version is intact as changes to .ttl file must reflect in sparql.sql
Fixed missing qualification of aggregate
Fixed compilation of ORDER BY column_idz clause in iterator of fetching Network Resource with loop
Fixed UNION of SELECTs and for multiple OPTIONALs at one level with "good" and "bad" equalities
Fixed support for define output:format "JSON"
Fixed crash of rfc1808_expand_uri on base without schema
Fixed redundant trailing '>' in results of TTL load when IRIs contain special chars
Fixed "option (score ...)" in a gp with multiple OPTIONAL {...}
Fixed when different TZ is used, must find offset and transform via GMT
Fixed SPARQL parsing and SQL codegen for negative numbers
Fixed some 'exotic' cases of NT outputs

ODS Applications

Added support for ckeditor
Added new popup calendar based on OAT
Added VSP and REST implementation for user API
Added new API functions
Added WebID? Protocol groups
Added feed admin rights
Added Facebook registration and login
Removed support for Kupu editor
Removed support for rte editor
Removed support for IE 5 and 6 compatibility
Fixed users paths to physical location
Fixed problem with activity pages

Previous Years

CategoryVirtuoso CategoryOpenSource CategoryWebSite