CA2453605A1 - Integrated visual and language-based system and method for reusable data transformations - Google Patents

Integrated visual and language-based system and method for reusable data transformations Download PDF

Info

Publication number
CA2453605A1
CA2453605A1 CA002453605A CA2453605A CA2453605A1 CA 2453605 A1 CA2453605 A1 CA 2453605A1 CA 002453605 A CA002453605 A CA 002453605A CA 2453605 A CA2453605 A CA 2453605A CA 2453605 A1 CA2453605 A1 CA 2453605A1
Authority
CA
Canada
Prior art keywords
modules
transformation
format
data
language
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CA002453605A
Other languages
French (fr)
Other versions
CA2453605C (en
Inventor
Srinivas Chari
Dirk A. Seelemann
Milorad Stefanovic
Crystal J. Su
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
IBM Canada Ltd
Original Assignee
IBM Canada Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by IBM Canada Ltd filed Critical IBM Canada Ltd
Priority to CA002453605A priority Critical patent/CA2453605C/en
Priority to US10/753,857 priority patent/US7512937B2/en
Publication of CA2453605A1 publication Critical patent/CA2453605A1/en
Application granted granted Critical
Publication of CA2453605C publication Critical patent/CA2453605C/en
Anticipated expiration legal-status Critical
Expired - Fee Related legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems
    • G06F16/258—Data format conversion from or to a database

Abstract

There is provided a system and method for deploying a set of coupled data transformation modules describing a data transformation, the data transformation for transforming a data structure from a first format to a second format, the method including the steps of receiving an instruction for selecting the set of transformation modules from a memory; converting each of the set of transformation modules to a common model format, the set of modules having at least one transformation module being of a module type of a type set including language constructed modules and visually constructed modules; and generating an executable version of the converted transformation modules suitable for execution by a data transformation engine; wherein the executable version when executed transforms the data structure from the first format to the second format.
CA002453605A 2003-12-17 2003-12-17 Integrated visual and language-based system and method for reusable data transformations Expired - Fee Related CA2453605C (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
CA002453605A CA2453605C (en) 2003-12-17 2003-12-17 Integrated visual and language-based system and method for reusable data transformations
US10/753,857 US7512937B2 (en) 2003-12-17 2004-01-08 Integrated visual and language-based method for reusable data transformations

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CA002453605A CA2453605C (en) 2003-12-17 2003-12-17 Integrated visual and language-based system and method for reusable data transformations
US10/753,857 US7512937B2 (en) 2003-12-17 2004-01-08 Integrated visual and language-based method for reusable data transformations

Publications (2)

Publication Number Publication Date
CA2453605A1 true CA2453605A1 (en) 2005-06-17
CA2453605C CA2453605C (en) 2009-06-30

Family

ID=34827919

Family Applications (1)

Application Number Title Priority Date Filing Date
CA002453605A Expired - Fee Related CA2453605C (en) 2003-12-17 2003-12-17 Integrated visual and language-based system and method for reusable data transformations

Country Status (2)

Country Link
US (1) US7512937B2 (en)
CA (1) CA2453605C (en)

Families Citing this family (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20070088735A1 (en) 2005-10-17 2007-04-19 International Business Machines Corporation Optimization-based visual context management
US7689576B2 (en) * 2006-03-10 2010-03-30 International Business Machines Corporation Dilation of sub-flow operators in a data flow
US9361137B2 (en) * 2006-03-10 2016-06-07 International Business Machines Corporation Managing application parameters based on parameter types
US7689582B2 (en) * 2006-03-10 2010-03-30 International Business Machines Corporation Data flow system and method for heterogeneous data integration environments
US9727604B2 (en) * 2006-03-10 2017-08-08 International Business Machines Corporation Generating code for an integrated data system
US8005849B2 (en) * 2006-08-31 2011-08-23 Red Hat, Inc. Database access server with reformatting
US8099725B2 (en) * 2006-10-11 2012-01-17 International Business Machines Corporation Method and apparatus for generating code for an extract, transform, and load (ETL) data flow
US8160999B2 (en) * 2006-12-13 2012-04-17 International Business Machines Corporation Method and apparatus for using set based structured query language (SQL) to implement extract, transform, and load (ETL) splitter operation
US8219518B2 (en) 2007-01-09 2012-07-10 International Business Machines Corporation Method and apparatus for modelling data exchange in a data flow of an extract, transform, and load (ETL) process
US8180880B2 (en) * 2009-11-25 2012-05-15 At&T Intellectual Property I, L.P. Active intelligent content
US9977653B2 (en) 2012-06-30 2018-05-22 International Business Machines Corporation Discovery and modeling of deployment actions for multiple deployment engine providers
US11922564B2 (en) 2017-06-05 2024-03-05 Umajin Inc. Generative content system that supports location-based services and methods therefor
US20200285977A1 (en) 2017-06-05 2020-09-10 Umajin Inc. Asset tracking system and methods
WO2018226621A1 (en) 2017-06-05 2018-12-13 Umajin Inc. Methods and systems for an application system
US11726822B2 (en) 2017-06-05 2023-08-15 Umajin Inc. Systems and methods for providing digital twin-enabled applications
US11188390B2 (en) 2017-06-05 2021-11-30 Umajin Inc. Method for configuring a server kit by a server management system

Family Cites Families (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5421008A (en) * 1991-11-08 1995-05-30 International Business Machines Corporation System for interactive graphical construction of a data base query and storing of the query object links as an object
US5694578A (en) 1992-12-18 1997-12-02 Silicon Graphics, Inc. Computer-implemented method and apparatus for converting data according to a selected data transformation
US5911070A (en) * 1995-08-07 1999-06-08 Inprise Corporation Development system with methods for bi-directional application program code generation
US6032144A (en) * 1996-05-29 2000-02-29 Lucent Technologies Inc. Optimization of queries using relational algebraic theta-semijoin operator
JPH1165832A (en) * 1997-08-21 1999-03-09 Sony Corp Source code converting method and record medium
US6282699B1 (en) 1999-02-23 2001-08-28 National Instruments Corporation Code node for a graphical programming system which invokes execution of textual code
US6662356B1 (en) * 1999-06-30 2003-12-09 Microsoft Corporation Application program interface for transforming heterogeneous programs
US6993717B2 (en) * 2002-02-12 2006-01-31 Siemens Medical Solutions Health Services Inc. Data transformation system

Also Published As

Publication number Publication date
US7512937B2 (en) 2009-03-31
CA2453605C (en) 2009-06-30
US20050137852A1 (en) 2005-06-23

Similar Documents

Publication Publication Date Title
CA2453605A1 (en) Integrated visual and language-based system and method for reusable data transformations
WO2003003240A3 (en) Method and system for transforming an xml document according to subset of xml grammar rules
WO2006081084A3 (en) Remote component and connection architecture
WO2003069442A3 (en) Ontology frame-based knowledge representation in the unified modeling language (uml)
EP0768612A3 (en) Method and apparatus for generating structured document
EP1657649A3 (en) System and method for transforming legacy documents into XML documents
WO2005041033A3 (en) Method and apparatus for a hierarchical object model-based constrained language interpreter-parser
CA2351701A1 (en) System and method for implementing a natural language user interface
WO2001067290A3 (en) Method and system for modeling a legacy computer system
EP1491999A3 (en) Software development infrastructure
WO2003071519A8 (en) Voice-controlled data entry
WO2006118872A3 (en) Application description language
WO2002082318A3 (en) System and method for extracting information
WO2007062140A3 (en) System and method for generating, maintaining, and rendering landing and web pages
WO2001071542A3 (en) System and method for the transformation and canonicalization of semantically structured data
WO2005003965A3 (en) Data migration and format transformation system
WO2005008473A3 (en) System and method for using an xml file to control xml to entity/relationship transformation
CA2390440A1 (en) System and method for multiple level architecture by use of abstract application notation
GB2438555A (en) Method and system for product design
Ginev et al. The LATEXML daemon: Editable math on the collaborative web
WO2009017640A3 (en) Process modeling and optimization method and system
EP1675026A3 (en) Arrangement enabling thin client to access and present data in custom defined reports
EP0747792A3 (en) Modular print engine assessment method using models
WO2003102763A3 (en) Generation of executable processes for distribution
WO2002079929A3 (en) Method and system for converting data files from a first format to a second format

Legal Events

Date Code Title Description
EEER Examination request
MKLA Lapsed

Effective date: 20121217

MKLA Lapsed

Effective date: 20121217