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

RE: recently a newbie

From: Peter Foley <peter.foley@abs.gov.au>
Date: Wed, 19 Jun 2002 14:35:02 +1000
To: www-ql@w3.org
Message-ID: <CA256BDD.00191FE3.00@ABSInternet02.abs.gov.au>



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 GMT

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