发明名称 |
PRUNING DISK BLOCKS OF A CLUSTERED TABLE IN A RELATIONAL DATABASE MANAGEMENT SYSTEM |
摘要 |
Techniques are provided for generating a “dimensional zonemap” that allows a database server to avoid scanning disk blocks of a fact table based on filter predicates in a query that qualify one or more dimension tables. The zonemap divides the fact table into sets of contiguous disk blocks referred to as “zones”. For each zone, a minimum value and a maximum value for each of one or more “zoned” columns of the dimension tables is determined and maintained in the zonemap. For a query that contains a filter predicate on a zoned column, the predicate value can be compared to the minimum value and maximum value maintained for a zone for that zoned column to determine whether a scan of the disk blocks of the zone can be skipped. |
申请公布号 |
EP2901313(A2) |
申请公布日期 |
2015.08.05 |
申请号 |
EP20130734548 |
申请日期 |
2013.06.13 |
申请人 |
ORACLE INTERNATIONAL CORPORATION |
发明人 |
ZIAUDDIN, MOHAMED;WITKOWSKI, ANDREW |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|