COLUMN-ORIENTED STORAGE IN A ROW-ORIENTED DATABASE MANAGEMENT SYSTEM

• US 20110264667A1
• Filed: 04/27/2010
• Published: 10/27/2011
• Est. Priority Date: 04/27/2010
• Status: Abandoned Application

• Current Assignee: Hewlett Packard Enterprise Development LP (Hewlett-Packard Enterprise Company)
• Original Assignee: Hewlett Packard Enterprise Development LP (Hewlett-Packard Enterprise Company)
• Inventors: HARIZOPOULOS, Stavros, Simitsis, Alkiviadis
• Application Number:
  US12/768,088
• Publication Number:
  US 20110264667A1
• Time in Patent Office: Days
• US Class Current: 707/743
• CPC Class Codes: G06F 16/221 Column-oriented storage; Management thereof

Abstract

Systems, methods, and computer-readable storage media are provided for column-oriented storage in a row-oriented database management system. Data may be provided in one or more columns, each datum associated with a position within a column. A list may be created of one or more records per column, each record including a plurality of values stored in an order of position within the column and a first positional indicator. An index may be created to access a value stored in a record, wherein the index includes an index parameter derived from each record in the list and the index parameters are ordered in accordance with an order of records in the list.

Claims

1. A method of adapting a row-oriented database management system to store and access column-oriented information, comprising:

providing data in one or more columns, each datum associated with a position within a column;

creating a list of one or more records per column, each record including a plurality of values stored in an order of position within the column, and each record further including a first positional indicator indicating positional information for the values in the record; and

creating an index to access a value stored in a record, wherein the index includes an index parameter derived from each record in the list and the index parameters are ordered in accordance with an order of records in the list.

2. The method of claim 1, each record further including a second positional indicator, and wherein the first positional indicator indicates the position in the column of the first value in the record, and the second positional indicator indicates the total number of values stored in the record.

3. The method of claim 1, wherein the index includes the first positional indicator of each record in the list, and the index is a positional index.

4. The method of claim 1, wherein the index includes the first value of each record in the list, and the index is a sparse value index.

5. The method of claim 1, wherein the index includes all values of each record in the list, the index parameters are further ordered by position within each record, and the index is a full value index.

6. The method of claim 1, further comprising:

executing instructions to store values in a record using an optimization algorithm.

7. The method of claim 6, wherein the values are of variable length and one or more records include a slotted array that indicates the location of a value in a record.

8. The method of claim 6, wherein one or more records include a table of data and the corresponding value for each datum, and the optimization algorithm converts between a datum and its corresponding value.

9. The method of claim 1, further comprising:

searching an index to determine the presence in the records of a value that satisfies a condition.

10. The method of claim 9, wherein the condition is equality of a value to a user-defined parameter.

11. The method of claim 9, wherein the condition is presence of a value within a user-defined range.

12. The method of claim 9, further comprising:

storing a value that satisfies the condition in a buffer.

13. A computer-readable storage medium having computer-executable instructions for adapting a row-oriented database management system to store and access column-oriented values, the instructions causing a computer to perform steps comprising:

reading data in one or more columns, each datum associated with a position within a column;

creating a list of one or more records per column, each record including a plurality of values stored in an order of position within the column, a first positional indicator indicating the position in the column of the first value in the record, and a second positional indicator indicating the total number of values stored within the record;

extracting an index parameter from each record in the list; and

creating an index for the list including index parameters ordered in accordance with an order of records in the list.

14. The computer-readable storage medium of claim 13, wherein the index includes the first positional indicator of each record in the list, and the index is a positional index.

15. The computer-readable storage medium of claim 13, wherein the index includes the first value of each record in the list, and the index is a sparse value index.

16. The computer-readable storage medium of claim 13, wherein the index includes all values of each record in the list, the index parameters are further ordered by position within each record, and the index is a full value index.

17. The computer-readable storage medium of claim 13, further including computer-executable instructions for:

storing values in a record using an optimization algorithm.

18. The computer-readable storage medium of claim 13, further including computer-executable instructions for:

searching an index to determine the presence in the records of a value that satisfies a condition.

19. The computer-readable storage medium of claim 13, further including computer-executable instructions for:

storing a value that satisfies the condition in a buffer.

20. A system for storing and accessing values, comprising:

data in one or more columns, each datum associated with a position within a column;

a database management system configured to;

create a list of one or more records per column, each record including a plurality of values stored in an order of position within the column, a first positional indicator indicating the position in the column of the first value in the record, and a second positional indicator indicating the total number of values stored within the record;

extract an index parameter from each record in the list; and

create an index for the list including index parameters ordered in accordance with an order of records in the list; and

a query execution engine configured to;

search an index to determine the presence in the records of a value that satisfies a condition.