CN106886568B8 - One kind divides table method, apparatus and electronic equipment - Google Patents

Abstract

The embodiment of the invention discloses one kind to divide table method, apparatus and electronic device, is related to technical field of data processing.The embodiment of the present invention divides table method to include：The multiple sublist model classes of dynamic generation, the sublist model class is registered in the configuration center of Open Framework, select to need the sublist model class for carrying out data manipulation in the sublist model class, and the data manipulation function provided using the Open Framework, corresponding data manipulation is performed to the example of the sublist model class for needing to carry out data manipulation.In addition, the embodiment of the invention also discloses one kind to divide meter apparatus and electronic equipment.By the scheme of the embodiment of the present invention, the efficiency of point table can be effectively improved.

Description

Method, device and electronic equipment for dividing meter

Technical field

[0001] The present invention relates to the field of data processing technology, and in particular to database sub-table processing technology.

Background technique

[0002] Hibernate is a Java-based open source persistence middleware, which encapsulates JDBC (Java Data Base Connectivity) lightly. It adopts ORM (Object Relation Mapping, Object Relation Mapping) mechanism to realize the mapping between Java objects and relational databases, pass SQL statements to the database, and encapsulate the results returned by the database into objects. The operation of JDBC access to the database is encapsulated internally, and an object-oriented database access API is provided to the upper application. Because it can manipulate data in the form of objects, it only needs to modify the configuration file when replacing the database, without worrying about the type of database, thus improving the development efficiency.

[0003] Table splitting is a method for dividing a large table into multiple tables in the same database to resist the performance impact due to excessive data volume. In the process of implementing the present invention, the inventor discovered that the Hi Bernat e-Shards open source framework is a powerful sub-library 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 the table name cannot be dynamically determined based on instance parameters. Generally, it can only be used in scenarios where tables are split by time. Hibernate Query Interceptor 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. SQL statements need to be parsed, which is complex to implement, and has poor performance and maintainability. And it is not possible to dynamically determine the table name based on the instance parameters. Generally, the user can only divide the table by time.

[0004] Therefore, there is a need for a simpler and more effective method for table splitting based on Hibernate.

Summary of the invention

[0005] In view of this, the embodiments of the present invention provide a method, device and electronic device for dividing a meter, which at least partially solve the problems existing in the prior art.

[0006] In the first aspect, an embodiment of the present invention provides a table splitting method, including:

[0007] Dynamically generate multiple sub-table model classes;

[0008] Register the sub-table model class in the configuration center of the open source framework;

[0009] Select the sub-table model class that needs to perform data operations among the sub-table model classes;

[0010] Using the data operation function provided by the open source framework, perform corresponding data operations on the instance of the sub-table model class that needs to perform data operations.

[0011] According to a specific implementation manner of the embodiment of the present invention, before the dynamically generating multiple sub-table model classes, the method further includes:

[0012] A single-table model class is defined in the open source framework.

[0013] According to a specific implementation of the embodiment of the present invention, the dynamically generating multiple sub-table model classes includes:

[0014] Obtain the sub-table requirements of the database associated with the open source framework;

[0015] Based on the requirements for sub-tables, a third-party open source class library is used to dynamically generate multiple sub-table model classes.

[0016] According to a specific implementation manner of the embodiment of the present invention, the registering the sub-table model class in the configuration center of the open source framework includes:

[0017] generating a class file corresponding to the sub-table model class;

[0018] Save the class files in a preset scanning location of the open source framework.

[0019] According to a specific implementation manner of the embodiment of the present invention, the registering the sub-table model class in the configuration center of the open source framework includes:

[0020] Obtain the session interface file of the open source framework;

[0021] Based on the session interface file, determine whether the sub-table model class is loaded in a dynamic manner;

[0022] When the sub-table model class is loaded in a dynamic manner, the configuration file of the open source framework is updated, and the session interface file of the open source framework is recreated.

[0023] According to a specific implementation manner of the embodiment of the present invention, the selecting the sub-table model class that needs to perform data operations among the sub-table model classes includes:

[0024] A hash method is defined based on the sub-table requirements of the database associated with the open source framework;

[0025] Acquire preset fields of the database associated with the open source framework;

[0026] performing data operations on the preset fields based on the hash method;

[0027] According to the result of the data operation, determine the sub-table model class that needs to perform the data operation.

[0028] According to a specific implementation of the embodiment of the present invention, the use of the data operation function provided by the open source framework to perform corresponding data operations on the instance of the sub-table model class that needs to perform data operations includes:

[0029] Use the data addition, data deletion, data modification, and data query functions provided by the open source framework to explicitly specify the sub-table model class that needs to perform data operations to perform related data operations.

