TECHNIQUES FOR DATA RETENTION

1 - 20 . (canceled)

21 . A method, comprising:

obtaining, by a data retention system implemented via a database system, a data retention policy associated with a tenant of a multitenant computing environment, the data retention policy indicating one or more parameters associated with temporal attributes of data to be copied from a relational database to a non-relational database;

copying at least a portion of first data, identified from the relational database based on the data retention policy, to the non-relational database, wherein the copying continues until backup of the first data in the non-relational database is complete;

obtaining a query received via a user interface, the query being received in a relational database language;

using the query received in the relational database language to scan the non-relational database using data of the relational database and data of the non-relational database;

combining results of the query on the non-relational database; and

providing the combined results via the user interface.

22 . The method of claim 21 , wherein the one or more parameters include: daily backup retention, twice daily backup retention, weekly backup retention, and/or monthly backup retention.

23 . The method of claim 21 , wherein the data retention policy specifies how frequently backups are created.

24 . The method of claim 21 , wherein the backup is a background job that is independent of the database system.

25 . The method of claim 21 , further comprising:

performing, in parallel, multiple scans of the non-relational database.

26 . The method of claim 21 , further comprising:

providing, to an application, access to application data stored on a server system of the data retention system, the application data being stored in a non-relational format.

27 . The method of claim 21 , wherein the non-relational database is stored in a columnar format.

28 . A data retention system, comprising:

a database system implemented using at least a server computing device, the database system configurable to cause:

obtaining, by the data retention system, a data retention policy associated with a tenant of a multitenant computing environment, the data retention policy indicating one or more parameters associated with temporal attributes of data to be copied from a relational database to a non-relational database;

copying at least a portion of first data, identified from the relational database based on the data retention policy, to the non-relational database, wherein the copying continues until backup of the first data in the non-relational database is complete;

obtaining a query received via a user interface, the query being received in a relational database language;

using the query received in the relational database language to scan the non-relational database using data of the relational database and data of the non-relational database;

combining results of the query on the non-relational database; and

providing the combined results via the user interface.

29 . The system of claim 28 , wherein the one or more parameters include: daily backup retention, twice daily backup retention, weekly backup retention, and/or monthly backup retention.

30 . The system of claim 28 , wherein the data retention policy specifies how frequently backups are created.

31 . The system of claim 28 , wherein the backup is a background job that is independent of the database system.

32 . The system of claim 28 , further comprising:

performing, in parallel, multiple scans of the non-relational database.

33 . The system of claim 28 , the database system further configurable to cause:

providing, to an application, access to application data stored on a server system of the data retention system, the application data being stored in a non-relational format.

34 . The system of claim 28 , wherein the non-relational database is stored in a columnar format.

35 . 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 computer-readable program code comprising computer-readable instructions configurable to cause:

obtaining, by a data retention system implemented via a database system, a data retention policy associated with a tenant of a multitenant computing environment, the data retention policy indicating one or more parameters associated with temporal attributes of data to be copied from a relational database to a non-relational database;

copying at least a portion of first data, identified from the relational database based on the data retention policy, to the non-relational database, wherein the copying continues until backup of the first data in the non-relational database is complete;

obtaining a query received via a user interface, the query being received in a relational database language;

using the query received in the relational database language to scan the non-relational database using data of the relational database and data of the non-relational database;

combining results of the query on the non-relational database; and

providing the combined results via the user interface.

36 . The computer program product of claim 35 , wherein the one or more parameters include: daily backup retention, twice daily backup retention, weekly backup retention, and/or monthly backup retention.

37 . The computer program product of claim 35 , wherein the data retention policy specifies how frequently backups are created.

38 . The computer program product of claim 35 , wherein the backup is a background job that is independent of the database system.

39 . The computer program product of claim 35 , further comprising: performing, in parallel, multiple scans of the non-relational database.

40 . The computer program product of claim 35 , wherein the non-relational database is stored in a columnar format.