Tag Info

New answers tagged

1

Neo4j is a schema-optional graph database. You could choose to enforce a full schema and reap the benefits.


-1

@Erik You don't replace a 150 mph car by one that can do 200 mph just for the fun of it. If you have a customer who runs into performance problems orif you get a new one, who will need more power, okay. But no sane person will spend tons of money rewriting the whole software to do the same thing again. And calling people idiots just when you are narrow ...


0

There are two ways I would approach this. 1.) Dump your json from Mongo into a tmp_retrieval_table in MySQL, then write corresponding db functions to perform the parsing / ETL to the schemata of choice in what ever fashion you see fit. 2.) Utilize MySQL's partitioning functionality. Where you could in deed sort the records by a specific key or timestamp. ...


-1

Never touch a running system, especially not for the sake of making it "better" without adding value. If you add some feature and in the same class can do some refactoring, do it, test it thorough. But never just for the sake of changing it. In most cases NoSQL reads and stores the whole document too, just like the hibernate mapping you describe, so there ...


5

Welcome to database hell! NoSQL is often championed as a solution to these types of applications. However, your problem here is clearly that the programmers have no idea what they are doing. Furthermore, it looks like your management is afraid of change, or unwilling to take the hard decisions which you correctly list and which are likely to fix the root ...


0

I'll try to address your concerns one at a time. Cassandra doesn't store the rows in any ordered way, so simply adding LIMIT X to the CQL query returns random-ish rows. The ORDER BY command in CQL only works for columns that are (part of) the key. Not entirely correct, on either point. The on-disk sort order in Cassandra is determined by the ...


1

Just execute on shell "use dbname" When you insert the first document on any collection you will see the db with "show dbs"



Top 50 recent answers are included