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

A meter distribution method, device and electronic equipment

technical field

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

Background technique

Hibernate is an open-source persistence middleware based on Java, and JDBC (Java Data Base Connectivity Java database connection) has been done lightweight encapsulation. 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 database, thus improving the development efficiency.

Table sub-table is a method of cutting a large table into multiple tables of the same database, and resisting performance impact due to excessive data volume. The inventor found in the process of implementing the present invention that the Hibernate e-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 Query Interceptor is a query interceptor provided by Hibernate. Users can intercept SQL statements when they are generated, and dynamically replace the corresponding table names with specific sub-tables. SQL statements need to be parsed, which is complicated to implement and poor in performance and maintainability. Moreover, the table name cannot be dynamically determined according to the instance parameters. Generally, the user can only divide the table by time.

Therefore, need a kind of more simple and effective sub-table processing method based on Hibernate.

Contents of the invention

Summary of the invention In view of this, the embodiment of the present invention provides a kind of table sub-method, device and electronic equipment, at least partially solve the problems existing in the prior art.

First aspect, the embodiment of the present invention provides a kind of sub-table method, comprising:

A plurality of sub-table model classes are dynamically generated;

Register described sub-table model class in the configuration center of open source framework;

Select the sub-table model class that needs to carry out data operation in described sub-table model class;

Utilize the data operation function that described open-source framework provides, carry out corresponding data operation to the instance of the sub-table model class that needs to carry out data operation.

According to a kind of specific implementation of the embodiment of the present invention, before described dynamically generating a plurality of sub-table model classes, described method also includes:

[0012] Define the single-table model class in the open-source framework.

According to a kind of concrete implementation of the embodiment of the present invention, described dynamic generation multiple sub-table model classes, comprise:

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

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

According to a kind of specific implementation mode of the embodiment of the present invention, described in the configuration center of open source framework, described sub-table model class is registered, comprising:

Generate the class file corresponding to the sub-table model class;

[0018] The class file is stored in the preset scanning position of the open source framework.

According to a kind of specific implementation mode of the embodiment of the present invention, described in the configuration center of open source framework, described sub-table model class is registered, comprising:

Obtain the session interface file of described open source framework;

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

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.

According to a kind of specific implementation mode of the embodiment of the present invention, the sub-table model class that needs to carry out data operation in the described sub-table model class of described selection, comprises:

Based on the sub-table requirement definition hash method of the database associated with the open source framework;

Obtain the preset field of the database associated with the open source framework;

Carry out data operation to described preset field based on described hash method;

[0027] According to the result of the data operation, the sub-table model class that needs to be operated on is determined.

According to a kind of specific implementation mode of the embodiment of the present invention, described utilize the data operation function that described open-source framework provides, carry out corresponding data operation to the instance of the subtable model class described needing to carry out data operation, comprising:

Use the data increase, data deletion, data modification and data query function provided by the open source framework, explicitly specify the sub-table model classes that need to perform data operations to perform relevant data operations.

According to a kind of concrete implementation mode of the embodiment of the present invention, described utilize the data operation function that described open source framework provides, carry out corresponding data operation to the instance of the sub-table model class that needs to carry out data operation, also include :

Use reflection method to build the model instance of the sub-table model class that needs to carry out data operation;

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

Second aspect, the embodiment of the present invention also provides a kind of sub-table device, comprising:

Generating module, for dynamically generating a plurality of sub-table model classes;

Registration module, for registering described sub-table model class in the configuration center of open source framework;

Selection module, for selecting the sub-table model class that needs to carry out data operation in described sub-table model class;

Executing module is used for utilizing the data operation function that described open source framework provides, to the described needing to carry out data operation The example of subtable model class carries out corresponding data operation.

According to a kind of specific implementation of the embodiment of the present invention, described device also comprises:

Define module, be used for defining single table model class in described open source framework.

