Chapter 1 Introduction to Database1
1.1 Overview of database technology 2
1.1.1 Data2
1.1.2 Records3
1.1.3 Databases3
1.1.4 Database management systems4
1.1.5 Database systems5
1.2 Development history of database technology5
1.2.1 The emergence and development of database technology5
1.2.2 Comparison of the three stages of data management6
1.2.5 Hierarchical model, network model and relational model8
1.2.6 Structured Query Language11
1.2.7 Characteristics of relational database12
1.2.8 History review of relational database products12
1.2.9 Other data models14
1.2.10 New challenges in data management technology15
1.2.11 NoSQL database16
1.2.12 NewSQL18
1.2.13 Database ranking19
1.3 Architecture of relational database19
1.3.1 Development of database architecture19
1.3.2 Standalone architecture20
1.3.3 Packet architecture - active/standby21
1.3.4 Packet architecture - master/slave22
1.3.5 Packet architecture - master/master22
1.3.6 Shared storage multi-site architecture23
1.3.7 Sharding architecture24
1.3.8 Non-sharing architecture24
1.3.9 Massively parallel processing architecture 25
1.3.10 Comparison of the characteristics of database architecture26
1.4 Main stream application scenarios of relational database27
1.4.1 Online transaction processing27
1.4.2 Online analytical processing27
1.4.3 Measurement indicators of database performance28
1.5 Summary of the chapter29
1.6 Exercises30
Chapter 2 Database Fundamentals31
2.1 Introduction to database management32
2.1.1 Database management and its scope of work32
2.1.2 Object management33
2.1.3 Backup and recovery management34
2.1.4 Security management38
2.1.5 Performance management41
2.1.6 Operation and maintenance management43
2.2 Important concepts of database46
2.2.1 Database and cases of database46
2.2.2 Database connection and session47
2.2.3 Schema48
2.2.4 Tablespace49
2.2.5 Table50
2.2.6 How tables are stored51
2.2.7 Partition52
2.2.8 Data distribution54
2.2.9 Data types55
2.2.10 View57
2.2.11 Index58
2.2.12 Constraints59
2.2.13 Transaction61
2.4 Exercises66
Chapter 3 Introduction to SQL Syntax...67
3.1 Overview of SQL statement68
3.1.1 Introduction to SQL statement68
3.1.2 Comprehensive application of SQL statement69
3.2 Data types69
3.2.1 Common data types70
3.2.2 Uncommon data types72
3.2.3 Cases of data types72
3.3 System functions73
3.3.1 Numeric computation functions73
3.3.2 Character handling functions75
3.3.3 Date and time functions78
3.3.4 Type conversion functions80
3.3.5 System information functions81
3.4 Operators81
3.4.1 Logical operators82
3.4.2 Comparison operators83
3.4.3 Arithmetic operators83
3.4.4 Test operators84
3.4.5 Other operators86
3.5 Summary86
3.6 Exercises86
Chapter 4 Classification of SQL Syntax...88
4.1 Data queries89
4.1.1 Simple queries89
4.1.2 Remove duplicate values90
4.1.3 Query column selection90
4.1.4 Conditional queries92
4.1.5 Join queries95
4.1.6 Subqueries99
4.1.7 Merge result set100
4.1.8 Differential result set102
4.1.9 Data packet102
4.1.10
