Chapter 1 Introduction 1
Chapter 2 Evolution of Computer and Origin of In-memory Computing Technology 7
2.1 Evolution of Computer 8
2.1.1 Changes ofGenerations ofComputer 8
2.1.2 Development ofProcessor 9
2.1.3 History ofMemory 10
2.2 Origin of In-memory Computing Technology 11
2.2.1 Business Needs 12
2.2.2 Development ofHardware 14
2.2.3 Software Technology Innovation 19
2.3 Conclusions 20
Chapter 3 Features of SAP HANA In-memoru Computing Technology 23
3.1 Profiles of Main In-memory Computing Technology Products 24
3.1.1 SAP HANA 24
3.1.2 Oracle Exalytics 25
3.1.3 Oracle TimesTen 26
3.1.4 IBM SolidDB 27
3.2 Characteristics ofSAP HANA memory technology 28
3.2.1 Efficient Parallel Processing Mechanism 29
3.2.2 Memory-based Efficient Data Read and Process 30
3.2.3 Efficient Data Compression to Optimize Memory Utilization 31
3.2.4 Row-column Storage Mixed-mode 32
3.2.5 Virtual Modelling to Reduce Data Redundancy 33
3.2.6 Data-intensive Computing at the Database Layer 35
3.2.7 Other Characteristics of SAP HANA 36
3.3 Conclusions 37
Chapter 4 Basic Knowledge of SAP HANA In-memory Computing Technology Application 39
4.1 SAP HANA Appliance Architecture 40
4.1.1 HANA In-memory Computing Engine 41
4.1.2 HANA Studio 41
4.1.3 Presentation Layer of HANA 42
4.1.4 HANA-Enabled Data Sources 43
4.2 SAP HANA Applicable Hardware Servers 43
4.2.1 SAP HANAApplicable Platform Requirements 44
4.2.2 Explanation ofAdaptability of SAP HANA to P770 46
4.2.3 Instruction of Support ofHANA to Superdome and rx8640 46
4.2.4 Conclusions ofAnalysis on SAP HANA Applicable Platform 47
4.3 SAP HANA Studio(HANA Studio) 48
4.3.1 System Requirements 48
4.3.2 Enabling Platforms 49
4.3.3 Functions ofHANA Studio 49
4.4 SAP HANA Reporting Presentation Tools 53
4.4.1 HANA Database Access Interfaces 53
4.4.2 HANA Reporting Presentation Tools 54
4.5 SAP HANAApplication Restrictions 56
Chapter 5 Data Extraction Mechanism of SAP HANA 59
5.1 Trigger-Based Replication-SLT Data Synchronization 61
5.1.1 Initialization Import 63
5.1.2 Incremental Updating 63
5.1.3 SLT Data Synchronization Features 63
5.2 ETL-Based Replication-DS Data Synchronization 64
5.2.1 Data Service Modelling Tools 64
5.2.2 Data Initialization Import and Incremental Updating 65
5.2.3 Features of DS Data Synchronization 65
5.2.4 Components Required by ETL-Based Data Synchronization 65
5.3 Log-Based Replication-SRS Data Synchronization 66
5.3.1 Data Initialization Import and Incremental Updating 66
5.3.2 Features of SRS Data Synchronization 67
5.3.3 Components ofLog-Based Data Synchronization 67
5.4 Comprehensive Comparison ofThree Data Replication Technologies 68
Chapter 6 System Security and Privilege Management of SAP HANA 69
6.1 User Management and Authentication 70
6.1.1 User Management Tools and Validation 70
6.1.2 User Type 71
6.1.3 Standard Users and Roles 71
6.2 Authorization 72
6.2.1 Authorization Concepts 72
6.2.2 Privilege Type 73
6.3 Network and Communications Security 74
6.3.1 Network Security 74
6.3.2 Communications Security 74
6.4 Storage Security 75
6.4.1 Protection of Data in File System 75
6.4.2 Data Encryption 75
6.4.3 Data Storage Security 75
6.5 System Audit 75
6.5.1 Audit Policy 76
6.5.2 Global Audit Configuration 76
Chapter 7 SAP HANA Modelling Techniques 77
7.1 SAP HANA Studio Modelling 78
7.1.1 SAP HANA Modelling Process 78
7.1.2 Three View Tools of HANA Studio 79
7.1.3 Procedures ofHANA Studio(Procedures) 82
7.1.4 Model Import/Export 83
7.2 HANA Data Modelling in BW 86
7.3 Call HANA Database via ABAP in ECC6 88
7.4 Comparison ofThree Data Modelling Approaches 92
Chapter 8 Applications of SAP HANA In-memory Computing Technology 97
8.1 SAP HANA and Value of Information System 98
8.2 Enterprise Operational Performance and Manpower,Assets and Materials Management 103
8.2.1 Integrated Management 103
8.2.2 Human Resource Management 104
8.2.3 Financial Management 105
8.2.4 Materials Management 106
8.3 Planning and Construction 107
8.3.1 Grid Planning 107
8.3.2 Grid Construction 107
8.4 Marketing Management 108
8.4.1 Customer Relationship Management 108
8.4.2 Marketing Business Management 109
8.4.3 Marketing Project Management 110
8.5 Operation and Maintenance Management 110
8.5.1 Grid Scheduling Operation Management 111
8.5.2 Grid Equipment Maintenance(Safety Production) 112
8.5.3 Operating Status ofInformation System 112
Chapter 9 SAP HANA PoC Project Conducted by LNEPC 121
9.1 Authentication Goals 122
9.2 System Architecture Overview 124
9.2.1 Authentication of System Architecture 125
9.2.2 Hardware Authentication 127
9.2.3 Authentication Software 130
9.3 PoC Project Methods 132
9.4 Issues and Solutions 135
9.4.1 Hardware and Software Installation and System Configuration 135
9.4.2 Modelling and Configuration in Implementation Process 136
9.4.3 System Migration Issues 138
9.4.4 System Upgrading 139
9.4.5 System Application Issues 139
9.4.6 SAP HANA Support Issue 140
Chapter 10 Project Management of SAP HANA Implementation 141
10.1 SAP HANA Implementation Methodology Overview 142
10.2 SAP HANA Project Implementation Organizational Structure 143
10.2.1 Goal ofProject Organizational Structure 143
10.2.2 Members ofHANA Project Implementation Team 144
10.3 Implementation Plan and Steps of HANA Project 147
10.3.1 Implementation Plan 147
10.3.2 Implementation Process Overview 148
10.3.3 Project Implementation Process Examples 164
10.4 Key Outputs and Deliverables ofHANA 166
10.5 HANA Project Training and Knowledge Transfer 168
10.5.1 Training and Knowledge Transfer Targets 168
10.5.2 Training and Knowledge Transfer Methods 169
10.5.3 Training and Knowledge Transfer Contents 170
10.6 Other Project Management Activities 172
10.6.1 Project Integration Management 172
10.6.2 Project Scope Management 172
10.6.3 Project Communication Management 175
10.6.4 Project Risk Management 177
10.7 Conclusions and Recommendations 178
Chapter 11 SAP HANA System Building 181
11.1 System Installation and Administration 182
11.1.1 Server Installation 182
11.1.2 SAP HANA System Administration 184
11.2 Modelling Practice 187
11.2.1 Naming Rules ofDevelopment Objects 187
11.2.2 Case 1:Plan and Execute Comparison 190
11.2.3 Case 2:Financial Accounting Analysis 220
11.3 Go live Strategy 235
11.3.1 Environment Preparation 235
11.3.2 Object Migration 237
11.3.3 Data Extraction 238
11.3.4 Authentication Testing 238
11.3.5 Formal Go live 238
11.4 System Migration Operation Practice 239
11.4.1 SAP HANA Migration 239
11.4.2 DS Migration 245
11.4.3 BO Migration 248
11.4.4 System Migration Experience Summary 253
Chapter 12 Experience and Recommendations on SAP HANA System Deployment and Application 255
12.1 Deployment Experience ofHANAProject 256
12.2 HANAApplication Constraints 258
12.3 HANAApplication Suggestions 259
Rererence 261
Appendix 1 Manual for HANA System Server Installation 265
Appendix 2 Manual for Installation of HANA Studio and BO4.0 Client 275
Appendix 3 Manual for HANA-SLT data provisioning training 295
Appendix 4 Manual for HANA Modelling Operation 303
Appendix 5 Manual for Excel on SAP HANA 339
Appendix 6 Manual for System Deployment-Production System Preparation 345