According to a kind of concrete implementation of the embodiment of the present invention, described generating module is also used for:

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

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

According to a kind of specific implementation mode of the embodiment of the present invention, described registration module is also used for:

Generate the class file corresponding to the sub-table model class;

[0045] The class file is stored in the preset scanning position of the open source framework.

According to a kind of concrete implementation of the embodiment of the present invention, described registration module is also used for:

Obtain the session interface file of described open source framework;

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

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.

According to a kind of specific implementation of the embodiment of the present invention, described selection module comprises:

Definition module, for the sub-table requirement definition hash method based on the database associated with the open source framework;

Obtaining module, for obtaining the preset field of the database associated with described open source framework;

Operation module, for carrying out data operation to described preset field based on described hash method;

[0054] Determining module, for determining 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 of the embodiments of the present invention, the execution module includes:

Appointed module, for using the data increase that described open source framework provides, data deletion, data modification and data inquiry function, explicitly designate the sub-table model class that needs to carry out data operation to carry out relevant data operation.

[0057] According to a specific implementation of the embodiments of the present invention, the execution module also includes:

Building block, for using reflection method to construct the model instance of the sub-table model class that needs to carry out data operation;

[0059] A filling module, configured to fill the model instance with data using a class set that does not contain repeated elements.

In a third aspect, the embodiment of the present invention also provides a kind of electronic equipment, and this electronic equipment comprises:

at least one processor; and,

A memory connected in communication with the at least one processor; wherein,

[0063] The memory stores instructions that can be executed 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 perform any of the aforementioned first aspects or any implementation of the first aspect The sub-table method in the method.

[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 stores computer instructions, and the computer instructions are used to enable the computer to execute the aforementioned first A table-splitting method in any implementation manner of the aspect or the first aspect.

In the fifth aspect, the embodiment of the present invention also provides a computer program product, the computer program product includes a computing 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 made to execute the table splitting method in the aforementioned first aspect or any implementation manner of the first aspect.

The sub-table method, device, electronic equipment, non-transitory computer-readable storage medium and computer program that the embodiment of the present invention provides, by dynamically generating a plurality of sub-table model classes and combining the data operation function of Hibernate, and then being able to Under the premise of obviously affecting the performance and maintainability, the function of realizing 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 comprehension is strong, and the learning cost and maintenance cost are greatly reduced. The technical effect improves the efficiency of sub-metering on the whole.

Description of drawings

In order to illustrate the technical scheme of the embodiment of the present invention more clearly, the accompanying drawing that needs to use in the embodiment will be briefly introduced below, obviously, the accompanying drawing in the following description is only some embodiments of the present invention , for those skilled in the art, other drawings can also be obtained based on these drawings without creative work.

Fig. 1 is the schematic flow chart of a kind of sub-table method that the embodiment of the present invention provides;

Fig. 2 is the schematic flow chart of another kind of sub-table method that the embodiment of the present invention provides;

Fig. 3 is that a kind of dynamic loading child table model class that the embodiment of the present invention provides is to the flow diagram of Hibernate configuration center;

Fig. 4 is a kind of hash-based sub-table model class selection flow schematic diagram that the embodiment of the present invention provides;

Fig. 5 is a kind of schematic flow chart that carries out corresponding data operation to the instance of subtable model class that the embodiment of the present invention provides;

Fig. 6 is a schematic block diagram of a kind of sub-table device provided by the embodiment of the present invention;

Fig. 7 is a schematic block diagram of another kind of sub-table device provided by the embodiment of the present invention;

Fig. 8 is a schematic block diagram of a selection module provided by an embodiment of the present invention;

Fig. 9 is a schematic block diagram of an execution module provided by an embodiment of the present invention;

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

detailed description

[0078] The embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings.

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

Fig. 1 is a kind of sub-table method that the embodiment of the present invention provides, referring to Fig. 1, this method comprises the following steps:

[0081] S101, dynamically generate a plurality of sub-table model classes.

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

(1) sub-table by natural time

As the statistical data volume of a business reaches certain scale (as about 2,000,000), then just can consider using the data of one year to store as a table, for example, the name of table is app, then the data in 2010 is app_2010, app— 2011, . . •. Of course, other time methods can also be used, such as dividing according to the month, such as app_2010_01, app_2010-02, ....

(2) sub-table by digital type hash

For example, if the information of the user is to be stored, and the amount of business data is very large, the storage requirement cannot be met with a single table, then the user's numbering can be used for hashing, and it is common to use the remainder operation, If you want to store user information in 30 tables, then user 1%30 = 1 with user number 1, then it will be stored in user_01 table, if the user number is 500, then 500%30 = 20, the user's The information is stored in the user_20 table.

(3) sub-table by md5 value

Assuming that the file uploaded by the user is to be stored, if the upload volume is large, the bottleneck problem of the system will also be brought. For example, if there are more than 20,000 files in a database table, the browsing efficiency of the file will be reduced. At this time, you can use the user name of the file to md5 or use the md5 check value of the file to do it. You can use the first 3 digits of !^5 to do the hash, so that we can get 16~3 = 40% of the tables at most, each When storing a file for the first time, 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.

[0089] Each table generated by the above preset rules corresponds to a sub-table model class. Specifically, ByteBuddy can be used to dynamically generate multiple sub-table model classes, and 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 the open source class library asm, 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] Registering to the hibernate configuration center can be loaded in a static mode or in a dynamic mode. Hibernate usually scans the Class file according to the relevant configuration information when the web container starts, and then registers in the SessionFactory, and can operate the Java subsection code to construct the dynamic Java class, which is specifically generated by the assembly instruction serialization of writing Java A class file, and then use classloader to load this class file.

