relational databases and non-relational databases

The current relational data on the market are: Oracle, DB2, Microsoft SQL Server, Microsoft Access, MySQL, and more.

Non-relational databases are: Nosql,cloudant

Non-relational databases are still nosql, so the difference between NoSQL and relational databases is:

Excellent: 1. Cost: NoSQL databases are simple and easy to deploy, basically open source software, and do not need to spend a lot of money to buy and use like Oracle, which is cheaper than relational databases.

2. Query speed: NoSQL databases store data in cache, relational databases store data on hard disks, and natural queries are far less fast than NoSQL databases.

3. Format for storing data: NoSQL storage formats are key,value forms, document forms, picture forms, and so on, so you can store the underlying types and objects or collections, and the database supports only the underlying types.

4. Extensibility: The limitations of a relational database with a multi-table query mechanism like join cause the extension to be difficult.

Missing: 1. Maintenance tools and data are limited, because NoSQL is a new technology and cannot be 10几 with relational database technology.

2. Do not provide support for SQL, if not support industry standards such as SQL, will generate a certain user's learning and use costs.

3. Do not provide relational database processing of things.

relational databases and non-relational databases