Method and apparatus for storing and accessing data records on solid state disks
AssigneeInternational Business Machines Corporation
InventorsYuan-Chi Chang, Christian Alexander Lang
Life of this patent
Estimating the term…
Abstract
A computer implemented method, computer program product and data processing system, for optimizing a layout of a relational database on a solid state disk. The optimized layout comprises forming a plurality of column to disk block assignments, wherein each disk block is assigned substantially the same amount of column data. A column having a size less than a greatest size of any disk block is assigned to one of a plurality of disk blocks. A column having a size greater than or equal to the greatest size of any disk block is allowed a multiple disk block assignment.
Claims20
A computer implemented method for optimizing a database layout on a solid state disk, the method comprising:
- responsive to a column having a size less than a greatest size of any disk block in the solid state disk, creating a plurality of column to disk block assignments by assigning each column of a plurality of columns in a set of data records to one of a plurality of disk blocks on a disk page, wherein each disk block is assigned substantially a same amount of column data;
- and
- responsive to the column having a size greater than or equal to the greatest size of any disk block, creating a multiple disk block assignment if needed for the column.
A computer program product comprising:
- a computer usable medium including computer usable program code for optimizing a database layout on a solid state disk, said computer program product comprising:
- computer usable program code for creating a plurality of column to disk block assignments by assigning each column of a plurality of columns in a table of data records to one of a plurality of disk blocks on a disk page, wherein each disk block is assigned substantially a same amount of column data, responsive to a column having a size less than a greatest size of any disk block;
- and
- allowing a multiple disk block assignment, responsive to the column having a size greater than or equal to the greatest size of any disk block.
A data processing system comprising:
- a bus system;
- a communications system connected to the bus system;
- a memory connected to the bus system, wherein the memory includes a set of instructions;
- and
- a processing unit connected to the bus system, wherein the processing unit executes the set of instructions to create a plurality of column to disk block assignments by assigning each column of a plurality of columns in a table of data records to one of a plurality of disk blocks on a disk page, wherein each disk block is assigned substantially the same amount of column data, responsive to a column having a size less than a greatest size of any disk block, allowing a multiple disk block assignment, responsive to a column having a size greater than or equal to the greatest size of any disk block, responsive to the column having a size greater than or equal to the greatest size of any disk block.
Dependencies are inferred from the claim text.