MEMORY OPTIMIZATION USING DATA AGING IN FULL TEXT INDEXES

• US 20170344599A1
• Filed: 05/30/2016
• Published: 11/30/2017
• Est. Priority Date: 05/30/2016
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: K, Naveen, GOPI, Ajalesh P, PAI, Vittal Gopinatha
• Granted Patent: US 11,288,257 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/31 Indexing; Data structures therefor; Storage structures

Abstract

A framework for memory optimization of database indexes, and in particular for aging full-text index data, is described herein. In one embodiment, if, while a database table is aged, there are index tables associated with the database table, the associated index tables are automatically aged. This way, the system memory footprint will be reduced, leading to reduced cost as less system memory is required to perform remaining operations, and leading to increased performance as more system memory is available for other operations.

Claims

1. A computer-implemented method of aging database index data, comprising:

receiving a command to unload a database table, wherein the database table is associated with a database index, and wherein the database index is stored in a database index table; and

in response to the command, unloading the database table and the database index table.

2. The computer-implemented method of claim 1, wherein the database table is stored in a relational database.

3. The computer-implemented method of claim 1, wherein the database table is stored in a NoSQL database.

4. The computer-implemented method of claim 1, wherein the database index includes a full-text index.

5. The computer-implemented method of claim 1, wherein unloading the database index table is performed using a database UNLOAD command.

6. The computer-implemented method of claim 1, wherein the database table is associated with a plurality of database indexes, and wherein unloading the database table and the database index table includes unloading the plurality of database indexes.

7. The computer-implemented method of claim 1, further comprising:

receiving a command to load the database table; and

loading the database table and the database index table from a secondary storage medium into a system memory.

8. A computing apparatus facilitating aging of database index data, the computing apparatus comprising:

a processor; and

a memory storing instructions that, when executed by the processor, configures the apparatus to;

receive a command to unload a database table, wherein the database table is associated with a database index, and wherein the database index is stored in a database index table, and

in response to the command, unload the database table and the database index table.

9. The computing apparatus of claim 8, wherein the database table is stored in an object database.

10. The computing apparatus of claim 8, wherein unloading the database index table includes copying data contained in the database index table from a system memory to a secondary storage.

11. The computing apparatus of claim 8, wherein the database index includes a clustered index.

12. The computing apparatus of claim 8, wherein unloading the database table is performed using a database UNLOAD command.

13. The computing apparatus of claim 8, wherein the database table is associated with a plurality of database indexes, and wherein unloading the database table and the database index table includes unloading the plurality of database indexes.

14. The computing apparatus of claim 8, wherein the database table is associated with a database index based on an entry stored in a table-index association table, wherein the entry includes an identifier of the database table and an identifier of the database index.

15. A non-transitory computer-readable storage medium facilitating aging of database index data, the computer-readable storage medium including instructions that when executed by a computer, cause the computer to:

receive a command to unload a database table, wherein the database table is associated with a database index, and wherein the database index is stored in a database index table; and

in response to the command, unload the database table and the database index table.

16. The non-transitory computer-readable storage medium of claim 15, wherein the database table is stored in an in-memory database.

17. The non-transitory computer-readable storage medium of claim 15, wherein unloading the database index table includes copying data contained in the database index table from a system memory to a secondary storage.

18. The non-transitory computer-readable storage medium of claim 17, wherein the secondary storage includes a disc based storage medium.

19. The non-transitory computer-readable storage medium of claim 15, wherein, before being unloaded, the database table and the database table index are stored in system memory.

20. The non-transitory computer-readable storage medium of claim 15, wherein the database index includes a full-text index.