Shulou(Shulou.com)06/01 Report--

In this issue, the editor will bring you an introduction to the vertical split in the database. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

The concept of vertical segmentation

Vertical split is split according to the relevance of the data tables in the database. For example, there are both user data and order data in a database. Then vertical split can put user data into the user database and order data into the order database. Vertical split table is a way to split a data table vertically. it is common to split a large multi-field table according to commonly used fields and unused fields. The number of data records in each table is generally the same, but the fields are different. Use primary key association.

Advantages of vertical slicing

The splitting of the database is simple and clear, and the splitting rules are clear.

The application module is clear and easy to integrate.

Data maintenance is easy and easy to locate.

Disadvantages of vertical slicing

Partial table association cannot be done at the database level and needs to be done in the program

For tables with extremely frequent access and a large amount of data, there is still calm performance, which may not necessarily meet the requirements.

Transaction processing is relatively more complex

After the segmentation reaches a certain degree, the scalability will be limited.

Overreading syncopation may make the system too complex and difficult to maintain.

For vertical segmentation may encounter data segmentation and transaction problems, it is very difficult to find a better processing scheme at the database level. In practical application cases, most of the vertical segmentation of the database corresponds to the module of the application system, and the data source of the same module is stored in the same database, which can solve the problem of data association within the module. Between modules, the required data is provided to each other through the application program in the way of service interface. Although this does increase the overall number of operations of the database, it is beneficial in terms of overall system scalability and architectural modularization.

The single response time may increase slightly in some operations, but the overall performance of the system is likely to be improved to some extent. And expand the bottleneck problem.

The above is the vertical split in the database shared by the editor. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

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.