[go: up one dir, main page]

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
Legal status (The legal status 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 status listed.)
Ceased
Application number
PCT/US2000/004249
Other languages
French (fr)
Other versions
WO2000075849A2 (en
Inventor
Richard L Lackey
Gadi Yedwab
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Hyperion Solutions Corp
Original Assignee
Brio Technology Inc
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 filed Critical Brio Technology Inc
Priority to AU30020/00A priority Critical patent/AU3002000A/en
Publication of WO2000075849A2 publication Critical patent/WO2000075849A2/en
Anticipated expiration legal-status Critical
Publication of WO2000075849A3 publication Critical patent/WO2000075849A3/en
Ceased legal-status Critical Current

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)
  • Strategic Management (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Human Resources & Organizations (AREA)
  • General Engineering & Computer Science (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (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 Ceased 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 Ceased 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 (33)

* 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
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
WO2004104786A2 (en) * 2003-05-19 2004-12-02 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
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
EP1896995A4 (en) * 2005-06-24 2009-05-27 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
CN115658679A (en) * 2022-09-09 2023-01-31 江苏新蝶数字科技有限公司 A Realization Method of Unified Data Access Model
CN115510137B (en) * 2022-09-26 2025-09-16 北京信格科技有限公司 Command conversion method, system, computer equipment and medium based on JDBC specification
WO2024225933A1 (en) * 2023-04-28 2024-10-31 Общество с ограниченной ответственностью "Технологии Отраслевой Трансформации" Aggregating data from information systems for visualization
US20240378136A1 (en) * 2023-05-10 2024-11-14 Fivetran Inc. Debugging defective data connectors generated using artificial intelligence using annotated knowledge graph

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
WO2002031625A3 (en) A system and method of translating a universal query language to sql
WO2001080088A3 (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
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
WO2004077215A3 (en) System and method for data migration and conversion
EP1331543A3 (en) Access control
EP2189925A3 (en) Database obfuscation system and method
EP2562663A3 (en) Parent-child query indexing for XML databases
WO2001016725A3 (en) A system, method and article of manufacture for managing information in a development architecture framework
WO2002061622A3 (en) Technique for encapsulating a query definition
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
WO2005029356A3 (en) Method, system and program for data synchronization
TW200508902A (en) A method for searching Peer-based security policy database
WO2005052764A3 (en) System and method of broadcasting entertainment related data
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

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