StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to choose database between MongoDB and Cassandra
text
Body
copied!<p>Now I want to design a database, and there will be some tables within some dynamic attributes. I can choose a traditional RDBMS like MySQL to implement them with the EAV design model. But now I want to try some thing new. I heard that NoSQL database can solve the dynamic attributes problem in an easy way, and I want to choose one between MongoDB and Cassandra.</p> <p>And here's some situations about the database I want to design:</p> <p>There will be about 200,000 items in this database and the database will be store in a single server.</p> <p>When a user want to use this database, the main procedure is that: the user would first visit table A, the a foreign key of table B, then visit table B, get a foreign key of table C. Table C has lots of fixed attributes and some dynamic attributes. Then the user will get a tuple from table C, read some values and then modify some values of this tuple, and may add some dynamic values of this tuple.</p> <p>I would import almost all of this tuples from an Excel spreadsheet into my database in Java. So which one has a better support for Java?</p> <p>After I import these data, there won't be any more insert or delete operations. Almost all of the operations for outside users are read and update. So which database is better for this scenario.</p> <p>I know it's not necessary to use a NoSQL database in this small project, but I really want to try and learn one recently. So thanks for your answers, and if you have another options for me, it would be very great.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload