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; CALCULATING OR 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; 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

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

* 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
EP1423804A4 (en) * 2001-08-10 2006-11-08 Datavine Res Services 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
CA2861894A1 (en) 2002-07-26 2004-02-05 Datatrak International, Inc. Method and system of unifying data
WO2004031989A1 (en) * 2002-09-18 2004-04-15 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
CA2536541A1 (en) * 2003-05-19 2004-12-02 Business Objects, S.A. 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
EP1875335A4 (en) * 2005-03-07 2008-10-08 Skytide Inc System and method for analyzing and reporting extensible data from multiple sources in multiple formats
CA2551030A1 (en) * 2005-06-24 2006-12-24 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 南京财经大学 Method for exhibiting data of different source data switching 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

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
WO2002031625A3 (en) A system and method of translating a universal query language to sql
WO2001080088A8 (en) Method of searching and producing matching color information
WO2004057568A3 (en) Method and system for network downloading of music files
EP1482430A3 (en) System and method of transforming queries based upon e/r schema into multi-dimensional expression queries
WO2005008473A3 (en) System and method for using an xml file to control xml to entity/relationship transformation
WO2002006999A3 (en) Performing spreadsheet-like calculations in a database system
WO2005033879A3 (en) Automatically targeting web-based advertisements
WO2003012698A3 (en) Method and apparatus for processing a query to a multi-dimensional data structure
WO2001075887A3 (en) Method, system and computer program product for full news integration and automation in a real time video production environment
EP0955592A3 (en) A system and method for querying a music database
AU2003245506A1 (en) Parent-child query indexing for xml databases
WO2005114478A3 (en) Encrypted table indexes and searching encrypted tables
EP1331543A3 (en) Access control
EP2189925A3 (en) Database obfuscation system and method
WO2002061622A3 (en) Technique for encapsulating a query definition
WO2004059443A3 (en) Mobile data and software update system and method
WO2005084381A3 (en) System and method for retrieving digital multimedia content from a network node
WO2004095237A3 (en) Relationship view
WO2005029356A3 (en) Method, system and program for data synchronization
WO2002103575A3 (en) Method of facilitating database access
WO2004084454A3 (en) Relational model for management information in network devices
EP1324222A3 (en) Multimedia data searching and browsing system
WO2002063517A8 (en) A method and apparatus for processing a token
WO2003013435A3 (en) N-acetyl-d-glucosamine and process for producing n-acetyl-d-glucosamine

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