In-Memory Data Management : Technology and Applications

In the last fifty years the world has been completely transformed through the use of IT. We have now reached a new inflection point. This book presents, for the first time, how in-memory data management is changing the way businesses are run. Today, enterprise data is split into separate databases for performance reasons. Multi-core CPUs, large main memories, cloud computing and powerful mobile devices are serving as the foundation for the transition of enterprises away from this restrictive model. This book provides the technical foundation for processing combined transactional and analytical operations in the same database. In the year since we published the first edition of this book, the performance gains enabled by the use of in-memory technology in enterprise applications has truly marked an inflection point in the market. The new content in this second edition focuses on the development of these in-memory enterprise applications, showing how they leverage the capabilities of in-memory technology. The book is intended for university students, IT-professionals and IT-managers, but also for senior management who wish to create new business processes. In-MemoryData Management 2 In Praise of ‘‘In-Memory Data Management’’ 4 Foreword 11 Preface 12 The Essence of In-Memory Data Management 15 Contents 18 Acronyms 23 Introduction 25 Part III How In-Memory Changes the Game 29 1 Desirability, Feasibility, Viability: The Impact of In-Memory 30 1.1 Information in Real Time: Anything, Anytime, Anywhere 30 1.1.1 Response Time at the Speed of Thought 31 1.1.2 Real-Time Analytics and Computation on the Fly 33 1.2 The Impact of Recent Hardware Trends 33 1.2.1 Database Management Systems for Enterprise Applications 34 1.2.2 Main Memory is the New Disk 37 1.2.3 From Maximizing CPU Speed to Multi-Core Processors 38 1.2.4 Increased Bandwidth Between CPU and Main Memory 40 1.3 Reducing Cost Through In-Memory Data Management 43 1.3.1 Total Cost of Ownership 43 1.3.2 Cost Factors in Enterprise Systems 44 1.3.3 In-Memory Performance Boosts Cost Reduction 45 1.4 Conclusion 46 2 Why Are Enterprise Applications So Diverse? 47 2.1 Current Enterprise Applications 48 2.2 Examples of Enterprise Applications 49 2.3 Enterprise Application Architecture 51 2.4 Data Processing in Enterprise Applications 52 2.5 Data Access Patterns in Enterprise Applications 53 2.6 Conclusion 53 3 SanssouciDB: Blueprint for an In-Memory Enterprise Database System 54 3.1 Targeting Multi-Core and Main Memory 55 3.2 Designing an In-Memory Database System 56 3.3 Organizing and Accessing Data in SanssouciDB 58 3.4 Conclusion 60 8 Scaling SanssouciDB in the Cloud 239 8.1 What Is Cloud Computing? 240 8.2 Types of Cloud Applications 241 8.3 Cloud Computing from the Provider Perspective 243 8.3.1 Multi-Tenancy 243 8.3.2 Low-End Versus High-End Hardware 248 8.3.3 Replication 249 8.3.4 Energy Efficiency by Employing In-Memory Technology 250 8.4 Conclusion 251 9 The In-Memory Revolution has Begun 252 9.1 Risk-Free Transition to In-Memory Data Management 252 9.1.1 Operating In-Memory and Traditional Systems Side by Side 253 9.1.2 System Consolidation and Extensibility 254 9.2 Customer Proof Points 255 9.2.1 Charité---Universitätsmedizin Berlin 256 9.2.2 Hilti 258 9.3 Conclusion 260 About the Authors 261 Glossary 262 References 271 Index 279 Annotation In the last 50 years the world has been completely transformed through the use of IT. We have now reached a new inflection point. Here we present, for the first time, how in-memory computing is changing the way businesses are run. Today, enterprise data is split into separate databases for performance reasons. Analytical data resides in warehouses, synchronized periodically with transactional systems. This separation makes flexible, real-time reporting on current data impossible. Multi-core CPUs, large main memories, cloud computing and powerful mobile devices are serving as the foundation for the transition of enterprises away from this restrictive model. We describe techniques that allow analytical and transactional processing at the speed of thought and enable new ways of doing business. The book is intended for university students, IT-professionals and IT-managers, but also for senior management who wish to create new business processes by leveraging in-memory computing Front Matter....Pages i-xxxiv Front Matter....Pages 165-165 Desirability, Feasibility, Viability: The Impact of In-Memory....Pages 3-19 Why Are Enterprise Applications So Diverse?....Pages 21-27 SanssouciDB: Blueprint for an In-Memory Enterprise Database System....Pages 29-36 The Technical Foundations of SanssouciDB....Pages 39-96 Organizing and Accessing Data in SanssouciDB....Pages 97-164 Application Development....Pages 167-194 Finally, A Real Business Intelligence System Is at Hand....Pages 195-217 Scaling SanssouciDB in the Cloud....Pages 219-231 The In-Memory Revolution has Begun....Pages 233-241 Back Matter....Pages 243-267