SYSTEMS AND METHODS TO MANAGE ONLINE ANALYTICAL AND TRANSACTIONAL PROCESSING FOR AN IN-MEMORY COLUMNAR DATABASE

摘要

According to some embodiments, a database, containing entries, may be stored across first and second storage medium, entries in the second storage medium being default invisible for online transactional processing. A central software layer processor between the database and an application may identify a subset of the entries stored in the first storage medium as being default visible for online transactional processing, wherein entries stored in the first storage medium that are not within the subset are default invisible for online transactional processing. Note that entries in the first storage medium may be accessible by the application more quickly as compared to entries in the second storage medium.

主权项

1. A system comprising:
a first storage device; a second storage device, wherein a database, containing entries, is stored across the first and second storage devices, entries in the second storage medium being default invisible for online transactional processing; and a computing device comprising:
a memory storing processor-executable program code, anda processor to execute the processor-executable program code in order to cause the computing device to:
identify, at a central software layer processor between the database and an application, a subset of the entries stored in the first storage medium as being default visible for online transactional processing, wherein entries stored in the first storage medium that are not within the subset are default invisible for online transactional processing.