What's new in Virtuoso Open-Source Edition 7.2.0

Feb 13, 2015
  • Virtuoso Engine:
  • Added new threadsafe / reentrant SQL parser
  • Added support for using TLSF library for page-maps
  • Added support for setting SSL Protocols and Ciphers
  • Added support for new Unicode-3 based collations
  • Added support for custom HTTPLogFormat
  • Added support for quality factor in accept headers
  • Added rate limiter for bad connections
  • Added ODBC 3.x alias for current_date, current_time and current_timestamp
  • Improved cost based optimizer
  • Improved LDP support
  • Improved XPER support
  • Improved CSV support
  • Fixed handling of regexp cache size and pcre_match depth limit
  • Fixed handling of multibyte strings
  • Fixed handling of nvarchar data with zeroes in the middle
  • Fixed handling of values in 10 day gap between Julian and Gregorian dates
  • Fixed if expr in rdf o range condition, set super so they get placed once
  • Fixed issue possibly reading freed block
  • Fixed issue with TZ field without separator
  • Fixed issue with duplicate hashes
  • Fixed issue with invariant preds
  • Fixed issue with non chash distinct gby with nulls
  • Fixed issue with user aggregates and chash flush
  • Fixed issues with outer join, order by and group by
  • Fixed sending IRI IDs to remotes when using 'where 0'
  • Fixed use SHA256 as default for certificate signing
  • Fixed memory leaks and memory fragmentation
  • Fixed ssl read/write error condition
  • Fixed windows build
  • GEO functions:
  • Added support for SPARQL INSERT with GEO literals
  • Added support for upcoming proj4 plugin
  • Fixed issue with rdf box with a geometry rdf type and a non geometry content
  • Fixed calculation of serialization lengths for geo boxes
  • Fixed compilation of a query with bif:st_intersects inside service {}
  • Fixed serialization of geo boxes
  • Fixed intersect to working with other geo shapes
  • SPARQL:
  • Added new SPARQL pragma: define sql:comment 0/1
  • Added indicator when max rows is returned on /sparql endpoint
  • Added new role SPARQL_LOAD_SERVICE_DATA
  • Added new client callable graph ins/del/replace functions
  • Added support for __tag of UNAME
  • Added support for multiple sparql update commands
  • Added support for xsd:gYear and the like
  • Added support for CASE x WHEN ... and CASE when in SPARQL
  • Added support for 'HTML with nice turtle' output format
  • Added TransStepMode option to virtuoso.ini
  • Improved handling of floats and doubles in SPARQL compiler
  • Improved Turtle parser
  • Fixed SPARQL DELETE DATA when a complete RDF box w/o RO_ID is passed as obj
  • Fixed URI() is synonym for IRI()
  • Fixed equality of unames and strings, iri strings
  • Fixed issue eliminating empty {} in VALUE join
  • Fixed issue with R2RML
  • Fixed issue with XMLA
  • Fixed issue with base graph when using 'with_delete' in bulkloader
  • Fixed issue with multiple OPTIONAL
  • Fixed issue with sparql ... with delete on certain datatypes
  • Fixed issue with varbinary in rdf views
  • Fixed printing optimized-away data rows of VALUES in sparql_explain() dump
  • Fixed propagation of limits if SPART_VARR_EXTARNAL/GLOBAL variables present
  • Fixed regression for SPARQL 1.1 VALUES bindings
  • Fixed sort accented letters from "ORDER BY" in alphabetical order
  • Fixed startup speed with many graph group members
  • Jena & Sesame:
  • Upgraded to Jena 2.12.0
  • Added support for Bulk Loading
  • Added support for Dataset method using defaultInsertGraph and defaultRemoveGraph
  • Fixed handling of blank nodes
  • Fixed transaction handling
  • Fixed NullPointerException for sparql with OPTIONAL
  • Fixed issue with statement leaks in older Virtuoso JDBC driver
  • Fixed issue with class definitions and classcast exceptions
  • Fixed issue with large datasets like Uniprot
  • JDBC Driver:
  • Enhanced Connection Pool implementation
  • Added support for arrays for RDF Bulk loader
  • Added JDBC4 compliant metadata required by JBOSS
  • Fixed issue with statement leaks
  • Fixed issue with RoundRobin if server out of license
  • Fixed issue with stored procedures returning multiple resultsets
  • Fixed issue with rewind on Virtuoso blob
  • Fixed issue with batch procedure execution
  • Fixed issue with dates
  • Fixed issue with SQL_UTF8_EXECS=1
  • Fixed issue with JDBC testsuite
  • Faceted Browser:
  • Added support for graph selection and persist in fct state
  • Added support for link out icons on certain doc and image links
  • Added new description and sponger options as entity link types
  • Added option for json output to fct service
  • Added group by to speed up distinct
  • Added precompiled queries to speed up usage.vsp
  • Fixed base uri for crawlers
  • Fixed color scheme
  • Fixed graph perm check
  • Fixed handling of foaf:depiction
  • Fixed handling of iframe
  • Fixed issue when lang is missing to fct service
  • Fixed issue with dateTime
  • Fixed issue with double quotes in literals
  • Fixed issue with nodeID
  • Fixed issue with null graphs
  • Fixed labels
  • Fixed links

