Home » Developer & Programmer » JDeveloper, Java & XML » Relational frontend on XML DB
Relational frontend on XML DB [message #91911] Tue, 05 August 2003 02:10
Messages: 1
Registered: August 2003
Junior Member
We would like to create a relational frontend on out XML DB (Oracle 9.2) to make it possible to use Discoverer to query the database. Could we use materialized views e.g.:

"create materialized view User_view as select
extractValue(value(x),'/User/Uid') Uid_,
extractValue(value(x),'/User/RevisionNo') RevisionNo_,
extractValue(value(x),'/User/UserId') UserId_,
.... etc.

and then create the nescessary index on the views?


Previous Topic: Scheduling Jobs with Java
Next Topic: XSQL and Chinese XML tag
Goto Forum:

Current Time: Mon Jul 26 17:08:30 CDT 2021