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
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 claimed from US09/877,370 external-priority patent/US7117215B1/en
Application filed by Informatica Corp filed Critical Informatica Corp
Priority to EP01948540A priority Critical patent/EP1374090A2/en
Priority to AU2001270013A priority patent/AU2001270013A1/en
Priority to CA2414230A priority patent/CA2414230C/en
Publication of WO2002001415A2 publication Critical patent/WO2002001415A2/en
Publication of WO2002001415A3 publication Critical patent/WO2002001415A3/en

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

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 (3)

Application Number Priority Date Filing Date Title
EP01948540A EP1374090A2 (en) 2000-06-26 2001-06-21 Computer method and device for transporting data
AU2001270013A AU2001270013A1 (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 US7117215B1 (en) 2001-06-07 2001-06-07 Method and apparatus for transporting data for data warehousing applications that incorporates analytic data interface
US09/877,370 2001-06-07

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

Families Citing this family (8)

* 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
AU2003284303A1 (en) 2002-10-21 2004-05-13 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 高晋愚 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 *

Also Published As

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

Similar Documents

Publication Publication Date Title
WO2005048188A3 (en) Method and apparatus for capturing paper-based information on a mobile computing device
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
EP1156477A4 (en) Method and apparatus for information processing, and medium for storing program
TW200508860A (en) Systems and methods for storing data on computer systems
WO2007038390A3 (en) System and method for augmenting content in electronic documents with links to contextually relevant information
EP1109371A3 (en) Apparatus and method for dynamically limiting information sent to a viewing device
CA2313201A1 (en) Data input and retrieval apparatus
WO2001042952A3 (en) Method and system for constructing personalized result sets
TWI348640B (en) Method, memory device, and memory card that supports file system interoperability
EP1274022A3 (en) Reproducing apparatus and method of providing bookmark information thereof
EP1577797A3 (en) Rendering tables with natural language commands
WO2001041083A3 (en) Method and apparatus for use in entering financial data into an electronic device
EP1282055A4 (en) Information processing apparatus with optical data reader, servers, and electronic commerce method
WO2001067419A3 (en) Method and apparatus for providing emergency response information
WO2008014011A3 (en) Identifying and/or extracting data in connection with creating or updating a record in a database
WO2004068307A3 (en) Method and apparatus for processing a dynamic webpage
EP1426877A3 (en) Importing and exporting hierarchically structured data
WO2004084002A3 (en) Systems and methods for providing access to data stored in different types of data repositories
EP0856818A3 (en) Apparatus and method for accessing secured data stored in a portable data carrier
WO2003075178A3 (en) Method and system for recording user interaction with an application
EP1109104A1 (en) Deleting unused templates
WO2002001415A3 (en) Computer method and device for transporting data
TW346578B (en) Method and apparatus for information processing using an electronic mail, storage medium for storing a program for controlling an information processing apparatus
AU1856400A (en) Device for recording data corresponding to written or recorded information

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