Patent attributes
A database-management system (DBMS) dynamically adjusts the logical and physical partitioning of data stored in database tables. An artificially intelligent DBMS partition manager draws expert inferences from the DBMS's current workload, execution logs, and data statistics, in order to identify ranges of database key values that are frequently accessed by incoming queries. The ranges are allocated to logical partitions that are then mapped to physical partitions, such that database records identified by a pair of subranges are stored in proximate areas of physical storage. This partitioning reduces the number of physical-storage accesses by populating each physical partition with records likely to be accessed together. The partition manager splits and merges the logical and physical partitions to ensure that the size of each partition falls within a predetermined range and continues to update the physical partitioning in a similar manner by drawing additional inferences from subsequent DBMS workloads, logs, and statistics.
