Data aging in hana using grading attributes

Patent metadata

Field	Value
Publication number	US-9703813-B2
Application number	US-201414501626-A
Country	US
Kind code	B2
Filing date	Sep 30, 2014
Priority date	Sep 30, 2014
Publication date	Jul 11, 2017
Grant date	Jul 11, 2017

Abstract

According to an embodiment of the present disclosures, systems, methods, and non-transitory computer-readable mediums having program instructions thereon, provide for process of segregating data from database tables into different layers depending on the frequency of access to the data—so that each layer of the data can be stored in an appropriate storage mechanism. For example, infrequently-accessed data can be stored in a hard disk drive (HDD) and frequently-accessed can be stored in random-access memory (RAM). Further, the data can also be stored in a sold-state drive (SSD) or other memory-storing devices. In an embodiment, grading attributes are used to layer the data and, accordingly, segregate the data into appropriate storage mechanisms.

First claim

What is claimed is:

1. A computer-implemented method for segregating at least one data record from a database table into at least two data layers, the method comprising:
retrieving, with a processor, the database table from a database in response to a user-inputted data aging object;
determining, with the processor, for each of the data records in the database table, the corresponding grading attribute; and
mapping, with the processor, each of the data records and at least one other data record to one of the at least two data layers based on the corresponding grading attribute of each of the data records, wherein the at least one other data record corresponds to an at least one other database table, wherein the database table and the at least one other database table correspond to the data aging object;
wherein the data aging object is a data object representing a logical grouping of the database table and the at least one other database table such that the logically grouped database tables are similarly layered and stored in a storage device;
wherein the database is an in-memory database in which frequently accessed data is stored in random-access memory and less frequently accessed data is stored on a hard disk drive.

2. The method of claim 1 , wherein the data aging object includes (1) the database table, (2) a grading attribute name and (3) a view.

3. The method of claim 2 , wherein the corresponding grading attribute of the data record is determined through the view of a primary key of the database table and a grading attributes field of a table containing the grading attributes.

4. The method of claim 3 , wherein the database table and the table containing the grading attributes are joined according to a first date field of the database table and a second date field of the table containing the grading attributes.

5. The method of claim 1 , wherein the grading attribute is of a date data type.

6. The method of claim 1 , wherein the mapping of the data record is done by a mapping table stored in the database.

7. A non-transitory computer readable medium containing program instructions for segregating at least one data record from a database table into at least two data layers, wherein execution of the program instructions by one or more processors of a computer system causes one or more processors to carry out the steps of:
retrieving the database table from a database in response to a user-inputted data aging object;
determining, for each of the data records in the database table, the corresponding grading attribute; and
mapping each of the data records and at least one other data record to one of the at least two data layers based on the corresponding grading attribute of each of the data records, wherein the at least one other data record corresponds to an at least one other database table, wherein the database table and the at least one other database table correspond to the data aging object;
wherein the data aging object is a data object representing a logical grouping of the database table and the at least one other database table such that the logically grouped database tables are similarly layered and stored in a storage device;
wherein the database is an in-memory database in which frequently accessed data is stored in random-access memory and less frequently accessed data is stored on a hard disk drive.

8. The non-transitory computer readable medium of claim 7 , wherein the data aging object includes (1) the database table, (2) a grading attribute name and (3) a view.

9. The non-transitory computer readable medium of claim 8 , wherein the corresponding grading attribute of the data record is determined through the view of a primary key of the database table and a grading attributes field of a table containing the grading attributes.

10. The non-transitory computer readable medium of claim 9 , wherein the database table and the table containing the grading attributes are joined according to a first date field of the database table and a second date field of the table containing the grading attributes.

11. The non-transitory computer readable medium of claim 7 , wherein the grading attribute is of a date data type.

12. The non-transitory computer readable medium of claim 7 , wherein the mapping of the data record is done by a mapping table stored in the database.

13. A system directed to for segregating at least one data record from a database table into at least two data layers, the system comprising:
a database;
a processor, wherein the processor is configured to perform operations comprising:
retrieving the database table from a database in response to a user-inputted data aging object;
determining, for each of the data records in the database table, the corresponding grading attribute; and
mapping each of the data records and at least one other data record to one of the at least two data layers based on the corresponding grading attribute of each of the data records, wherein the at least one other data record corresponds to an at least one other database table, wherein the database table and the at least one other database table correspond to the data aging object;

wherein the data aging object is a data object representing a logical grouping of the database table and the at least one other database table such that the logically grouped database tables are similarly layered and stored in a storage device;
wherein the database is an in-memory database in which frequently accessed data is stored in random-access memory and less frequently accessed data is stored on a hard disk drive.

14. The system of claim 13 , wherein the data aging object includes (1) the database table, (2) a grading attribute name and (3) a view.

15. The system of claim 14 , wherein the corresponding grading attribute of the data record is determined through the view of a primary key of the database table and a grading attributes field of a table containing the grading attributes.

16. The system of claim 15 , wherein the database table and the table containing the grading attributes are joined according to a first date field of the database table and a second date field of the table containing the grading attributes.

17. The system of claim 13 , wherein the grading attribute is of a date data type.

18. The system of claim 13 , wherein the mapping of the data record is done by a mapping table stored in the database.

Assignees

• Sap Se

Inventors

• Hegde Sumanth
• A Dharshan

Classifications

• G06F16/217 Primary

  Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409) · CPC title

• G06F17/30306 Primary

  Physics · mapped topic