The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jul. 18, 2006
Filed:
Apr. 15, 2002
Multidimensional data clustering scheme for query processing and maintenance in relational databases
Ramesh C. Agarwal, Cupertino, CA (US);
Bishwaranjan Bhattacharjee, Yorktown Heights, NY (US);
Leslie A. Cranston, Toronto, CA;
Matthew A. Huras, Ajax, CA;
Tony Wen Hsun Lai, Toronto, CA;
Timothy R. Malkemus, Round Rock, TX (US);
Sriram K. Padmanabhan, Briarcliff Manor, NY (US);
Ramesh C. Agarwal, Cupertino, CA (US);
Bishwaranjan Bhattacharjee, Yorktown Heights, NY (US);
Leslie A. Cranston, Toronto, CA;
Matthew A. Huras, Ajax, CA;
Tony Wen Hsun Lai, Toronto, CA;
Timothy R. Malkemus, Round Rock, TX (US);
Sriram K. Padmanabhan, Briarcliff Manor, NY (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
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.