Method and device for determining data mapping relationship between database tables

A data mapping and database technology, which is applied in the field of determining the data mapping relationship between the source database table and the target database table, can solve problems such as failure to find BI solution errors, achieve comprehensive test coverage, save time and cost.

Inactive Publication Date: 2015-02-11
IBM CORP
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] Some errors in the BI solution may not be discovered as only part of the data in the target and source databases can be validated

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 device for determining data mapping relationship between database tables
  • Method and device for determining data mapping relationship between database tables
  • Method and device for determining data mapping relationship between database tables

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] Embodiments of the present invention will be described below with reference to the drawings. In the following description, numerous specific details are set forth in order to provide a more complete understanding of the present invention. It will be apparent, however, to one skilled in the art that the present invention may be practiced without some of these specific details. Furthermore, it should be understood that the invention is not limited to the particular embodiments described. Instead, it is conceivable to implement the present invention in any combination of the following features and elements, regardless of whether they relate to different embodiments. Accordingly, the following aspects, features, embodiments and advantages are by way of illustration only and should not be considered as elements or limitations of the appended claims unless expressly stated in the claims.

[0024] Now refer to the attached image 3 , which shows a method for determining a d...

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

A method and apparatus for determining a data mapping relationship between a source database table and a target database table are included. The method includes obtaining attribute values of an attribute other than a primary key and corresponding primary key value sets from plural rows of data in a source database table, and obtaining attribute values of a specific attribute other than a corresponding primary key and corresponding primary key value sets from plural rows of data in the target database table. A determination is made as to whether the attribute of the source database table and the specific attribute of the target database table have a potential data mapping relationship. If the determination is affirmative, a data mapping relationship is determined therebetween.

Description

technical field [0001] The present invention relates to data processing technology, in particular to a method and device for determining the data mapping relationship between a source database table and a target database table, and a method and device for verifying data. Background technique [0002] For many years, business intelligence (BI) has been a technology hotspot, and more and more enterprises have adopted business intelligence technology to provide decision support. Business intelligence refers to computer-based techniques for discovering, collecting, and analyzing business data such as sales, costs, and revenues of an enterprise. Business intelligence technology usually uses the process of ETL (Extract-Transform-Load, that is, data extraction, conversion, and loading), from the enterprise itself, such as ERP (Enterprise Resource Planning, that is, enterprise resource planning), CRM (Customer Relationship Management, that is, customer relationship management) ) an...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
CPCG06F17/30563G06F16/254
Inventor 谈华芳朱俊高雪峰鞠琳
Owner IBM CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap