Buch, Englisch, 722 Seiten, Format (B × H): 175 mm x 228 mm, Gewicht: 1508 g
Reihe: SAP PRESS Englisch
Buch, Englisch, 722 Seiten, Format (B × H): 175 mm x 228 mm, Gewicht: 1508 g
Reihe: SAP PRESS Englisch
ISBN: 978-1-59229-952-2
Verlag: Rheinwerk Verlag GmbH
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
Autoren/Hrsg.
Fachgebiete
- Mathematik | Informatik EDV | Informatik Business Application Unternehmenssoftware SAP
- Wirtschaftswissenschaften Betriebswirtschaft Wirtschaftsinformatik, SAP, IT-Management
- Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung
- Mathematik | Informatik EDV | Informatik Daten / Datenbanken Relationale Datenbanken
Weitere Infos & Material
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 Standard Roles for SAP HANA Systems ... 575
13.6 Troubleshooting Authorization Issues ... 575
13.7 Summary ... 587
14. Planning and Setting Up an SAP HANA System Landscape ... 589
14.1 Preparation: Sizing, Hardware Choices, and More ... 590
14.2 Planning the System Landscape ... 601
14.3 Bootstrapping the System ... 615
14.4 Summary ... 638
15. Tools for Performance Analysis ... 639
15.1 Load Diagram ... 639
15.2 Alerts Tab ... 642
15.3 Expensive Statements Trace ... 642
15.4 EXPLAIN PLAN ... 644
15.5 PlanViz ... 645
15.6 Further Resources ... 668
15.7 Summary ... 669
16. Monitoring and Root-Cause Analysis ... 671
16.1 Monitoring ... 671
16.2 Error Messages ... 675
16.3 Diagnostic Files ... 681
16.4 Server Side Traces ... 692
16.5 Client-Side Traces ... 701
16.6 Summary ... 706
The Authors ... 709
Index ... 711