Query processing using horizontal partial covering join index
作者： Carlos Bouloy , Grace Au , Hong Gui
DOI:
关键词: Index (publishing) 、 Algorithm 、 Database index 、 Set (abstract data type) 、 Join (sigma algebra) 、 Table (database) 、 Data mining 、 Relational database 、 Row 、 Query optimization 、 Computer science
摘要: A computer implemented system and method includes obtaining a query referring to rows in relational database. sparse index of the database that has set is subset referred obtained. Rows are not then obtained union such performed obtain complete row for processing query.
lens.org 参考文章(25)
Grace Kwan-On Au, Optimizing an aggregate join query ,(2001)
Chi Kim Hoang, Grace Kwan On Au, Aggregate join index for relational databases ,(2000)
Chi Kim Hoang, Grace Kwan On Au, Common spool files for maintaining join indexes ,(2001)
Randall Bello, Andrew Witkowski, Mohamed Ziauddin, Rewriting queries to access materialized views that group along an ordered dimension ,(1999)
Paul Leach, Chris Weider, System and method for generating hierarchical forward knowledge ,(2002)
Lee A. Barford, Revising a test suite using diagnostic efficacy evaluation ,(2002)
Daniel DeKimpe, Nathan Colossi, Steven Sit, Jason Dere, Method, system, and program for improving performance of database queries ,(2003)
Vikram Kapoor, Kurt Alan Shoens, Mark Steven Schultz, Rex Rilen Hamilton, Snapshots of file systems in data storage systems ,(2004)
John Raitto, James Finnerty, Mohamed Ziauddin, Rewriting a query in terms of a summary based on aggregate computability and canonical format, and when a dimension table is on the child side of an outer join ,(1998)
Simon J Case, Marcus Thint, Method and apparatus for automatic updating of user profiles ,(2002)