[go: up one dir, main page]

WO2002001415A3 - Computer method and device for transporting data - Google Patents

Computer method and device for transporting data Download PDF

Info

Publication number
WO2002001415A3
WO2002001415A3 PCT/US2001/019768 US0119768W WO0201415A3 WO 2002001415 A3 WO2002001415 A3 WO 2002001415A3 US 0119768 W US0119768 W US 0119768W WO 0201415 A3 WO0201415 A3 WO 0201415A3
Authority
WO
WIPO (PCT)
Prior art keywords
data
translated
common structure
present
source
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.)
Ceased
Application number
PCT/US2001/019768
Other languages
French (fr)
Other versions
WO2002001415A2 (en
Inventor
Firoz Kanchwalla
David Lyle
Sujit Bais
Srinivasan Maadapusi
Amol Dongre
Premkumar Somakumar
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.)
Informatica LLC
Original Assignee
Informatica LLC
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
Priority claimed from US09/877,370 external-priority patent/US7117215B1/en
Application filed by Informatica LLC filed Critical Informatica LLC
Priority to AU2001270013A priority Critical patent/AU2001270013A1/en
Priority to EP01948540A priority patent/EP1374090A2/en
Priority to CA2414230A priority patent/CA2414230C/en
Publication of WO2002001415A2 publication Critical patent/WO2002001415A2/en
Anticipated expiration legal-status Critical
Publication of WO2002001415A3 publication Critical patent/WO2002001415A3/en
Ceased legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Warehouses Or Storage Devices (AREA)

Abstract

A method and apparatus for transporting data for a data warehousing application. Data is extracted from one or more source containing data having a standard data structure and is translated into data that contains meaningful business terms. The translated data is then stored. In the present embodiment, an analytic business component is operable for extracting data from the source, translating the extracted data and for storing the translated data into a staging area. The translated data is then processed to obtain data having a common structure. In the present embodiment, a source adapter processes the translated data to obtain data having a common structure. The data having a common structure is then transformed into a format suitable for loading into a data mart. In the present embodiment, an analytic data interface receives the data having a common structure and transforms the data for loading into a data warehouse. The data is then stored in a data warehouse.
PCT/US2001/019768 2000-06-26 2001-06-21 Computer method and device for transporting data Ceased WO2002001415A2 (en)

Priority Applications (3)

Application Number Priority Date Filing Date Title
AU2001270013A AU2001270013A1 (en) 2000-06-26 2001-06-21 Computer method and device for transporting data
EP01948540A EP1374090A2 (en) 2000-06-26 2001-06-21 Computer method and device for transporting data
CA2414230A CA2414230C (en) 2000-06-26 2001-06-21 Computer method and device for transporting data

Applications Claiming Priority (4)

Application Number Priority Date Filing Date Title
US21429900P 2000-06-26 2000-06-26
US60/214,299 2000-06-26
US09/877,370 2001-06-07
US09/877,370 US7117215B1 (en) 2001-06-07 2001-06-07 Method and apparatus for transporting data for data warehousing applications that incorporates analytic data interface

Publications (2)

Publication Number Publication Date
WO2002001415A2 WO2002001415A2 (en) 2002-01-03
WO2002001415A3 true WO2002001415A3 (en) 2003-10-16

Family

ID=26908858

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2001/019768 Ceased WO2002001415A2 (en) 2000-06-26 2001-06-21 Computer method and device for transporting data

Country Status (4)

Country Link
EP (1) EP1374090A2 (en)
AU (1) AU2001270013A1 (en)
CA (1) CA2414230C (en)
WO (1) WO2002001415A2 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7260772B2 (en) 2002-10-21 2007-08-21 The Boeing Company System and method for creating a pert chart

