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
Grant status
Application
Patent type
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

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/30Information retrieval; Database structures therefor ; File system structures therefor
    • G06F17/30286Information retrieval; Database structures therefor ; File system structures therefor in structured data stores
    • G06F17/30557Details of integrating or interfacing systems involving at least one database management system
    • G06F17/30569Details of data format conversion from or to a database
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/30Information retrieval; Database structures therefor ; File system structures therefor
    • G06F17/30286Information retrieval; Database structures therefor ; File system structures therefor in structured data stores
    • G06F17/30557Details of integrating or interfacing systems involving at least one database management system
    • G06F17/3056Details of integrating or interfacing systems involving at least one database management system between a Database Management System and a front-end application

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

Priority Applications (4)

Application Number Priority Date Filing Date Title
US21429900 true 2000-06-26 2000-06-26
US60/214,299 2000-06-26
US09/877,370 2001-06-07
US09877370 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 (2)

Application Number Priority Date Filing Date Title
EP20010948540 EP1374090A2 (en) 2000-06-26 2001-06-21 Computer method and device for transporting data
CA 2414230 CA2414230C (en) 2000-06-26 2001-06-21 Computer method and device for transporting data

Publications (2)

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

Family

ID=26908858

Family Applications (1)

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

Country Status (3)

Country Link
EP (1) EP1374090A2 (en)
CA (1) CA2414230C (en)
WO (1) WO2002001415A3 (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
EP1556797A4 (en) * 2002-10-04 2006-05-10 Tenix Invest Pty Ltd Data quality integrity engine
WO2004038614A3 (en) * 2002-10-21 2004-05-27 Boeing Co Client-server system for converting project management data
WO2004038550A3 (en) 2002-10-21 2005-10-27 Boeing Co 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 Type
CA2414230A1 (en) 2002-01-03 application
EP1374090A2 (en) 2004-01-02 application
WO2002001415A2 (en) 2002-01-03 application
CA2414230C (en) 2011-01-11 grant

Similar Documents

Publication Publication Date Title
US5761641A (en) Method and system for creating voice commands for inserting previously entered information
WO2005055093A3 (en) System and method for generating extensible file system metadata and file system content processing
JPH04252375A (en) Information providing method
EP1564652A3 (en) Method and apparatus for visually emphasizing numerical data contained within an electronic document
US7568156B1 (en) Language rendering
GB2365662B (en) Automatic configuration of a computer system based on its physical location
JPS59103460A (en) Method for converting facsimile multiple address edition
Yang et al. A high-speed Korean morphological analysis method based on pre-analyzed partial words
JPS6118074A (en) Pre-editing system
JPH0314184A (en) Document image rearrangement filing device
CA2045907A1 (en) A method for storing and retrieving annotations and redactions in final form documents
JPH04128926A (en) Program comment translating system
JPH03179570A (en) Document processing system and automatic program generating method
JPS6140671A (en) Word division processing system
JPH0418646A (en) Data base processing system
WO2000056055A3 (en) Collaborative document annotation system
JPH0351961A (en) Data display system for multi-media data base
JPH0232455A (en) Item extracting system
JPS6340938A (en) Synonym retrieving system for retrieval of information
JPS63156229A (en) Data base retrieving device
JPH0261758A (en) Document editing device
JPH04111063A (en) Translated word selecting method for translating plural sentences and machine translation system using the method
JPS60164860A (en) Data processor
JPS6115234A (en) Analysis system for processing correlation of element item
JPH11143864A (en) Method and device for date expression normalization and storage medium for recording date expression normalization program

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