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

Method and system for developing data integration applications with reusable functional rules that are managed according to their output variables

Inactive Publication Date: 2009-11-12
QLIKTECH INT
View PDF21 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Benefits of technology

[0011]When a database system is upgraded or replaced, the existing data must be transferred to the new system. This process, called data migration, is becoming increasingly expensive as database systems become larger and more complex. Planning

Problems solved by technology

This process, called data migration, is becoming increasingly expensive as database systems become larger and more complex.
Planning and executing a data migration consumes valuable resources and can often result in considerable downtime.
Also, mistakes in data migration can lead to data corruption, which is not an acceptable risk for institutions that handle sensitive data.
These difficulties are compounded when it is necessary to combine data from several different data storage systems, a process known as data integration.
These are complicated tasks, and they require careful planning and detailed knowledge of the structure of the source databases.
Errors in data integration are common, difficult to diagnose, and expensive to fix.
In the past, data integration applications have typically been developed for a specific database upgrade or merger task, and they become useless after this task is complete.
This ad hoc approach makes it impossible to reuse program code, substantially increasing the cost of development.
Also, it tends to produce applications that are written from scratch and not comprehensively tested, increasing the likelihood of data corruption.

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 system for developing data integration applications with reusable functional rules that are managed according to their output variables
  • Method and system for developing data integration applications with reusable functional rules that are managed according to their output variables
  • Method and system for developing data integration applications with reusable functional rules that are managed according to their output variables

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035]I. Introduction

[0036]Preferred embodiments of the present invention provide semantic systems and methods for developing, deploying, running, maintaining, and analyzing data integration applications and environments.

[0037]Those data integration applications that are relevant to the techniques described herein are broadly described by the class of applications concerned with the movement and transformation of data between systems and commonly represented by, but not limited to: data warehousing or ETL (extract-transform-load) applications, data profiling and data quality applications, and data migration applications that are concerned with moving data from old to new systems.

[0038]Data integration applications developed and maintained using these techniques are developed using a semantic model. At its core, a semantic development model enables an application to be partially or fully developed without knowledge of the physical data identities (locations, structures, names, types,...

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

Methods and systems for developing data integration applications with reusable functional rules that are managed according to their output variables. Methods include receiving a functional rule as part of a data integration application, associating the functional rule with the semantic name of its output value, and reusing the same functional rule later in the development process in order to express the same output value.

Description

CROSS-REFERENCE TO RELATED APPLICATIONS[0001]This application claims the benefit under 35 U.S.C. §119(e) of the following application, the contents of which are incorporated by reference herein:[0002]U.S. Provisional Application No. 61 / 052,548, entitled Method and System for Structuring and Performing Data Integration and Conversion Using a Semantic Model, filed on May 12, 2008.[0003]This application is related to the following applications, filed on an even date herewith:[0004]U.S. patent application Ser. No. ______, entitled Method and System for Debugging Data Integration Applications with Reusable Synthetic Data Values;[0005]U.S. patent application Ser. No. ______, entitled Method and System for Managing the Development of Data Integration Projects to Facilitate Project Development and Analysis Thereof,[0006]U.S. patent application Ser. No. ______, entitled Method and System for Developing Data Integration Applications with Reusable Semantic Identifiers to Represent Application ...

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
CPCG06F8/71G06Q10/06G06F17/30569G06F16/258
Inventor RUSSELL, JOHN
Owner QLIKTECH INT
Features
  • Generate Ideas
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More