Home » Developer & Programmer » JDeveloper, Java & XML » Relational frontend on XML DB
Relational frontend on XML DB [message #91911] Tue, 05 August 2003 02:10
Flemming
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?

Thanks

Flemming
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