Cornell University
Library
Cornell UniversityLibrary

eCommons

Help
Log In(current)
  1. Home
  2. Cornell Computing and Information Science
  3. Computer Science
  4. Computer Science Technical Reports
  5. Relational Query Optimization with Enhanced ADTs

Relational Query Optimization with Enhanced ADTs

File(s)
98-1693.pdf (152.01 KB)
98-1693.ps (829.72 KB)
Permanent Link(s)
https://hdl.handle.net/1813/7347
Collections
Computer Science Technical Reports
Author
Seshadri, Praveen
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.

Date Issued
1998-07
Publisher
Cornell University
Keywords
computer science
•
technical report
Previously Published as
http://techreports.library.cornell.edu:8081/Dienst/UI/1.0/Display/cul.cs/TR98-1693
Type
technical report

Site Statistics | Help

About eCommons | Policies | Terms of use | Contact Us

copyright © 2002-2026 Cornell University Library | Privacy | Web Accessibility Assistance