Method and system for database partition

A non-transitory computer readable article of manufacture tangibly embodying computer readable instructions which, when executed, cause a computer device to implement a method of partitioning data stored in a database, the method comprising:

• acquiring at least one data partition rule from a set of data partition rules stored in the database, wherein
• each rule of the set of data partition rules comprises at least one data partition condition for a given database partition of a database,
• the at least one data partition condition indicates at least one condition to be satisfied by data items for association with the given database partition;
• pre-calculating a set of data partition keys, wherein the pre-calculating comprises:
• creating a given table in the database, wherein the given table is initially empty;
• selecting a set of random data partition keys;
• inserting each key of the set of random data partition keys into the given table that is empty;
• querying, for each key of the set of random data partition keys inserted into the given table, the database for a partition number which corresponds to the inserted data partition key, wherein the querying at least sends one or more queries to the database comprising at least one key of the set of random data partition keys inserted into the table;
• receiving, based on the querying, the partition number for each of the set of random data partition keys inserted into the table;
• and
• storing each number of the partition numbers and each key of the set of random data partition keys in a match table, wherein the match table is separate and distinct from a given database partition associated with the partition numbers and the set of random data partition keys;
• identifying, based on the at least one data partition rule and the match table, a data partition key associated with the given database partition;
• associating, based on the identifying, the data partition key with the at least one data partition condition;
• determining that at least one data item stored in the database satisfies the at least condition of the at least one data partition condition;
• adding, based on the determining, the data partition key associated with the at least one data partition condition to the at least one data item;
• and
• storing, based on the adding, the at least one data item in the given database partition according to the data partition key of the at least one data item.

A computer implemented method utilizing at least one computer processor for querying a database, the method comprising:

• acquiring a data query request;
• parsing the data query request;
• identifying, based on the parsing, at least one column value of the data query request;
• comparing the column value to a set of data partition rules stored in the database, wherein
• each rule of the set of data partition rules comprises at least one data partition condition for a given database partition of the database,
• the data partition condition indicates at least one condition to be satisfied by data items for association with the given database partition, and
• each rule of the set of data partition rules further comprises an identifier of the given database partition and is separate and distinct from the given database partition;
• determining, based on the comparing, that the column value satisfies the at least one data partition condition of at least one data partition rule in the set of data partition rules;
• identifying, based on the determining, a data partition key from the at least one data partition rule comprising the at least one data partition condition that has been satisfied;
• modifying, prior to processing the data query request against the database, the data query request to include the data partition key, the modifying comprising adding at least one predicate to the data query request comprising the data partition key;
• and
• sending the data query request comprising the data partition key to the database.

An information processing system for partitioning data stored in a database, the information processing system comprising:

• a processor implemented at least partially by hardware;
• a memory communicatively coupled to the processor;
• and
• a data partitioning system communicatively coupled to the processor and the memory, wherein the data partitioning system is configured to perform a method comprising:
• acquiring at least one data partition rule from a set of data partition rules stored in the database, wherein
• the set of data partition rules includes at least one rule defined based on at least one of
• data query frequency in the database, and
• feedback information comprising statistical information associated with data queries performed on the database,
• each rule of the set of data partition rules comprises at least one data partition condition for a given database partition of the database,
• the at least one data partition condition indicates at least one condition to be satisfied by data items for association with the given database partition;
• identifying, based on the data partition rule, a data partition key associated with the given database partition;
• associating, based on the identifying, the data partition key with the at least one data partition condition;
• determining that at least one data item stored in the database satisfies the at least one condition of the at last one data partition condition;
• adding, based on the determining, the data partition key associated with the at least one data partition condition to the data item, wherein the adding comprises adding a column comprising the data partition key to at least one data item table in the database comprising the data item;
• and
• storing, based on the adding, the data item in the given database partition according to the data partition key of the data item.