发明授权
- 专利标题： Multidimensional data clustering scheme for query processing and maintenance in relational databases
- 专利标题（中）： 关系数据库中查询处理和维护的多维数据聚类方案
-
申请号： US10122502申请日： 2002-04-15
-
公开(公告)号： US07080081B2公开(公告)日： 2006-07-18
- 发明人: Ramesh C. Agarwal , Bishwaranjan Bhattacharjee , Leslie A. Cranston , Matthew A. Huras , Tony Wen Hsun Lai , Timothy R. Malkemus , Sriram K. Padmanabhan
- 申请人： Ramesh C. Agarwal , Bishwaranjan Bhattacharjee , Leslie A. Cranston , Matthew A. Huras , Tony Wen Hsun Lai , Timothy R. Malkemus , Sriram K. Padmanabhan
- 申请人地址： US NY Armonk
- 专利权人： International Business Machines Corporation
- 当前专利权人： International Business Machines Corporation
- 当前专利权人地址： US NY Armonk
- 代理机构： F. Chau & Associates, LLC
- 主分类号： G06F7/00
- IPC分类号： G06F7/00
摘要：
Multidimensional clustered tables are provided for efficient processing and management in a relational database management system. A multidimensional clustered table is one whose data is simultaneously clustered along one or more independent dimensions, or clustering keys, and physically organized into blocks or pages on disk. When such a table is created, one can specify one or more keys as dimensions along which to cluster the table's data. Each of the dimensions can consist of one or more columns. Further provided are efficient query processing and maintenance techniques for use in conjunction with multidimensional clustered tables.