SG101443A1 - Execution of database queries including filtering - Google Patents

Execution of database queries including filtering

Info

Publication number
SG101443A1
SG101443A1 SG200102178A SG200102178A SG101443A1 SG 101443 A1 SG101443 A1 SG 101443A1 SG 200102178 A SG200102178 A SG 200102178A SG 200102178 A SG200102178 A SG 200102178A SG 101443 A1 SG101443 A1 SG 101443A1
Authority
SG
Singapore
Prior art keywords
execution
database queries
including filtering
queries including
filtering
Prior art date
Application number
SG200102178A
Other languages
English (en)
Inventor
C Sharpe David
C Huffman Paul
C Zilio Daniel
A Mcknight Kathy
Original Assignee
Ibm
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 Ibm filed Critical Ibm
Publication of SG101443A1 publication Critical patent/SG101443A1/en

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/2455—Query execution
    • G06F16/24553—Query execution of query operations
    • G06F16/24554—Unary operations; Data partitioning operations
    • 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/2455—Query execution
    • G06F16/24553—Query execution of query operations
    • G06F16/24554—Unary operations; Data partitioning operations
    • G06F16/24557—Efficient disk access during query execution
    • 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/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/99941—Database schema or data structure
    • Y10S707/99943—Generating database or data structure, e.g. via user interface
    • 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/99941—Database schema or data structure
    • Y10S707/99944—Object-oriented database structure
    • Y10S707/99945—Object-oriented database structure processing

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)
SG200102178A 2000-04-28 2001-04-18 Execution of database queries including filtering SG101443A1 (en)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CA002307155A CA2307155A1 (fr) 2000-04-28 2000-04-28 Execution d'interrogations d'une base de donnees permettant le filtrage

Publications (1)

Publication Number Publication Date
SG101443A1 true SG101443A1 (en) 2004-01-30

Family

ID=4166033

Family Applications (1)

Application Number Title Priority Date Filing Date
SG200102178A SG101443A1 (en) 2000-04-28 2001-04-18 Execution of database queries including filtering

Country Status (5)

Country Link
US (3) US6879977B2 (fr)
JP (1) JP4106198B2 (fr)
CA (1) CA2307155A1 (fr)
GB (1) GB2366039B (fr)
SG (1) SG101443A1 (fr)

Families Citing this family (18)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
AU2003221792A1 (en) * 2002-04-03 2003-10-20 Venture Catalyst Incorporated Information processing system for targeted marketing and customer relationship management
CA2427209A1 (fr) * 2003-04-30 2004-10-30 Ibm Canada Limited - Ibm Canada Limitee Optimisation d'interrogations de vues definies par des expressions conditionnelles ayant des conditions incompatibles
US7308437B2 (en) * 2003-10-22 2007-12-11 International Business Machines Corporation Optimization of queries using retrieval status of resources used thereby
US7996419B2 (en) 2004-03-31 2011-08-09 Google Inc. Query rewriting with entity detection
US7536382B2 (en) 2004-03-31 2009-05-19 Google Inc. Query rewriting with entity detection
US20060095406A1 (en) * 2004-10-29 2006-05-04 International Business Machines Corporation Displaying explain data for a SQL query of a database
US20060242119A1 (en) * 2005-04-20 2006-10-26 Bea Systems, Inc. SQL-style filtered rowset
US7725462B2 (en) * 2006-12-28 2010-05-25 Teradata Us, Inc. Applying segment conditions to measure results
US7984043B1 (en) 2007-07-24 2011-07-19 Amazon Technologies, Inc. System and method for distributed query processing using configuration-independent query plans
US10169599B2 (en) * 2009-08-26 2019-01-01 International Business Machines Corporation Data access control with flexible data disclosure
US9224007B2 (en) 2009-09-15 2015-12-29 International Business Machines Corporation Search engine with privacy protection
US9600134B2 (en) * 2009-12-29 2017-03-21 International Business Machines Corporation Selecting portions of computer-accessible documents for post-selection processing
US9195853B2 (en) 2012-01-15 2015-11-24 International Business Machines Corporation Automated document redaction
US9342553B1 (en) * 2012-05-13 2016-05-17 Google Inc. Identifying distinct combinations of values for entities based on information in an index
US9892278B2 (en) 2012-11-14 2018-02-13 International Business Machines Corporation Focused personal identifying information redaction
CN104484400B (zh) * 2014-12-12 2018-02-23 北京国双科技有限公司 数据查询处理方法及装置
US10380104B2 (en) 2016-08-09 2019-08-13 International Business Machines Corporation Method to monitor dynamic SQL statements for automatic stabilization in a data sharing environment
CN107609091B (zh) * 2017-09-08 2020-10-27 国云科技股份有限公司 一种跨库多表联合查询系统的实现方法

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO1997004407A1 (fr) * 1995-07-14 1997-02-06 Alcatel N.V. Emulateur pour base de donnees relationnelles sql
US5724570A (en) * 1995-06-07 1998-03-03 Tandem Computers Incorporated Method and apparatus for a complete SQL subquery elimination process
US5768578A (en) * 1994-02-28 1998-06-16 Lucent Technologies Inc. User interface for information retrieval system

