Modifying archive data without table changes

Patent metadata

Field	Value
Publication number	US-10838934-B2
Application number	US-201715690644-A
Country	US
Kind code	B2
Filing date	Aug 30, 2017
Priority date	Aug 30, 2017
Publication date	Nov 17, 2020
Grant date	Nov 17, 2020

Abstract

A method, computer system, and computer program product for accessing archived data in a data processing system. The data processing system includes a transactional engine maintaining a first data table and an analytical engine. The method includes first archiving at the analytical engine the first data table, resulting in a first archived data table. Changes applicable to the first archived data table may be archived, wherein the second archiving includes: in case the changes induce a change in the structure of the first archived data table or modify the values of the first data table a second archived data table is created. In case the changes include data having a structure different from the structure of the first archived data table part of the changes that is storable according to the structure of the first archived data table may be inserted in the first archived data table.

First claim

What is claimed is:

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 at a time t 0 , wherein the first archiving creates a first archived data table comprising one or more attribute values of a first attribute type;
receiving a change of the first attribute type to a second attribute type to the first data table;
based on an attribute value type difference between a first data attribute value of the changed first data table compared to a corresponding first data attribute value of the first archived data table, performing a second archiving at the analytical engine at a time t 1 , wherein performing the second archiving comprises creating a second archived data table at the time t 1 , storing only a first portion of the first attribute value of the changed first data table that corresponds to the first attribute type in the first archived data table at the time t 1 and storing only the remaining portion of the first attribute value of the first data table consisting of the attribute value type difference in the second archived data table at the time t 1 ;
receiving at the analytical engine a query for accessing the archived data; and
running the query on a combination of the first archived data table and the second archived data table.

2. The method of claim 1 , further comprising:
creating a database view comprising the combination of the first archived data table and the second archived data table, wherein running the query comprises redirecting the received query for running against the database view.

3. The method of claim 1 , wherein running the query on the combination of the first archived data table and the second archived data table further comprises:
joining the first archived data table with records of the second archived data table having corresponding records of the first archived data table.

4. The method of claim 1 , further comprising:
performing a third archiving at the analytical engine; and
creating a third archived data table, wherein the third archived data table comprises a description of the second archiving.

5. The method of claim 1 ,
wherein the data processing system comprises a hybrid on-line analytical processing (OLTP) and on-line analytical processing (OLAP) database system, wherein the transactional engine is configured for performing OLTP processes, and wherein the analytical engine is configured for performing OLAP processes.

6. The method of claim 1 , further comprising:
based on the attribute value type difference between the first data table and the combination of the first archived data table and the second archived data table or a difference between a second data value of the first data table compared to a corresponding second data value of the combined first archived data table and the second archived data table, performing a third archiving at the analytical engine, wherein performing the third archiving comprises creating a third archived data table, storing a first portion of the a second data value in the first archived data table, storing a second portion of the second data value in the second archived data table, and storing a remaining portion of the second data value in the third archived data table, wherein the remaining portion of the second data value corresponds to the second structure difference;
receiving at the analytical engine a second query for the accessing archived data; and
running the query on a combination of the first archived data table, the second archived data table, and the third archived data table.

7. The method according to claim 1 , wherein the first data table comprises an arrangement of data in one or more rows and one or more columns, and wherein a data element corresponds to each combination of a row of the one or more rows and a column of the one or more columns, and wherein a record comprises data elements of a column of the one or columns and corresponding data elements of a row of the one or more rows.

8. The method according to claim 1 , further comprising:
identifying a new record in the first data table, wherein the new record is not in the first archived data table; and
archiving the new record in the first archived data table.

9. A computer program product 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 computer program product comprising:
one or more computer-readable storage medium and program instructions stored on at least one of the one or more storage medium, the program instructions executable by a processor, the program instructions comprising:
program instructions to perform a first archiving at the analytical engine of the first data table at a time t 0 , wherein the first archiving creates a first archived data table comprising one or more attribute values of a first attribute type;
program instructions to receive a change of the first attribute type to a second attribute type to the first data table;
based on an attribute value type difference between a first data attribute value of the changed first data table compared to a corresponding first data attribute value of the first archived data table, program instructions to perform a second archiving at the analytical engine at a time t 1 , wherein performing the second archiving comprises program instructions to create a second archived data table at the time t 1 , program instructions to store only a first portion of the first attribute value of the changed first data table that corresponds to the first attribute type in the first archived data table at the time t 1 and program instructions to store only the remaining portion of the first attribute value of the first data table consisting of the attribute value type difference in the second archived data table at the time t 1 ;
program instructions to receive at the analytical engine a query for accessing the archived data; and
program instructions to run the query on a combination of the first archived data table and the second archived data table.

10. The computer program product of claim 9 , further comprising:
program instructions to create a database view comprising the combination of the first archived data table and the second archived data table, wherein the program instructions to run the query comprises program instructions to redirect the received query for running against the database view.

11. The computer program product of claim 9 , wherein the program instructions to run the query on the combination of the first archived data table and the second archived data table further comprises:
program instructions to join the first archived data table with records of the second archived data table having corresponding records of the first archived data table.

12. The computer program product of claim 9 , further comprising:
program instructions to perform a third archiving at the analytical engine; and
program instructions to create a third archived data table, wherein the third archived data table comprises a description of the second archiving.

13. The computer program product of claim 9 ,
wherein the data processing system comprises a hybrid on-line analytical processing (OLTP) and on-line analytical processing (OLAP) database system, wherein the transactional engine is configured for performing OLTP processes, and wherein the analytical engine is configured

Assignees

• IBM

Inventors

• Becker Patric
• Immel Thomas
• Martin Daniel
• Stolze Knut

Classifications

• G06F16/21 Primary

  Design, administration or maintenance of databases · CPC title

• G06F16/2455

  Query execution · CPC title

• G06F16/219 Primary

  Managing data history or versioning (querying versioned data G06F16/2474; querying temporal data G06F16/2477) · CPC title

• G06F16/2456

  Join operations · CPC title

• G06F16/254

  Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses · CPC title