[0030] According to a specific implementation of the embodiment of the present invention, the use of the data operation function provided by the open source framework to perform a corresponding data operation on the instance of the sub-table model class that requires data operation also includes :

[0031] Use the reflection method to construct the model instance of the sub-table model class that needs to be operated on data;

[0032] The model instance is filled with data using a cluster that does not contain repeated elements.

[0033] In the second aspect, an embodiment of the present invention also provides a meter division device, including:

[0034] The generation module is used to dynamically generate multiple sub-table model classes;

[0035] The registration module is used to register the sub-table model class in the configuration center of the open source framework;

[0036] The selection module is used to select the sub-table model classes that need to perform data operations among the sub-table model classes;

[0037] The execution module is used to use the data operation function provided by the open source framework to perform corresponding data operations on the instance of the sub-table model class that needs to perform data operations.

[0038] According to a specific implementation manner of the embodiment of the present invention, the device further includes:

[0039] The definition module is used to define a single table model class in the open source framework.

[0040] According to a specific implementation manner of the embodiment of the present invention, the generating module is further configured to:

[0041] Obtain the sub-table requirements of the database associated with the open source framework;

[0042] Based on the requirements for sub-tables, a third-party open source class library is used to dynamically generate multiple sub-table model classes.

[0043] According to a specific implementation manner of the embodiment of the present invention, the registration module is further configured to:

[0044] generating a class file corresponding to the sub-table model class;

[0045] Save the class files in a preset scanning location of the open source framework.

[0046] According to a specific implementation manner of the embodiment of the present invention, the registration module is further configured to:

[0047] Obtain the session interface file of the open source framework;

[0048] Based on the session interface file, determine whether the sub-table model class is loaded in a dynamic manner;

[0049] When the sub-table model class is loaded in a dynamic manner, the configuration file of the open source framework is updated, and the session interface file of the open source framework is recreated.

[0050] According to a specific implementation manner of the embodiment of the present invention, the selection module includes:

[0051] A definition module for defining a hashing method based on the sub-table requirements of the database associated with the open source framework;

[0052] An acquisition module for acquiring preset fields of the database associated with the open source framework;

[0053] an operation module, configured to perform data operation on the preset field based on the hash method;

[0054] The determining module is used to determine the sub-table model class that needs to be operated on according to the result of the data operation. [0055] According to a specific implementation manner of the embodiment of the present invention, the execution module includes:

[0056] The designated module is used to use the data addition, data deletion, data modification, and data query functions provided by the open source framework to explicitly specify the sub-table model classes that need to be operated on to perform related data operations.

[0057] According to a specific implementation manner of the embodiment of the present invention, the execution module further includes:

[0058] The building module is used to construct the model instance of the sub-table model class that needs to perform data operations by using the reflection method;

[0059] The filling module is used to fill the model instance with data using a cluster that does not contain repeated elements.

[0060] In a third aspect, an embodiment of the present invention also provides an electronic device, the electronic device including:

[0061] at least one processor; and,

[0062] A memory communicatively connected with the at least one processor; wherein,

[0063] The memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor, so that the at least one processor can execute any of the foregoing first aspect or any implementation of the first aspect The sub-table method in the mode.

[0064] In a fourth aspect, embodiments of the present invention also provide a non-transitory computer-readable storage medium, the non-transitory computer-readable storage medium storing computer instructions, and the computer instructions are used to make the computer execute the aforementioned first Aspect or any implementation of the first aspect.

[0065] In a fifth aspect, embodiments of the present invention also provide a computer program product, the computer program product includes a calculation program stored on a non-transitory computer-readable storage medium, the computer program includes program instructions, when the program When the instructions are executed by a computer, the computer is caused to execute the aforementioned first aspect or the table splitting method in any implementation manner of the first aspect.

[0066] The method, device, electronic equipment, non-transitory computer readable storage medium and computer program provided by the embodiments of the present invention can dynamically generate multiple sub-table model classes and combine the data operation function of Hibernate, thereby being able to Under the premise of significantly affecting performance and maintainability, the function of sub-table ORM based on the Hibernate framework is realized. Since the table name can be dynamically determined according to the instance parameters during the table splitting process, the user only needs to formulate the rules for dynamically determining the table name according to the instance parameters, so the realization method is simple, the understandability is strong, and the learning and maintenance costs are greatly reduced. The technical effect of the overall improvement of the efficiency of sub-metering.

Description of the drawings

[0067] In order to more clearly describe the technical solutions of the embodiments of the present invention, the following will briefly introduce the drawings needed in the embodiments. Obviously, the drawings in the following description are only some embodiments of the present invention. For those of ordinary skill in the art, other drawings can be obtained based on these drawings without creative work.

