CA2241767A1 - A system for transforming and exchanging data between distributed heterogeneous computer systems - Google Patents

A system for transforming and exchanging data between distributed heterogeneous computer systems

Info

Publication number
CA2241767A1
CA2241767A1 CA002241767A CA2241767A CA2241767A1 CA 2241767 A1 CA2241767 A1 CA 2241767A1 CA 002241767 A CA002241767 A CA 002241767A CA 2241767 A CA2241767 A CA 2241767A CA 2241767 A1 CA2241767 A1 CA 2241767A1
Authority
CA
Canada
Prior art keywords
data
import
bag
export
transforming
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
CA002241767A
Other languages
French (fr)
Other versions
CA2241767C (en
Inventor
Darin Ellis
Michael Doyle
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.)
Juxtacomm Technologies Inc
Original Assignee
Juxtacomm Technologies Inc
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
Family has litigation
First worldwide family litigation filed litigation Critical https://patents.darts-ip.com/?family=21969053&utm_source=google_patent&utm_medium=platform_link&utm_campaign=public_patent_search&patent=CA2241767(A1) "Global patent litigation dataset” by Darts-ip is licensed under a Creative Commons Attribution 4.0 International License.
Application filed by Juxtacomm Technologies Inc filed Critical Juxtacomm Technologies Inc
Priority to CA002446831A priority Critical patent/CA2446831A1/en
Publication of CA2241767A1 publication Critical patent/CA2241767A1/en
Application granted granted Critical
Publication of CA2241767C publication Critical patent/CA2241767C/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
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/12—Use of codes for handling textual entities
    • G06F40/151—Transformation
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99931—Database or file accessing
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99931—Database or file accessing
    • Y10S707/99932—Access augmentation or optimizing
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99931—Database or file accessing
    • Y10S707/99938—Concurrency, e.g. lock management in shared database
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99941—Database schema or data structure
    • Y10S707/99943—Generating database or data structure, e.g. via user interface
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99941—Database schema or data structure
    • Y10S707/99944—Object-oriented database structure

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Computer And Data Communications (AREA)

Abstract

