Menu
what's the difference between NoSql DB and OO Db?
254
SQL databases are vertically scalable, while NoSQL databases are horizontally scalable. SQL databases are table-based, while NoSQL databases are document, key-value, graph, or wide-column stores. SQL databases are better for multi-row transactions, while NoSQL is better for unstructured data like documents or JSON.
NoSQL databases don't require any predefined schema, allowing you to work more freely with “unstructured data.” Relational databases are vertically scalable, but usually more expensive, whereas the horizontal scaling nature of NoSQL databases is more cost efficient.
MongoDB is a type of NoSQL. It is an easy to use, open source software written in C++ which is fast and flexible. The key difference between NoSQL and MongoDB is that NoSQL is a mechanism to store and retrieve data in a non-relational database and MongoDB is a document-oriented database which belongs to NoSQL.
NoSQL DB are normally de-normalized (save copy of object data in place of object), where as OODB is normalized database with object relationships. In OODB, data is stored in object at one place and is linked (relation) to other objects.
Due t above difference of de-normalized and normalized, both have their own pros and cons. NoSQL DBs like Mongo are fast to read but poor in writing / updating data. Due to de-normalized nature of NoSQL DBs, it hard to maintain integrity of data with that, where as OODB as Wakanda are easy to manage and have data integrity. You delete one object and all its relations are deleted automatically.
I tried a lot to figure out some good javascript object oriented DB, but as of now could not find any other than www.wakanda.org. In case you know any, kindly share details.
145
An object-oriented database, like db4o, would be considered one of the alternatives presented by NoSQL, which means Not Only SQL. It's a set of alternatives to relational databases: Voldemort, Hadoop, MongoDB, CouchDB, BigTable, Neo4J, db4o and others.
39
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
