Sap Se

Naveen K

Ajalesh Puthenparambil Gopi

Vittal Gopinatha Pai

Nidhi Prashant Augustine

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.

Memory optimization using data aging in full text indexes

A database system includes a data server, a disk-based storage system in communication with the data server, a source table including a plurality of columns, where data of the source table is stored in the disk-based storage system in columnar format, a full-text index associated with one of the plurality of columns, and a text analysis result table associated with the one of the plurality of columns, where the data of the text analysis result table is stored in the disk-based storage system in columnar format.

Growing community of inventors

Bengaluru, India

Naveen K