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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 03:30:38 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.