SAP HANA内存计算技术项目实战指南 英文版PDF电子书下载

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