Shulou(Shulou.com)05/31 Report--

This article shares with you the content of a sample analysis of mongodb and sql relational data comparisons. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

After groping for a few days, it is generally included in the door of mongodb. If you think about it carefully, there is a big difference between mongodb and traditional relational databases.

In the traditional relational database, a database has one or more tables (Table). The data in the table is called a record, a row, and each row is divided into different fields.

Give an easy-to-understand example. A person has a name, sex, age, and many bank cards

If we use a relational database, we may use two or more tables to record, one user table to store the basic information of the user, and the other table to store the corresponding relationship of this person's multiple bank cards through the user id and the bank card id.

So if it's in mongodb, it corresponds to a file.

For example, this is the data.

{Name:' Xiaoming', Sex:' male', Age:'25',BankCards: ['123445678', 12233333', '5555555']}

So in the current mongodb, it doesn't have the concept of relationship.

This figure reflects the comparison between mongdb and traditional relational database (mysql,oracle).

It should be said that mongodb stores a complete object, and the object data is stored in the form of a document. As for its advantages, a large number of people on the Internet say that it has its advantages. Here, post the content on the Internet:

Architecture: MongoDB is a document database in which a collection holds different files. The number of fields, the content, and the size of the file can be different from copying from one file to another.

A single object is clear structure.

No complex connections.

Deep inquiry ability. MongoDB supports dynamic queries using document-based query languages such as SQL files that are almost as powerful

Tuning

Easy to scale: MongoDB is easy to extend

Application object conversion / mapping that does not require database objects

Use internal memory to store (window) workgroups for faster data access

But there are many disadvantages, first of all: do not support things, but will not support this kind of inner join, left join and other relational connections, (because it is not a relational database). There is also a disadvantage that I think it takes up space!

Thank you for reading! This is the end of the article on "sample Analysis of mongodb and sql Relational data comparison". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.