Here are some other factors that might enter into your recommendation:

 

Ø  Are these files volatile or static? 

 

The XML files are relatively static - a few are updated for errors but most stay the same.

 

Ø  Are there requirements for further processing or consuming them as XML

Ø  elsewhere or are they just a query source? 

 

The XML files are just a query source. The results of the queries on the XML documents are used as input to SAS and SPSS analytics.

 

Ø  What type of queries, with what frequency?

 

We want multiple people to query multiple times a day. Right now the query frequency is low because the queries take days to run.

 

What’s your recommendation?

 

/Roger

From: Costello, Roger L.
Sent: Thursday, March 05, 2015 10:37 AM
To: xml-dev@l...
Subject: RE: What is the general direction you are seeing these days to store and query lots of large complex XML?

 

Ø  I smell a rat here... where did you get them from.

 

Hmm, no rat here. Those are actual, real numbers. We deal with big data … real big data.

 

/Roger

 

From: Ihe Onwuka [mailto:ihe.onwuka@g...]
Sent: Thursday, March 05, 2015 10:33 AM
To: Costello, Roger L.
Cc: xml-dev@l...
Subject: Re: What is the general direction you are seeing these days to store and query lots of large complex XML?

 

I smell a rat here... where did you get them from.

 

On Thu, Mar 5, 2015 at 3:26 PM, Costello, Roger L. <costello@m...> wrote:

As always Michael, you are very wise. And I certainly appreciate your graciousness.

I have some figures regarding size and complexity:

        There are 50 million XML files, each 50MB in size.
        The files are mostly flat (not deeply nested).
        We need to perform queries across the 50 million files.

What's your recommendation for storing and querying this huge amount of XML files?

/Roger

_______________________________________________________________________

XML-DEV is a publicly archived, unmoderated list hosted by OASIS
to support XML implementation and development. To minimize
spam in the archives, you must subscribe before posting.

[Un]Subscribe/change address: http://www.oasis-open.org/mlmanage/
Or unsubscribe: xml-dev-unsubscribe@l...
subscribe: xml-dev-subscribe@l...
List archive: http://lists.xml.org/archives/xml-dev/
List Guidelines: http://www.oasis-open.org/maillists/guidelines.php