OUT OF MEMORY ERROR HANDLING FOR DATA DEFINITION LANGUAGE OPERATIONS

摘要

The subject matter disclosed herein relates to out of memory error handling in a database system. A database operation can be received by an in-memory database. The database operation can be for a database object stored in a database table that can be represented as a plurality of pages that can be persisted in a page chain. The in-memory database can reserve out of memory space sufficient to load a predetermined number of pages in the page chain into memory. The in-memory database can iteratively process each page in the page chain until completion of the database operation. The iterative process can include loading the page from persistence into memory of the in-memory database, performing at least a portion of the database operation using the loaded page, and unloading the page from the memory of the in-memory database. Related apparatus, systems, techniques, and articles are also described.

主权项

1. A computer-implemented method comprising:
receiving, by an in-memory database, a database operation for a database object stored in a database table that is represented as a plurality of pages that are persisted in a page chain; reserving, by the in-memory database, out of memory space sufficient to load a predetermined number of pages in the page chain into memory; and iteratively processing, by the in-memory database, each page in the page chain until completion of the database operation by:
loading the page from persistence into memory of the in-memory database,performing at least a portion of the database operation using the loaded page, andunloading the page from the memory of the in-memory database.