SAP HANA Administration (Hardcover, 1st)

Preface ... 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. Scale-Out 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 Authentication Methods ... 516 12.4 Securing SAP HANA's Network Interfaces ... 525 12.5 Auditing in the Database ... 534 12.6 Summary ... 541 13. Roles and Privileges ... 543 13.1 Database Roles ... 543 13.2 Privileges in the Database Catalog and Repository ... 553 13.3 Types of Privileges in SAP HANA ... 560 13.4 Critical Privileges and Privilege Combinations ... 570 13.5 Standar