[0068] FIG. 1 is a schematic flowchart of a method for dividing a table according to an embodiment of the present invention;

[0069] FIG. 2 is a schematic flow chart of another table splitting method provided by an embodiment of the present invention;

[0070] FIG. 3 is a schematic diagram of a process of dynamically loading sub-table model classes to the Hibernate configuration center provided by an embodiment of the present invention;

[0071] FIG. 4 is a schematic diagram of a selection process of a hash-based sub-table model class according to an embodiment of the present invention;

[0072] FIG. 5 is a schematic diagram of a flow chart of performing corresponding data operations on instances of sub-table model classes according to an embodiment of the present invention;

[0073] FIG. 6 is a schematic block diagram of a meter division device according to an embodiment of the present invention;

[0074] FIG. 7 is a schematic block diagram of another meter division device according to an embodiment of the present invention;

[0075] FIG. 8 is a schematic block diagram of a selection module according to an embodiment of the present invention;

[0076] FIG. 9 is a schematic block diagram of an execution module according to an embodiment of the present invention;

[0077] FIG. 10 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.

Detailed ways

[0078] The following describes the embodiments of the present invention in detail with reference to the accompanying drawings.

[0079] It should be clear that the described embodiments are only a part of the embodiments of the present invention, rather than all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative work shall fall within the protection scope of the present invention.

[0080] FIG. 1 is a table splitting method provided by an embodiment of the present invention. Referring to FIG. 1, the method includes the following steps:

[0081] S101, dynamically generating multiple sub-table model classes.

[0082] After the data capacity in the database has developed to a certain extent, in order to improve the response speed of the database, it is necessary to split a single large table of the entire database into multiple small tables. When splitting, a variety of preset rules can be used, such as:

[0083] (1) Dividing tables according to natural time

[0084] If the amount of statistical data of a business reaches a certain scale (such as about 2 million pieces), then one year's data can be considered as a table for storage. For example, if the table is named app, then the data for 2010 is app_2010, app—2011,... •. Of course, you can also use other time methods, such as entering according to the month, such as app_2〇l〇_〇l, app_2010-02,....

[0085] (2) According to the number type hash table

[0086] For example, if you want to store user information, and the amount of business data is very large, and a single table cannot meet the storage requirements, then you can use the user number to hash, and the common one is to use the remaining operation. If you want to divide 30 tables to store user information, then the user 1% 30 = 1 with the user number 1, then it exists in the user_01 table, if the user number is 500, then 500% 30 = 20, this user’s The information is stored in the table of user_20.

[0087] ⑶ According to md5 value to divide the table

[0088] Assuming that files uploaded by users are to be stored, if the upload volume is large, it will also cause system bottlenecks. For example, if there are more than 20,000 files in a database table, the browsing efficiency of files will be reduced. At this time, you can use the user name of the file to md5 or use the md5 checksum of the file to do it. You can use the first 3 digits of !^5 as the hash, so that at most we can get 16~3 = 40% tables. When storing a file, the first 3 digits of the md5 value of the file name can be used to determine which table the file should be stored in.

[0089] Each table generated by the aforementioned preset rules corresponds to a sub-table model class. Specifically, ByteBuddy can be used to dynamically generate multiple sub-table model classes. Of course, other third-party open source libraries such as cglib or javaassist can also be used to dynamically generate multiple sub-table model classes. These three class libraries all use asm, an open source class library, which can dynamically manipulate java subsection codes to construct dynamic Java classes.

[0090] S102, register the sub-table model class in the configuration center of the open source framework.

[0091] The registration to the hibernate configuration center can be loaded in a static way, or it can be loaded in a dynamic way. [0092] Hibernate usually scans the Class file according to the relevant configuration information when the web container is started, and then registers it in the SessionFactory. The Java subsection code can be manipulated to construct a dynamic Java class, which is specifically generated by writing Java's assembly instruction serialization. A class file, and then use classloader to load this class file.

[0093] For the class generated during the normal operation of the program after the container startup has been completed, since Hibernate cannot recognize the newly created class, the Hibernate interface cannot be used directly at this time. This can be done by means of dynamic registration. Taking into account the security issue, instead of using the existing SessionFactory, the SessionFactory is obtained, and it is judged whether the sub-table model class is dynamically loaded into the JVM. If it is, the current Configuration is updated and a SessionFactory is recreated.

[0094] S103: Select a sub-table model class that needs to perform data operations among the sub-table model classes.

[0095] Define a hashing method, and select the corresponding sub-table model class according to a specific hash parameter. The hash parameter can be the model primary key Id, other fields of the model, or time parameters.

