A Cost-Based Range Estimation for Mapping Top-k Selection Queries over Relational Databases

Abstract

Finding efficient methods for supporting top-k relational queries has received significant attention in academic research. One of the approaches in the recent literature is query-mapping, in which top-k queries are mapped (translated) into equivalent range queries that relational database systems (RDBMSs) normally support. This approach combines the advantage of simplicity as well as practicality by avoiding the need for modifications to the query engine, or specialized data structures or indexing techniques to handle top-k queries separately. However, existing methods following this approach fall short of adequately modeling the problem environment and providing consistent results. In this article, the authors propose a cost-based range estimation model for the query-mapping approach. They provide a methodology for trading-off relevant query execution cost components and mapping a top-k query into a cost-optimal range query for efficient execution. Their experiments on real world and synthetic data sets show that the proposed strategy not only avoids the need to calibrate workloads on specific database contents, but also performs at least as well as prior methods.

Techniques for Ensuring Index Usage Predictability in Microsoft SQL Server

“…In [6], the authors propose a cost-based range estimation model that maps a top-k query into a costoptimal range query for efficient execution. The top k query efficiency is also discussed in [7], in the context of retrieving data from different web services.…”

A Meta-Analysis Comparing Relational and Semantic Models

“…Studies on object oriented approaches (e.g., Siau & Cao, DOI: 10.4018/jdm.2011100103 2001; Siau & Loo, 2006;Taha & Elmasri, 2009;Gemino & Parker, 2009;VanderMeer & Dutta, 2009;Evermann & Wand, 2009;Siau & Tian, 2009;Shank et al, 2010;Siau, 2010;Tan et al, 2011) started to appear in academic publications in the 2000s. Despite the emergence of object oriented modeling techniques, relational and ER/EER models and their query languages continue to be important and widely studied (e.g., Sengupta & Ramesh, 2009;Niu et al, 2009;Sakr, 2009;Ayanso et al, 2009;Huh et al, 2010;An et al, 2010;Bera et al, 2010;Shlezinger et al, 2010). Further, relational database management systems are widely used and relational data model is still the dominant model in industry.…”