17530396. MAINTAINING AT A TARGET DATABASE SYSTEM A COPY OF A SOURCE TABLE OF A SOURCE DATABASE SYSTEM simplified abstract (International Business Machines Corporation)

MAINTAINING AT A TARGET DATABASE SYSTEM A COPY OF A SOURCE TABLE OF A SOURCE DATABASE SYSTEM

Organization Name

International Business Machines Corporation

Inventor(s)

Daniel Martin of Leinfelden-Echterdingen (DE)

Christian Wilhelm Paul Hoerst of Boeblingen (DE)

[[:Category:Jens M�ller of Stuttgart (DE)|Jens M�ller of Stuttgart (DE)]][[Category:Jens M�ller of Stuttgart (DE)]]

Johannes Severin Kern of Boeblingen (DE)

Kevin Pelletier of Saint-Genis Pouilly (FR)

Vassil Radkov Dimov of Stuttgart (DE)

Namik Hrle of Boeblingen (DE)

MAINTAINING AT A TARGET DATABASE SYSTEM A COPY OF A SOURCE TABLE OF A SOURCE DATABASE SYSTEM - A simplified explanation of the abstract

This abstract first appeared for US patent application 17530396 titled 'MAINTAINING AT A TARGET DATABASE SYSTEM A COPY OF A SOURCE TABLE OF A SOURCE DATABASE SYSTEM

Simplified Explanation

The abstract of this patent application describes a method for creating a target database system with a target table and a history table, both having attributes from a source table and a time attribute indicating the validity of each record. When a change is requested for the source table, the change is applied to the target table and assigned a time value. The previous version of the record is stored in the history table. The target table and history table can be used to process queries based on the time attribute.

• The patent application describes a method for creating a target database system with a target table and a history table.
• Both tables have attributes from a source table and a time attribute indicating the validity of each record.
• When a change is requested for the source table, it is applied to the target table and assigned a time value.
• The previous version of the record is stored in the history table.
• The target table and history table can be used to process queries based on the time attribute.

Potential Applications

• This technology can be applied in various industries that require tracking changes to data over time, such as financial services, healthcare, and supply chain management.
• It can be used in data analysis and reporting systems where historical data is important for making informed decisions.
• This method can be implemented in customer relationship management (CRM) systems to track changes in customer data and analyze trends over time.

Problems Solved

• This technology solves the problem of efficiently managing and tracking changes to data over time in a database system.
• It provides a solution for maintaining a historical record of data changes, allowing for analysis and reporting based on specific time periods.
• The method addresses the challenge of processing queries that require selecting data based on its validity at a specific time.

Benefits

• The use of a target table and history table allows for efficient storage and retrieval of data changes over time.
• By assigning a time attribute to each record, it becomes easier to track and analyze changes in the data.
• The ability to process redirected queries based on the time attribute enables users to retrieve data as it was valid at a specific point in time.

Original Abstract Submitted

Creating at a target database system, a target table and a history table each having a set of attributes of a source table in addition to at least one time attribute, wherein the time attribute of a record indicates the time when the record is valid. Receiving a request for applying a change of the source table to the target table. The request comprises a time value generated by the source database system indicating a time of the change. The change to the target table and the time value may be assigned to the time attribute of the current version and previous version of the record. The previous version of the record may be stored in the history table. The target table and the history table may be used to process a redirected query comprising a selection criterion on the time attribute.