What is the meaning of Internet splitting

Split library, that is, vertical data split, such as split into merchant library, customer library, order library. Split library to solve the IO competition between multiple tables, stand-alone capacity issues.

Split table, that is, horizontal data split. Split table improves single table query speed.

First vertical split according to business dimensions, different applications can use different databases, and then horizontal split according to range or hash.

Database splitting can be done at the application layer or at the middleware layer. The advantage of using middleware for database splitting is that the application queries the middleware layer as if it were a single database and single table.

Splitting the library brings the problem of not being able to join across libraries, and splitting the table brings the problem of not being able to query across each part of the table. The original query may become multiple queries, complicating business logic. In order to reduce the problem of separate sub-table call. Data can be isomorphized according to the query. For example, according to the query dimension isomerization, the order database can be isomerized out of the merchant order database, user order database. Another example is through the commodity base library, commodity attribute library, commodity image library, aggregated data isomerization out of the commodity library.