Family Cites Families (29)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH03108036A (ja) 1989-09-20 1991-05-08 Fujitsu Ltd データベース管理システムの性能見積もり方法
US5504873A (en) * 1989-11-01 1996-04-02 E-Systems, Inc. Mass data storage and retrieval system
US5506984A (en) * 1993-06-30 1996-04-09 Digital Equipment Corporation Method and system for data retrieval in a distributed system using linked location references on a plurality of nodes
DE19515020A1 (de) * 1994-07-01 1996-01-04 Hewlett Packard Co Verfahren und Vorrichtung zum Optimieren von Abfragen mit Gruppieren-nach-Operatoren
JP3441807B2 (ja) * 1994-09-19 2003-09-02 株式会社日立製作所 Ｂ木インデクスの管理方法およびシステム
US5758149A (en) * 1995-03-17 1998-05-26 Unisys Corporation System for optimally processing a transaction and a query to the same database concurrently
US5778354A (en) 1995-06-07 1998-07-07 Tandem Computers Incorporated Database management system with improved indexed accessing
US5706457A (en) * 1995-06-07 1998-01-06 Hughes Electronics Image display and archiving system and method
US6101531A (en) 1995-12-19 2000-08-08 Motorola, Inc. System for communicating user-selected criteria filter prepared at wireless client to communication server for filtering data transferred from host to said wireless client
JP3434641B2 (ja) 1996-02-23 2003-08-11 三菱電機株式会社 データベース処理方法
JP3808941B2 (ja) 1996-07-22 2006-08-16 株式会社日立製作所 並列データベースシステム通信回数削減方法
US5950188A (en) * 1996-11-14 1999-09-07 Sybase, Inc. Database system with methods for executing system-created internal SQL command statements
US5937401A (en) * 1996-11-27 1999-08-10 Sybase, Inc. Database system with improved methods for filtering duplicates from a tuple stream
US6026404A (en) * 1997-02-03 2000-02-15 Oracle Corporation Method and system for executing and operation in a distributed environment
US5899986A (en) * 1997-02-10 1999-05-04 Oracle Corporation Methods for collecting query workload based statistics on column groups identified by RDBMS optimizer
US5822748A (en) * 1997-02-28 1998-10-13 Oracle Corporation Group by and distinct sort elimination using cost-based optimization
US5987463A (en) * 1997-06-23 1999-11-16 Oracle Corporation Apparatus and method for calling external routines in a database system
US6049800A (en) * 1997-06-23 2000-04-11 Oracle Corporation Mechanism and method for performing callbacks
US6195653B1 (en) * 1997-10-14 2001-02-27 International Business Machines Corporation System and method for selectively preparing customized reports of query explain data
US6175829B1 (en) 1998-04-22 2001-01-16 Nec Usa, Inc. Method and apparatus for facilitating query reformulation
US6192370B1 (en) * 1998-06-19 2001-02-20 Sap Aktiengesellschaft Method and system for rapid memory-resident processing of transactional data
US6339768B1 (en) 1998-08-13 2002-01-15 International Business Machines Corporation Exploitation of subsumption in optimizing scalar subqueries
US6223171B1 (en) * 1998-08-25 2001-04-24 Microsoft Corporation What-if index analysis utility for database systems
JP2000076288A (ja) 1998-09-01 2000-03-14 Oki Electric Ind Co Ltd データベース管理システム
US6363387B1 (en) * 1998-10-20 2002-03-26 Sybase, Inc. Database system providing methodology for enhancing concurrency using row update bit and deferred locking
US6470330B1 (en) * 1998-11-05 2002-10-22 Sybase, Inc. Database system with methods for estimation and usage of index page cluster ratio (IPCR) and data page cluster ratio (DPCR)
US6411951B1 (en) * 1998-12-16 2002-06-25 Microsoft Corporation Evaluating SQL subqueries
US6249792B1 (en) * 1998-12-16 2001-06-19 Microsoft Corporation On-line dynamic file shrink facility
US6360228B1 (en) * 1999-06-02 2002-03-19 Oracle Corporation Transactional framework for executing statements involving non-native code

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5768578A (en) * 1994-02-28 1998-06-16 Lucent Technologies Inc. User interface for information retrieval system
US5724570A (en) * 1995-06-07 1998-03-03 Tandem Computers Incorporated Method and apparatus for a complete SQL subquery elimination process
WO1997004407A1 (fr) * 1995-07-14 1997-02-06 Alcatel N.V. Emulateur pour base de donnees relationnelles sql