Families Citing this family (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
GB2343763B (en) 1998-09-04 2003-05-21 Shell Services Internat Ltd Data processing system
AU2002951910A0 (en) * 2002-10-04 2002-10-24 Tenix Industries Pty Limited Data quality and integrity engine
WO2004038614A2 (en) * 2002-10-21 2004-05-06 The Boeing Company Client-server system for converting project management data
US7627504B2 (en) * 2002-10-31 2009-12-01 Thomson Reuters (Tax and Accounting) Services, Inc. Information processing system for determining tax information
CN103455477B (en) * 2013-09-09 2016-04-06 高晋愚 A kind of term unified approach for supplementary translation
US11093318B2 (en) 2017-06-23 2021-08-17 International Business Machines Corporation Data integration process refinement and rejected data correction
US11636129B2 (en) 2019-07-12 2023-04-25 Xivvic, LLC Active data executable

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5781911A (en) * 1996-09-10 1998-07-14 D2K, Incorporated Integrated system and method of data warehousing and delivery

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5781911A (en) * 1996-09-10 1998-07-14 D2K, Incorporated Integrated system and method of data warehousing and delivery

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
DUNCAN K ET AL: "Optimizing the data warehousing environment for change: the persistent staging area", CUTTER IT JOURNAL, JUNE 1999, CUTTER INF. CORP, USA, vol. 12, no. 6, pages 28 - 35, XP002245741, ISSN: 1048-5600 *
WEYMAN P J: "THE CASE FOR A PROCESS-DRIVEN APPROACH TO DATA WAREHOUSING", DATABASE AND NETWORK JOURNAL, A.P. PUBLICATIONS, LONDON, GB, vol. 27, no. 1, 1 February 1997 (1997-02-01), pages 3 - 6, XP002074806, ISSN: 0265-4490 *
WHITE C: "MANAGING DATA TRANSFORMATIONS", BYTE, MCGRAW-HILL INC. ST PETERBOROUGH, US, vol. 22, no. 12, 1 December 1997 (1997-12-01), pages 53 - 54, XP000728707, ISSN: 0360-5280 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7260772B2 (en) 2002-10-21 2007-08-21 The Boeing Company System and method for creating a pert chart

Also Published As

Publication number Publication date
WO2002001415A2 (en) 2002-01-03
AU2001270013A1 (en) 2002-01-08
EP1374090A2 (en) 2004-01-02
CA2414230A1 (en) 2002-01-03
CA2414230C (en) 2011-01-11

Similar Documents

Publication Publication Date Title
WO2000057316A3 (en) System and method for inputting, retrieving, organizing and analyzing data
WO2003075181A3 (en) A method and apparatus for providing search results in response to an information search request
WO2003077151A3 (en) A dynamic dictionary and term repository system
WO2001043030A8 (en) A method of component-based system development
TW200508860A (en) Systems and methods for storing data on computer systems
CA2313201A1 (en) Data input and retrieval apparatus
WO2007038390A3 (en) System and method for augmenting content in electronic documents with links to contextually relevant information
EP0856818A3 (en) Apparatus and method for accessing secured data stored in a portable data carrier
EP1109371A3 (en) Apparatus and method for dynamically limiting information sent to a viewing device
WO2001031828A3 (en) System and method for integrating paper-based business documents with computer-readable data entered via a computer network
WO2001042952A3 (en) Method and system for constructing personalized result sets
EP1274022A3 (en) Reproducing apparatus and method of providing bookmark information thereof
WO2005002108A3 (en) System and method for implementing sensor functionality in mobile devices
WO2007138600A3 (en) Method and system for transformation of logical data objects for storage
WO2001041083A3 (en) Method and apparatus for use in entering financial data into an electronic device
EP1577797A3 (en) Rendering tables with natural language commands
WO2008014011A3 (en) Identifying and/or extracting data in connection with creating or updating a record in a database
WO2001071542A3 (en) System and method for the transformation and canonicalization of semantically structured data
MY134408A (en) Method and computer-readable medium for imorting and exporting hierarchically structured data
EP1109104A1 (en) Deleting unused templates
WO2002001415A3 (en) Computer method and device for transporting data
WO2002059721A3 (en) System, method and software application for accessing and processing information
TWI348640B (en) Method, memory device, and memory card that supports file system interoperability
AU1856400A (en) Device for recording data corresponding to written or recorded information
TW346578B (en) Method and apparatus for information processing using an electronic mail, storage medium for storing a program for controlling an information processing apparatus

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG UZ VN YU ZA ZW

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): GH GM KE LS MW MZ SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE TR BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
DFPE Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101)
WWE Wipo information: entry into national phase

Ref document number: 2001948540

Country of ref document: EP

REG Reference to national code

Ref country code: DE

Ref legal event code: 8642

WWE Wipo information: entry into national phase

Ref document number: 2414230

Country of ref document: CA

WWP Wipo information: published in national office

Ref document number: 2001948540

Country of ref document: EP

NENP Non-entry into the national phase

Ref country code: JP

WWR Wipo information: refused in national office

Ref document number: 2001948540

Country of ref document: EP

WWW Wipo information: withdrawn in national office

Ref document number: 2001948540

Country of ref document: EP