Will NoSQL databases continue as promised?

This article is about WillNoSQLDatabasesLiveUptoTheirPromise? Brief translation of the article. The name of the person or institution is omitted in the translation, and only the opinions of others cited by the author or the author are translated. [Original] Compared with relational databases, NoSQL databases have the biggest advantage in that they can efficiently process unstructured data, such as words.

This article is about WillNoSQLDatabasesLiveUptoTheirPromise? Brief translation of the article. The name of the person or institution is omitted in the translation, and only the opinions of others cited by the author or the author are translated. [Original] Compared with relational databases, NoSQL databases have the biggest advantage in that they can efficiently process unstructured data, such as words.

This article is about Will NoSQL Databases Live Up to Their Promise? Brief translation of the article. The translation omitted the name of the person, the name of the research institution, and the Hong Kong virtual host. It only translated the views of others cited by the author or the author.

[Original]

Compared with relational databases, NoSQL databases can efficiently process unstructured data, such as character files, emails, multimedia, and social media. Some NoSQL databases can run in a distributed environment. Therefore, you can use multiple inexpensive devices to complete the functions of a high-performance server.

Some

Earliest proposal and use

Limitations of relational databases:

Scale. When the data size becomes very large, the Hong Kong server is rented, and one server will not be able to complete all the tables. In this case, distributed processing is required. However, distributed processing of relational databases is not easy because it is difficult to join tables on different machines. In addition, relational databases are not designed to split data. Therefore, it is difficult to divide them into distributed functions.

Complexity. Relational databases need to convert data to tables. When a type of data is not easily converted to table-type data, the structure of the corresponding relational database will become complex and difficult to use.

SQL. SQL is very effective for processing structured data, but it is insufficient for unstructured data.

A large number of constraints. Relational databases have strict constraints and data integrity requirements. However, NoSQL advocates believe that database users generally do not need such strict constraints, and do not like the cost caused by these constraints and the increased complexity of the system.

Due to these limitations inherent in relational data, suppliers and users are gradually turning

There are three common NoSQL databases:

Key-value

As its name implies,

Uppsala

Other examples include

Column-based database)

Compared to a relational database that stores highly structured columns and standardized columns in a unified format, a columnar database contains an extensible column (

Representatives of such databases include:

Document-based stores)

These databases store and organize data in a collection of files. In this way, you can add any number of arbitrary length fields (

Examples include:

Open Source

Most NoSQL databases are open-source, which also reflects a development trend in the global software market.

Note: The biggest benefit of open-source software is that it can quickly converge software development to a stable version. The profit model of the Hong Kong virtual host is generally to make money through the peripheral products of the software, for example, provide technical support, certification, or provide a richer version of functions.

Advantages and disadvantages of NoSQL

Advantages:

NoSQL

To improve performance, developers generally do not require their own

NoSQL

Disadvantages:

① Complexity and overhead

Because

② Reliability

Inherent support for relational databases

③ Consistency

Because

④ Unfamiliar with technology

Because many organizations

⑤ Limited ecological structure

Unlike commercial relational databases, many open-source NoSQL applications do not provide commercial support or management tools.

Outlook

In the next five years

In the last one or two years,

NoSQL databases do not replace relational databases, but they are the best choice for certain types of projects. In the future, when you select a database for your data, there will be other options than the relational database. You can select an appropriate database type based on your needs.

Author information:

Editor: Lee Garber, Computer,

L.garber@computer.org