A system and method is described for importing data from a source computer system, manipulating and transforming of that data, and exporting the data to a target computer system under control of a script processor using stored metadata definitions. Metadata is used to describe the properties of the data being manipulated.
The system includes a means for manipulating the metadata definitions. The metadata definitions are created to import data into the system, export data from the system, create views of the external data, store generic format data within the system, manipulate generic format data within the system and to control data flow through the system. Data is imported into the system using an import data definition to map the external data into an import data bag. Data imported into an import data bag becomes independent of the original data source. Data is manipulated within the system using script control commands and data is transformed within the system using rule sets that act upon data bags. Data is exported from the system using an export data definition to map the import data bag into the required export data bag format and then to write data in the export data bag to the external data target.
CA002241767A 1997-06-27 1998-06-26 A system for transforming and exchanging data between distributed heterogeneous computer systems Expired - Fee Related CA2241767C (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CA002446831A CA2446831A1 (en) 1997-06-27 1998-06-26 System for transforming and exchanging data between distributed heterogeneous computer systems

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US5105297P 1997-06-27 1997-06-27
US60/051,052 1997-06-27

Related Child Applications (1)

Application Number Title Priority Date Filing Date
CA002446831A Division CA2446831A1 (en) 1997-06-27 1998-06-26 System for transforming and exchanging data between distributed heterogeneous computer systems

Publications (2)

Publication Number Publication Date
CA2241767A1 true CA2241767A1 (en) 1998-12-27
CA2241767C CA2241767C (en) 2004-01-20

Family

ID=21969053

Family Applications (1)

Application Number Title Priority Date Filing Date
CA002241767A Expired - Fee Related CA2241767C (en) 1997-06-27 1998-06-26 A system for transforming and exchanging data between distributed heterogeneous computer systems

Country Status (2)

Country Link
US (1) US6195662B1 (en)
CA (1) CA2241767C (en)

Families Citing this family (65)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6728933B1 (en) * 1996-11-03 2004-04-27 International Business Machines Corporation System and method for importing data
US6310888B1 (en) * 1997-12-30 2001-10-30 Iwork Software, Llc System and method for communicating data
US6446075B1 (en) * 1998-02-25 2002-09-03 International Business Machines Corporation System and method for automatically synchronizing different classes of databases utilizing a repository database
US6366916B1 (en) * 1998-05-22 2002-04-02 International Business Machines Corporation Configurable and extensible system for deploying asset management functions to client applications
US6338069B1 (en) * 1998-12-11 2002-01-08 Daman, Inc. Method and apparatus for managing functions
US6889260B1 (en) * 1999-06-10 2005-05-03 Ec Enabler, Ltd Method and system for transferring information
US6449619B1 (en) * 1999-06-23 2002-09-10 Datamirror Corporation Method and apparatus for pipelining the transformation of information between heterogeneous sets of data sources
US7046691B1 (en) 1999-10-04 2006-05-16 Microsoft Corporation Methods and systems for dynamic conversion of objects from one format type to another format type by selectively using an intermediary format type
US6665657B1 (en) * 1999-11-19 2003-12-16 Niku Corporation Method and system for cross browsing of various multimedia data sources in a searchable repository
US6772413B2 (en) * 1999-12-21 2004-08-03 Datapower Technology, Inc. Method and apparatus of data exchange using runtime code generator and translator
US10002167B2 (en) * 2000-02-25 2018-06-19 Vilox Technologies, Llc Search-on-the-fly/sort-on-the-fly by a search engine directed to a plurality of disparate data sources
US20020042835A1 (en) * 2000-03-29 2002-04-11 Pepin Christine S. Method and apparatus for enabling bulk loading of data
US6718336B1 (en) * 2000-09-29 2004-04-06 Battelle Memorial Institute Data import system for data analysis system
US6910045B2 (en) 2000-11-01 2005-06-21 Collegenet, Inc. Automatic data transmission in response to content of electronic forms satisfying criteria
US20040068509A1 (en) * 2001-01-19 2004-04-08 Garden Peter William Data transfer and/or transformation system and method
US7302634B2 (en) * 2001-03-14 2007-11-27 Microsoft Corporation Schema-based services for identity-based data access
US20020133535A1 (en) * 2001-03-14 2002-09-19 Microsoft Corporation Identity-centric data access
US7539747B2 (en) * 2001-03-14 2009-05-26 Microsoft Corporation Schema-based context service
US7284271B2 (en) 2001-03-14 2007-10-16 Microsoft Corporation Authorizing a requesting entity to operate upon data structures
US7136859B2 (en) * 2001-03-14 2006-11-14 Microsoft Corporation Accessing heterogeneous data in a standardized manner
US7024662B2 (en) * 2001-03-14 2006-04-04 Microsoft Corporation Executing dynamically assigned functions while providing services
CN1384454A (en) * 2001-05-01 2002-12-11 株式会社东芝 Information generalizing system and method
US20030163479A1 (en) * 2001-05-14 2003-08-28 Mathews Michael B. Method and apparatus for implementing a data management system using a metadata specification
US20030140220A1 (en) * 2001-06-29 2003-07-24 Bull Hn Information Systems Inc. Method and data processing system providing remote program initiation and control across multiple heterogeneous computer systems
US7421704B2 (en) * 2001-07-05 2008-09-02 Computer Associates Think, Inc. System and method for identifying and generating business events
IL159689A0 (en) * 2001-07-05 2004-06-20 Computer Ass Think Inc System and method for analyzing business events
GB2395041A (en) * 2001-08-14 2004-05-12 Bloomberg Lp Distribution and mapping of financial records from data stream
US7089245B1 (en) * 2001-08-31 2006-08-08 Bmc Software, Inc. Service desk data transfer interface
US20030182273A1 (en) * 2002-03-22 2003-09-25 Goldberg Robert N. Method and apparatus for generating a query object
EP1349080A1 (en) * 2002-03-26 2003-10-01 Deutsche Thomson-Brandt Gmbh Methods and apparatus for using metadata from different sources
US7574652B2 (en) * 2002-06-20 2009-08-11 Canon Kabushiki Kaisha Methods for interactively defining transforms and for generating queries by manipulating existing query data
US9886309B2 (en) 2002-06-28 2018-02-06 Microsoft Technology Licensing, Llc Identity-based distributed computing for device resources
AU2002953555A0 (en) * 2002-12-23 2003-01-16 Canon Kabushiki Kaisha Method for presenting hierarchical data
US7644361B2 (en) * 2002-12-23 2010-01-05 Canon Kabushiki Kaisha Method of using recommendations to visually create new views of data across heterogeneous sources
TW200419413A (en) 2003-01-13 2004-10-01 I2 Technologies Inc Master data management system for centrally managing core reference data associated with an enterprise
US7970698B2 (en) * 2003-08-27 2011-06-28 Equifax, Inc. Application processing and decision systems and processes
US11132183B2 (en) 2003-08-27 2021-09-28 Equifax Inc. Software development platform for testing and modifying decision algorithms
EP1513076A1 (en) * 2003-09-05 2005-03-09 Sap Ag Method and computer system for data conversion
US7574926B2 (en) * 2003-12-19 2009-08-18 Deere & Company Rotary cam driven sensor and feedback control
US20050228765A1 (en) * 2004-01-16 2005-10-13 Taiwan Semiconductor Manufacturing Co. Mechanism for synchronizing manafacturing information systems and document content management systems data
US8311974B2 (en) * 2004-02-20 2012-11-13 Oracle International Corporation Modularized extraction, transformation, and loading for a database
DE112005000509T5 (en) * 2004-03-04 2007-01-18 Mathsoft Engineering & Education, Inc., Cambridge Method for automatically enabling traceability of engineering calculations
US8554805B2 (en) * 2004-05-17 2013-10-08 Sap Ag Methods and systems for importing source data
US7437358B2 (en) 2004-06-25 2008-10-14 Apple Inc. Methods and systems for managing data
US7730012B2 (en) 2004-06-25 2010-06-01 Apple Inc. Methods and systems for managing data
US20060106856A1 (en) * 2004-11-04 2006-05-18 International Business Machines Corporation Method and system for dynamic transform and load of data from a data source defined by metadata into a data store defined by metadata
US8321465B2 (en) * 2004-11-14 2012-11-27 Bloomberg Finance L.P. Systems and methods for data coding, transmission, storage and decoding
US20060224613A1 (en) * 2005-03-31 2006-10-05 Bermender Pamela A Method and system for an administrative apparatus for creating a business rule set for dynamic transform and load
US7483882B1 (en) * 2005-04-11 2009-01-27 Apple Inc. Dynamic management of multiple persistent data stores
US7779017B2 (en) * 2006-01-12 2010-08-17 Microsoft Corporation Employing abstract pipeline component connections to maintain data flow
US20070299828A1 (en) * 2006-06-05 2007-12-27 Digital Mountain, Inc. Method and Apparatus for Processing Heterogeneous Data
CA2695898C (en) * 2007-08-07 2016-12-20 Equifax, Inc. Systems and methods for managing statistical expressions
US8918412B1 (en) * 2007-11-15 2014-12-23 Progress Software Corporation Query proxy system for client-specified models
FR2931272B1 (en) * 2008-05-13 2012-04-20 Thales Sa METHOD FOR IMPORT EXPORT OF DATA FROM A DATABASE
US8359323B2 (en) * 2008-06-11 2013-01-22 International Business Machines Corporation Method and system for providing access to adapters
US20100057678A1 (en) * 2008-08-28 2010-03-04 Gene Fein Import/export modeling system
US8234219B2 (en) * 2008-09-09 2012-07-31 Applied Systems, Inc. Method, system and apparatus for secure data editing
TWI513237B (en) * 2009-06-19 2015-12-11 Chunghwa Telecom Co Ltd Off - site network information exchange and multiple communication protocol transmission system and its method
CN103412765A (en) * 2013-09-04 2013-11-27 广东全通教育股份有限公司 Method for realizing universality of data exporting interface
CN104765736B (en) * 2014-01-03 2017-11-14 北大方正集团有限公司 Database leads storehouse method and device
US11080244B2 (en) * 2014-05-28 2021-08-03 Hewlett Packard Enterprise Development Lp Inter-version mapping of distributed file systems
US8938414B1 (en) * 2014-06-05 2015-01-20 GoodData Corporation Data abstraction layer for interfacing with reporting systems
US20160306883A1 (en) * 2015-04-20 2016-10-20 Tobias Weller Business Intelligence Computing System with Offline Usage
US10437440B2 (en) * 2015-09-04 2019-10-08 Salesforce.Com, Inc. Analytic data export tool
CN110532305B (en) * 2018-05-23 2022-11-08 中国移动通信集团浙江有限公司 Service data cutting-over method and system

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5497491A (en) * 1993-01-26 1996-03-05 International Business Machines Corporation System and method for importing and exporting data between an object oriented computing environment and an external computing environment
US6078925A (en) * 1995-05-01 2000-06-20 International Business Machines Corporation Computer program product for database relational extenders
US5729733A (en) * 1995-05-05 1998-03-17 Harris Corporation Method of operating a distributed databse based on object ownership and transaction classification utilizing an aggressive reverse one phase commit protocol
US5988862A (en) * 1996-04-24 1999-11-23 Cyra Technologies, Inc. Integrated system for quickly and accurately imaging and modeling three dimensional objects
US5970490A (en) * 1996-11-05 1999-10-19 Xerox Corporation Integration platform for heterogeneous databases

Also Published As

Publication number Publication date
US6195662B1 (en) 2001-02-27
CA2241767C (en) 2004-01-20

Similar Documents

Publication Publication Date Title
CA2241767A1 (en) A system for transforming and exchanging data between distributed heterogeneous computer systems
EP1324182A3 (en) System and method for peripheral device virtual functionality overlay
GB2383929A (en) Real-time streamed data download system and method
EP0578204A3 (en)
WO2000057316A3 (en) System and method for inputting, retrieving, organizing and analyzing data
WO2000056066A8 (en) Systems and methods for electronic program guide data services
WO2002046927A3 (en) System and method for redirecting a data dump generated by network devices
AU2014599A (en) A home audio/video network with device control
WO2002057926A8 (en) Data transfer and/or transformation system and method
WO2001067289A3 (en) Method and system for applying xml schema
WO2002057875A3 (en) Method of accessing data and logic on existing systems through dynamic construction of software components
CA2290983A1 (en) System and method for changing program guide format
AU7440900A (en) Pattern matching for data exchange between computer aided design systems
EP1274021A3 (en) Method and system for capturing memories of deceased individuals
TW324127B (en) Sound reproducing array processing system
AU4483397A (en) Method for accessing information on a host computer from a client computer
EP1361520A4 (en) Electronic mail system, electronic mail creating method, program, and record medium
CA2150765A1 (en) Method and Operating System for Separately Manipulating the Architecture and Content of a Document
CA2097564A1 (en) Method of coupling open systems to a proprietary network
WO1997042575A3 (en) System and method for handling technical information
WO2001042985A3 (en) Sharing data between operating systems
CA2239168A1 (en) Method and system for data transfer
CA2362618A1 (en) Method, computer program product and system for the transmission of computer data to an output device
WO2002008979A1 (en) Assets management system, terminal for assets management, and assets management device
WO2003078252A3 (en) Method and apparatus for a hydrogen fuel cassette distribution and recovery system

Legal Events

Date Code Title Description
EEER Examination request
MKLA Lapsed

Effective date: 20130626