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

RE: are native XML databases needed?

  • To: "Bullard, Claude L (Len)" <len.bullard@i...>,"Ken North" <kennorth@s...>, <xml-dev@l...>
  • Subject: RE: are native XML databases needed?
  • From: "Hunsberger, Peter" <Peter.Hunsberger@S...>
  • Date: Thu, 26 Aug 2004 09:09:17 -0500
  • Thread-index: AcSK9ESvZmN0VGXUQ6qbQFUSXqYznAAfJR6Q
  • Thread-topic: are native XML databases needed?

inverted star schema
Bullard, Claude L (Len) <len.bullard@i...> asks:

> Off topic, but since data warehousing comes up from 
> time to time:  what is the advantage of using 
> an OLAP design vs a relational design?  Is this 
> advantage better or worse than a triple design?

Now you've done it, you've gone and imported a perm thread from the
database world into xml-dev...

With the exception of the specialized spatial, null compressed, database
designs, for the most part, OLAP designs are relational designs just
highly denormalized. I can't really see a significant relationship to
triple stores.  Your prototypical warehouse "star" schema puts a single
large table at the center of a bunch of smaller tables (snowflake
schemas normalize a bit).  Most of the many to many relationships are
denormalized. Relationships are hard coded in the center tables and your
standard relationship traversal goes away (that's the whole point, avoid
join processing costs at the cost of higher storage utilization).  

Now you could just plop an entire triple store into a single table but I
can't see how that approach would work at all, all relationships would
be via procedural value look up and comparison.  To put it another way,
triples are all about relationship management as opposed to value
management which is what a data warehouse schema is for.

Having said that I'll note that if you go to 5th normal form you end up
with a sort of inverted star; tiny little tables connected to a bunch of
larger tables.  This is because you've used a single table (with
possibly a single column) to normalize out a bunch of relationships.
This pattern does have something to do with triple stores (since that's
what we're using it for). Given my statements above I'd guess it has
something to do with ending up with a single key for relationship
traversal across multiple dimensions/perspectives and thus being able to
annotate the relationships. I'd postulate that there are some formal
properties shared between graphs and 5th normal form databases.


Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
First Name
Last Name
Subscribe in XML format
RSS 2.0
Atom 0.3

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.

Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

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-2013 All Rights Reserved.