发明名称 |
Partition pruning with composite partitioning |
摘要 |
Techniques are disclosed for expanding the concept of partitioning in variety of ways. In particular techniques are provided for performing multiple-dimension partitioning. In multiple-dimension partitioning, a database object is divided into partitions based on one criteria, and each of those resulting partitions is divided into sub-partitions based on a second criteria. The process of partitioning partitions based on different criteria may be repeated across any number of dimensions. Entirely different partitioning techniques may be used for each level of partitioning. The database server takes advantage of partitions when processing queries by selectively accessing a subset of partitions on disk or reducing the number of internal join operations.
|
申请公布号 |
US6665684(B2) |
申请公布日期 |
2003.12.16 |
申请号 |
US19990405980 |
申请日期 |
1999.09.27 |
申请人 |
ORACLE INTERNATIONAL CORPORATION |
发明人 |
ZAIT MOHAMED;DAGEVILLE BENOIT;KRUGLIKOV ANDRE;PUTZOLU GIANFRANCO |
分类号 |
G06F7/00;G06F17/00;(IPC1-7):G06F17/00 |
主分类号 |
G06F7/00 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|