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

What is the difference between relational databases and non-relational databases? For this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more small partners who want to solve this problem find a simpler and easier way.

Non-relational database (nosql)

Non-relational databases are also called nosql databases. Please note that nosql's original meaning is "notonlySQL", which refers to non-relational databases, not "noSQL". Therefore, nosql is not created to completely negate relational databases, but as an effective supplement to traditional relational databases. NoSQL databases can exert unimaginable high efficiency and high performance in specific scenarios.

With the rise of the Internet, ultra-large-scale and high-concurrency microblogs, WeChat, SNS type web2.0 pure dynamic websites have become inadequate, exposing many insurmountable problems, such as: Traditional relational database IO bottleneck, performance bottleneck are difficult to effectively break through, so began to appear a large number of specific scenarios for the purpose of high performance and ease of use of the database products, NoSQL database is born in such a scenario and has been very rapid development

NoSQL is a broad definition of a non-relational database. It breaks the long-standing unification of relational database and ACID theory. NoSQL data storage does not need fixed table structure, and there is usually no join operation. It has incomparable performance advantages over relational database in large data access. This term (NoSQL) has been widely recognized in early 2009.

Google's BigTable and Amazon's Dynamo are very successful commercial NoSQL, and some open source NoSQL architectures, such as

Redis, mongodb is also gradually becoming more and more popular and sought after by all large, medium and small enterprises.

Types of non-relational databases

key-value store data

Key-value databases are similar to hash tables used in traditional languages. Data can be added, queried, or deleted by key. Because key primary keys are used for access, high performance and scalability will be obtained.

Key-value database mainly uses a hash table, which has a specific key and a pointer to specific data. The advantages of key/value model for IT system are simple, easy to deploy and high concurrency.

relational database

(1) Origin of Relational Database

Although mesh database and hierarchical database have solved the problem of data centralization and sharing well, there are still many deficiencies in data independence and abstraction level. When users access these two databases, they still need to make clear the storage structure of the database and spend the access path. Relational database can solve these problems well.

(2) Introduction to relational databases

Relational database model is to reduce complex data structure to simple binary relations (i.e. two-dimensional format table).

Relational database has been born for more than 40 years, from theory to real products, such as: the most common mysql and oracle database, oracle in the database field rose to the dominant position, forming a huge industrial market of tens of billions of dollars every year, and mysql is also a database that cannot be ignored, so that it was acquired by oracle center.

About relational database and non-relational database what is the difference between the answer to the question to share here, I hope the above content can be of some help to everyone, if you still have a lot of doubts not solved, you can pay attention to the industry information channel to learn more related knowledge.

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.