Method for dividing database and table of data

The invention provides a method for dividing data into databases and tables. The method comprises the following steps: dispersing data into a plurality of databases; the single-node performance limitation is broken through; dividing the cut-in level of the middleware; the basic principle of splittin...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: CHEN YUXU, LIU MINGWEI, AO ZHIQI, KANG YI
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The invention provides a method for dividing data into databases and tables. The method comprises the following steps: dispersing data into a plurality of databases; the single-node performance limitation is broken through; dividing the cut-in level of the middleware; the basic principle of splitting; and data fragmentation, distributed transaction and database governance are carried out. The business of each province is relatively independent, and the data of the same province is in the same library; cross-fragment query/connection/transaction is avoided; a database partition table is used to shield the complexity of horizontal table division; and historical data migration is facilitated. The middle station needs to store the data of each service domain, the related range is wide, and the data volume is large. 本发明提供的一种数据分库分表的方法,包括:将数据分散到多个数据库;突破单节点性能限制;划分中间件的切入层次;拆分的基本原则;将数据分片、分布式事务和数据库治理。实现了各省业务相对独立,同一省的数据在同一个库;避免了跨分片查询/连接/事务;使用数据库分区表,屏蔽水平分表复杂性;方便历史数据迁移。中台要存储各个业务域的数据,涉及范围广、数据量大。