The NoSQL Revolution still needs to wait a long time

Recently, an explosive news came out in the database field. Some experts have proposed open-source NoSQL projects. Simply put, they want to overturn the original Relational Database

Recently, an explosive news came out in the database field. Some experts have proposed open-source NoSQL projects. Simply put, they want to overturn the original Relational Database

Recently, an explosive news came out in the database field. Some experts have proposed open-source NoSQL projects. Simply put, they want to overturn the original relational database model and design a database system without SQL statements. The author is opposed to this, or is not optimistic about its prospects in the near future.

I. background of the NoSQL project.

NoSQL supporters like this NoSQL project, mainly focusing on its performance advantages. NoSQL supporters said that NoSQL technology can break the performance bottleneck of traditional relational databases. For example, the NoSQL architecture can save the time for converting Web or Java applications and data into SQL-friendly formats, reduce the time for SQL statement parsing and optimization, and make the application faster.

Indeed, SQL-based relational databases have some performance bottlenecks. However, most of these are not caused by this SQL technology. It is because the relationship between tables, indexes of tables, and the deployment of tablespaces are not well designed during database design. Therefore, the performance of relational databases is not satisfactory, and it cannot be all blamed on such technology. Generally, optimizing the original database design can greatly improve the database performance. Therefore, the background of the NoSQL project is untenable.

2. The NoSQL Revolution still needs to wait.

According to the current situation, I am not very optimistic about the prospects of the NoSQL project. Or, they are very pessimistic about their future. NoSQL projects are hard to compete with traditional relational databases. It is even difficult to reach the height of the MySQL open-source database.

1. NoSQL is hard to achieve data integrity.

Since the beginning of the NoSQL project, I have also paid attention to it. However, I was not very impressed with this project. According to my understanding, many excellent and practical functions of relational databases cannot be implemented in NoSQL databases. For example, in any relational database, data integrity can be easily realized. For example, in Oracle databases, entity integrity (achieved through primary keys or non-null constraints) and referential integrity (achieved through primary keys and Foreign keys) can be easily realized), and user-defined integrity (implemented by constraints or triggers ). Data integrity can be achieved through these mechanisms. For example, you can set that the value of a column in a table is unique and cannot be null. In other words, if a foreign key is referenced in a table, this value must exist in another table. It must exist when deleted or updated.

NoSQL supporters also acknowledge that the role of relational databases in data integrity is irreplaceable. However, they retorted that enterprises may not use such complex functions. I do not agree with this. Data integrity is basically required for any enterprise application. For example, most applications require at least one user authentication process. Therefore, the user name must be saved in the database during system implementation. Because this user name involves user authentication, the user name must be unique. In this case, the uniqueness constraint is required. In relational databases, you only need to set the user name to unique during table design. In NoSQL, code must be used for uniqueness. It was easy to implement, but now it is incredible to turn around and implement it. Since it is difficult to achieve data integrity in NoSQL projects, this data integrity is indispensable in enterprise applications. Therefore, I believe that NoSQL projects are hard to be popularized in enterprises. At least in a short time, the NoSQL Revolution still needs to wait.

2. Lack of strong technical support.

NoSQL projects are open-source so far. Therefore, they lack formal support from suppliers and technicians. At this point, NoSQL projects, like most open-source projects, have to seek support from the community. However, NoSQL projects are much more difficult than other open-source projects. The NoSQL Project is a database system project. Or, it is the most basic device for some network applications. If an error occurs, the consequences are serious. Due to the lack of official support, the consequences of database operation errors are very serious. In addition, the user will not be able to complain. Therefore, the NoSQL project is basically at the research stage. If it is to be officially put into use in the enterprise, it will be accepted by the database administrator, at least its stability should be improved. In other words, when a problem occurs, the database administrator must be able to repair the operation fault in time. Due to the lack of strong technical support, database administrators are worried that the fault may not be quickly solved. Therefore, many administrators refuse to use NoSQL projects, even if they are open-source and free of charge. For example, Oskarsson, the organizer of the NoSQL project, admitted that his company is not currently using NoSQL databases, and even has no such plans in the short term. Although they are currently using open-source database systems, they are still SQL-based relational databases. For example, the organizers of NoSQL projects do not dare to deploy this NoSQL database easily in enterprises. Who would dare to be the first hero to eat crabs? This is not a joke about your future.