Query Execution Techniques for Caching Expensive Methods

Object-Relational and Object-Oriented DBMSs allow users to invoke time-consuming ("expensive") methods in their queries. When queries containing these expensive methods are run on data with duplicate values, time is wasted redundantly computing methods on the same value. This problem has been studied in the context of programming languages, where "memoization" is the standard solution. In the database literature, sorting has been proposedto dealwith this problem. We compare these approachesalong with a third solution, a variant of unary hybrid hashing which we call Hybrid Cache. We demonstrate that Hybrid Cache always dominates memoization, and significantly outperforms sorting in many instances. This provides new insights into the tradeoff between hashing and sorting for unary operations. Additionally, ourHybrid Cache algorithm includes some new optimizations for unary hybrid hashing, which can be used for other applications such as grouping and duplicate eliminati...

• Type: Conference
• Year: 1996
• Where: SIGMOD
• Authors: Joseph M. Hellerstein, Jeffrey F. Naughton
• Keywords: Database, Expensive Methods, Hybrid Cache, SIGMOD 1996, Unary Hybrid Hashing