Techniques for data retention
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.
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.