What NoSql solution is best for the following requirements? This question is related to this question. The amount and names of columns is unknown and can range from 1 to millions of records. My language of choice will be C# and I may need a client to access the data store. The data store will need efficient data paging so if the CSV files has 2 million rows I need an efficient way to navigate to page 2500 and needs to support sorting and advanced filtering. Any ideas?
Asked
Active
Viewed 1,389 times
-1
-
What exactly is your question? – Andrew Barber Aug 26 '12 at 23:02
-
he is asking for a nosql store to store his csv files. – DarthVader Aug 26 '12 at 23:04
-
Thats correct but I will not store the csv files as a whole. I will convert the csv file into a table with multiple columns and then store it into nosql data store. – Luke101 Aug 26 '12 at 23:09
-
@Luke101, please back-link related questions. In this case it looks like you're asking about this because you want to implement the approach you asked about in http://stackoverflow.com/questions/12127814/database-design-to-create-tables-on-the-fly and http://stackoverflow.com/questions/12131443/database-within-a-database-table-design – Craig Ringer Aug 27 '12 at 02:14
1 Answers
1
I would recommend you to use a Document Store, can be mongodb, couchdb.
If you take one row as one document, where as columns may vary this is a good fit for you.
There is no strict schema so columns may vary.
MongoDb has c# support, it has a nice client that takes care of pooling, sharding etc.
It s open source.
It provides all those features you want, easy to query etc.
DarthVader
- 52,984
- 76
- 209
- 300