Table division method and apparatus, and electronic device

Abstract

Embodiments of the invention disclose a table division method and apparatus, and an electronic device, and relate to the technical field of data processing. The table division method comprises the steps of dynamically generating a plurality of sub-table model classes; registering the sub-table model classes in a configuration center of an open source framework; selecting the sub-table model classes needed to be subjected to data operation in the sub-table model classes; and by utilizing a data operation function provided by the open source framework, executing corresponding data operation on instances of the sub-table model classes needed to be subjected to the data operation. In addition, the embodiments of the invention disclose the table division apparatus and the electronic device. Through the scheme provided by the table division method and apparatus, and the electronic device, the table division efficiency can be effectively improved.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to the database sub-table processing technology. Background technique [0002] Hibernate is an open source persistent middleware based on Java, which makes a lightweight package for JDBC (Java Data Base Connectivity, Java Database Connection). It adopts the ORM (Object Relation Mapping) mechanism to realize the mapping between Java objects and relational databases, transmit SQL statements to the database, and encapsulate the results returned by the database into objects. Internally encapsulates the operation of JDBC to access the database, and provides an object-oriented database access API to upper-level applications. Because it can operate data in the form of objects, it only needs to modify the allocation file when replacing the database, and it does not need to care about the type of the database, thus improving the development efficiency. [0003] Table splitting is a...

AI Technical Summary

Problems solved by technology

The inventor found in the process of realizing the present invention that the Hibernate-Shards open source framework is a powerful sub-database framework based on Hibernate, but does not support sub-tables

Hibernate NamingStrategy is a table name replacement strategy provided by Hibernate. It can perform simple table splitting operations, but it cannot dynamically determine the table name based on instance parameters. Generally, it can only be used in scenarios where tables are split by time.

Hibernate QueryInterceptor is a query interceptor provided by Hibernate. Users can intercept when generating sql statements, and dynamically replace the corresponding table names with specific sub-tables. It needs to parse sql statements, which is complicated to implement, poor in performance and maintainability, and It is also not possible to dynamically determine the table name according to the instance parameters. Generally, the user can only divide the table by time

Images