Patent ID: 9081805
Filing Date: 2015-07-14
Classification: G06F

Abstract:
1. A tenant aware relational database management system comprising: a non-transitory computer-readable medium storing computer-executable code, the computer-executable code comprising: a query engine for receiving and parsing commands, the query engine adapted to receive commands and data; a buffer manager for temporarily storing commands and data, the buffer manager coupled for communication with the query engine; a table storing a logical table name and an identification number; and a storage manager for retrieving information from and storing information to a database, the storage manager coupled for communication with the buffer manager, the table and the database, the storage manager using a first multi-tenant structure for mapping the logical table name and the identification number to a first physical location in the database for a plurality of tenants, the storage manager using a second multi-tenant structure for mapping a logical index name to a physical storage identifier, the physical storage identifier identifying a second physical location in the database for index data, the storage manager using the first multi-tenant structure and the second multi-tenant structure to store data associated with the plurality of tenants in the database, the storage manager to determine one or more tenants affected by a schema change by using a tenant object of the first multi-tenant structure and a table identified in the schema change and modify a table or index for the one or more affected tenants; wherein the first and second multi-tenant structures are used by the query engine to assign different tenants different priorities for a central processing unit time and the buffer manager to assign different tenants different priorities for buffer space, wherein the buffer manager limits the number of buffers used on a per tenant basis.