Database Tuning: Principles, Experiments, and Troubleshooting Techniques
By Dennis Shasha and Philippe Bonnet
4/5
()
About this ebook
Tuning your database for optimal performance means more than following a few short steps in a vendor-specific guide. For maximum improvement, you need a broad and deep knowledge of basic tuning principles, the ability to gather data in a systematic way, and the skill to make your system run faster. This is an art as well as a science, and Database Tuning: Principles, Experiments, and Troubleshooting Techniques will help you develop portable skills that will allow you to tune a wide variety of database systems on a multitude of hardware and operating systems. Further, these skills, combined with the scripts provided for validating results, are exactly what you need to evaluate competing database products and to choose the right one.
- Forward by Jim Gray, with invited chapters by Joe Celko and Alberto Lerner
- Includes industrial contributions by Bill McKenna (RedBrick/Informix), Hany Saleeb (Oracle), Tim Shetler (TimesTen), Judy Smith (Deutsche Bank), and Ron Yorita (IBM)
- Covers the entire system environment: hardware, operating system, transactions, indexes, queries, table design, and application analysis
- Contains experiments (scripts available on the author's site) to help you verify a system's effectiveness in your own environment
- Presents special topics, including data warehousing, Web support, main memory databases, specialized databases, and financial time series
- Describes performance-monitoring techniques that will help you recognize and troubleshoot problems
Dennis Shasha
Dennis Shasha is the author or coauthor of seven books, including this book's predecessor Database Tuning: A principal Approach (Prentice Hall) and Out of Their Minds: The Lives and Discoveries of 15 Great Computer Scientists (Copernius/Springer-Verlag), numerous journal and conference papers, and four patents. He also writes monthly puzzle columns for Scientific American and Dr. Dobb's Journal.
Related to Database Tuning
Related ebooks
An Introduction to Data Base Design Rating: 0 out of 5 stars0 ratingsSharing Data and Models in Software Engineering Rating: 5 out of 5 stars5/5Parallel Processing for Artificial Intelligence 1 Rating: 5 out of 5 stars5/5Physical Database Design: The Database Professional's Guide to Exploiting Indexes, Views, Storage, and More Rating: 5 out of 5 stars5/5Data Structures, Computer Graphics, and Pattern Recognition Rating: 0 out of 5 stars0 ratingsDatabase Modeling with Microsoft® Visio for Enterprise Architects Rating: 0 out of 5 stars0 ratingsKalman Filters: Fundamentals and Applications Rating: 0 out of 5 stars0 ratingsFuzzy Modeling and Genetic Algorithms for Data Mining and Exploration Rating: 5 out of 5 stars5/5DevOps in Python: Infrastructure as Python Rating: 0 out of 5 stars0 ratingsTime and Relational Theory: Temporal Databases in the Relational Model and SQL Rating: 5 out of 5 stars5/5Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server Rating: 0 out of 5 stars0 ratingsUNIX for OpenVMS Users Rating: 0 out of 5 stars0 ratingsDatabase Security A Complete Guide - 2021 Edition Rating: 0 out of 5 stars0 ratingsMicroservices Architecture Standard Requirements Rating: 0 out of 5 stars0 ratingsProgramming Language Structures Rating: 0 out of 5 stars0 ratingsOperator Methods in Quantum Mechanics Rating: 0 out of 5 stars0 ratingsIBM COBOL A Complete Guide - 2021 Edition Rating: 0 out of 5 stars0 ratingsSOA for the Business Developer: Concepts, BPEL, and SCA Rating: 0 out of 5 stars0 ratingsEffective MySQL Optimizing SQL Statements Rating: 3 out of 5 stars3/5Annotated C# Standard Rating: 0 out of 5 stars0 ratingsBeginning SQL Server Reporting Services Rating: 0 out of 5 stars0 ratingsProfessional Assembly Language Rating: 4 out of 5 stars4/5Hello World: Student to Software Professional - a Transformation Guide Rating: 0 out of 5 stars0 ratingsJava Design Patterns for Automation and Performance Rating: 4 out of 5 stars4/5Mastering MATLAB: A Comprehensive Journey Through Coding and Analysis Rating: 0 out of 5 stars0 ratingsModern C for Absolute Beginners: A Friendly Introduction to the C Programming Language Rating: 0 out of 5 stars0 ratingsIntel Xeon Phi Processor High Performance Programming: Knights Landing Edition Rating: 0 out of 5 stars0 ratings
Databases For You
Excel 2021 Rating: 4 out of 5 stars4/5Practical Data Analysis Rating: 4 out of 5 stars4/5Building a Scalable Data Warehouse with Data Vault 2.0 Rating: 4 out of 5 stars4/5Learn SQL in 24 Hours Rating: 5 out of 5 stars5/5Access 2019 For Dummies Rating: 0 out of 5 stars0 ratingsGrokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5SQL Clearly Explained Rating: 5 out of 5 stars5/5SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5Python Projects for Everyone Rating: 0 out of 5 stars0 ratingsData Science Strategy For Dummies Rating: 0 out of 5 stars0 ratingsSQL Server: Tips and Tricks - 1 Rating: 5 out of 5 stars5/5Data Management for Researchers: Organize, maintain and share your data for research success Rating: 0 out of 5 stars0 ratingsCodeless Data Structures and Algorithms: Learn DSA Without Writing a Single Line of Code Rating: 0 out of 5 stars0 ratingsBusiness Intelligence Strategy and Big Data Analytics: A General Management Perspective Rating: 5 out of 5 stars5/5Serverless Architectures on AWS, Second Edition Rating: 5 out of 5 stars5/5Data Governance: How to Design, Deploy and Sustain an Effective Data Governance Program Rating: 4 out of 5 stars4/5Getting Started with SQL Server 2014 Administration Rating: 0 out of 5 stars0 ratingsBehind Every Good Decision: How Anyone Can Use Business Analytics to Turn Data into Profitable Insight Rating: 5 out of 5 stars5/5A Concise Guide to Object Orientated Programming Rating: 0 out of 5 stars0 ratingsVisualizing Graph Data Rating: 0 out of 5 stars0 ratingsBlockchain Basics: A Non-Technical Introduction in 25 Steps Rating: 5 out of 5 stars5/5Database Management for Business Leaders: Building and Using Data Solutions That Work for You Rating: 0 out of 5 stars0 ratings100+ SQL Queries T-SQL for Microsoft SQL Server Rating: 4 out of 5 stars4/5Jump Start MySQL: Master the Database That Powers the Web Rating: 0 out of 5 stars0 ratingsRaspberry Pi Server Essentials Rating: 0 out of 5 stars0 ratingsAccess 2010 All-in-One For Dummies Rating: 4 out of 5 stars4/5Advanced Analytics in Power BI with R and Python: Ingesting, Transforming, Visualizing Rating: 0 out of 5 stars0 ratingsLearning ArcGIS Geodatabases Rating: 5 out of 5 stars5/5CompTIA DataSys+ Study Guide: Exam DS0-001 Rating: 0 out of 5 stars0 ratings
Reviews for Database Tuning
3 ratings0 reviews