SG101443A1 - Execution of database queries including filtering - Google Patents
Execution of database queries including filteringInfo
- 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
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/24554—Unary operations; Data partitioning operations
-
- 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/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)
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)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2003085483A2 (fr) * | 2002-04-03 | 2003-10-16 | Venture Catalyst Incorporated | Système de traitement d'informations permettant de gérer une relation mercatique-client ciblée |
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)
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)
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 | 株式会社日立製作所 | B木インデクスの管理方法およびシステム |
US5758149A (en) * | 1995-03-17 | 1998-05-26 | Unisys Corporation | System for optimally processing a transaction and a query to the same database concurrently |
US5706457A (en) * | 1995-06-07 | 1998-01-06 | Hughes Electronics | Image display and archiving system and method |
US5778354A (en) | 1995-06-07 | 1998-07-07 | Tandem Computers Incorporated | Database management system with improved indexed accessing |
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 |
US6049800A (en) * | 1997-06-23 | 2000-04-11 | Oracle Corporation | Mechanism and method for performing callbacks |
US5987463A (en) * | 1997-06-23 | 1999-11-16 | Oracle Corporation | Apparatus and method for calling external routines in a database system |
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 |
-
2000
- 2000-04-28 CA CA002307155A patent/CA2307155A1/fr not_active Abandoned
-
2001
- 2001-01-10 US US09/757,428 patent/US6879977B2/en not_active Expired - Lifetime
- 2001-02-12 GB GB0103345A patent/GB2366039B/en not_active Expired - Lifetime
- 2001-04-18 SG SG200102178A patent/SG101443A1/en unknown
- 2001-04-25 JP JP2001127376A patent/JP4106198B2/ja not_active Expired - Lifetime
-
2004
- 2004-08-03 US US10/910,119 patent/US20050004906A1/en not_active Abandoned
-
2007
- 2007-07-20 US US11/780,777 patent/US8825616B2/en active Active
Patent Citations (3)
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 |
---|---|
JP2001357063A (ja) | 2001-12-26 |
US6879977B2 (en) | 2005-04-12 |
CA2307155A1 (fr) | 2001-10-28 |
GB0103345D0 (en) | 2001-03-28 |
GB2366039B (en) | 2004-05-12 |
US20080256053A1 (en) | 2008-10-16 |
US20010037329A1 (en) | 2001-11-01 |
JP4106198B2 (ja) | 2008-06-25 |
US20050004906A1 (en) | 2005-01-06 |
US8825616B2 (en) | 2014-09-02 |
GB2366039A (en) | 2002-02-27 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
SG101443A1 (en) | Execution of database queries including filtering | |
GB2369695B (en) | Database | |
GB0006153D0 (en) | Database | |
EP1300908A4 (fr) | Filtre | |
DE60119407D1 (de) | Filter | |
DE60130409D1 (de) | Filter | |
DE50105628D1 (en) | Filter | |
EP1262204A4 (fr) | Nouveau filtre pour leucopherese | |
AU6902901A (en) | Synchronisation of databases | |
EE200200410A (et) | Meetod atsetüülamidiniofenüülalanüültsükloheksüülglütsüülpüridinioalaniinamiidide valmistamiseks ning selleks vajalikud lähte- ja vaheühendid | |
FI20001521A (fi) | Suodatin | |
GB2365144B (en) | Filter | |
AU8342001A (en) | Pseudomycins useful against plant diseases | |
GB0106655D0 (en) | Databases for collections | |
GB2367257B (en) | "Oil filter" | |
GB0007761D0 (en) | Database | |
GB0102220D0 (en) | Databases | |
TW417724U (en) | Structure of oil filter | |
TW470266U (en) | Improved structure of filter | |
GB0002287D0 (en) | Improvements relating to filters | |
GB2364583B (en) | Database interrogation | |
NO20032707D0 (no) | Ny fremgangsmåte for fremstilling av diaryl-4- aminopiperidinylforbindelser | |
GB0005159D0 (en) | Cleaning of filters | |
GB0029606D0 (en) | Filters | |
GB0029607D0 (en) | Filters |