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

Piatetsky-Shapiro, Gregory

Brossura

ISBN 10: 1333453132 ISBN 13: 9781333453138

Casa editrice: Forgotten Books, 2018

Riassunto

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

Dettagli dell'edizione

• Editore: Forgotten Books
• Data di pubblicazione: 2018
• Lingua: Inglese
• ISBN 10: 1333453132
• ISBN 13: 9781333453138
• Rilegatura: Copertina flessibile
• Numero di pagine: 117
• Contatto del produttore: Copytech (UK) Ltd, Trading as Printondemand-worldwide.com; gpsr@podww.com; ; 9 Culley Court; Orton Southgate; Peterborough; Cambridgeshire; PE2 6WA; Regno Unito
• Persona responsabile: Easy Access System Europe Oü, 16879218; +358405003575; gpsr.requests@easproject.com; ; Mustamäe tee 50; Tallinn; 10621; Estonia