Techniques for data retention

Patent metadata

Field	Value
Publication number	US-11507589-B2
Application number	US-202016853572-A
Country	US
Kind code	B2
Filing date	Apr 20, 2020
Priority date	Nov 15, 2013
Publication date	Nov 22, 2022
Grant date	Nov 22, 2022

Abstract

Systems and techniques for managing data in a relational database environment and a non-relational database environment. Data in the relational database environment that is static and to be maintained beyond a preselected threshold length of time is identified. The data is copied from the relational database and stored in the data the non-relational database. Access to the data is provided from the non-relational database via a user interface that accesses both the relational database and the non-relational database.

First claim

What is claimed is:

1. A method, comprising:
obtaining a data retention configuration associated with a tenant of a multitenant computing environment, the data retention configuration indicating one or more parameters defining data to be copied from a relational database to a non-relational database;
identifying, using the data retention configuration, first data associated with the tenant;
copying the first data from the relational database;
storing the copied first data to the non-relational database in association with a tenant identifier of the tenant;
obtaining a query received via a user interface, the query being received in a relational database language;
transforming the query received in the relational database language to multiple scans, each scan corresponding to a row key range of multiple row key ranges of the non-relational database;
performing the multiple scans on the non-relational database;
merging results of the performed multiple scans on the non-relational database; and
providing the merged results via the user interface.

2. The method of claim 1 , wherein the data comprises field history data.

3. The method of claim 1 , further comprising:
enqueuing a message corresponding to the first data, the message including one or more parameters;
wherein the copying of the first data is performed according to the message.

4. The method of claim 1 , wherein the identifying of the first data is performed in response to detection of one or more trigger conditions.

5. The method of claim 1 , further comprising:
deleting the first data from the relational database.

6. A system, comprising:
a database system implemented using at least a server computing device, the database system configurable to cause:
obtaining a data retention configuration associated with a tenant of a multitenant computing environment, the data retention configuration indicating one or more parameters defining data to be copied from a relational database to a non-relational database;
identifying, using the data retention configuration, first data associated with the tenant;
copying the first data from the relational database;
storing the copied first data to the non-relational database in association with a tenant identifier of the tenant;
obtaining a query received via a user interface, the query being received in a relational database language;
transforming the query received in the relational database language to multiple scans, each scan corresponding to a row key range of multiple row key ranges of the non-relational database;
performing the multiple scans on the non-relational database;
merging results of the performed multiple scans on the non-relational database; and
providing the merged results via the user interface.

7. The system of claim 6 , wherein the data comprises field history data.

8. The system of claim 6 , the database system further configurable to cause:
enqueuing a message corresponding to the first data, the message including one or more parameters;
wherein the copying of the first data is performed according to the message.

9. The system of claim 6 , wherein the identifying of the first data is performed in response to detection of one or more trigger conditions.

10. The system of claim 6 , the database system further configurable to cause:
deleting the first data from the relational database.

11. A computer program product comprising computer-readable program code capable of being executed by one or more processors when retrieved from a non-transitory computer-readable medium, the program code comprising computer-readable instructions configurable to cause:
obtaining a data retention configuration associated with a tenant of a multitenant computing environment, the data retention configuration indicating one or more parameters defining data to be copied from a relational database to a non-relational database;
identifying, using the data retention configuration, first data associated with the tenant;
copying the first data from the relational database;
storing the copied first data to the non-relational database in association with a tenant identifier of the tenant;
obtaining a query received via a user interface, the query being received in a relational database language;
transforming the query received in the relational database language to multiple scans, each scan corresponding to a row key range of multiple row key ranges of the non-relational database;
performing the multiple scans on the non-relational database;
merging results of the performed multiple scans on the non-relational database; and
providing the merged results via the user interface.

12. The computer program product of claim 11 , wherein the data comprises field history data.

13. The computer program product of claim 11 , the program code comprising computer-readable instructions configurable to cause:
enqueuing a message corresponding to the first data, the message including one or more parameters;
wherein the copying of the first data is performed according to the message.

14. The computer program product of claim 11 , wherein the identifying of the first data is performed in response to detection of one or more trigger conditions.

Assignees

• Salesforce Com Inc

Inventors

• Bruce Jonathan
• Levine Eli
• Toens Simon
• Varley Ian

Classifications

• G06F16/25 Primary

  Integrating or interfacing systems involving database management systems · CPC title

• G06F16/27

  Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor · CPC title

• G06F16/256

  in federated or virtual databases · CPC title

• G06F16/284 Primary

  Relational databases · CPC title

• G06F16/258

  Data format conversion from or to a database · CPC title