New in Virtuoso Open-Source Edition 7.0.0 (Aug 7, 2013)

  • Fixed error in make install when virt_html has not been generated Fixed use Dkalloc_nc.c for driver
  • Updated NEWS and ChangeLog
  • Fixed whitespace
  • Rebuild driver
  • Fixed missing initialization
  • Added missing monitor.h to distribution
  • Fixed issue with testsuite on VOS
  • Fixed small issues in tsuite for VOS
  • Updated version of driver to 3.65

New in Virtuoso Open-Source Edition 6.1.6 (Aug 2, 2012)

  • Database engine:
  • Added support for Sparql Service Description
  • Added support for SOUNDEX and DIFFERENCE
  • Added support for FROM SUBQUERY { .. } in quad map
  • Added optimizations to JSON parser
  • Added support for SSL Chain Certificates
  • Added webid protected endpoints template
  • Added error reporting if query compilation fails
  • Added extra checks for db slices
  • Added dsn name to explain output
  • Added support for CORS in web services
  • Added propagation of LIMIT restrictions
  • Added support for protocol switching e.g. using websockets
  • Added generation of url rewrite rules
  • Fixed ETag calculation
  • Fixed bad code for clear graph
  • Fixed buffer overflow when using wide chars
  • Fixed check to prevent out of range seek
  • Fixed clear errors on ODBC connection handle
  • Fixed compiler warnings
  • Fixed datetime conversion
  • Fixed external vars in table subqueries of scalar subqueries
  • Fixed http_ses_arg is supposed to return ws_session
  • Fixed issue with content type if already set by rewrite rule
  • Fixed issue with transitive subqueries
  • Fixed issue with unknown BIF msg in SPARQL compiler error
  • Fixed issue with Bison 2.6 code generation
  • Fixed issue with SERVICE
  • Fixed issue with UNIONs
  • Fixed issue with incomplete rdf box
  • Fixed memory leaks
  • Fixed multi-column transitivity
  • Fixed portability issues on FreeBSD, Solaris and Mac OS X
  • Fixed print of builtin expressions with multipart alias name
  • Fixed use provided password from ODBC connect handle
  • Fixed valgrind warnings
  • Updated documentation
  • SPARQL and RDF:
  • Added RDFa and MTML+Microdata autodetection
  • Added REPORT method
  • Added WebDAV DET folder type
  • Added Wolfram|Alpha cartridge
  • Added debug code for sponger
  • Added di: scheme
  • Added extra debugging code to SPARQL engine
  • Added new mime type application/n-triples
  • Added procedure view for SPARQL BINDINDS
  • Added rdb2rdf VAD
  • Added support for INF, -INF and NaN
  • Added support for SPARQL 1.1 BINDINGS
  • Added support for self-description
  • Added support for slash proxy IRIs
  • Added support for sponging of ftp urls
  • Added support for subqueries inside QUAP MAP { .. } groups
  • Added support for tab-separated-values (TSV) format in sparql
  • Added support for text/turtle
  • Fixed SPARQL LOAD SERVICE DATA
  • Fixed access rights and status for SPARUL_LOAD_SERVICE_DATA
  • Fixed escaping of weird IRIs in RDF/XML output
  • Fixed grants for SPARQL LOAD SERVICE DATA
  • Fixed issue joining two federated queries to the same host
  • Fixed issue with double "AS" for lang in resultset
  • Fixed issue with RDF View, bif:contains and option(?score)
  • Fixed issue with SPARQL-FED code generation
  • Fixed issue with graph level security check in SPARQL-FED subquery
  • Fixed issue with transitive query
  • Fixed issue with xsd:dateTime in SPARQL results
  • Fixed issues loading microdata with namespace decls
  • Fixed negation to use SPARQL 1.1 FILTER NOT EXISTS
  • Fixed possible stack overflow on long UNIONs
  • Fixed resource name encoding problem
  • Fixed service SPARQL codegen with zero retvals
  • Fixed support for SERVICE
  • Improved error diagnostics for ALTER QUAD STORAGE { DROP }
  • Removed test for @rel, @rev or @property from application/xhtml+xml
  • Upgraded sesame driver to use Sesame 2.5.6

