[XMLSCHEMA-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Designing XML Schemas for use in Oracle 10 - flatter is better or nested is better?

From: Costello, Roger L. <costello@mitre.org>
Date: Tue, 16 May 2006 15:23:08 -0400
Message-ID: <B8415163A689094689542C617ECA0366B87421@IMCSRV5.MITRE.ORG>
To: <xmlschema-dev@w3.org>, "Costello, Roger L." <costello@mitre.org>
oracle 10 xml
Hi Folks,

 

Suppose that you are designing an XML Schema for use in an Oracle 10
database.  

 

Does the fact that the Schema is being used in Oracle 10 influence how
you design the Schema?  

 

A colleague told me that, in Oracle 10, queries on data that is
structured in a flat fashion are faster than queries on data that is
structured in a nested (hierarchical) fashion.  "Therefore, we must
design our XML Schemas to structure the data in a flat fashion."  

 

Is my colleague correct - in Oracle 10 queries are faster on flat data
than nested data?

 

I hate to be forced into making Schema design decisions based on the
limitations of the tool being used.  However, we are using Oracle 10,
and if performance is poor on data that is hierarchical then I must be
practical and structure the data in a flat fashion. 

 

Does anyone have experience with designing XML Schemas for use in
Oracle 10?  What's your recommendation - flat or nested?   /Roger

 
Received on Tuesday, 16 May 2006 19:23:17 GMT

Subscribe to the Stylus Scoop newsletter for helpful XML tips and tutorials.
Email
First Name
Last Name
Company

Download Stylus Studio 6 XML Enterprise Edition

Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2007 All Rights Reserved.