[0096] For example, for a database that records all purchase records of users, if all the records are put into one table, the userbuy table, it is bound to be very huge. Therefore, the purchase records of different users can be put into different sub-tables by performing sub-table processing on the user id. The specific methods are as follows:

[0097] To estimate the business volume, expand the original userbuy table to 100 userbuy_index tables with the same table structure. The original table structure is as follows:

[0098] Table 1 Userbuy table data structure

[0099] _ Field|Type|Null|Key value|Default id bigint (20) unsigned NO PRI NULL uid int (10)unsigned NO 0 goods varchar (128) NO num int (10)unsigned NO 0 ctime int (10) unsigned NO 0

[0l00] All sub-tables adopt the same table structure. When a new sub-table record needs to be added, the process is as follows: first, perform a hash calculation on the user id to obtain the hash value. The hash value must be 0-99, and the purpose is Write the corresponding user id data into the same sub-table. At this time, the sub-table model class can be selected based on the hash value.

[0101] S104. Use the data operation function provided by the open source framework to perform corresponding data operations on the instance of the sub-table model class that needs to perform data operations.

[0102] Use the native Hibernate data operation functions such as data addition, data deletion, data modification, and data query, and explicitly specify specific sub-table model classes to perform related data operations. By displaying the designated sub-table, the user can clearly specify which sub-table to initiate related data operations, and the user can clearly understand the physical data structure of the data.

[0103] Specifically, the data operation function is realized by constructing an instance of the sub-table model class and performing data operations on the instance of the sub-table model class. When constructing an instance of a model class, first select the corresponding sub-table model class according to the hash parameters, then use the reflection method Class.newlnstance to construct a model instance of the corresponding subclass, and finally use the set method to fill the object.

[0104] In the process of realizing the table division, in addition to steps S101 to S104 in the foregoing embodiment, optionally, referring to FIG. 2, the table division method may further include the following steps:

[0105] S201. Define a single-table model class in the open source framework.

[0106] Specifically, the following code can be added to the Hibernate configuration file hibernate.cfg.xml:

[0107] <properties>

[0108] <property name =''hibernate. hbm2ddl • auto〃value = 〃create〃/>

[0109] </properties>

[0110] By defining the single-table model class in the open source framework, when multiple sub-table model classes are dynamically generated in step S101, the single-table model class code defined in step S201 can be reused to simplify code writing. At the same time, it is easier to maintain the code.

[0111] The table splitting method in this embodiment is simple to implement, simple to use, has strong comprehensibility, greatly reduces learning costs and maintenance costs, and has performance close to native ORM single-table operations.

[0112] Optionally, the embodiment of the present invention also provides a method for dynamically loading the sub-table model class to the Hibernate configuration center. Referring to FIG. 3, the method includes the following steps:

[0113] S301. Obtain a session interface file of the open source framework.

[0m] For Hibernate, you need to obtain the SessionFactory interface. Specifically, you can create a SessionFactory through a Configuation instance, as shown below:

[0115] Configuration config=new Configuration () .configure ();

[0116] SessionFactory SessionFactory two config.buildSessionFactory 〇;

[0117] The Configuration instance config will construct a SessionFactory instance and return it according to the current configuration information.

[0118] S302, based on the session interface file, determine whether the sub-table model class is loaded in a dynamic manner.

[0119] Specifically, a Map can be obtained through the getAllClassMetadata method of SessionFactory, where the key of the Map is the name of the entity class, and the value is the ClassMetadata object, by judging whether the sub-table model class is included in the map.keySet() It is determined whether the sub-table model class is loaded in a dynamic manner. for example:

[0120] M^<String,CI_Metadata>maft.sesSionFacto_ge^^lassM_a_ta0; Set<String> set = map.keySet(); if(!set.contams(entityClass.getName〇)){}

[0121] S303: When the sub-table model class is loaded in a dynamic manner, update the configuration file of the open source framework, and recreate the session interface file of the open source framework.

[0122] Specifically, the configuration file of ffibernate can be updated by the setting function configuration.addAnnotatedClass (), and the SessionFactory of Hibernate can be recreated by setting the function sessionFactoryList.add ().

[0123] Through the above method, the sub-table model class can be dynamically loaded to the configuration center of Hibernate.

[0124] Referring to FIG. 4, an embodiment of the present invention also provides a method for selecting a sub-table model class based on a hash, which includes the following steps:

[0125] S401. Define a hashing method based on the table sub-table requirements of the database associated with the open source framework.

[0126] According to specific table splitting requirements, a hash method is defined. Taking the database form structure shown in Table 1 as an example, the database table should be divided into 100 sub-tables. At this time, you can choose to use the Crc32 method for hash calculation.

