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

Piatetsky-Shapiro, Gregory

Couverture souple

ISBN 10 : 1333453132 ISBN 13 : 9781333453138

Editeur : Forgotten Books, 2018

Synopsis

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. ---

A propos du livre

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.

Détails de l'édition

• Éditeur: Forgotten Books
• Date d'édition: 2018
• Langue: anglais
• ISBN 10: 1333453132
• ISBN 13: 9781333453138
• Reliure: Broché
• Nombre de pages: 117
• Coordonnées du fabricant: Copytech (UK) Ltd, Trading as Printondemand-worldwide.com; gpsr@podww.com; ; 9 Culley Court; Orton Southgate; Peterborough; Cambridgeshire; PE2 6WA; Royaume-Uni
• Personne responsable: Easy Access System Europe Oü, 16879218; +358405003575; gpsr.requests@easproject.com; ; Mustamäe tee 50; Tallinn; 10621; Estonie