TRUNCATING DATA ASSOCIATED WITH OBJECTS IN A MULTI-TENANT DATABASE
First Claim
1. A computer-implemented method of truncating data from a multi-tenant database that maintains database objects for a plurality of different tenants, each database object in the multi-tenant database being identified by a unique combination of a key prefix and a tenant identifier, the method comprising:
- maintaining an entity definition table having a plurality of metadata entries corresponding to the database objects, including a metadata entry for an existing database object, the metadata entry comprising a tenant identifier for a particular tenant associated with the existing database object, an entity name for the existing database object, and an old key prefix for the existing database object;
obtaining an instruction to remove all data from the existing database object; and
in response to obtaining the instruction, updating the metadata entry to replace the old key prefix with a new key prefix that is not currently associated with any other database object for the particular tenant, wherein updating the metadata entry results in an updated database object that is identified by the new key prefix and the tenant identifier.
1 Assignment
0 Petitions
Accused Products
Abstract
An embodiment of a multi-tenant database system includes a multi-tenant database, an entity definition table, and a data processing engine. The database has objects for multiple tenants, including an existing object for a designated tenant. Each entry in the existing object has a respective entity identifier. The definition table has entries for the database objects, including a metadata entry for the existing object. This metadata entry has a tenant identifier for the designated tenant, an entity name for the existing object, and an old key prefix for the existing object. Each entity identifier of the existing object begins with the old key prefix. The engine performs a data truncation operation on the existing object by updating the metadata entry to replace the old key prefix with a new key prefix. This results in an updated object that is identified by the new key prefix and the tenant identifier.
-
Citations
20 Claims
-
1. A computer-implemented method of truncating data from a multi-tenant database that maintains database objects for a plurality of different tenants, each database object in the multi-tenant database being identified by a unique combination of a key prefix and a tenant identifier, the method comprising:
-
maintaining an entity definition table having a plurality of metadata entries corresponding to the database objects, including a metadata entry for an existing database object, the metadata entry comprising a tenant identifier for a particular tenant associated with the existing database object, an entity name for the existing database object, and an old key prefix for the existing database object; obtaining an instruction to remove all data from the existing database object; and in response to obtaining the instruction, updating the metadata entry to replace the old key prefix with a new key prefix that is not currently associated with any other database object for the particular tenant, wherein updating the metadata entry results in an updated database object that is identified by the new key prefix and the tenant identifier. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A computer-implemented method of removing stored data associated with a database object, the method comprising:
-
assigning a new and previously unused key prefix to an existing database object to disassociate stored data from an old key prefix, resulting in an empty database object that is void of data; updating a graphical representation of a table to reflect the empty database object; and presenting the graphical representation of the table to a user. - View Dependent Claims (8, 9, 10, 11, 12, 13, 14, 15, 16, 17)
-
-
18. A multi-tenant database system comprising:
-
a multi-tenant database comprising one or more database objects for a plurality of tenants, including an existing database object for a designated tenant, wherein each entry in the existing database object is uniquely associated with a respective entity identifier; an entity definition table having a plurality of metadata entries corresponding to the one or more database objects, and including a metadata entry for the existing database object, the metadata entry comprising a tenant identifier that identifies the designated tenant, an entity name for the existing database object, and an old key prefix for the existing database object, wherein each entity identifier of the existing database object begins with the old key prefix; and a data processing engine configured to perform a data truncation operation on the existing database object by updating the metadata entry to replace the old key prefix with a new key prefix, wherein updating the metadata entry results in an updated database object that is identified by the new key prefix and the tenant identifier. - View Dependent Claims (19, 20)
-
Specification