JavaScript is disabled for your browser. Some features of this site may not work without it.
Relational Query Optimization with Enhanced ADTs
dc.contributor.author | Seshadri, Praveen | en_US |
dc.date.accessioned | 2007-04-23T18:13:43Z | |
dc.date.available | 2007-04-23T18:13:43Z | |
dc.date.issued | 1998-07 | en_US |
dc.identifier.citation | http://techreports.library.cornell.edu:8081/Dienst/UI/1.0/Display/cul.cs/TR98-1693 | en_US |
dc.identifier.uri | https://hdl.handle.net/1813/7347 | |
dc.description.abstract | Object-relational queries access large complex data types and expensive methods of those data types. In earlier work, we modeled complex types as "Enhanced ADTs" (E-ADTs) and demonstrated the resulting performance improvements when implemented in the PREDATOR system. This paper explores the opportunities for further improvements through interactions between relational query optimization and E-ADT optimization. We identify four broad categories of optimization opportunities and study specific examples in each of these categories. These examples span query rewrite, indexing, aggregation and join optimization. Our conclusion is that non-trivial interactions exist between E-ADTs and relational queries, and that special optimization techniques are necessary to achieve good performance. These techniques have been prototyped in PREDATOR, and we present experimental results that demonstrate their effect. | en_US |
dc.format.extent | 155654 bytes | |
dc.format.extent | 849631 bytes | |
dc.format.mimetype | application/pdf | |
dc.format.mimetype | application/postscript | |
dc.language.iso | en_US | en_US |
dc.publisher | Cornell University | en_US |
dc.subject | computer science | en_US |
dc.subject | technical report | en_US |
dc.title | Relational Query Optimization with Enhanced ADTs | en_US |
dc.type | technical report | en_US |