Data consistency and rollback for cloud analytics

• US 9,646,042 B2
• Filed: 09/22/2015
• Issued: 05/09/2017
• Est. Priority Date: 02/11/2013
• Status: Active Grant

• Current Assignee: Dell Products LP (Dell Technologies Inc.)
• Original Assignee: Dell Products LP (Dell Technologies Inc.)
• Inventors: Bengali, Ketan, Mandal, Kaniska, Chen, Alex J.
• Primary Examiner(s): Stevens, Robert
• Application Number:
  US14/862,007
• Publication Number:
  US 20160085794A1
• Time in Patent Office: 595 Days
• Field of Search: 707602
• CPC Class Codes: G06F 11/1469 Backup restoration techniques
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 2201/80 Database-specific techniques

Abstract

An extract-transform-load (ETL) platform fetches consistent datasets in a batch for a given period of time and provides the ability to rollback that batch. The batch may be fetched for an interval of time, and the ETL platform may fetch new or changed data from different cloud/on-premise applications. It will store this data in the cloud or on-premise to build data history. As the ETL platform fetches new data, the system will not overwrite existing data, but rather will create new versions so that change history is preserved. For any reason, if businesses would like to rollback data, they could rollback to any previous batch.

Claims

1. A system for retrieving consistent datasets, comprising:

a staging database for storing batches of data corresponding to a period of time, wherein a batch of data includes one or more distinct datasets; and

a plurality of tenant devices, wherein each tenant device of the plurality of tenant devices includes a processor that executes instructions stored in memory to;

collect a current batch of data associated with a first period of time from one or more sources, wherein collection of the first batch of data includes instructions to collect new or changed data compared to a marked current batch of data that has been previously stored in memory,

assign identification information for the collected current batch of data, wherein the collected current collected current batch of data includes at least one new or changed dataset compared to the marked current batch of data that is previously stored in a batch log,

store the collected current batch of data in the staging database, wherein the stored current batch of data does not overwrite previously stored batches of data listed in the batch log, and wherein a location associated with the stored current batch of data is updated in the batch log,

mark the collected current batch of data as the current batch of data in the batch log,

detect a rollback event, wherein the rollback event indicates that the marked current batch of data should not be used,

select a previously stored batch of data as the current batch using the batch log, wherein information for the previously stored batch of data is included in the batch log,

retrieve the previously stored batch of data from the staging database using the identification information in the batch log, wherein the retrieved previously stored batch of data is used to overwrite the first batch of data, and

deleting information pertaining to the first batch of data from the batch log.

2. The system of claim 1, wherein the collected batches of data from the one or more sources corresponds with one or more applications associated with the tenant.

3. The system of claim 1, wherein the current batch of data and the previously stored batches of data include the same data objects.

4. The system of claim 1, wherein the detected rollback event corresponds to an automated event.

5. The system of claim 4, wherein the automated event includes a generated failure output if a batch of data cannot be stored in memory.

6. The system of claim 1, wherein collection of the current batch of data from the one or more sources includes instructions that indicates the period of time associated with the data to be collected and what data is to be collected.

7. The system of claim 1, wherein collection of the current batch of data from the one or more sources includes updating the batch log with a status associated with the collection.

8. The system of claim 7, wherein the collection status updated in the batch log includes “

not started”

, “

in-progress”

, “

successful”

, and “

failure”

.