Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and a system for merging data into a database table

A data import and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as inconsistency, data corruption, improper analysis of database identification fields and other relationships

Active Publication Date: 2015-03-25
SIEMENS AG
View PDF5 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, a persistent problem in the industrial environment of Manufacturing Execution Systems (MES) is the problem of inserting / merging data between different databases that are subject to physical and / or logical and / or Constraints caused by the application
Additionally, database engines often include backup / restore functionality, but backup / restore functionality is useless for merging data identity, because these database engines do not properly analyze the identity fields and other relationships of the database, causing possible Data Corruption and Inconsistency

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and a system for merging data into a database table
  • Method and a system for merging data into a database table
  • Method and a system for merging data into a database table

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] figure 1 A master parent table 2 and a temporary copy 4 of the master parent table 2 are schematically shown. In this example, the main parent table 2 includes three columns: the first column PK containing the primary key, the second column ID containing the data identifier, and the third column DSC containing the valid value of the data identifier. The temporary copy 4 of the main parent table 2 includes five columns, wherein the first three columns are the same as the three columns of the main parent table 2 in terms of structure. The fourth column PK_NEW includes the new primary key identified by each data before the merge operation. The fifth column, OPER, includes the type of merge operation performed during the merge operation.

[0035] Temporary copy 4 typically includes all data items that have to be merged into main parent table 2 . The comparison operation is performed in the data structure of the main parent table 2 and the temporary copy 4, where the anal...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The present invention relates to a method and a system for importing data into a database table with constraints consistency analysis and customized merge parameters. 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 generated and contains at least one data identity to be merged into the table. The table structure of the table and the table structure of the temporary copy are determined. A temporary copy of a new column is created and contains a final primary key of the related data identity for its transfer into the table, thereby assigning the same primary key to the data identity in the temporary copy if the data exists already in the table. A new primary key is assigned to the data identity in the temporary copy if the data identity is not present yet in 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. An import function for the data identities having a newly assigned primary key comprised in the new column of the temporary copy is also executed. The locked data identities are unlocked after the successful execution of the updating and the importing function.

Description

technical field [0001] The present invention relates to a method and system for importing data into a database table using constraint consistency analysis and custom merging parameters. Background technique [0002] A known method and system for storing data identities in a database structure, such as that of a SQL server, comprises: storing values ​​in fields of a table having several records. Fields can be of various data types such as char, varchar, nvarchar, decimal, integer, real, etc. Each data type has its own size, which can be predetermined or variable. For example, "varchar", "nvarchar" data types are suitable for storing values ​​with variable size, while "char", "decimal", "integer" data types are suitable for storing values ​​with fixed size. [0003] In this regard, a database management system (DBMS) allocates storage space of a non-constant size to fields with "nvarchar" datatype. In some known implementations, in order to avoid the storage waste caused by...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30
CPCG06F16/2379G06F16/2365G06F16/2282
Inventor 马泰奥·巴尔迪尼安德烈亚·博埃罗达维德·米尼
Owner SIEMENS AG
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com