W3C home > Mailing lists > Public > www-ql@w3.org > April to June 2002

RE: recently a newbie

From: Andrew Hill <ahill@openlinksw.com>
Date: Wed, 19 Jun 2002 09:54:06 -0400
To: "'Peter Foley'" <peter.foley@abs.gov.au>, <www-ql@w3.org>
Message-ID: <011d01c21798$d0c20800$eb0ba8c0@usnet.private>

Hi Peter,

Let me answer your questions in terms of Virtuoso:
http://www.openlinksw.com/virtuoso/whatis.htm

a) Yes, the data is in local Virtuoso tables or any back end RDBMS.  We
"target" any databases with ODBC or JDBC support, so Oracle is not a
problem - simply link the tables into Virtuoso and treat them as part of
the local schema.

b) XPath or XQuery may be used, or SQL statements returning specific
results presented as an XML document.  The syntax of the document may be
generated by Virtuoso or specifically controlled by your definition, and
further transformed via XSLT.

Hope this helps.

Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software  http://www.openlinksw.com
Universal Data Access & Virtuoso Universal Server

-----Original Message-----
From: www-ql-request@w3.org [mailto:www-ql-request@w3.org] On Behalf Of
Peter Foley
Sent: Tuesday, June 18, 2002 11:35 PM
To: www-ql@w3.org
Subject: RE: recently a newbie




Two questions:

(a) Does the data already reside in SQL tables and you are building an
    XML *view* on top of it? What RDBMS's are you targetting?

The data lives in Oracle tables and we are trying to build an XML view.

(b) Do you want your programmers to use standard Xquery or can you live
    with any XML oriented query language?
We prefer standards but are open to suggestions.

Our Current system

Table Metadata
TableName   ColumnName      Name
Cars2001  Model           Cars
Age1995   Description     Age

Table Cars2001
Model
Ford
Holden
...

Table Age1995
Description
0-5
6-10
...

To get all Models of Cars

Select * from Metadata where name="Cars"
Select model from Cars2001

Problem: programmers need to know internal details of metadata model and
implementation

Proposed system

Programmer generates queries that looks like

Get all Cars/Model

Get all Age

Get Cars/Model='Ford'

etc




-----------------------------------------------
ABS Web Site:  www.abs.gov.au
Received on Wednesday, 19 June 2002 09:54:50 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Saturday, 22 July 2006 00:10:18 GMT