After the container start has been completed, the class produced during the normal operation of the program, because Hibernate cannot recognize this newly created class, the interface of Hibernate cannot be directly used this moment. This can be done by means of dynamic registration. Considering security issues, instead of using the existing SessionFactory, obtain the SessionFactory to determine whether the subtable model class is dynamically loaded into the JVM. If so, update the current Configuration and recreate a SessionFactory.

[0094] S103. Select the sub-table model class that needs to be operated on in the sub-table model class.

Define hash method, select corresponding sub-table model class according to specific hash parameter, this hash parameter can be Model primary key Id, also can be other fields of model, can also be time parameter etc.

For example, such as for the database of all purchase records of record user, if all records are put into a table userbuy table, certainly will be very huge. Therefore, the purchase records of different users can be put into different sub-tables by sub-table processing of user id. The specific method is as follows:

Estimate business volume, with initial userbuy table, be expanded into the userbuy_index table of 100 identical table structures, former table structure is as follows:

Table one userbuy table data structure

_field | type | Null | healthy 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

[0100] All sub-tables adopt exactly the same table structure. When a new sub-table record needs to be added, the process is as follows: first, the user id is hash calculated to obtain a hash value. This hash value must be 0-99, and the purpose is to 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.

S104, utilize the data operation function that described open-source framework provides, carry out corresponding data operation to the instance of the sub-table model class that needs to carry out data operation.

Use original Hibernate data to increase, data deletion, data modification, and data query and other data manipulation functions, explicitly designate specific sub-table model classes to carry out relevant data manipulations. By displaying the specified 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.

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

In the process of realizing sub-table, except steps S101～S104 in the above-mentioned embodiment, optional, referring to Fig. 2, this sub-table method can also comprise the following steps:

[0105] S201, define a single table model class in the open source framework.

Concrete, can add following code in the configuration file hibernate.cfg.xml of Hibernate:

<properties>

<property name=''hibernate.hbm2ddl • auto"value="create"/>

[0109] </properties>

