Maybe Jonathan is trying to learn XML using a simple example. Avoiding the normal XML to RDBMS design and translation might be reason enough if there is there are large amounts of data.
-----Original Message----- From: sedna-discussion-requ...@lists.sourceforge.net [mailto:sedna-discussion-requ...@lists.sourceforge.net] Sent: Saturday, March 09, 2013 10:39 AM To: sedna-discussion@lists.sourceforge.net Subject: Sedna-discussion Digest, Vol 79, Issue 3 Send Sedna-discussion mailing list submissions to sedna-discussion@lists.sourceforge.net To subscribe or unsubscribe via the World Wide Web, visit https://lists.sourceforge.net/lists/listinfo/sedna-discussion or, via email, send a message with subject or body 'help' to sedna-discussion-requ...@lists.sourceforge.net You can reach the person managing the list at sedna-discussion-ow...@lists.sourceforge.net When replying, please edit your Subject line so it is more specific than "Re: Contents of Sedna-discussion digest..." Today's Topics: 1. Which database is best [for me] (Silver, Jonathan) 2. Re: Which database is best [for me] (A. P. Garcia) 3. The transaction is a victim of deadlock resolution procedure. (Jocelyn Raymond) ---------------------------------------------------------------------- Message: 2 Date: Fri, 8 Mar 2013 18:40:18 -0600 From: "A. P. Garcia" <a.phillip.gar...@gmail.com> Subject: Re: [Sedna-discussion] Which database is best [for me] To: "Silver, Jonathan" <jonathan.sil...@siemens-enterprise.com> Cc: "sedna-discussion@lists.sourceforge.net" <sedna-discussion@lists.sourceforge.net> Message-ID: <cafcbnztdyerkycjdcqsscyj7zz3k5nd7e1bpct1884x75am...@mail.gmail.com> Content-Type: text/plain; charset="windows-1252" Hi, It doesn't sound like an XML database is a good fit for this purpose. You can make it work, but it sounds like you're just using XML to transfer some data where the schema is really simple and doesn't look like it will change much (xml's flexibility is one of the things that makes XML dbs so appealing; you don't even have to know the schema ahead of time, and it can change pretty much any time you want). Another cool thing you can do with XML is map complex objects to it, which can be difficult with relational databases. Your data, on the other hand, can trivially map to an ordinary rdbms. Hope this helps, A. P. Garcia On Mar 8, 2013 3:36 PM, "Silver, Jonathan" < jonathan.sil...@siemens-enterprise.com> wrote: > > I am new to xml base databases and I?ve been reading through baseX, > eXist and Sedona documentation trying to figure out which addresses my application needs and have not been able to figure it out. Any advise is appreciated. > > > > I have a set of documents like: > > <booklist> > > <listDate> date </listDate> > > <Book> > > <title>title 1 </Title> > > <LastPublishDate> date </> > > <copiesSoldLastMonth> 213 </> > > </Book> > > ?? > > </booklist> > > > > I will get this xml doc each month and I?d like query for things like > > Which books sold the most last month > > Which Book has the most sold copies (need to add copiesSoldLastMonth from each doc) > > Which books have been added to the list > > Which books have been removed from this list > > > > I?ve also been reading through Xquery and I do not see how to do this > or if any database has facilities to support this kind of thing. > > > > Thanks for any pointers, > > jonathan > ------------------------------------------------------------------------------ Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the endpoint security space. For insight on selecting the right partner to tackle endpoint security challenges, access the full report. http://p.sf.net/sfu/symantec-dev2dev _______________________________________________ Sedna-discussion mailing list Sedna-discussion@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sedna-discussion
