query XML/JSON collection like a relational database?

Question

i saved 10.000 api call answers in a plain txt file. there are 100s of most things have most set..

how to simply automatically import it into a database and make various queries efficiently?

-sample data: http://pastebin.com/C5yjSjCf

-scheme: http://awis.amazonaws.com/AWSAlexa/AWSAlexa.xsd )

thanks

Answer 1

I can think of two solutions,

1. Use one of the many NoSQL DB, check this out, mongoDB looks like a good choice
2. Use unix commands to query the file