Database Storage Architecture
First Claim
Patent Images
1. A computer-implemented method comprising:
- storing data of a projection of a database at least partly in grouped ROS format and partly in column format based on patterns of updating the projection data; and
updating the projection data so that the updated projection is stored partly in grouped ROS format and partly in column format.
9 Assignments
0 Petitions
Accused Products
Abstract
Methods, systems and program products for database storage. In one implementation, data of a projection of a database is stored at least partly in grouped ROS format and partly in column format based on patterns of updating the projection data. The projection data is updated so that the updated projection is stored partly in grouped ROS format and partly in column format.
-
Citations
37 Claims
-
1. A computer-implemented method comprising:
-
storing data of a projection of a database at least partly in grouped ROS format and partly in column format based on patterns of updating the projection data; and updating the projection data so that the updated projection is stored partly in grouped ROS format and partly in column format. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A computer-implemented method comprising:
-
selecting at least two different storage formats for data of a database projection based on patterns of updating data of the projection; and updating projection data based on the patterns using the selected storage formats. - View Dependent Claims (14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24)
-
-
25. A computer readable medium storing a projection of a table of a database system, the projection comprising columns of data of the table, the projection comprising:
-
first rows for at least two of the columns in grouped ROS format, each of the first row'"'"'s columns being stored in a single file with the columns of at least one other first row; and distinct second rows for at least two of the columns in column format, each of the second row'"'"'s columns being stored in separate files and each separate file storing the same column of more than one of the second rows.
-
-
26. A computer-implemented method for associating at least two columns of a projection of a database system with respective storage locations, the method comprising:
-
ranking storage locations according to their respective speeds; ranking the columns according to their preferred speeds; and for each of the columns and according to their ranked order, assigning the column to the fastest storage location based on free space of the storage location and a size of the column. - View Dependent Claims (27, 28, 29)
-
-
30. A computer-implemented method comprising:
-
determining that a plurality of new rows for a plurality of a projection'"'"'s columns are to be stored in persistent storage wherein the determining is based a criterion, and wherein the projection'"'"'s columns store data for a table in a database system; selecting a storage format for the new rows wherein the storage format is grouped ROS format or column format and wherein grouped ROS format stores a plurality of the projection'"'"'s columns together in a single file and wherein column format stores columns of the projection in separate files; and storing the new rows in the selected format in persistent storage. - View Dependent Claims (31, 32, 33)
-
-
34. A computer-implemented method comprising:
-
selecting a plurality of candidate projection containers wherein each candidate container holds rows for one or more columns of the projection; identifying a plurality of containers to merge in the candidate containers; selecting a storage format wherein the storage format is grouped ROS format or column format and wherein grouped ROS format stores a plurality of the projection columns together in a single file and wherein column format stores columns of the projection in separate files; merging the identified containers into a new container according to the selected storage format; and wherein selecting a storage format is based on an assessment of existing storage allocated to the projection such that some but not all of projection data is stored in grouped ROS format. - View Dependent Claims (35, 36)
-
-
37. A computer-implemented method comprising:
-
determining that data is to be added to a projection of a database based on at least one of a size or an age of the data; and storing the data in at least partly in grouped ROS format and partly in column format.
-
Specification