By defining the single-table model class in the open source framework, when a plurality of sub-table model classes dynamically generated in step S101, the single-table model class code defined in step S201 can be reused, writing in simplified code At the same time, it is easier to maintain the code.

The sub-table method in the present embodiment is simple to implement, easy to use, has strong comprehensibility, greatly reduces the learning cost and maintenance cost, and the performance is close to the original ORM single-table operation.

Optionally, the embodiment of the present invention also provides a kind of method of dynamically loading subtable model class to Hibernate configuration center, referring to Fig. 3, the method comprises the steps:

[0113] S301. Obtain the 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 〇;

Configuration instance config can construct SessionFactory instance and return according to current configuration information.

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

[0119] Specifically, a Map can be obtained through the getAllClassMetadata method of the SessionFactory, the key of the Map is the name of the entity class, and the value is the ClassMetadata object, by judging whether the map.keySet () contains the mode of the sub-table model class It is judged 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〇)){ }

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.

Concrete, can update the configuration file of Wibernate by setting function configuration.addAnnotatedClass (), and recreate the SessionFactory of Hibernate by setting function sessionFactoryList.add ().

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

Referring to Fig. 4, the embodiment of the present invention also provides a kind of subtable model class selection method based on hash, comprises the following steps:

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

According to concrete sub-table requirement, define hashing method, take the database form structure shown in Table 1 as example, the table of database will be divided into 100 sub-tables, at this moment, can choose to use Crc32 mode to carry out hash calculation.

[0127] S402. Acquire the preset fields of the database associated with the open source framework.

Specifically, any field in Table 1 can be adopted to carry out 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.

The crc32 calculation result is a decimal number, under the operating system of different bit positions, the value obtained may be different, so it is carried out a unified process, then this natural number is carried out to get remainder calculation, take remainder The divisor is the sub-table number, for example, 100 here.

[0131] S404, determine the sub-table model class that needs to be operated on according to the result of the data operation.

By calculating the preset field of the database, a table suffix number index within 0-99 has been obtained, and 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 above-mentioned embodiment, a single table can be more evenly distributed to each sub-table.

Referring to Fig. 5, the embodiment of the present invention also provides a kind of method that carries out corresponding data operation to the instance of subtable model class, comprises the steps:

[0135] S501, use the data addition, data deletion, data modification and data query functions provided by the open source framework to explicitly designate the sub-table model classes that require data operations to perform related data operations.

Use native Hibernate data to increase, data deletion, data modification, and data query and other data manipulation functions, explicitly designate specific sub-table model classes to carry out relevant data manipulations. By displaying the specified 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.

Taking the deletion operation of the sub-table model class as an example, the following code can be adopted to carry out:

