Philippe Bonnet – författare

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

Why do brilliant ideas so often fail to make it through the organisations that need them most?The problem is rarely the idea itself. Good ideas stall because organisations are political systems: places where competing priorities, hidden resistance, shifting alliances and questions of trust determine what gets attention, resources and support.In The Architecture of Influence, leadership experts Allen Morrison, Cyril Bouquet and Philippe Bonnet reveal how to navigate these forces and turn promising ideas into lasting impact.Drawing on original research with senior leaders around the world and compelling stories from organizations including LEGO, Boeing, Amazon, SpaceX, Netflix, Novo Nordisk, Samsung and Ørsted, they identify the three forces every leader needs: Adaptive Power, to build the backing that gets ideas moving; Organisational Acumen, to understand how decisions really get made; and Earned Trust, to keep people committed when the outcome is uncertain.Practical, insightful and grounded in the realities of organizational life, The Architecture of Influence is a guide to getting your ideas heard, building the support they need and creating organizations where innovation can thrive.Having a great idea is only the beginning. The real challenge is making it win.

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.

This book offers a comprehensive resource on Solid-State Drives (SSD) as the field undergoes a radical evolution characterized by the incredible variety of SSD forms and their rapid diversification. It proposes a new classification system to help readers navigate the SSD landscape. For years, the evolution of SSDs was obscured by the unchanging abstractions of block devices and POSIX I/O, but it is apparent that these abstractions have become a problematic hinderance to performance and also fail to reduce software complexity. The book explores how such a state of affairs impacts the database community in at least two ways. First, it considers how using SSDs through legacy interfaces that hide internal mechanisms invariably results in erratic performance. While the blame often goes to the notoriously expensive garbage collection of SSDs, the authors argue that in truth, several other complex processes result in nonlinear effects on latency and bandwidth. The book describes these processes and how they are implemented in modern devices, knowledge that will help system designers better choose SSDs and shape database workloads to match their performance characteristics. Second, the book explores how the inadequacy of the traditional I/O abstractions opens up an entire research field focused on the co-design of database management systems and SSD. Such research aims at devising mechanisms and policies coupling the storage manager of database and SSD internals, e.g., placing an SSD FTL under the control of database, changing SSD sub-systems in response to the workload, or executing logic within an SSD on a database’s behalf. The book introduces these principles of DBMS/SSD co-design and argues that a more seamless integration of databases and storage solutions as well as the study of SSD variations adapted to database computations are central to the development of the next generation of database systems.