- From: Peter Foley <peter.foley@abs.gov.au>
- Date: Wed, 19 Jun 2002 14:35:02 +1000
- To: www-ql@w3.org
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 00:35:49 UTC