Method and system for managing large write-once tables in shadow page databases
AssigneeSap SE
InventorIvan Schreter
Life of this patent
Estimating the term…
Abstract
Methods and systems for managing large write-once tables are described. In some embodiments, a relational database management system includes a space allocation module that utilizes both a logical space allocation scheme, as well as a physical space allocation scheme, to allocate space in units (e.g., pages) having two different sizes—small pages and big pages. For instance, small pages are logically allocated with a conventional converter module, which manages a converter table for mapping logical pages to physical pages, while big pages are physically allocated with an object directory manager, which manages big objects comprised of big pages.
Claims19
A relational database management system comprising:
- a command and query processing module configured to process commands and queries received from one or more applications executing on client computing devices, the command and query module including a logic layer for performing database operations to read and/or write data to any one of several database tables including a first database table stored in pages of a first size and a second database table stored in pages of a second size greater than the first size, the pages of the first size allocated and addressed logically with use of a converter to map logical pages to physical pages, and the pages of the second size allocated physically and addressed logically with use of a big object directory manager.
A computer-readable storage medium storing instructions thereon, which, when executed by a processor of a server, cause the server to:
- in accordance with a first command received from an application executing on a client computing device, process a first write operation to write data to a database table stored in pages of a first size, the pages of the first size allocated and addressed logically with use of a converter to map logical pages to physical pages;
- and
- in accordance with a second command received from an application executing on a client computing device, process a write operation to append data to a database table stored in pages of a second size greater than the first size by an integer multiple, the pages of the second size allocated physically and addressed logically with use of a big object directory manager.
A computer-implemented method comprising:
- in accordance with a first command received from an application executing on a client computing device, processing a first write operation to write data to a database table stored in pages of a first size, the pages of the first size allocated and addressed logically with use of a converter to map logical pages to physical pages;
- and
- in accordance with a second command received from an application executing on a client computing device, processing a write operation to append data to a database table stored in pages of a second size greater than the first size by an integer multiple, the pages of the second size allocated physically and addressed logically with use of a big object directory manager.
Dependencies are inferred from the claim text.