New in Virtuoso Open-Source Edition 6.1.4 (Nov 1, 2011)

  • Database engine
  • Added new implementation of search_excerpt that can handle both ANSI/UTF8 and Wide strings
  • Added new setting RdfFreeTextRulesSize
  • Added improved support for inference and RDF views to "non-default" storages
  • Added option to register post-processing callbacks to DESCRIBE
  • Added initial support for PHP 5.3
  • Added aggregate DB.DBA.GROUP_DIGEST which makes it possible to
  • return part of big output of DB.DBA.GROUP_CONCAT without running out of row length limits
  • Added optimised codegen for built-in aggregate functions
  • Added option to enable/disable ?P statistics
  • Added support for HTML+Microformat, Microformat/JSON and JSON-LD output formats
  • Added support for SPARQL 1.1 build-in IF and COALESCE
  • Added support for SPARQL 1.1 Graph Store HTTP Protocol
  • Added support for SPARQL Graph CRUD
  • Added support for SQLQUERY syntax in declaration of RDF views
  • Added support to call XPath/XQuery functions in SPARQL
  • Added option to enable/disable ?P statistics
  • Fixed code generation using gawk 4
  • Fixed code generation for service invocation for case of IN parameter that is not bound in SINV sub-query is neither external/global nor fixed in parent group pattern
  • Fixed col_default to be same dtp as col_dtp to prevent default value misuse
  • Fixed compiler warnings
  • Fixed connection leak in connection pool during long checkpoints
  • Fixed crash running FILTER query containing IN clause with only one item in it
  • Fixed deadlock on attempt of qr_recompile during the run of SPARQL-to_SQL front-end
  • Fixed disable dep cols check
  • Fixed disabled pg_check_map by default to make checkpoint faster
  • Fixed handling of GROUP BY and ORDER BY using expressions
  • Fixed hang or crash after checkpoint is finished
  • Fixed issues with cost based optimizer
  • Fixed issue with multiple transitive subqueries in sql optimizer
  • Fixed issue with ORDER BY expression optimization
  • Fixed JSON output for native parsers
  • Fixed key dep cols check for sample
  • Fixed lock status report
  • Fixed memory leaks
  • Fixed possible mutex deadlock
  • Fixed problems re-creating quad map
  • Fixed rdfview generation
  • Fixed recompile all qr's cached on cli connection when dropping a group or creating new graph group
  • Fixed set sl_owner before cpt_rollback in order to know which thread owns the process, otherwise other threads may wrongly go inside the wait_checkpoint
  • Fixed skip rules which perform http redirect when doing a POST
  • Fixed space calculation when changed records does not fit in available space on page
  • Fixed SPARQL OPTIONAL keyword sometimes causing queries to not return graph matches
  • Fixed SQL codegen bug in SPARQL queries of R2RML rewriter
  • Fixed when iri exceeds 2KB limit and flag is enabled then shorten the iri, instead of rejecting it
  • Rebuild Jena, Sesame2 and JDBC drivers
  • Updated documentation

