A Self-Organizing Database System (Classic Reprint): A Different Approach to Query Optimization - Couverture souple

Piatetsky-Shapiro, Gregory

 
9781333453138: A Self-Organizing Database System (Classic Reprint): A Different Approach to Query Optimization

Synopsis

A self-organizing database system monitors relational queries and automatically selects secondary indices to minimize the average query cost. This work explores query optimization, selectivity estimation, and recording query frequencies, offering practical methods and formal analysis.

The book frames a dynamic approach to database tuning. It explains why large systems benefit from automatic restructuring and shows how to balance speed with accuracy across evolving workloads. Readers will see how theory translates into algorithms that adapt to real data and usage patterns.

- Learn how the system analyzes queries to pick index sets that reduce overall cost.
- See methods for estimating how many records satisfy conditions and how often queries occur.
- Explore two algorithms for optimal index selection and their trade-offs.
- Understand how converting queries to CNF helps compute efficient evaluation plans.

Ideal for readers of database research and practitioners seeking automatic, data-driven tuning in large relational systems.

Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.

Présentation de l'éditeur

This book was originally published prior to 1923, and represents a reproduction of an important historical work, maintaining the same format as the original work. While some publishers have opted to apply OCR (optical character recognition) technology to the process, we believe this leads to sub-optimal results (frequent typographical errors, strange characters and confusing formatting) and does not adequately preserve the historical character of the original artifact. We believe this work is culturally important in its original archival form. While we strive to adequately clean and digitally enhance the original work, there are occasionally instances where imperfections such as blurred or missing pages, poor pictures or errant marks may have been introduced due to either the quality of the original work or the scanning process itself. Despite these occasional imperfections, we have brought it back into print as part of our ongoing global book preservation commitment, providing customers with access to the best possible historical reprints. We appreciate your understanding of these occasional imperfections, and sincerely hope you enjoy seeing the book in a format as close as possible to that intended by the original publisher.

Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.

Autres éditions populaires du même titre