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 embodiment
source
Prior art date
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
Original Assignee
Informatica Corp
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 to US21429900P priority Critical
Priority to US60/214,299 priority
Priority to US09/877,370 priority
Priority to US09/877,370 priority patent/US7117215B1/en
Application filed by Informatica Corp filed Critical Informatica Corp
Publication of WO2002001415A2 publication Critical patent/WO2002001415A2/en
Publication of WO2002001415A3 publication Critical patent/WO2002001415A3/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/252Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/258Data format conversion from or to a database

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 WO2002001415A2 (en)

Priority Applications (4)

Application Number Priority Date Filing Date Title
US21429900P true 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

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
AU7001301A AU7001301A (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

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 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) AU7001301A (en)
CA (1) CA2414230C (en)
WO (1) WO2002001415A2 (en)

Families Citing this family (6)

* 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
WO2004038550A2 (en) 2002-10-21 2004-05-06 The Boeing Company System and method for creating a pert chart
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 高晋愚 The term unified method for assisted translation

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 *

Also Published As

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

Similar Documents

Publication Publication Date Title
TW567477B (en) System, method and computer program product for updating content stored on a portable storage medium
GB2379771B (en) System and method for storing and accessing digital media content using smart card technology
TW449991B (en) Method and system for securely handling information between two information processing devices
TW428137B (en) Sentence processing apparatus and method thereof
TW571233B (en) Image retrieval system and image retrieval method
TW359776B (en) Data processor and data processing system
TW530215B (en) Creation of mini dump files from full dump files
CA2045907A1 (en) A method for storing and retrieving annotations and redactions in final form documents
TW563362B (en) Reproducing apparatus and method of providing bookmark information thereof
WO2006011995A3 (en) Method and apparatus for storing and retrieving business contact information in a computer system
WO2004051555A3 (en) Method and apparatus for improved information transactions
WO2003042918A3 (en) Analysing events
EP0805403A3 (en) Translating apparatus and translating method
TW460795B (en) Method and arrangement for allowing a computer to communicate with a data storage device
CA2162583A1 (en) Computer-human interface system for compound documents
WO2003073743A3 (en) Video receiver/recorder with computer interface
JPH03218514A (en) Method for optimizing size of i/o buffer and computer system provided with optimized i/o buffer
WO2002073353A3 (en) Method and apparatus for annotating a document with audio comments
WO2001086640A3 (en) Handheld portable interactive data storage device
TW200516392A (en) A distributed file serving architecture system with metadata storage virtualization and data access at the data server connection speed
WO2002046867A3 (en) Controller and manager for device-to-device pervasive digital output
WO2004046920A3 (en) Processor cache memory as ram for execution of boot code
TW395112B (en) Image data processing system
WO2002095659A3 (en) A system and method for managing gene expression data
CA2345218A1 (en) A method for compressing digital documents with control of image quality and compression rate

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 in:

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