Managing database
First Claim
1. A system for managing a database, each item of data in the database being associated with a timestamp and a data point, the timestamps being used as row keys for rows of a table in the database, the rows defined on one of two dimensions of the table, the system comprising:
- a hardware processor in communication with said database, said hardware processor configured to perform a method comprising;
obtaining a behavior characteristic of a user based on a previous data access to the database by the user, said behavior characteristic indicating a time span of the previous data access;
partitioning columns in the table into column families based on the obtained behavior characteristic and a system configuration of the database, the system configuration indicating a size of blocks in a file system associated with the database, the columns defined on the other of the two dimensions of the table; and
storing data in the database in respective column families at least in part based on the associated data points.
1 Assignment
0 Petitions
Accused Products
Abstract
The present invention discloses a method and system for managing a database. According to embodiments of the present invention, there is provided a method for managing a database, each item of data in the database being associated with a timestamp and a data point, the timestamps being used as row keys for rows of a table in the database, the method comprising: obtaining a behavior characteristic of a user based on a previous data access to the database by the user; partitioning columns in the table into column families based on the obtained behavior characteristic and system configuration of the database; and causing data in the database to be stored in respective column families at least in part based on the associated data point. There is further disclosed a corresponding system.
44 Citations
13 Claims
-
1. A system for managing a database, each item of data in the database being associated with a timestamp and a data point, the timestamps being used as row keys for rows of a table in the database, the rows defined on one of two dimensions of the table, the system comprising:
-
a hardware processor in communication with said database, said hardware processor configured to perform a method comprising; obtaining a behavior characteristic of a user based on a previous data access to the database by the user, said behavior characteristic indicating a time span of the previous data access; partitioning columns in the table into column families based on the obtained behavior characteristic and a system configuration of the database, the system configuration indicating a size of blocks in a file system associated with the database, the columns defined on the other of the two dimensions of the table; and storing data in the database in respective column families at least in part based on the associated data points. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A computer program product for managing a database, each item of data in the database being associated with a timestamp and a data point, the timestamps being used as row keys for rows of a table in the database, the rows defined on one of two dimensions of the table, the computer program product comprising a non-transitory storage medium readable by a processing circuit and storing instructions run by the processing circuit for performing a method, the method comprising:
-
obtaining a behavior characteristic of a user based on a previous data access to the database by the user, said behavior characteristic indicating a time span of the previous data access; partitioning columns in the table into column families based on the obtained behavior characteristic and a system configuration of the database, the system configuration indicating a size of blocks in a file system associated with the database, the columns defined on the other of the two dimensions of the table; and storing data in the database in respective column families at least in part based on the associated data points. - View Dependent Claims (9, 10, 11, 12, 13)
-
Specification