[0127] S402. Obtain a preset field of the database associated with the open source framework.

[0128] Specifically, any field in Table 1 can be used for hash calculation, for example, id can be selected as a preset field.

[0129] S403: Perform data operations on the preset field based on the hash method.

[0130] The calculation result of crc32 is a decimal number. Under different bit operating systems, the obtained value may be different, so a unified process is performed on it, and then the natural number is calculated by taking the remainder, and the remainder is taken The divisor is the number of points, such as 100 here.

[0131] S404: Determine, according to the result of the data operation, the sub-table model class that needs to enter the data operation.

[0132] By calculating the preset fields of the database, a table suffix number index within 0-99 is obtained. By associating the index value with the sub-table model class, the sub-table model that needs to be operated on can be determined kind.

[0133] Through the method in the foregoing embodiment, a single table can be more evenly distributed to each sub-table.

[0134] Referring to FIG. 5, an embodiment of the present invention also provides a method for performing corresponding data operations on an instance of a sub-table model class, which includes the following steps:

[0135] S501: Use the data addition, data deletion, data modification, and data query functions provided by the open source framework to explicitly specify the sub-table model class that needs to perform data operations to perform related data operations.

[0136] Use the native Hibernate data operation functions such as data addition, data deletion, data modification, and data query, and explicitly specify specific sub-table model classes to perform related data operations. By displaying the designated sub-table, the user can clearly specify which sub-table to initiate related data operations, and the user can clearly understand the physical data structure of the data.

[0137] Taking the deletion operation of the sub-table model class as an example, the following code can be used:

[0138] tx = session.beginTransaction ();

