Nosqlの Database The future star

relational database value

In the study of NoSQL is we certainly think of the current database mainstream ———— SQL database. Why SQL database is now the mainstream, mainly based on the following advantages:

Get persisted data: mainly because of the two storage areas in the computer architecture, primary storage and backup memory.

Concurrency: Using the transaction mechanism can be done

Integration: Implementing shared Database integration for multiple applications common to the same database

Near-standard models: Based on the above advantages, and the various SQL dialect are similar, making it a near-standard model.

Impedance detuning

But the relational database has a big drawback: the most disappointing thing for application developers is that there is a difference between the relational model and the data structure in memory, which is often referred to as "impedance detuning."

The data content of an application database application is accessed directly from the code base of an application, and this codebase is maintained by a team. Such a database becomes the application database "integrated database" SQL acts as an integration mechanism for the application, which is the main reason for the mainstream of SQL. The concept of integration has been explained above, and the integrated database is a database based on this principle. It's simple.

Cluster

There must be more computer resources in the face of increased data and traffic. There are two scenarios for dealing with this type of growth: vertical scaling and scale-out. The former requires a more powerful computer, such as the increase in processor and disk, memory. The latter uses multiple small computers to form clusters. The second method can be more resilient: we can build a highly stable cluster that calculates that some of these computers often fail without affecting the entire cluster's operation.

NoSQL based on these issues, Google and Amazon have to innovate new avenues, namely BigTable and Dynamo. NoSQL can be a good solution to these problems, and the common features of various NoSQL databases are as follows:Do not use a relational modelRunning well in the clusterUsually used under open source conditions (also closed source)Internet companies for the 21 worldThe important impact of the rise of modeless nosql is hybrid persistence.

Nosqlの Database The future star