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
>
------------------------------------------------------------------------------
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