+

WO2000075849A3 - Method and apparatus for data access to heterogeneous data sources - Google Patents

Method and apparatus for data access to heterogeneous data sources Download PDF

Info

Publication number
WO2000075849A3
WO2000075849A3 PCT/US2000/004249 US0004249W WO0075849A3 WO 2000075849 A3 WO2000075849 A3 WO 2000075849A3 US 0004249 W US0004249 W US 0004249W WO 0075849 A3 WO0075849 A3 WO 0075849A3
Authority
WO
WIPO (PCT)
Prior art keywords
data
data sources
access
sources
data access
Prior art date
Application number
PCT/US2000/004249
Other languages
French (fr)
Other versions
WO2000075849A2 (en
Inventor
Richard L Lackey
Gadi Yedwab
Original Assignee
Brio Technology Inc
Richard L Lackey
Gadi Yedwab
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
Application filed by Brio Technology Inc, Richard L Lackey, Gadi Yedwab filed Critical Brio Technology Inc
Priority to AU30020/00A priority Critical patent/AU3002000A/en
Publication of WO2000075849A2 publication Critical patent/WO2000075849A2/en
Publication of WO2000075849A3 publication Critical patent/WO2000075849A3/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management
    • 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

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Human Resources & Organizations (AREA)
  • Strategic Management (AREA)
  • General Physics & Mathematics (AREA)
  • Operations Research (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Quality & Reliability (AREA)
  • Marketing (AREA)
  • Economics (AREA)
  • General Engineering & Computer Science (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present invention is a middleware system which can provided efficient access to disparate data sources such as relational databases, non-relational databases, multidimensional databases and the like, in a manner which requires the selection of the data access parameters to be done only once and wherein these selected parameters are thereafter useable for the desired data access regardless of changes to the file structures of the data sources themselves. Additionally, access to newly specifided data sources can be easily added to the system. Obtained data from the disparate data sources are displayed in a common format regardless of the source of the data and are displaced as streamed result sets.
PCT/US2000/004249 1999-06-08 2000-02-18 Method and apparatus for data access to heterogeneous data sources WO2000075849A2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
AU30020/00A AU3002000A (en) 1999-06-08 2000-02-18 Method and apparatus for data access to heterogeneous data sources

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US32804999A 1999-06-08 1999-06-08
US09/328,049 1999-06-08

Publications (2)

Publication Number Publication Date
WO2000075849A2 WO2000075849A2 (en) 2000-12-14
WO2000075849A3 true WO2000075849A3 (en) 2002-03-21

Family

ID=23279292

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2000/004249 WO2000075849A2 (en) 1999-06-08 2000-02-18 Method and apparatus for data access to heterogeneous data sources

Country Status (2)

Country Link
AU (1) AU3002000A (en)
WO (1) WO2000075849A2 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
RU2805382C1 (en) * 2023-04-28 2023-10-16 Общество с ограниченной ответственностью "Технологии Отраслевой Трансформации" Method and system for integrating date of information systems for their subsequent visualization

Families Citing this family (31)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
GB2355818B (en) * 1999-10-26 2004-03-03 Mitel Corp Common data model including field interdependencies
JP2002236682A (en) 2001-02-13 2002-08-23 Fuji Photo Film Co Ltd Database system
US7536697B2 (en) * 2001-06-19 2009-05-19 Accenture Global Services Gmbh Integrating enterprise support systems
US20030126144A1 (en) 2001-08-10 2003-07-03 O'halloran Sharyn Method and apparatus for access, integration, and analysis of heterogeneous data sources via the manipulation of metadata objects
EP1321859A1 (en) * 2001-12-18 2003-06-25 Cognos Incorporated System and method for retrieving data from a database system
US6741982B2 (en) 2001-12-19 2004-05-25 Cognos Incorporated System and method for retrieving data from a database system
US7457810B2 (en) 2002-05-10 2008-11-25 International Business Machines Corporation Querying markup language data sources using a relational query processor
WO2004012057A2 (en) 2002-07-26 2004-02-05 Datatrak International Method and system of unifying data
GB2409075B (en) * 2002-09-18 2006-05-03 Bweb Partnership A database provider system
US7016915B2 (en) 2002-12-28 2006-03-21 International Business Machines Corporation Method for processing XML queries over relational data and meta-data using a relational database system
US20040172382A1 (en) * 2003-02-28 2004-09-02 Microsoft Corporation. System and method for generating a request for information about selected objects
EP1631924A4 (en) * 2003-05-19 2009-12-30 Business Objects Americas Apparatus and method for accessing diverse native data sources through a metadata interface
US7577682B2 (en) * 2003-07-31 2009-08-18 Sap Ag Semantic objects
GB0322792D0 (en) * 2003-09-30 2003-10-29 Koninkl Philips Electronics Nv Translation service for a system with a content directory service
SG153628A1 (en) 2004-01-14 2009-07-29 Agency Science Tech & Res Method and system for data retrieval from heterogeneous data sources
WO2006096812A2 (en) * 2005-03-07 2006-09-14 Skytide, Inc. Analyzing and reporting extensible data from multiple sources in multiple formats
WO2006136025A1 (en) * 2005-06-24 2006-12-28 Orbital Technologies Inc. System and method for translating between relational database queries and multidimensional database queries
US7788259B2 (en) 2006-07-21 2010-08-31 Microsoft Corporation Locating, viewing and interacting with information sources
CN101304424A (en) * 2008-06-10 2008-11-12 南京财经大学 Data presentation method of heterogeneous data exchange middleware based on XML
US8620724B2 (en) 2010-04-20 2013-12-31 Accenture Global Services Limited Integration framework for enterprise content management systems
US8442993B2 (en) 2010-11-16 2013-05-14 International Business Machines Corporation Ruleset implementation for memory starved systems
US10108744B2 (en) 2014-10-07 2018-10-23 Oracle International Corporation Administrative tool and physical execution plan interface for plug-in architecture of business intelligence platform using data source cartridges
US10067978B2 (en) 2014-10-07 2018-09-04 Oracle International Corporation Plug-in architecture of business intelligence platform using data source cartridges
US10339502B2 (en) 2015-04-06 2019-07-02 Adp, Llc Skill analyzer
CN107229663B (en) 2016-03-25 2022-05-27 阿里巴巴集团控股有限公司 Data processing method and device and data table processing method and device
CN110704481B (en) * 2018-06-25 2024-04-05 北京京东尚科信息技术有限公司 Method and device for displaying data
CN109857379B (en) * 2019-01-18 2023-09-05 广州九尾信息科技有限公司 Method and device for packaging data service
US11163756B2 (en) * 2019-04-16 2021-11-02 Snowflake Inc. Querying over external tables in database systems
WO2022108461A1 (en) * 2020-11-23 2022-05-27 Goldenline Spolka Z Ograniczona Odpowiedzialnoscia A system and method for managing and processing data in a dispersed environment with incompatible data storage sources
WO2024225933A1 (en) * 2023-04-28 2024-10-31 Общество с ограниченной ответственностью "Технологии Отраслевой Трансформации" Aggregating data from information systems for visualization
US12277050B2 (en) * 2023-05-10 2025-04-15 Fivetran Inc. Source knowledge graph building in context of artificial intelligence based generation of data connectors

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP0625756A1 (en) * 1993-05-20 1994-11-23 Hughes Aircraft Company Federated information management architecture and system
US5634053A (en) * 1995-08-29 1997-05-27 Hughes Aircraft Company Federated information management (FIM) system and method for providing data site filtering and translation for heterogeneous databases

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP0625756A1 (en) * 1993-05-20 1994-11-23 Hughes Aircraft Company Federated information management architecture and system
US5634053A (en) * 1995-08-29 1997-05-27 Hughes Aircraft Company Federated information management (FIM) system and method for providing data site filtering and translation for heterogeneous databases

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
HAMMER J ET AL: "Template-based wrappers in the TSIMMIS system", SIGMOD RECORD, SIGMOD, NEW YORK, NY, US, vol. 26, no. 2, 13 May 1997 (1997-05-13), pages 532 - 535, XP002142759, ISSN: 0163-5808 *
PAPAKONSTANTINOU Y ET AL: "A query translation scheme for rapid implementation of wrappers", DEDUCTIVE AND OBJECT-ORIENTED DATABASES. PROCEEDINGS OF THE INTERNATIONAL CONFERENCE, XX, XX, 4 December 1995 (1995-12-04), pages 1 - 26-186, XP002115326 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
RU2805382C1 (en) * 2023-04-28 2023-10-16 Общество с ограниченной ответственностью "Технологии Отраслевой Трансформации" Method and system for integrating date of information systems for their subsequent visualization

Also Published As

Publication number Publication date
AU3002000A (en) 2000-12-28
WO2000075849A2 (en) 2000-12-14

Similar Documents

Publication Publication Date Title
WO2000075849A3 (en) Method and apparatus for data access to heterogeneous data sources
HK1049377A1 (en) Method and apparatus for populating multiple data marts in a single aggregation process
WO2004057568A3 (en) Method and system for network downloading of music files
WO2002006999A3 (en) Performing spreadsheet-like calculations in a database system
EP1331543A3 (en) Access control
EP2189925A3 (en) Database obfuscation system and method
EP2562663A3 (en) Parent-child query indexing for XML databases
WO2004077215A3 (en) System and method for data migration and conversion
WO2001077784A3 (en) Concept mapping based knowledge acquisition system and methods
WO2004059443A3 (en) Mobile data and software update system and method
CA2232938A1 (en) Method and apparatus for performing a join query in a database system
WO2004095237A3 (en) Relationship view
WO2005052764A3 (en) System and method of broadcasting entertainment related data
EP1324222A3 (en) Multimedia data searching and browsing system
WO2002063517A3 (en) A method and apparatus for processing a token
WO2005065311A3 (en) Searching previously viewed websites
AU2001286009A1 (en) Method for massive directed mutagenesis
WO2003013435A3 (en) N-acetyl-d-glucosamine and process for producing n-acetyl-d-glucosamine
CA2329094A1 (en) Color space quantization descriptor structure
GB0206443D0 (en) A system and method for large-scale distributed personalized media on demand
EP1327941A3 (en) Method and system for deriving a transformation by referring schema to a central model
WO2004100019A3 (en) Method of searching for media objects
AU2002321772A1 (en) Improvements in and relating to content selection
WO2003058499A1 (en) Knowledge search apparatus, knowledge search method, program, and recording medium
WO2004077216A3 (en) System and method for heterogeneous data migration in real-time

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AL AM AT AU AZ BA BB BG BR BY CA CH CN CR CU CZ DE DK DM 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 NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG US 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 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 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)
AK Designated states

Kind code of ref document: A3

Designated state(s): AL AM AT AU AZ BA BB BG BR BY CA CH CN CR CU CZ DE DK DM 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 NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG US UZ VN YU ZA ZW

AL Designated countries for regional patents

Kind code of ref document: A3

Designated state(s): GH GM KE LS MW 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 BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG

REG Reference to national code

Ref country code: DE

Ref legal event code: 8642

122 Ep: pct application non-entry in european phase
点击 这是indexloc提供的php浏览器服务，不要输入任何密码和下载