Please download the dossier by clicking on the dossier button x
×

Techniques for data retention

  • US 10,176,235 B2
  • Filed: 11/14/2014
  • Issued: 01/08/2019
  • Est. Priority Date: 11/15/2013
  • Status: Active Grant
First Claim
Patent Images

1. A method of managing data in a multitenant environment having a relational database and a non-relational database, the method comprising:

  • receiving, with one or more server computing systems that provide the multitenant environment, a set of one or more policies for field history data retention corresponding to data stored in a history table in the relational database environment, wherein the policies for data retention are defined on a tenant-by-tenant basis within the multitenant environment, wherein the one or more policies for data retention define what data is to be copied from the relational database to the non-relational database, how to copy the data, how long to retain the data in the relational database after the copy and how long to retain the data in the non-relational database after the copy;

    deploying, with the one or more computing systems that provide the multitenant environment, the policies to data in the relational database on a tenant-by-tenant basis within the multitenant environment;

    identifying, with the one or more computing systems that provide the multitenant environment and according to the policies, data to be copied from the relational database to the non-relational database, wherein the data to be copied comprises at least field history information indicating changes made to one or more fields in the relational database and the non-relational database provides a field history archive;

    storing the data to be copied in the non-relational database while maintaining tenant isolation so that data belonging to the respective tenants is not accessible by other tenants when stored in the non-relational database utilizing a two-stage archival operation where each of the two stages are independently scheduled and executed, the first stage to copy rows from the relational database to the non-relational database and the second stage to delete rows from the relational database that have been copied to the non-relational database; and

    providing access to the data from the non-relational database via a user interface that accesses both the relational database and the non-relational database, wherein searching of the data stored in the non-relational database comprises transforming a query in a relational database language to multiple parallel scans of the non-relational database to retrieve result data and merging results of the multiple parallel scans to present the result data.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×