[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 requires data manipulation.

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

[0145] S503. Fill the model instance with data using a cluster that does not contain repeated elements.

Concrete, can adopt and use set method to carry out data filling to described model instance, such as:

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

[0148] user setName ("user_modified")

By the method in this embodiment, can specify the sub-table model class that needs to carry out data operation by explicit mode and carry out relevant data operation.

Fig. 6 is a kind of sub-table device provided by the embodiment of the present invention, referring to Fig. 6, the device includes:

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

After the data capacity in the database develops to a certain extent, in order to improve the response speed of the database, the 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:

(1) sub-table by natural time

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

(2) sub-table by digital type hash

For example, if the user's information is to be stored, and the amount of business data is very large, the storage requirement cannot be met with a single table, then the user's numbering can be used for hashing, and it is common to use the remainder operation, If you want to store user information in 30 tables, then user 1%30 = 1 with user number 1, then it will be stored in the user_01 table. If the user number is 500, then 500% 30 = 20, the user's The information is stored in the table user_20.

(3) divide table by md5 value

Assuming that the files uploaded by the user are to be stored, if the upload volume is large, it will also bring about a bottleneck problem in the system. 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 check value of the file to do it. You can use the first 3 digits of md5 to do the hash, so that we can get 16~3 = 4096 tables at most, 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 above preset rules corresponds to a sub-table model class. Specifically, you can use ByteBuddy to dynamically generate multiple sub-table model classes, and 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 the open source class library asm, which can dynamically manipulate java subsection codes to construct dynamic Java classes

[0160] The registration module 602 is configured 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 mode or in a dynamic mode. Hibernate usually scans the Class file according to the relevant configuration information when the web container starts, and then registers in the SessionFactory, and can operate the Java subsection code to construct the dynamic Java class, which is specifically generated by serializing the assembly instructions of writing java A class file, and then use the class loader to load this class file.

After the container startup has been completed, the class produced during the normal operation of the program, because hibernate cannot recognize this newly created class, the interface of hibernate cannot be directly used this moment. At this time, dynamic registration can be used. Considering 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 so, update the current Configuration and recreate a SessionFactory with jf.

[0164] The selection module (5) is used to select the sub-table model classes that need to perform data operations in the sub-table model classes.

Define hash method, select corresponding sub-table model class according to specific hash parameter, this hash parameter can be model primary key Id, also can be other fields of model, can also be time parameter etc.

For example, such as for the database of all purchase records of record user, if all records are put into a table userbuy table, certainly will be very huge. Therefore, the purchase records of different users can be put into different sub-tables by sub-table processing of user id. The specific method is as follows:

Estimate business volume, with initial userbuy table, be extended to the userbuy_index table of 100 identical table structures, former table structure is as shown in Table 1:

All sub-tables adopt identical table structure, when needing to add a sub-table record, process is as follows: first user id is carried out hash calculation, obtains hash value, and this hash value must be 0-99, 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.

Execution module 604 is used for utilizing 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 requires data operations.

Use original Hibernate data increase, data deletion, data modification, and data query and other data manipulation functions to explicitly specify specific sub-table model classes to perform related data manipulations. By displaying the specified 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.

Specifically, by constructing the instance of the sub-table model class, and performing data manipulation on the instance of the sub-table model class to realize the data operation function. When constructing an instance of a model class, first select the corresponding subtable model class according to the hash parameter, 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. The reflection method is used because the corresponding child table model classes are defined dynamically.

Above-mentioned sub-table device 60, except comprising above-mentioned module, optional, referring to Fig. 7, sub-table device 60 can also comprise:

[0173] Definition module 701 is used to define the single form model class in the open source framework.

Concrete, can add following code in the configuration file hibernate·cfg·xml of Hibernate:

<properties>

<property name="hibernate • hbm2ddl • auto" value="create"/>

[0177] </properties>

By defining the single-table model class in the open source framework, when a plurality of sub-table model classes dynamically generated in step S101, the single-table model class code defined in step S201 can be reused, while simplifying code writing , making it easier to maintain the code.

The sub-table device in this embodiment is simple to implement, easy to use, has strong comprehensibility, greatly reduces learning costs and maintenance costs, and has performance close to the original ORM single-table operation.

Optionally, referring to Fig. 8, selection module 603 may include:

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

Operation module 803, for carrying out data operation to described preset field based on described hash method;

Determining module 804, is used for determining the subtable model class that needs to carry out data operation according to the result of described data operation.

Optionally, referring to Fig. 9, execution module 604 may include:

Appointment module 901, for using the data increase that described open source framework provides, data deletion, data modification and data query function, explicitly designate the sub-table model class that needs to carry out data operation to carry out relevant data operation;

Construction module 902, for using reflection method to construct the model instance of the sub-table model class that needs to carry out data operation;

[0188] The filling module 903 is configured to fill the model instance with data using a class set that does not contain repeated elements. The function of each module in the embodiment of Fig. 8-9 is corresponding to the content in its corresponding method embodiment, repeats no more 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 connection and communication between these components. At least one processor 1001 is configured to execute the computer instructions stored in the memory 1002, so that the at least one processor 1001 can execute any of the aforementioned embodiments of the table splitting 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 nonvolatile 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).

