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

Piatetsky-Shapiro, Gregory

Softcover

ISBN 10: 1333453132 ISBN 13: 9781333453138

Verlag: Forgotten Books, 2018

Inhaltsangabe

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

Details zur Ausgabe

• Verlag: Forgotten Books
• Erscheinungsdatum: 2018
• Sprache: Englisch
• ISBN 10: 1333453132
• ISBN 13: 9781333453138
• Einband: Taschenbuch
• Anzahl der Seiten: 117
• Kontakt zum Hersteller: Copytech (UK) Ltd, Trading as Printondemand-worldwide.com; gpsr@podww.com; ; 9 Culley Court; Orton Southgate; Peterborough; Cambridgeshire; PE2 6WA; Vereinigtes Königreich
• Verantwortliche Person: Easy Access System Europe Oü, 16879218; +358405003575; gpsr.requests@easproject.com; ; Mustamäe tee 50; Tallinn; 10621; Estland