Artículos relacionados a A Self-Organizing Database System (Classic Reprint):...

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

Piatetsky-Shapiro, Gregory

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

Sinopsis

Improve database speed with self-organizing indexing

This book explores how a self-organizing relational system can monitor workloads and automatically choose secondary indices to lower average query costs. It presents practical algorithms for selecting index sets and analyzing query plans, even when the underlying problem is NP-hard. The text covers how to estimate selectivity, measure query costs, and store query frequencies to guide automatic restructuring. You’ll see two concrete index-selection approaches, including a fast greedy method that often finds near-optimal results.

  • How to model query evaluation and index usage in a relational system
  • Two algorithms for optimal index selection, with performance insights
  • Techniques for estimating selectivity and planning data access
  • Practical notes on streaming query costs and frequency data
Ideal for readers of systems and database design, this work helps ops engineers and researchers understand self-optimizing techniques in large-scale databases. It’s a useful reference for anyone studying automatic performance tuning and index management in relational DBMS. ---

"Sinopsis" puede pertenecer a otra edición de este libro.

Reseña del editor

Excerpt from A Self-Organizing Database System: A Different Approach to Query Optimization

There are clear instructions concerning how the system catalogs should be physically structured (they begin as heaps and should be hashed when their size becomes somewhat stable). Even so. Some users fail to hash them appropriately. Of course, the system continues to run: it just gets slower and slower. We have finally removed this particular decision from the user's domain (it is done automatically).

The sods should continuously monitor the queries. When it senses degradation in performance it should analyze the usage and. If the cost of reorganization is offset by performance improvement. It should reorganize itself (or at least suggest that to the dea). The application programs can either be all recompiled at once. Or each program can be recompiled the first time it is used after the reorganization. We cannot resist the comparison of the all-knowing sods. Which always watches the user. With the Big Brother. Although intentions of the sods (we hope) are more benign.

About the Publisher

Forgotten Books publishes hundreds of thousands of rare and classic books. Find more at www.forgottenbooks.com

This book is a reproduction of an important historical work. Forgotten Books uses state-of-the-art technology to digitally reconstruct the work, preserving the original format whilst repairing imperfections present in the aged copy. In rare cases, an imperfection in the original, such as a blemish or missing page, may be replicated in our edition. We do, however, repair the vast majority of imperfections successfully; any imperfections that remain are intentionally left to preserve the state of such historical works.

"Sobre este título" puede pertenecer a otra edición de este libro.

Otras ediciones populares con el mismo título