DATA ALLOCATION CONTAINERS IN A PARTITIONED TABLE OF A COMPUTER DATABASE SYSTEM FOR HOLDING DATA BASED ON USAGE
First Claim
1. An apparatus comprising:
- at least one processor;
a memory coupled to the at least one processor;
a database residing in the memory having data in at least one partitioned database table divided into a plurality of data allocation containers (DACs); and
a database manager with a DAC manager residing in the memory and executed by the at least one processor that determines which of the plurality of DACs to place rows of data into based on usage of the rows of data in past queries from data usage information stored in the rows of the data of the DACs.
1 Assignment
0 Petitions
Accused Products
Abstract
An apparatus and method utilize partitioned database tables divided into data allocation containers (DACs) where data is placed into the DACs based on usage of the data in past queries. Records that are used most often are placed together and records that are used less often are placed together to improve database performance. In preferred embodiments, a database manager determines where to place data into the DACs based on how often the data is selected by a database query using a DAC selection ratio (DSR). The database manager may determine when to perform table maintenance to move rows of data to the appropriate DACs based on a timestamp or last check date (LCD) stored in the database.
-
Citations
20 Claims
-
1. An apparatus comprising:
-
at least one processor; a memory coupled to the at least one processor; a database residing in the memory having data in at least one partitioned database table divided into a plurality of data allocation containers (DACs); and a database manager with a DAC manager residing in the memory and executed by the at least one processor that determines which of the plurality of DACs to place rows of data into based on usage of the rows of data in past queries from data usage information stored in the rows of the data of the DACs. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9-16. -16. (canceled)
-
17. A program product comprising:
-
a database manager with a data allocation container (DAC) manager, wherein the DAC manager determines which of a plurality of DACs to place rows of data into based on usage of the rows of data in past queries from data usage information stored in the rows of the data of the DACs, wherein the plurality of DACs include a high priority DAC placed in a memory device with a faster access time and a low priority DAC placed in a memory device with a slower access time; and non-transitory computer-readable media bearing the database manager and the DAC manager. - View Dependent Claims (18, 19, 20)
-
Specification