Translation of tenant identifiers
Systems, devices, and techniques are disclosed for translation of tenant identifiers. A record may be received. A value of a tenant identifier for the record may be determined from a key for the record or a scan descriptor. The value of the tenant identifier in the key for the record may be replaced with a new value for the tenant identifier. A bitmap stored in a record header of the record may be used to identify columns of the record that stored an encoded value of the tenant identifier. An encoded new value of the tenant identifier may be stored in columns identified by the bitmap stored in the record header that include an attribute indicating that tenant identifier translation is enabled.
1 . A computer-implemented method comprising:
receiving a record;
removing an encoded value of a tenant identifier from a tenant identifier column of the record stored with records of a database in a persistent storage of a database server at a working storage of the database server;
determining that the encoded value of the tenant identifier is stored in at least one other column of the record;
generating a bitmap identifying columns of the record where the encoded value of the tenant identifier is stored;
removing the encoded value of the tenant identifier from the columns of the record identified by the bitmap without removing the columns of the record identified by the bitmap;
storing the bitmap and the encoded value of the tenant identifier in a record header of the record;
storing the record with the records of the database in the persistent storage of the database server;
identifying, using the bitmap the columns of the record that stored the encoded value of the tenant identifier; and
storing an encoded new value of the tenant identifier in the columns identified by the bitmap stored in the record header.
2 . The computer-implemented method of claim 1 , further comprising storing a bit in the record header of the record indicating that the bitmap and the encoded value of the tenant identifier are stored in the record header.
3 . The computer-implemented method of claim 1 , further comprising storing a bit in the record header of the record indicating that the encoded value of the tenant identifier was removed from the tenant identifier column of the record.
4 . The computer-implemented method of claim 1 , further comprising storing a tenant identifier column attribute number in the record header of the record that identifies the tenant identifier column.
5 . The computer-implemented method of claim 1 , wherein the record is received from the persistent storage of a multi-tenanted database system.
6 . The computer-implemented method of claim 1 , wherein the record is unpacked in working memory of a multi-tenanted database system.
7 . A computer-implemented system for translation of tenant identifiers comprising:
one or more storage devices comprising a persistent storage and a working storage; and a processor that retrieves a record from the persistent storage and writes the record to the working storage, removes an encoded value of a tenant identifier from a tenant identifier column of the record, determines that the encoded value of the tenant identifier is stored in at least one other column of the record, generates a bitmap identifying columns of the record where the encoded value of the tenant identifier is stored, removes the encoded value of the tenant identifier from the columns of the record identified by the bitmap without removing the columns of the record identified by the bitmap, stores the bitmap and the encoded value of the tenant identifier in a record header of the record stores the record with the records of the database in the persistent storage of the database server, and identifies, using the bitmap the columns of the record that stored the encoded value of the tenant identifier, and stores an encoded new value of the tenant identifier in the columns identified by the bitmap stored in the record header.
8 . The computer-implemented system of claim 7 , wherein the processor further stores a bit in the record header of the record indicating that the bitmap and the encoded value of the tenant identifier are stored in the record header.
9 . The computer-implemented system of claim 7 , wherein the processor further stores a bit in the record header of the record indicating that the encoded value of the tenant identifier was removed from the tenant identifier column of the record.
10 . The computer-implemented system of claim 7 , wherein the processor further stores a tenant identifier column attribute number in the record header of the record that identifies the tenant identifier column.
11 . The computer-implemented system of claim 7 , wherein the record is received from the persistent storage of a multi-tenanted database system.
12 . The computer-implemented system of claim 7 , wherein the record is unpacked in working memory of a multi-tenanted database system.
13 . A system comprising: one or more computers and one or more storage devices storing instructions which are operable, when executed by the one or more computers, to cause the one or more computers to perform operations comprising:
receiving a record;
removing an encoded value of a tenant identifier from a tenant identifier column of the record stored with records of a database in a persistent storage of a database server at a working storage of the database server;
determining that the encoded value of the tenant identifier is stored in at least one other column of the record;
generating a bitmap identifying columns of the record where the encoded value of the tenant identifier is stored;
removing the encoded value of the tenant identifier from the columns of the record identified by the bitmap without removing the columns of the record identified by the bitmap;
storing the bitmap and the encoded value of the tenant identifier in a record header of the record;
storing the record with the records of the database in the persistent storage of the database server;
identifying, using the bitmap the columns of the record that stored the encoded value of the tenant identifier; and
storing an encoded new value of the tenant identifier in the columns identified by the bitmap stored in the record header.
14 . The system of claim 13 , wherein the instructions are operable, when executed by the one or more computers, to further cause the one or more computers to perform operations comprising storing a bit in the record header of the record indicating that the bitmap and the encoded value of the tenant identifier are stored in the record header.
15 . The system of claim 13 , wherein the instructions are operable, when executed by the one or more computers, to further cause the one or more computers to perform operations comprising storing a bit in the record header of the record indicating that the encoded value of the tenant identifier was removed from the tenant identifier column of the record.
16 . The system of claim 13 , wherein the instructions are operable, when executed by the one or more computers, to further cause the one or more computers to perform operations comprising storing a tenant identifier column attribute number in the record header of the record that identifies the tenant identifier column.
17 . The system of claim 13 , wherein the record is received from the persistent storage of a multi-tenanted database system.
18 . The system of claim 13 , wherein the record is unpacked in working memory of a multi-tenanted database system.