Also Published As

Publication number Publication date
GB2366039B (en) 2004-05-12
JP4106198B2 (ja) 2008-06-25
GB0103345D0 (en) 2001-03-28
US8825616B2 (en) 2014-09-02
CA2307155A1 (fr) 2001-10-28
US6879977B2 (en) 2005-04-12
US20080256053A1 (en) 2008-10-16
GB2366039A (en) 2002-02-27
US20050004906A1 (en) 2005-01-06
JP2001357063A (ja) 2001-12-26
US20010037329A1 (en) 2001-11-01

Similar Documents

Publication Publication Date Title
SG101443A1 (en) Execution of database queries including filtering
GB2369695B (en) Database
DE60119407D1 (de) Filter
DE60130409D1 (de) Filter
HRP20030005A2 (en) Filter
DE60117307D1 (de) Zweifachmodus-Bandpassfilter
FR2818614B1 (fr) Piece de suspension d'un turboreacteur
AU6902901A (en) Synchronisation of databases
NO20030515D0 (no) Fremgangsmåte for fremstilling av dinapsolin
EE200200410A (et) Meetod atsetüülamidiniofenüülalanüültsükloheksüülglütsüülpüridinioalaniinamiidide valmistamiseks ning selleks vajalikud lähte- ja vaheühendid
AU2002357159A8 (en) Manufacture of trialkylaluminum compounds and alpha-alcohols
NO20023702L (no) Fremgangsmåte for fremstilling av 5-arylnikotinaldehyder
SG106636A1 (en) Purification of methylsilanes
GB2365144B (en) Filter
AU8342001A (en) Pseudomycins useful against plant diseases
GB2367257B (en) "Oil filter"
GB0007761D0 (en) Database
GB0102220D0 (en) Databases
TW470266U (en) Improved structure of filter
GB0002287D0 (en) Improvements relating to filters
GB0005159D0 (en) Cleaning of filters
GB0029607D0 (en) Filters
GB0029606D0 (en) Filters
TW444541U (en) Structure of ornaments
AU142954S (en) A set of tables