Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.

In Document based NoSQL to create tables (AFAIK) I need:

Create such many as many rows in table documents with same ID field (that will be table id) and each time need to set the columns (for each document).

Then you first search documents by id (table) and next search what you need in the selection.

Please correct if I understand it wrong... And is it sane? How could that be fast?

share|improve this question

3 Answers 3

up vote 2 down vote accepted

Perhaps. Only real way to tell is to setup some test cases and measure. My suspicion would be that how you are accessing the data in terms of pattern and usage matters most.

That said, thinking of document DBs in terms of tables is generally self-defeating. Think in terms of documents.

share|improve this answer
    
It's much easier for me to think about 100 nodes except of thinking about 100 documents with the same structure, and documents will be just realization, it's not hard to realize such "Table API" for documents, I really afraid usability and performance. –  Heather Apr 10 '12 at 8:19

Use the right tool to do the right thing. Documents databases should be used to store documents, not tables. If the documents have the same columns a relational database is more appropriate to store it or maybe a graph database.

share|improve this answer

What you describe (if I understand correctly what you describe) could be a performance nightmare in updating the said tables - if you store each "table" as a single document in a NoSQL system, and want to update a row in that "table", then you'd need to update the whole (potentially huge) document every time.

But if you need/want a strict structure, then why would you need to use NoSQL systems? For SQL type problems, SQL databases will be faster and better. For key-value type problems, key-value datasystems will be faster and better. For document storage type problems, document-based systems will be faster and better.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.