Re: Database choices
Re: Database choices
- Subject: Re: Database choices
- From: Ted Thibodeau Jr <email@hidden>
- Date: Tue, 30 Oct 2007 15:41:34 -0400
* Chuck Hill [2007/10/29 01:31 PM -0700] wrote:
> It is easy to install and administer and has pretty tools. But it is
> not free, not SQL92 standard, and doesn't have (last time I used it)
> multiple column indexes.
One choice that hasn't been mentioned, and is perhaps worth exploring
given the features raised as important here (clustering, replication,
SQL-9x/200x, optimization engine, EXPLAIN, multi-column indexes, etc.).
OpenLink Virtuoso Universal Server
http://virtuoso.openlinksw.com/wiki/main/Main/
http://sf.net/projects/virtuoso
The Open Source Edition is linked above. The Commercial version also
includes Virtual DBMS features -- so you can keep your existing Oracle,
MySQL, PostgreSQL, Progress, Informix, etc. repositories, and just make
use of them through Virtuoso's feature set, which includes --
* Object-Relational Database for SQL, XML, RDF, and Free Text
that includes Java and .NET runtime hosting
* RDF store and SPARQL
* WebDAV and Web Application Server
* Web Services Platform for SOA
* Data Access Interfaces for ODBC, JDBC, ADO.net and OLE/DB clients
* Web-based administration interface and interactive developer tutorials
The "what's new" blurbs for the latest two dot-releases --
> 2007-09-27: Release v5.0.2
>
> This release includes 64-bit Integer support, RDF Sink Folders for
> WebDAV (enabling RDF Quad Store population simply by dropping RDF
> files into WebDAV), SPARUL optimizations, enhanced typed literal
> support in SPARQL, automatic metadata extraction from audio binary
> files, support for PHP 5.2 runtime hosting, an enhanced UI for RDF
> Linked-Data deployment using URL-rewrite rules, sew Sponger
> cartridges for Facebook, Freebase, Wikipedia, GRDDL, RDFa, eRDF
> and more. The Demonstration Database includes RDF Views & SQL Table
> samples for the THALIA data integration benchmark and testsuite and
> the Tutorial application includes Linked Data-style RDF Views for
> the Northwind SQL DBMS schema (the standard Virtuoso demo database
> schema). There is a new Amazon EC2 Image variation of Virtuoso with
> a fully configured instance comprising the Virtuoso core, OpenLink
> Data Spaces application suite and the OpenLink Ajax Toolkit.
>
>
> 2007-05-31: Release v5.0.1
>
> This release includes an enhanced cost-based optimizer; fixed-cost
> calculation for RDF inf nodes; improved SPARQL performance and
> support for BREAKUP optimization for triple-construction from SQL
> data and support for the LIMIT and OFFSET clauses to CONSTRUCT and
> DESCRIBE; documentation updates; significant updates to all ODS
> applications: compliance with the latest SIOC vocabulary, calendar,
> OpenID login and registration. There are also small bug-fixes.
(Yes, I work for OpenLink. No, I get no benefit if you grab the Open
Source Edition, nor directly if you buy a license for the Commercial
Edition or any services associated with either. I would like to hear
from you about both positive and negative experiences with either.)
Be seeing you,
Ted
--
--
A: Yes. http://www.guckes.net/faq/attribution.html
| Q: Are you sure?
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?
Ted Thibodeau, Jr. // voice +1-781-273-0900 x32
Evangelism & Support // mailto:email@hidden
OpenLink Software, Inc. // http://www.openlinksw.com/
http://www.openlinksw.com/weblogs/uda/
OpenLink Blogs http://www.openlinksw.com/weblogs/virtuoso/
http://www.openlinksw.com/blog/~kidehen/
Universal Data Access and Virtual Database Technology Providers
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden