[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: Indexing solution for native XML database
On 11/30/05, Michael Kay <mike@s...> wrote: > > 2) there's often a need to mix tree models with standard relational > > data. In our case 90% of the data fits a relational model very well. > > The 10% that doesn't is critical and it can't easily be separated out > > into something else. > > > > For the latter case, what kind of approach do you recommend? > > Sure, you often have to make compromises, using the optimal technology for > each part of a problem is probably not optimal overall. > > I started out by saying that if I was building an XML database then I > wouldn't by choice build it on top of a SQL database, and I stick with that. I've always agreed that if you've got to set out to design a database to store any random piece of XML that comes along you wouldn't likely want to start to with an RDB. What I didn't understand was your object to Celko's adjacency list approach. Reading between the lines, it seems that you feel That Celko's writings encourage a belief that it is good enough approach that nothing else is needed? In a way, for people doing data (as opposed to (cough) document (cough)) storage I feel it is sufficient. The restriction being that you're working in a single application domain, and not, for example, trying to store random SOAP transactions or such. In such cases the bulk of the data is repetitious and the hierarchies are small. Even with things like parts inventories where the hierarchies may not be fixed they are usually not updated on a regular basis: you build the part description once and you can then retrieve it with a single flat query. I don't know where the inflection point is that causes one to start to look at alternative models. Certainly even medium requirements for update can make such models fall apart. However, for the real world I suspect that they are actually very useful. What would make them even more attractive is a couple of standardized schema's and prebuilt data management engines that embodied best practices as nicely as Saxon does for the XML/XSLT world... ;-) -- Peter Hunsberger
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|