In some implementations, the memory 1002 stores the program 10021, and the processor 1001 executes the program 10021, which is used to execute the content in any of the aforementioned embodiments of the sub-table method.

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

(1) Mobile communication equipment: the feature of this type of equipment is to possess mobile communication function, and to provide voice and data communication as the main goal. Such terminals include: smart phones (such as iPhone), multimedia phones, feature phones, and low-end phones.

(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 possesses the characteristics of mobile Internet access. Such terminals include: PDA, MID and UMPC equipment, such as iPad.

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

(4) Specific server: the equipment that provides computing service, the composition of server comprises processor, hard disk, internal memory, system bus etc., server and general computer architecture are similar, but because need provide highly reliable service, therefore in processing Higher requirements in terms of capability, stability, reliability, security, scalability, and manageability.

(5) other electronic equipment with data interaction function.

[0198] It should be noted that, in this article, relational terms such as first and second etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply that these entities or operations, any such actual relationship or order exists. Furthermore, the term "comprises", "comprises" or any other variation thereof is intended to cover a non-exclusive inclusion such that a process, method, article, or apparatus comprising a set of elements includes not only those elements, but also includes elements not expressly listed. other elements of or also include elements inherent in such a process, method, article, or device. Without further limitations, an element defined by the phrase "comprising a ..." does not exclude the presence of additional identical elements in the process, method, article or apparatus comprising said element.

Each embodiment in this description is described in a relevant manner, and the same and similar parts between the various embodiments can be referred to each other, and what each embodiment focuses on is the difference with other embodiments.

Especially, for the device embodiment, because it is basically similar to the method embodiment, so the description is relatively simple, and relevant parts can refer to the part description of the method embodiment.

[0201] The logic and/or steps represented in a flowchart or otherwise described herein, for example, may be considered as a sequenced listing of executable instructions for implementing logical functions, and may be embodied in any computer-readable medium for use in, or in connection with, an instruction execution system, apparatus, or device (such as a computer-based system, system including a processor, or other system capable of fetching and executing instructions from an instruction execution system, apparatus, or device) system, device or equipment. For the purposes of this specification, a "computer-readable medium" may be any device that can contain, store, communicate, propagate or transmit a program for use in or in conjunction with an instruction execution system, device or device. More specific examples (non-exhaustive list) of computer-readable media include the following: electrical connection with one or more wires (electronic device), portable computer disk case (magnetic device), random access memory (RAM), Read Only Memory (ROM), Erasable and Editable Read Only Memory (EPROM or Flash Memory), Fiber Optic Devices, and Portable Compact Disk 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, since the program can be read, for example, by optically scanning the paper or other medium, followed by editing, interpretation or other suitable processing if necessary. The program is processed electronically and stored in computer memory.

[0202] It should be understood that various parts of the present invention may be implemented by hardware, software, firmware or a combination thereof.

[0203] In the above-described embodiments, various steps or methods may be implemented by software or firmware stored in memory and executed by a suitable instruction execution system. For example, if it is implemented in 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, ASICs with suitable combinational logic gates, programmable gate arrays (PGAs), field programmable gate arrays (FPGAs), etc.

The above is only the specific embodiment of the present invention, but the scope of protection of the present invention is not limited thereto, and any skilled person familiar with the technical field can easily think of changes within the technical scope disclosed in the present invention Or replacement, all should be covered within the protection scope of the present invention. Therefore, the protection scope of the present invention should be based on the protection scope of the claims.

Claims (15)

1. A sub-table method is characterized in that, comprising: dynamically generating a plurality of sub-table model classes; registering the sub-table model classes in the configuration center of the open source framework; selecting the sub-table model classes that need to be operated on in the sub-table model classes Table model class; use the data operation function provided by the open source framework to perform corresponding data operations on the subtable model class that needs data operation; wherein, register the subtable model in the configuration center of the open source framework class, including: obtaining the session interface file of the open source framework; based on the session interface file, judging whether the sub-table model class is dynamically loaded; when the sub-table model class is dynamically loaded, updating The configuration file of the open source framework, and recreate the session interface file of the open source framework. ' 2. sub-table method according to claim 1, is characterized in that, before described dynamic generation multiple sub-table models, described method also comprises: Define single table model class in described open source framework. 3. The table sub-method according to claim 1, wherein the dynamic generation of a plurality of sub-table model classes comprises: Obtaining the sub-table requirements of the database associated with the open source framework; 'Based on the sub-table requirements, Use the third-party open source class library to dynamically generate multiple sub-table model classes. 4. The sub-table method according to claim 1, wherein the registration of 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; Class files are saved in the preset scan locations of the open source frameworks. 5. The table subdivision method according to claim 3, wherein the selection of subtable model classes that require data manipulation in the subtable model classes includes: Subtable based on the database associated with the open source framework Requirements define a hashing method; obtain the preset fields of the database associated with the open source framework; perform data operations on the preset fields based on the hashing method; determine the sub-tables that need to be operated on according to the results of the data operations model classes. 6. The table sub-method according to claim 1, wherein the data operation function provided by the open source framework is used to perform corresponding data operations on the instance of the sub-table model class that requires data operations, Including: using the data addition, data deletion, data modification and data query functions provided by the open source framework, and explicitly specifying the sub-table model classes that need to perform data operations to perform related data operations. 7. The table subdivision method according to claim 6, wherein the data operation function provided by the open source framework is used to perform corresponding data operations on the instance of the subtable model class that requires data operations, It also includes: constructing a model instance of the sub-table model class that requires data manipulation using a reflection method; filling the model instance with data using a class set that does not contain repeated elements. 8. A sub-table device, is characterized in that, comprises: Generation module, is used for dynamically generating a plurality of sub-table model classes; Registration module, is used for registering described sub-table model class in the configuration center of open source framework; Selection module, uses To select the sub-table model class that needs to perform data operation in the sub-table model class; the execution module is used to use the data operation function provided by the open source framework to perform data manipulation on the sub-table model class that requires data manipulation The instance executes the corresponding data operation •, wherein 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 subtable 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. 9. The table subdivision device according to claim 8, further comprising: a definition module, configured to define a single table model class in the open source framework. 10. The sub-table device according to claim 8, wherein the generating module is also used for: Obtaining the sub-table requirements of the database associated with the open source framework; Based on the sub-table requirements, using a third-party open source The class library dynamically generates multiple child table model classes. 11. The sub-table device according to claim 8, wherein the registration module is also used for: generating a class file corresponding to the sub-table model class; storing the class file in the open source framework Preset scan position. 12. The sub-table device according to claim 10, wherein the selection module includes: a definition module for defining a hash method based on the sub-table requirements of the database associated with the open source framework; an acquisition module for Obtaining the preset fields of the database associated with the open source framework; an operation module, configured to perform data operations on the preset fields based on the hash method; Subtable model class for data manipulation. 13. The meter subdivision device according to claim 8, wherein the execution module includes: a specified 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 sub-table device according to claim 13, wherein the execution module further comprises: a building module, configured to use a reflection method to construct a model instance of the sub-table model class that requires data manipulation; filling A module for populating said model instance with data using a collection of classes that do not contain repeated elements. ' 15. An electronic device, characterized in that the electronic device comprises: at least one processor; and, a memory connected in communication with the at least one processor; wherein, the memory stores information that can be processed by the at least one processor The instruction executed by the processor, the instruction is 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 1-7. ie. A non-transitory computer-readable storage medium, the non-transitory computer-readable storage medium stores computer instructions, and the computer instructions are used to cause the computer to execute the table splitting method described in any one of claims 1-7.