[0139] user= (UserEntity) session.get (UserEntity.shardFor ("2〃), 〃2");

[0140] System.out.println (user.getName());

[0141] session.delete (user);

[0142] tx.commit ();

[0143] S502, using a reflection method to construct a model instance of the sub-table model class that needs to perform data operations.

[0144] Specifically, first select the corresponding sub-table model class according to the hash parameters, and then use the reflection method Class·newlnstance () to construct a model instance of the corresponding sub-class.

[0145] S503: Use a cluster that does not contain repeated elements to fill the model instance with data.

[0146] Specifically, the set method can be used to fill the model instance with data, for example:

[0147] UserEntityuser= (UserEntity) session• get (UserEntity• shardFor (〃2〃), "2");

[0148] user•setName (〃user—modified")

[0149] Through the method in this embodiment, it is possible to explicitly specify the sub-table model class that needs to perform data operations to perform related data operations.

[0150] FIG. 6 is a meter division device provided by an embodiment of the present invention. Referring to FIG. 6, the device includes:

[0151] The generating module 601 is used to dynamically generate multiple sub-table model classes.

[0152] After the data capacity in the database has developed to a certain extent, in order to improve the response speed of the database, a single large table of the entire database can be split into multiple small tables. When splitting, a variety of preset rules can be used, such as:

[0153] (1) Dividing tables according to natural time

[0154] If the amount of statistical data of a business reaches a certain scale (such as about 20,000 items), then one year's data can be considered as a table for storage. For example, if the table is named app, then 2〇10 The data for the year is app_2010, app_ 2011, • • •. Of course, other time methods can also be used, such as dividing by month, such as app_2〇l〇_〇l, app_ 2010-02, ___〇

[0155] (2) According to the number type hash table

[0156] For example, if you want to store user information, and the amount of business data is large, and a single table cannot meet the storage requirements, you can use the user number to hash, and the common one is to use the remaining operation. If you want to divide 30 tables to store user information, then user 1% 30 = 1 with the user number 1, then it exists in the user_01 table. For example, if the user number is 500, then 500% 30 = 20. The information is stored in the table of user_20.

[0157] (3) Divide the table by md5 value

[0158] Assuming that files uploaded by users are to be stored, if the upload volume is large, it will also cause system bottlenecks. For example, if there are more than 20,000 files in a database table, the browsing efficiency of the files will be reduced. At this time, you can use the user name of the file to md5 or use the md5 checksum of the file to do it. You can use the first 3 digits of md5 as the hash, so that at most we can get 16~3 = 4〇96 tables, each time When storing a file, you can use the first 3 digits of the md5 value of the file name to determine which table the file should be stored in.

[0159] Each table generated by the foregoing preset rules corresponds to a sub-table model class. Specifically, you can use ByteBuddy to dynamically generate multiple sub-table model classes, of course, you can also use cglib and javaassist third-party open source class libraries to dynamically generate multiple sub-table model classes. These three class libraries all use asm, an open source class library, which can dynamically manipulate java subsection codes to construct dynamic Java classes

[0160] The registration module 602 is used to register the sub-table model class in the configuration center of the open source framework.

[0161] Registering to the hibernate configuration center can be loaded in a static way, or it can be loaded in a dynamic way. [0162] Hibernate usually scans the Class file according to the relevant configuration information when the web container is started, and then registers it in the SessionFactory. The Java subsection code can be manipulated to construct a dynamic Java class, which is specifically generated by writing java assembly instruction serialization A class file, and then use class loader to load this class file.

[0163] For the class generated during the normal operation of the program after the container startup has been completed, since hibernate cannot recognize this newly created class, the hibernate interface cannot be used directly at this time. At this time, the method of dynamic registration can be adopted. Taking into account security issues, the original SessionFactory is no longer used at this time, but the SessionFactory is obtained to determine whether the sub-table model class is dynamically loaded into the JVM. If it is, the current Configuration is updated and jf creates a SessionFactory.

[0164] The selection module (V3) is used to select the sub-table model class that needs to perform data operations among the sub-table model classes.

[0165] Define a hash method, and select the corresponding sub-table model class according to a specific hash parameter. The hash parameter can be the model primary key Id, or other fields of the model, or a time parameter.

[0166] For example, for a database that records all purchase records of users, if all the records are put into one table, the userbuy table, it is bound to be very huge. Therefore, the purchase records of different users can be put into different sub-tables by performing sub-table processing on the user id. The specific methods are as follows:

[0167] To estimate the business volume, expand the original userbuy table to 100 userbuy_index tables with the same table structure. The original table structure is as shown in Table 1:

[0168] All sub-tables adopt the same table structure. When a new sub-table record needs to be added, the process is as follows: first, perform a hash calculation on the user id to obtain the hash value. The hash value must be 0-99, and the purpose is Write the corresponding user id data into the same sub-table. At this time, the sub-table model class can be selected based on the hash value.

[0169] The execution module 604 is configured to use the data operation function provided by the open source framework to perform corresponding data operations on the instance of the sub-table model class that needs to perform data operations.

[0170] Use the native Hibernate data operation functions such as data addition, data deletion, data modification, and data query to explicitly specify specific sub-table model classes to perform related data operations. By displaying the designated sub-table, the user can clearly specify which sub-table to initiate related data operations, and the user can clearly understand the physical data structure of the data.

[0171] Specifically, the data manipulation function is realized by constructing an instance of the sub-table model class and performing data operations on the instance of the sub-table model class. When constructing an instance of a model class, first select the corresponding sub-table model class according to the hash parameters, then use the reflection method Class.newlnstance () to construct the model instance of the corresponding sub-class, and finally use the set method to fill the object. The reflection method is used because the corresponding sub-table model class is dynamically defined.

[0172] In addition to the above-mentioned modules, the above-mentioned meter-dividing device 60 may optionally, referring to FIG. 7, the meter-dividing device 60 may further include:

[0173] The definition module 701 is used to define a single table model class in the open source framework.

[0174] Specifically, the following code can be added to the Hibernate configuration file hibernate • cfg • xml:

[0175] <properties>

[0176] <property name = "hibernate • hbm2ddl • auto"value = "create〃/>

[0177] </properties>

[0178] By defining the single-table model class in the open source framework, when multiple sub-table model classes are dynamically generated in step S101, the single-table model class code defined in step S201 can be reused, while simplifying code writing , It is easier to maintain the code.

[0179] The meter splitting device in this embodiment is simple to implement, simple to use, has strong comprehensibility, greatly reduces learning costs and maintenance costs, and has performance close to native ORM single meter operations.

[0180] Optionally, referring to FIG. 8, the selection module 603 may include:

[0181] The definition module 801 is used to define a hashing method based on the table-splitting requirements of the database associated with the open source framework; [0182] The acquisition module 802 is used to obtain preset fields of the database associated with the open source framework;

[0183] Operation module 803, configured to perform data operation on the preset field based on the hash method;

[0184] The determination module 804 is configured to determine the sub-table model class that needs to perform data operations according to the result of the data operation.

[0185] Optionally, referring to FIG. 9, the execution module 604 may include:

[0186] The specifying module 901 is used to use the data addition, data deletion, data modification and data query functions provided by the open source framework to explicitly specify the sub-table model classes that need to be operated on to perform related data operations;

[0187] The building module 902 is configured to use the reflection method to build the model instance of the sub-table model class that needs to perform data operations;

[0188] The filling module 903 is configured to use a cluster that does not contain repeated elements to fill the model instance with data. [0189] The function of each module in the embodiments of FIGS. 8-9 corresponds to the content in the corresponding method embodiment, and will not be repeated here.

[0190] FIG. 10 shows a schematic structural diagram of an electronic device 100 provided by an embodiment of the present invention. The electronic device 100 includes at least one processor 1001 (such as a CPU), at least one input and output interface 1004, and a memory 1002. And at least one communication bus 1003, used to realize the connection and communication between these components. The at least one processor 1001 is configured to execute computer instructions stored in the memory 1002, so that the at least one processor 1001 can execute any embodiment of the aforementioned table division method. The memory 1002 is a non-transitory memory (non-transitory memory), which may include a volatile memory, such as a high-speed random access memory (RAM: Random Access Memory), and may also include a non-volatile memory (nonvolatile memory). ), Such as at least one disk storage. The communication connection with at least one other device or unit is realized through at least one input and output interface 1004 (which may be a wired or wireless communication interface).

[0191] In some implementation manners, the memory 1002 stores a program 10021, and the processor 1001 executes the program 10021, which is used to execute the content in any one of the foregoing embodiment of the table splitting method.

[0192] The electronic device may exist in various forms, including but not limited to:

[0193] (1) Mobile communication equipment: This type of equipment is characterized by having a mobile communication function, and its main goal is to provide voice and data communication. Such terminals include: smart phones (such as iPhone), multimedia phones, functional phones, and low-end phones.

[0194] (2) Ultra-mobile personal computer equipment: This type of equipment belongs to the category of personal computers, has calculation and processing functions, and generally also has mobile Internet features. Such terminals include: PDA, MID and UMPC devices, such as iPad.

[0195] (3) Portable entertainment equipment: This type of equipment can display and play multimedia content. Such devices include: audio, video players (such as iPod), handheld game consoles, e-books, as well as smart toys and portable car navigation devices.

[0196] (4) A specific server: a device that provides computing services. The structure of the server includes a processor, hard disk, memory, system bus, etc. The server is similar to a general computer architecture, but because it needs to provide highly reliable services, it is processing Ability, stability, reliability, security, scalability, manageability and other aspects have high requirements.

[0197] (5) Other electronic devices with data interaction functions.

[0198] It should be noted that in this article, relational terms such as first and second are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply these entities. Or there is any such actual relationship or sequence between operations. Moreover, the terms "include", "include" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements not only includes those elements, but also includes those that are not explicitly listed Other elements of, or also include elements inherent to this process, method, article or equipment. Without more restrictions, the element defined by the sentence "including a..." does not exclude the existence of other same elements in the process, method, article, or equipment that includes the element.

[0199] The various embodiments in this specification are described in a related manner, and the same or similar parts between the various embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments.

[0200] In particular, as for the device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and for related parts, please refer to the part of the description of the method embodiment.

[0201] The logic and/or steps represented in the flowchart or described in other ways herein, for example, can be considered as a sequence table of executable instructions for realizing logical functions, and can be embodied in any computer readable In the medium, for use by an instruction execution system, device, or device (such as a computer-based system, a system including a processor, or other systems that can fetch instructions from the instruction execution system, device, or device and execute the instructions), or execute in combination with these instructions System, device or equipment. For the purposes of this specification, a "computer-readable medium" can be any device that can contain, store, communicate, propagate, or transmit a program for use by an instruction execution system, device, or device or in combination with these instruction execution systems, devices, or devices. More specific examples (non-exhaustive list) of computer readable media include the following: electrical connections (electronic devices) with one or more wiring, portable computer disk cases (magnetic devices), random access memory (RAM), Read-only memory (ROM), erasable and editable read-only memory (EPROM or flash memory), fiber optic devices, and portable CD-ROM read-only memory (CDR0M). In addition, the computer-readable medium may even be paper or other suitable medium on which the program can be printed, because it can be used, for example, by optically scanning the paper or other medium, and then editing, interpreting, or other suitable media if necessary. The program is processed in a way to obtain the program electronically and then stored in the computer memory.

[0202] It should be understood that each part of the present invention can be implemented by hardware, software, firmware, or a combination thereof.

[0203] In the foregoing embodiments, multiple steps or methods can be implemented by software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if it is implemented by hardware, as in another embodiment, it can be implemented by any one or a combination of the following technologies known in the art: Discrete logic circuits, application specific integrated circuits with suitable combinational logic gates, programmable gate array (PGA), field programmable gate array (FPGA), etc.

[0204] The above are only specific embodiments of the present invention, but the protection scope of the present invention is not limited thereto. Any person skilled in the art can easily think of changes within the technical scope disclosed in the present invention. Or replacements should be covered within the protection scope of the present invention. Therefore, the protection scope of the present invention should be subject to the protection scope of the claims.

Claims (15)

1. A table splitting method, comprising: dynamically generating a plurality of sub-table model classes; registering the sub-table model class in the configuration center of the open source framework; selecting the sub-table model classes that need to perform data operations Table model classes; use the data operation functions provided by the open source framework to perform corresponding data operations on the sub-table model classes that require data operations; wherein, the sub-table model is registered in the configuration center of the open source framework The class includes: obtaining the session interface file of the open source framework; based on the session interface file, determining whether the sub-table model class is loaded in a dynamic manner; updating when the sub-table model class is loaded in a dynamic manner The configuration file of the open source framework, and the session interface file of the open source framework is recreated. ' 2. The table segmentation method according to claim 1, wherein before the dynamically generating multiple sub-table models, the method further comprises: defining a single-table model class in the open source framework. 3. The table splitting method according to claim 1, wherein the dynamically generating a plurality of sub-table model classes includes: obtaining a table splitting requirement of a database associated with the open source framework;'based on the table splitting requirement, Use third-party open source class libraries to dynamically generate multiple sub-table model classes. 4. The table segmentation method according to claim 1, wherein the registering the sub-table model class in the configuration center of the open source framework comprises: generating a class file corresponding to the sub-table model class; The class file is stored in the preset scanning position of the open source framework. 5. The table segmentation method according to claim 3, wherein the selecting the sub-table model class that needs to perform data operations among the sub-table model classes comprises: table sub-table based on the database associated with the open source framework Demand-defined hashing method; obtaining preset fields of the database associated with the open source framework; performing data operations on the preset fields based on the hashing method; determining the sub-tables that require data operations based on the results of the data operations Model class. 6. The table segmentation method according to claim 1, wherein the data operation function provided by the open source framework is used to perform a corresponding data operation on the instance of the sub-table model class that requires data operation, Including: Use the data addition, data deletion, data modification and data query functions provided by the open source framework to explicitly specify the sub-table model class that needs to perform data operations to perform related data operations. 7. The table segmentation method according to claim 6, wherein the data operation function provided by the open source framework is used to perform a corresponding data operation on the instance of the sub-table model class that requires data operation, It also includes: using a reflection method to construct a model instance of the sub-table model class that requires data manipulation; and using a class set that does not contain repeated elements to fill the model instance with data. 8. A table splitting device, characterized in that it includes: a generating module for dynamically generating a plurality of sub-table model classes; a registration module for registering the sub-table model classes in the configuration center of the open source framework; a selection module for using To select the sub-table model classes that need to perform data operations among the sub-table model classes; the execution module is used to use the data manipulation functions provided by the open source framework to perform data exploration on the sub-table model classes that need to be processed The instance of executes the corresponding data operation•, where the registration module is also used to: obtain the session interface file of the open source framework; based on the session interface file, determine whether the sub-table model class is loaded in a dynamic manner When the sub-table model class is loaded in a dynamic manner, the configuration file of the open source framework is updated, and the session interface file of the open source framework is recreated. 9. The meter segmentation device according to claim 8, wherein the device further comprises: a definition module, configured to define a single meter model class in the open source framework. 10. The meter splitting device according to claim 8, wherein the generating module is further configured to: obtain a meter splitting requirement of a database associated with the open source framework; based on the meter splitting requirement, use a third-party open source The class library dynamically generates multiple sub-table model classes. 11. The meter segmentation device according to claim 8, wherein the registration module is further configured to: generate a class file corresponding to the sub-table model class; save the class file in the open source framework Preset scan position. 12. The table segmentation device according to claim 10, wherein the selection module comprises: a definition module for defining a hash method based on the table segmentation requirements of the database associated with the open source framework; To obtain the preset fields of the database associated with the open source framework; an arithmetic module for performing data operations on the preset fields based on the hashing method; a determining module for determining the need to perform operations based on the results of the data operations The sub-table model class for data manipulation. 13. The metering device according to claim 8, wherein the execution module comprises: a designated module for using the data addition, data deletion, data modification and data query functions provided by the open source framework to display The formula specifies the sub-table model class that needs to perform data operations to perform related data operations. 14. The table segmentation device according to claim 13, wherein the execution module further comprises: a building module, which is used to construct a model instance of the sub-table model class that needs to perform data operations by using a reflection method; filling The module is used to fill the model instance with data using a cluster that does not contain repeated elements. ' 15. An electronic device, wherein the electronic device includes: at least one processor; The instructions executed by the processor, the instructions are executed by the at least one processor, so that the at least one processor can execute the table splitting method according to any one of the preceding claims -17. ie. A non-transitory computer-readable storage medium storing computer instructions for causing the computer to execute the metering method according to any one of the preceding claims 1-7.