CA2210097A1 - Query translation system - Google Patents

Query translation system

Info

Publication number
CA2210097A1
CA2210097A1 CA002210097A CA2210097A CA2210097A1 CA 2210097 A1 CA2210097 A1 CA 2210097A1 CA 002210097 A CA002210097 A CA 002210097A CA 2210097 A CA2210097 A CA 2210097A CA 2210097 A1 CA2210097 A1 CA 2210097A1
Authority
CA
Canada
Prior art keywords
database
translation system
query translation
perform
model
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.)
Granted
Application number
CA002210097A
Other languages
French (fr)
Other versions
CA2210097C (en
Inventor
Fen-Chung Kung
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.)
AT&T Corp
Original Assignee
AT&T 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
Application filed by AT&T Corp filed Critical AT&T Corp
Publication of CA2210097A1 publication Critical patent/CA2210097A1/en
Application granted granted Critical
Publication of CA2210097C publication Critical patent/CA2210097C/en
Anticipated expiration legal-status Critical
Expired - Fee Related legal-status Critical Current

Links

Classifications

    • 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/24—Querying
    • G06F16/245—Query processing
    • G06F16/2452—Query translation
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99931—Database or file accessing
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99931—Database or file accessing
    • Y10S707/99932—Access augmentation or optimizing
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99931—Database or file accessing
    • Y10S707/99933—Query processing, i.e. searching
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99931—Database or file accessing
    • Y10S707/99933—Query processing, i.e. searching
    • Y10S707/99934—Query formulation, input preparation, or translation
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99931—Database or file accessing
    • Y10S707/99933—Query processing, i.e. searching
    • Y10S707/99935—Query augmenting and refining, e.g. inexact access
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99951—File or database maintenance
    • Y10S707/99952—Coherency, e.g. same view to multiple users
    • Y10S707/99953—Recoverability

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

