The Picasso database query optimizer visualizer

Haritsa, Jayant R. (2010) The Picasso database query optimizer visualizer The VLDB Journal, 3 (1-2). pp. 1517-1520. ISSN 1066-8888

Full text not available from this repository.

Official URL: http://dl.acm.org/citation.cfm?id=1921027

Abstract

Modern database systems employ a query optimizer module to automatically identify the most efficient strategies for executing the declarative SQL queries submitted by users. The efficiency of these strategies, called "plans", is measured in terms of "costs" that are indicative of query response times. Optimization is a mandatory exercise since the difference between the costs of the best execution plan, and a random choice, could be in orders of magnitude. The role of query optimizers has become especially critical during this decade due to the high degree of processing complexity characterizing current data warehousing and mining applications, as exemplified by the TPC-H and TPC-DS decision support benchmarks [20, 21].

Item Type:Article
Source:Copyright of this article belongs to Springer.
ID Code:62458
Deposited On:22 Sep 2011 03:20
Last Modified:22 Sep 2011 03:20

Repository Staff Only: item control page