CORADD: Correlation Aware Database Designer for Materialized Views and Indexes

We describe an automatic database design tool that exploits correlations between attributes when recommending materialized views (MVs) and indexes. Although there is a substantial body of related work exploring how to select an appropriate set of MVs and indexes for a given workload, none of this wo...

Full description

Bibliographic Details
Main Authors: Kimura, Hideaki, Huo, George, Rasin, Alexander, Madden, Samuel R., Zdonik, Stanley B.
Other Authors: Massachusetts Institute of Technology. Department of Electrical Engineering and Computer Science
Format: Article
Language:en_US
Published: Association for Computing Machinery (ACM) 2012
Online Access:http://hdl.handle.net/1721.1/73500
https://orcid.org/0000-0002-7470-3265