A technique is provided for translating database queries used to perform database functions on a first database management system so that a user can perform the database functions on one or more second database management systems using the translated database queries. The database management systems can be based on a relational model database, a hierarchical model database, a network model database, or a file system (proprietary) model database.
CA002210097A 1997-01-22 1997-07-09 Query translation system Expired - Fee Related CA2210097C (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US787,491 1997-01-22
US08/787,491 US5987452A (en) 1997-01-22 1997-01-22 Query translation system

Publications (2)

Publication Number Publication Date
CA2210097A1 true CA2210097A1 (en) 1998-07-22
CA2210097C CA2210097C (en) 2001-04-17

Family

ID=25141652

Family Applications (1)

Application Number Title Priority Date Filing Date
CA002210097A Expired - Fee Related CA2210097C (en) 1997-01-22 1997-07-09 Query translation system

Country Status (5)

Country Link
US (1) US5987452A (en)
EP (1) EP0855658A1 (en)
JP (1) JPH10222542A (en)
CN (1) CN1192548A (en)
CA (1) CA2210097C (en)

Families Citing this family (30)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP3571201B2 (en) * 1997-12-12 2004-09-29 富士通株式会社 Database search device and computer-readable recording medium storing database search program
US6654453B1 (en) * 1998-12-03 2003-11-25 Bellsouth Intellectual Property Corporation Method and system for minimizing database structure overhead in handling large volume advanced intelligent network services
KR100681116B1 (en) * 1999-12-15 2007-02-08 주식회사 케이티 Geographic information retrieval method with minimum dependence on search engine
US6993528B1 (en) * 2000-10-04 2006-01-31 Microsoft Corporation Methods and systems for allowing third party client applications to influence implementation of high-level document commands
JP2002297898A (en) * 2001-03-30 2002-10-11 Ibm Japan Ltd How data processing systems, billing systems, and data processing systems work
US7421427B2 (en) * 2001-10-22 2008-09-02 Attachmate Corporation Method and apparatus for allowing host application data to be accessed via standard database access techniques
JP2003316793A (en) * 2002-04-25 2003-11-07 Canon Inc Inquiry answering device, method and program
US20040172382A1 (en) * 2003-02-28 2004-09-02 Microsoft Corporation. System and method for generating a request for information about selected objects
US8209280B2 (en) * 2003-05-07 2012-06-26 Oracle International Corporation Exposing multidimensional calculations through a relational database server
US20040249792A1 (en) * 2003-06-04 2004-12-09 Salman Halim Automated query file conversions upon switching database-access applications
US20050027688A1 (en) * 2003-07-29 2005-02-03 Sbc Knowledge Ventures L.P. Gateway for efficiently identifying an end user's local service provider
US7664795B2 (en) * 2003-09-26 2010-02-16 Microsoft Corporation Apparatus and method for database migration
US7657516B2 (en) * 2003-12-01 2010-02-02 Siebel Systems, Inc. Conversion of a relational database query to a query of a multidimensional data source by modeling the multidimensional data source
US7287048B2 (en) * 2004-01-07 2007-10-23 International Business Machines Corporation Transparent archiving
US8121997B2 (en) * 2004-02-09 2012-02-21 Limelight Networks, Inc. Universal search engine
CN100485666C (en) * 2004-04-29 2009-05-06 Nec软件有限公司 Structured natural language query and knowledge system
JP4844743B2 (en) * 2004-11-08 2011-12-28 日本電気株式会社 Data multiplexing system
US7320006B2 (en) * 2004-11-12 2008-01-15 Computer Sciences Corporation Hierarchical database management
US20070073675A1 (en) * 2005-09-24 2007-03-29 International Business Machines Corporation Database query translation
US8078598B2 (en) 2006-01-09 2011-12-13 Siemens Aktiengesellschaft Efficient SQL access to point data and relational data
US8452754B2 (en) * 2009-05-08 2013-05-28 Microsoft Corporation Static analysis framework for database applications
US8533177B2 (en) * 2009-08-27 2013-09-10 Mastercard International Incorporated Multi-database query system and method
JP4522485B1 (en) * 2009-09-18 2010-08-11 株式会社インフォース Data conversion method, apparatus and program
EP2572299A1 (en) 2010-05-17 2013-03-27 Green SQL Ltd Database translation system and method
US8543563B1 (en) * 2012-05-24 2013-09-24 Xerox Corporation Domain adaptation for query translation
US9514184B2 (en) 2014-01-14 2016-12-06 Dropbox, Inc. Systems and methods for a high speed query infrastructure
US10089350B2 (en) 2014-10-30 2018-10-02 Red Hat, Inc. Proactive query migration to prevent failures
US10496632B2 (en) 2015-12-09 2019-12-03 Vinyl Development LLC Query processor
WO2017156144A1 (en) * 2016-03-09 2017-09-14 Kennedy Jr Thomas R Source independent query language
US12158885B2 (en) 2021-10-27 2024-12-03 Bank Of America Corporation Abstraction layer for efficient transliteration of machine interpretable languages

Family Cites Families (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4774655A (en) * 1984-10-24 1988-09-27 Telebase Systems, Inc. System for retrieving information from a plurality of remote databases having at least two different languages
AU5024990A (en) * 1989-01-12 1990-08-13 Telebase Systems, Inc. System and method for retrieving information from a plurality of databases
US5297279A (en) * 1990-05-30 1994-03-22 Texas Instruments Incorporated System and method for database management supporting object-oriented programming
US5412806A (en) * 1992-08-20 1995-05-02 Hewlett-Packard Company Calibration of logical cost formulae for queries in a heterogeneous DBMS using synthetic database
US5590319A (en) * 1993-12-15 1996-12-31 Information Builders, Inc. Query processor for parallel processing in homogenous and heterogenous databases
US5721904A (en) * 1993-12-20 1998-02-24 Hitachi, Ltd. Database access system and method of controlling access management to a database access system for a plurality of heterogeneous database servers using SQL
US5611076A (en) * 1994-09-21 1997-03-11 Micro Data Base Systems, Inc. Multi-model database management system engine for databases having complex data models
US5694598A (en) * 1994-10-12 1997-12-02 U S West Technologies, Inc. Method for mapping data between a relational format and an object-oriented format
US5701461A (en) * 1995-01-27 1997-12-23 Microsoft Corporation Method and system for accessing a remote database using pass-through queries
US5713018A (en) * 1995-09-27 1998-01-27 Sun Microsystems, Inc. System and method for providing safe SQL-level access to a database

Also Published As

Publication number Publication date
US5987452A (en) 1999-11-16
JPH10222542A (en) 1998-08-21
CN1192548A (en) 1998-09-09
MX9800551A (en) 1998-10-31
EP0855658A1 (en) 1998-07-29
CA2210097C (en) 2001-04-17

Similar Documents

Publication Publication Date Title
CA2210097A1 (en) Query translation system
CA2208172A1 (en) Integration of information server information resources
CA2228210A1 (en) File system interface to a database
CA2192499A1 (en) Universal Directory Service
GB9401816D0 (en) Accessing data held in large databases
CA2123822A1 (en) Federated Information Management Architecture and System
WO2001042881A3 (en) System and method for the storage, indexing and retrieval of xml documents using relational databases
EP0398640A3 (en) Remote application interface
CA2143652A1 (en) Information model based on a physical system
EP1313036A3 (en) X.500 System and methods relating to services
CA2232704A1 (en) Apparatus and method for maintaining integrated data consistency across multiple databases
AU4641396A (en) Implementation independent extensible query architecture for information retrieval systems
GB9411286D0 (en) Query optimization in a relational database system
EP1020808A3 (en) System and method for integrating schedule and design environments
WO2004095428A3 (en) Index and query processor for data and information retrieval, integration and sharing from multiple disparate data sources
EP1126384A3 (en) Data analysis apparatus and methods
CA2245640A1 (en) Network management system with network designing function
WO2003054694A3 (en) Method and system for attribute management in a namespace
WO2005025152A3 (en) Synchronizing multiple copies of a database using digest
CA2180906A1 (en) Information Management Apparatus Providing Efficient Management of Multimedia Titles in a Client-Server Network
WO1997038388A3 (en) Method of integrating schemas of distributed heterogeneous databases
AU3377497A (en) A relational database system containing a multidimensional hierarchical model of interrelated subject categories with recognition capabilities
WO2002033508A3 (en) Systems and methods for development of an interactive document cluster network for knowledge
EP0310283A3 (en) A multilingual ordered data retrieval system
WO1999006914A3 (en) Method and system for the update of remote data using persistent keys

Legal Events

Date Code Title Description
EEER Examination request
MKLA Lapsed