- Patent Title: Method for merging data into a database table by locking data identities in the database table that are also present in a temporary copy of the database table and executing update and import functions
-
Application No.: US14487305Application Date: 2014-09-16
-
Publication No.: US11294883B2Publication Date: 2022-04-05
- Inventor: Matteo Bardini , Andrea Boero , Davide Mini
- Applicant: SIEMENS AKTIENGESELLSCHAFT
- Applicant Address: DE Munich
- Assignee: SIEMENS AKTIENGESELLSCHAFT
- Current Assignee: SIEMENS AKTIENGESELLSCHAFT
- Current Assignee Address: DE Munich
- Agent Laurence A. Greenberg; Werner H. Stemer; Ralph E. Locher
- Priority: EP13184492 20130916
- Main IPC: G06F16/23
- IPC: G06F16/23 ; G06F16/22

Abstract:
A method and a system import data into a table. The method includes providing the table with data identities and a primary key assigned to each of the data identities. A temporary copy of the table is provided and contains a data identity to be merged into the table. The table structure of the table and of the temporary copy is determined and the determined table structure is compared to the table structure of the temporary copy to decide which data identities have to be updated and/or imported. In the temporary copy a new column contains a final primary key of the related data identity for its transfer into the table. The data identities in the table that are present in the temporary copy are locked and an update function for the data identities having the same primary key in both the table and the temporary copy are executed.
Public/Granted literature
Information query