Disk optimized paging for column oriented databases
First Claim
1. In a computing environment, a method of implementing a database system using a plurality of sequentially ordered drives to store sequential portions of columns of the database, but where the database system is usable by a system configured for use with in-memory database systems, the method comprising:
- loading one or more columns of a database into main memory of a computing system as a table based database;
dividing a column of the database into sequential portions, wherein each of the sequential portions is of sufficient size to create efficient transfers using hard disk controllers to transfer an entire sequential portion, and wherein the sufficient size of each of the sequential portions is configurable such that a size of a first sequential portion is different than a size of a second sequential portion; and
writing each of the sequential portions sequentially onto sequentially ordered drives in a round robin fashion such that sequential portions of the column are on sequential drives.
2 Assignments
0 Petitions
Accused Products
Abstract
Implementing a database system using a plurality of sequentially ordered drives to store sequential portions of columns of the database, but where the database system is usable by a system configured for use with in-memory database systems. The method includes loading one or more columns of a database into main memory of a computing system as a table based database. The method further includes dividing a column of the database into sequential portions. Each of the sequential portions is of sufficient size to create efficient transfers using hard disk controllers to transfer an entire sequential portion. The method further includes writing each of the sequential portions sequentially onto sequentially ordered drives in a round robin fashion such that sequential portions of the column are on sequential drives.
-
Citations
20 Claims
-
1. In a computing environment, a method of implementing a database system using a plurality of sequentially ordered drives to store sequential portions of columns of the database, but where the database system is usable by a system configured for use with in-memory database systems, the method comprising:
-
loading one or more columns of a database into main memory of a computing system as a table based database; dividing a column of the database into sequential portions, wherein each of the sequential portions is of sufficient size to create efficient transfers using hard disk controllers to transfer an entire sequential portion, and wherein the sufficient size of each of the sequential portions is configurable such that a size of a first sequential portion is different than a size of a second sequential portion; and writing each of the sequential portions sequentially onto sequentially ordered drives in a round robin fashion such that sequential portions of the column are on sequential drives. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. In a computing environment, a database system using a plurality of sequentially ordered drives to store sequential portions of columns of the database, but where the database system is usable by a system configured for use with in-memory database systems, the system comprising:
-
one or more processors; a plurality of sequentially ordered drives; main physical memory; and one or more computer readable media, wherein the one or more computer readable media comprise computer executable instructions that are executable by at least one of the one or more processors to cause at least one of the one or more processors to perform the following; load one or more columns of a database into the main memory of a database system as a table based database; divide a column of the database into sequential portions, wherein each of the sequential portions is of sufficient size to create efficient transfers using hard disk controllers to transfer an entire sequential portion, and wherein the sufficient size of each of the sequential portions is configurable such that a size of a first sequential portion is different than a size of a second sequential portion; and write each of the sequential portions sequentially onto the sequentially ordered drives in a round robin fashion such that sequential portions of the column are on sequential drives. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. In a computing environment, a physical computer readable storage medium comprising computer executable instructions that are executable by one or more processors to cause the following to be performed to implement a database system using a plurality of sequentially ordered drives to store sequential portions of columns of the database, but where the database system is usable by a system configured for use with in-memory database systems:
-
load one or more columns of a database into main memory of a computing system as a table based database; divide a column of the database into sequential portions, wherein each of the sequential portions is of sufficient size to create efficient transfers using hard disk controllers to transfer an entire sequential portion, and wherein the sufficient size of each of the sequential portions is configurable such that a size of a first sequential portion is different than a size of a second sequential portion; and write each of the sequential portions sequentially onto sequentially ordered drives in a round robin fashion such that sequential portions of the column are on sequential drives. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification