Hello Jonathan, I looked at BaseX, eXist, and Sedna prior to selecting Sedna. (You may want to consider the free version of DB2 also. There are other FOSS solutions.)
BaseX and eXist have changed a great deal since I originally reviewed them several years ago. The following is based on previous experience that may not apply anymore: * BaseX was just too immature at the time, I had issues setting up as a server, connection problems etc. * eXist performed well on small data sets, but totally fell apart on larger data sets. eXist had index corruption issues and could not support multiple databases. I use Senda on Amazon micro-instances (500 MB of available memory, with databases of 1G-5G). If you are a JavaBot, then BaseX or eXist may work for you. If you are not into Java, then I recommend considering Sedna first. XQuery has sum and sort features, so you can sum items, sort, and then pull the first item out of list (I do this a lot). I don't know how to handle which items have been added or removed other than keeping up with the transaction history. Malcolm -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Saturday, March 09, 2013 10:39 AM To: [email protected] Subject: Sedna-discussion Digest, Vol 79, Issue 3 Send Sedna-discussion mailing list submissions to [email protected] 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 [email protected] You can reach the person managing the list at [email protected] 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: 1 Date: Fri, 8 Mar 2013 16:47:15 +0000 From: "Silver, Jonathan" <[email protected]> Subject: [Sedna-discussion] Which database is best [for me] To: "[email protected]" <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain; charset="us-ascii" 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 [email protected] https://lists.sourceforge.net/lists/listinfo/sedna-discussion
