SAP HANA Administration

Who says that a leopard can't change its spots? With the advent of SAP HANA, database administration is evolving-and you can evolve along with it. Learn how traditional administration concepts are applied in SAP HANA, and find out about the new concepts relevant to an in-memory database. From the persistence layer to monitoring and root cause analysis, you'll get the background and practical examples you need to make your job easier. Whether you're an administration novice or a leopard trying to adapt to different surroundings, this book will help you sharpen your skills. Topic Highlights Architecture Installation and updates Administration tools Persistence layer Objects and tables Sessions and transactions Scaling out Performance Security Monitoring and root cause analysis Highlights: Architecture Installation and updates Administration tools Persistence layer Objects and tables Sessions and transactions Scaling out Performance Security Monitoring and root cause analysis

InhaltsangabePreface. 17 1. Architecture of the SAP HANA Database. 23 1.1 The Basics. 23 1.2 The Physical View: SAP HANA Servers. 26 1.3 The Operating System View: Database Processes. 29 1.4 The Logical View: Internal Architecture of the Database. 36 1.5 Distributed SAP HANA Systems. 41 1.6 The Appliance Concept of SAP HANA. 46 1.7 Release Cycles of SAP HANA Database Software. 53 1.8 Summary. 55 2. SAP HANA Scenarios: Administration Considerations. 57 2.1 SAP HANA as a Database in Application Servers. 58 2.2 SAP HANA as a Development Platform. 64 2.3 Mixed Scenarios. 68 2.4 Summary. 73 3. Installation and Updates. 75 3.1 Preparing for Installation and Updates. 75 3.2 Tools for Installing and Updating SAP HANA Systems. 85 3.3 Installing an SAP HANA Database. 88 3.4 Updating an SAP HANA Database. 101 3.5 Installing Multiple Instances of an SAP HANA Database on the Same Physical Server (Nonproduction). 110 3.6 Installation and Update in Batch Mode. 111 3.7 Installing and Updating Scale-Out Systems. 116 3.8 Troubleshooting. 119 3.9 Summary. 121 4. Administration Tools. 123 4.1 Introduction to SAP HANA Studio. 124 4.2 Database Administration with SAP HANA Studio. 135 4.3 Monitoring the Database with SAP HANA Studio. 144 4.4 DBA Cockpit for SAP HANA. 153 4.5 Summary. 156 5. The Persistence Layer. 157 5.1 Log and Data Volumes: The Data Image on Disk. 158 5.2 Log Backup. 186 5.3 Snapshots. 189 5.4 Data Backup and Recovery of the SAP HANA Database. 199 5.5 Disaster Recovery Setups and System Replication. 236 5.6 Summary. 254 6. ScaleOut Systems and High Availability. 255 6.1 Scaling Out SAP HANA Systems. 256 6.2 High Availability with Host Autofailover. 268 6.3 Client Connect in Distributed Systems. 273 6.4 Summary. 274 7. Objects. 275 7.1 Common Properties of Database Objects. 276 7.2 Tables. 290 7.3 Triggers and Constraints. 292 7.4 SQL Views. 295 7.5 Column Views. 302 7.6 Sequences. 305 7.7 Procedures and Functions. 312 7.8 Synonyms. 313 7.9 Summary. 315 8. Table Types. 317 8.1 Common Properties of All Tables. 318 8.2 Row Store Tables. 319 8.3 Column Store Tables. 324 8.4 Special Types of Tables. 338 8.5 Summary. 345 9. Working with Tables. 347 9.1 Loading Tables to and from Memory. 347 9.2 Running Delta Merges. 356 9.3 Partitioning and Distributing Tables. 365 9.4 Optimizing Table Distribution and Partitioning. 381 9.5 Importing and Exporting Tables. 395 9.6 Checking Tables for Consistency. 409 9.7 Summary. 411 10. Sessions and Transactions. 413 10.1 Introduction to Sessions and Transactions. 413 10.2 Processes and Threads. 428 10.3 Monitoring Sessions and Transactions. 445 10.4 Concurrency and Parallelism. 451 10.5 Summary. 465 11. Working with the Repository. 467 11.1 Properties of the SAP HANA Repository. 467 11.2 Creating and Editing Objects in SAP HANA Studio. 477 11.3 Deleting Development Objects in SAP HANA Studio. 486 11.4 Mechanisms for Exporting and Importing Objects. 488 11.5 Change Recording and Transports. 491 11.6 Summary. 494 12. User Management and Security. 497 12.1 Essential Security-Related Concepts. 498 12.2 Database Users. 498 12.3 Aut