New in Virtuoso Open-Source Edition 6.1.2 (Jul 10, 2010)

  • Database engine
  • Added FOAF+SSL based authentication for client connection
  • Added support for following http redirects automatically
  • Added extra functions for graph diff, iteration over dictionary
  • and obtaining biggest possible iri_id on given 32/64bit platform
  • Added initial support for bif_python_exec
  • Added semantic pingback client/server
  • 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 when using QtSql layer
  • Fixed handling http, soap, xml-rpc using proxies and reverse-proxies
  • Fixed when importing keys, let user decide which on to use as his
  • WebID for odbc/sql login
  • Fixed handling of column default value of 0
  • Fixed handling multiple certs
  • 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 cartridges for CSV, Etsy, FaceBook OpenGraph, Html5, Idiomag,
  • Tumblr, Vimeo, Wine and YouTube
  • Added more assertions to facets ontology
  • Added label as ipf
  • Added more properties for inferencing
  • Added support for extra encodings
  • Added initial support for ODATA atom serialization
  • Added EAV and SPO labeling modes
  • Added support for gz and zip compressed CSV
  • Added CSV parser mode option
  • Added CSV parser lax mode
  • Added optimization for large descriptions on about page
  • Fixed add escape to CR/LF in JSON format
  • Fixed Odata, Tesco, html2 cartridges
  • Fixed create list of unique graphs
  • Fixed use label ontology to extract 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 failing to parse both rel/rev
  • Fixed abnormal long RDFa parsing of document with i18n uris
  • Fixed issue with ?? with sparql compiler inside sql query
  • Fixed support for subproperties of inverse functional properties
  • Fixed support for loading aaa ruleset from multiple contology 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
  • 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 queryengine interface, so now Jena provider support
  • next query execution mode:
  • a) parse and execute query via ARQ
  • b) parse query via ARQ and execute query directly via Virtuoso
  • (new mode)
  • c) 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 performance loading lang/type cache on empty db
  • Fixed small bugs
  • ODS Applications
  • Added OpenID 2.0 login and registration
  • Added FOAF+SSL registration for users pages (jsp, php, vsp etc)
  • Added FOAF+SSL based authentication using acl
  • Added shared files using FOAF+SSL
  • Added description for property value in offers
  • Added support for multiple certificates in user profile
  • Added photo and audio upload for jtml, vsp, php and jsp pages
  • Added relation ontology
  • Added support for PubSubHub
  • Fixed OpenID to work with personal iri
  • Fixed can have many certs in foaf
  • Fixed handing of multiple items in alt name
  • Fixed goodsrelation sioc data
  • Fixed VTIMEZONE component in Calendar export
  • Fixed offers, favorites

New in Virtuoso Open-Source Edition 6.1.1 (Mar 31, 2010)

  • Database engine
  • Added support for CSV import
  • Added FOAF+SSL 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 support for oData
  • Added uStream cartridge
  • Added slidesix cartridge
  • Added support for Sesame 2 HTTP repository
  • 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
  • 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 to Jena 2.6.2
  • Upgraded to Sesame 2.3.1
  • ODS Applications
  • Added user's ontologies in favorites
  • Added a++ otion 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

New in Virtuoso Open-Source Edition 6.1.0 (Feb 13, 2010)

  • * 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 support for Google Base, ithalia, revyu
  • Added built-in predicate IsRef()
  • Added new error reporting for unsupported syntax
  • Added rdf box id only serialization; stays compatible with 5/6
  • Added Yelp categories
  • Added support for SPARQL INSERT DATA / DELETE DATA
  • Added support for HAVING in sparql
  • Added special codegen for sparql select distinct ?g where { graph ?g { ?s ?p ?o }}
  • Added support for RDFa export
  • 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 use of external 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, must 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
  • 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 FOAF+SSL 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

New in Virtuoso Open-Source Edition 5.0.8 (Aug 29, 2008)

  • SQL compiler is now re-entrant
  • Self-Join optimizations exposed at JDBC Driver level (as was already the case with ODBC)
  • SPARQL engine and SPARQL-BI extension optimizations have been merged
  • TriG? serialization format for RDF is now supported alongside RDFa, N3, Turtle, and RDF/XML
  • Additional Sponger Cartridges for Digg, FriendFeed?, and CrunchBase?
  • Improved graph quality and fidelity from existing Cartridges (especially Freebase, eBay, Amazon, Google, Yahoo, and many others)
  • Improved handling of and bug fixes relating to the `OPTIONAL' SPARQL keyword
  • Self-Dereferencing fixes (e.g., Sponger was not properly de-referencing its own Proxy URIs)
  • More flexible Mapping service model based on new OAT-based Mapping Control (which also includes a "province" locator)
  • Improved SyncML integration with Briefcase folders
  • Gem URL fixes for Atom, RSS, and RDF feeds