Pruning disk blocks in a relational database management system
作者： Mohamed Ziauddin , Andrew Witkowski
DOI:
关键词:
摘要: Techniques are provided for generating a “dimensional zonemap” that allows database server to avoid scanning disk blocks of fact table based on filter predicates in query qualify one or more dimension tables. The zonemap divides the into sets contiguous referred as “zones”. For each zone, minimum value and maximum “zoned” columns tables is determined maintained zonemap. contains predicate zoned column, can be compared zone column determine whether scan skipped.
lens.org 参考文章(90)
Ed Shaw-Lee Suen, Kazi A. Zaman, Shimin Song, Conversion of a relational database query to a query of a multidimensional data source by modeling the multidimensional data source ,(2003)
Jian Le, Daniel DeKimpe, Method, apparatus and program storage device for optimizing a data warehouse model and operation ,(2005)
Raymond Roccaforte, Techniques for indexing into a row of a database table ,(2003)
Mohammed Zait, Cetin Ozbutin, Alexander Channing Ho, Benoit Dageville, Method and mechanism for retrieving values from a database ,(1998)
Bruce Golbus, Igor Lubashev, Zhiqi Qiu, James Carey, Ekrem Soylemez, A. A. Hopeman, Techniques for managing what-if analysis of data managed by a relational database system ,(2003)
Guy Shaked, Reuven Bakalash, Joseph Caspi, Data aggregation server supporting rapid query response with sparse multi-dimensional data ,(2002)
Robert F. Novy, Arun Shah, Robert A. Ertl, Chameleon measure and metric calculation ,(2001)
Chon Hei Lei, Daniel Manhung Wong, Caching the results of security policy functions ,(2003)
Ron Everett, Data base and knowledge operating system ,(2003)
Xiaohong Yang, Luming Wang, Defining sub-cube scope based upon a query ,(2011)