dc.contributor.advisor | Hedrick, G. E. | |
dc.contributor.author | Hu, Jing | |
dc.date.accessioned | 2014-04-15T18:31:13Z | |
dc.date.available | 2014-04-15T18:31:13Z | |
dc.date.issued | 2006-07-01 | |
dc.identifier.uri | https://hdl.handle.net/11244/8168 | |
dc.description.abstract | A data warehouse is a user-centered environment for data analysis and decision support. To support decision maker in making decisions quickly and accurately, using materialized views can provide significant improvements in query processing time. The problem of answering queries using views is to find efficient methods of answering a query using a set of previously materialized views over the database, rather than accessing the database relations. The known algorithms, the bucket algorithm, the inverse-rules algorithm have been used to rewrite queries using views before executing the queries. The bucket algorithm, predominantly used to rewrite queries, generates a candidate rewriting to a query using views then checks that the rewriting is contained in the original query. However, we show same deficiencies in the bucket algorithm then describe the containment bucket algorithm and give an optimal method to solve this problem. We present an experiment comparing the performance of both algorithms. | |
dc.format | application/pdf | |
dc.language | en_US | |
dc.publisher | Oklahoma State University | |
dc.rights | Copyright is held by the author who has granted the Oklahoma State University Library the non-exclusive right to share this material in its institutional repository. Contact Digital Library Services at lib-dls@okstate.edu or 405-744-9161 for the permission policy on the use, reproduction or distribution of this material. | |
dc.title | Optimizing Queries Using a Materialized View in a Data Warehoue | |
dc.type | text | |
dc.contributor.committeeMember | George, K. M. | |
dc.contributor.committeeMember | Park, N. | |
osu.filename | Hu_okstate_0664M_1889.pdf | |
osu.college | Arts and Sciences | |
osu.accesstype | Open Access | |
dc.description.department | Computer Science Department | |
dc.type.genre | Thesis | |