×

MODIFYING ARCHIVE DATA WITHOUT TABLE CHANGES

  • US 20190065536A1
  • Filed: 08/30/2017
  • Published: 02/28/2019
  • Est. Priority Date: 08/30/2017
  • Status: Active Grant
First Claim
Patent Images

1. A method for accessing archived data in a data processing system, the data processing system comprising a transactional engine maintaining a first data table and an analytical engine, the method comprising:

  • performing a first archiving at the analytical engine of the first data table, wherein the first archiving creates a first archived data table;

    based on a structure difference between the first archived data table and the first data table or a data difference between a first data value of the first data table compared to a corresponding first data value of the first archived data table, performing a second archiving at the analytical engine, wherein performing the second archiving comprises creating a second archived data table, storing a first portion of the first data value in the first archived data table, and storing a remaining portion of the first data value in the second archived data table, and wherein the remaining portion corresponds to the structure difference;

    receiving at the analytical engine a query for accessing archived data; and

    running the query on a combination of the first archived data table and the second archived data table.

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