MX9802587A - Metodo y aparato para efectuar una consulta de union en un sistema de base de datos. - Google Patents

Metodo y aparato para efectuar una consulta de union en un sistema de base de datos.

Info

Publication number
MX9802587A
MX9802587A MX9802587A MX9802587A MX9802587A MX 9802587 A MX9802587 A MX 9802587A MX 9802587 A MX9802587 A MX 9802587A MX 9802587 A MX9802587 A MX 9802587A MX 9802587 A MX9802587 A MX 9802587A
Authority
MX
Mexico
Prior art keywords
join
database system
fragments
join query
record
Prior art date
Application number
MX9802587A
Other languages
English (en)
Other versions
MXPA98002587A (es
Inventor
Murali M Krishna
Anurag Kashyap
Robert Howard Gerber
Paul Sherwood Taylor
Scott Alan Shurts
Shengsong Ni
Prakash Sundaresan
Original Assignee
Informix Software 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 Informix Software Inc filed Critical Informix Software Inc
Publication of MX9802587A publication Critical patent/MX9802587A/es
Publication of MXPA98002587A publication Critical patent/MXPA98002587A/es

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/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24553—Query execution of query operations
    • G06F16/24561—Intermediate data storage techniques for performance improvement
    • 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/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24553—Query execution of query operations
    • G06F16/24558—Binary matching operations
    • G06F16/2456—Join operations
    • 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
    • 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

Abstract

Un método ejecutado por medio de una computadora para generar una respuesta a una union. Dos cuadros se dividen en fragmentos. Un mapa de fragmentos de union identifica, para cada fragmento respectivo del primer cuadro, los fragmentos del segundo cuadro que contengan un registro que satisfaga el predicado de union con un registro del fragmento respectivo del primer cuadro. El mapa se usa para eliminar fragmentos que no pueden satisfacer el predicado de union.
MXPA/A/1998/002587A 1997-04-07 1998-04-02 Metodo y aparato para efectuar una consulta de union en un sistema de base de datos MXPA98002587A (es)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US08833519 1997-04-07
US08/833,519 US5987453A (en) 1997-04-07 1997-04-07 Method and apparatus for performing a join query in a database system

Publications (2)

Publication Number Publication Date
MX9802587A true MX9802587A (es) 1998-12-31
MXPA98002587A MXPA98002587A (es) 1999-02-01

Family

ID=

Also Published As

Publication number Publication date
CA2232938A1 (en) 1998-10-07
EP0877327A2 (en) 1998-11-11
JP4866495B2 (ja) 2012-02-01
JPH10320423A (ja) 1998-12-04
CA2232938C (en) 2006-07-04
EP0877327B1 (en) 2008-07-23
AU752283B2 (en) 2002-09-12
US5987453A (en) 1999-11-16
AU5943798A (en) 1998-10-08
DE69839747D1 (de) 2008-09-04
BR9804282A (pt) 1999-11-16
EP0877327A3 (en) 2000-09-06

Similar Documents

Publication Publication Date Title
CA2232938A1 (en) Method and apparatus for performing a join query in a database system
AU2002368176A8 (en) System, method and apparatus for conducting a keyterm search
WO1995005629A3 (en) Method and apparatus for altering information in a database
WO2005036351A3 (en) Systems and methods for search processing using superunits
CA2249096A1 (en) Method for determining optimal database materializations using a query optimizer
EP1116139A4 (en) METHOD AND DEVICE FOR REORGANIZING AN ACTIVE END BMS TABLE
GB2353883A (en) Method and apparatus for document indexing and searching
AR022568A1 (es) Un sistema de bases de datos que tiene por lo menos dos bases de datos anfitrionas y una base de datos remota, y un metodo para sincronizar dichas bases dedatos
WO1998037474A3 (en) An information organization and collaboration tool for processing notes and action requests in computer systems
ATE205029T1 (de) Rechnersortiersystem zur datenkompression
ZA200003317B (en) Method and apparatus for optimizing query generation by selectively utilising attributes or key values.
MX9603053A (es) Metodo y aparatos mejroados para accesar una base de datos.
IL172518A0 (en) System and method for configuring voice readers using semantic analysis
DE69602364D1 (de) Rechnersystem um semantische objektmodelle von existierenden relationellen datenbanksystemen herzustellen
EP2562663A3 (en) Parent-child query indexing for XML databases
EP1164509A3 (en) Aggregate join index for relational databases
AU5332299A (en) System and method for filtering data
EP0867816A3 (en) File management apparatus and method therefor
WO2003058404A3 (en) Transactional supply chain system and method
TW331612B (en) Data processing apparatus and register address translation method.
FR2697661B1 (fr) Pupitre informatique interactif, notamment pupitre musical.
IT1275529B (it) Emulatore per un database relazionale in linguaggio sql
AU3957100A (en) A method and an apparatus for the processing of queries to database
DE60104658D1 (de) Datenwiederherstellung in einem verteilten system
HK1047168A1 (zh) 數據庫表格恢復系統

Legal Events

Date Code Title Description
FG Grant or registration
PD Change of proprietorship

Owner name: INTERNATIONAL BUSINESS MACHINES CORPORATION

MM Annulment or lapse due to non-payment of fees