Książki

This open access book contains eight chapters that deal with database technologies, including the development history of database, database fundamentals, introduction to SQL syntax, classification of SQL syntax, database security fundamentals, database development environment, database design fundamentals, and the application of Huawei's cloud database product GaussDB database.

This book can be used as a textbook for database courses in colleges and universities, and is also suitable as a reference book for the HCIA-GaussDB V1.5 certification examination. The Huawei GaussDB (for MySQL) used in the book is a Huawei cloud-based high-performance, highly applicable relational database that fully supports the syntax and functionality of the open source database MySQL. All the experiments in this book can be run on this database platform.

As the world's leading provider of ICT (information and communication technology) infrastructure and smart terminals, Huawei's products range from digital data communication, cyber security, wireless technology, data storage, cloud computing, and smart computing to artificial intelligence.

Database Principles and Technologies - Based on Huawei GaussDB

Chapter 1 Introduction to Database11.1 Overview of database technology 21.1.1 Data21.1.2 Records31.1.3 Databases31.1.4 Database management systems41.1.5 Database systems51.2 Development history of database technology51.2.1 The emergence and development of database technology51.2.2 Comparison of the three stages of data management61.2.5 Hierarchical model, network model and relational model81.2.6 Structured Query Language111.2.7 Characteristics of relational database121.2.8 History review of relational database products121.2.9 Other data models141.2.10 New challenges in data management technology151.2.11 NoSQL database161.2.12 NewSQL181.2.13 Database ranking191.3 Architecture of relational database191.3.1 Development of database architecture191.3.2 Standalone architecture201.3.3 Packet architecture - active/standby211.3.4 Packet architecture - master/slave221.3.5 Packet architecture - master/master221.3.6 Shared storage multi-site architecture231.3.7 Sharding architecture241.3.8 Non-sharing architecture241.3.9 Massively parallel processing architecture 251.3.10 Comparison of the characteristics of database architecture261.4 Main stream application scenarios of relational database271.4.1 Online transaction processing271.4.2 Online analytical processing271.4.3 Measurement indicators of database performance281.5 Summary of the chapter291.6 Exercises30
Chapter 2 Database Fundamentals312.1 Introduction to database management322.1.1 Database management and its scope of work322.1.2 Object management332.1.3 Backup and recovery management342.1.4 Security management382.1.5 Performance management412.1.6 Operation and maintenance management432.2 Important concepts of database462.2.1 Database and cases of database462.2.2 Database connection and session472.2.3 Schema482.2.4 Tablespace492.2.5 Table502.2.6 How tables are stored512.2.7 Partition522.2.8 Data distribution542.2.9 Data types552.2.10 View572.2.11 Index582.2.12 Constraints592.2.13 Transaction612.4 Exercises66Chapter 3 Introduction to SQL Syntax...673.1 Overview of SQL statement683.1.1 Introduction to SQL statement683.1.2 Comprehensive application of SQL statement693.2 Data types693.2.1 Common data types703.2.2 Uncommon data types723.2.3 Cases of data types723.3 System functions733.3.1 Numeric computation functions733.3.2 Character handling functions753.3.3 Date and time functions783.3.4 Type conversion functions803.3.5 System information functions813.4 Operators813.4.1 Logical operators823.4.2 Comparison operators833.4.3 Arithmetic operators833.4.4 Test operators843.4.5 Other operators863.5 Summary863.6 Exercises86
Chapter 4 Classification of SQL Syntax...884.1 Data queries894.1.1 Simple queries894.1.2 Remove duplicate values904.1.3 Query column selection904.1.4 Conditional queries924.1.5 Join queries954.1.6 Subqueries994.1.7 Merge result set1004.1.8 Differential result set1024.1.9 Data packet1024.1.10 Data sorting1044.1.11 Data limit1054.2 Data update1054.2.1 Data insertion1054.2.2 Data modification1074.2.3 Data deletion1084.3 Data definition1104.3.1 Database objects1104.3.2 Create a table1104.3.3 Modify table properties1124.3.4 Delete a table1134.3.5 Index1134.3.6 View1164.4 Data control1184.4.1 Transaction control1184.4.2 Commit a transaction1184.4.3 Rollback transaction1184.4.4 Transaction savepoints1194.5 Other1204.5.1 The show command1204.5.2 The set command1214.6 Summary of the chapter1224.7 Exercises122
Chapter 5 Database Security Fundamentals1255.1 Overview of data base security features1265.1.1 Overview of database security management1265.1.2 Database security framework1265.1.3 Overview of database security features1265.2 Access control1275.2.1 Overview of IAM1275.2.2 IAM features1275.2.3 IAM authorization1295.2.4 Relationship between IAM and GaussDB (for MySQL) application1295.2.5 Process of IAM using GaussDB (for MySQL)1305.2.6 Detailed explanation of SSL1305.3 User permission control1315.3.1 Concepts of permission1315.3.2 Users1325.3.3 Modification of users1335.3.4 Deletion of users1345.3.5 Roles1345.3.6 Authorization1355.3.7 Permission revocation1375.4 CTS auditing1385.4.1 Overview of CTS auditing1385.4.2 Key operations to support the auditing1395.5 Summary of the chapter1405.6 Exercises140
Chapter 6 Database Development Environment1416.1 GaussDB database drivers1426.1.1 Introduction to the concept of drivers1426.1.2 JDBC1426.1.3 ODBC1456.1.4 Others1506.2 Database tools1526.2.1 DDM1526.2.2 DRS1576.2.3 DAS1626.3 Client tools1706.3.1 zsql1706.2.2 gsql1786.2.3 Data Studio1806.2.4 MySQL Workbench1826.3 Summary of the chapter1836.4 Exercises183
Chapter 7 Database Design Fundamentals1857.1 Overview of database design1867.1.1 Difficulties in database design1867.1.2 Goals of database design1867.1.3 Methods of database design1877.2 Requirement analysis1877.2.1 Significance of requirement analysis1877.2.2 Tasks of requirement analysis phase1887.2.3 Methodology of requirement analysis phase1887.2.4 Data dictionary1897.3 Conceptual design1897.3.1 Conceptual design and conceptual models1897.3.2 E-R methodology1907.4 Logical design1917.4.1 Logical design and logical models1917.4.2 IDEF1X method1927.4.3 Entities and properties in the logical model1927.4.4 Normal Form1977.4.5 Notes for logical design2037.5 Physical design2037.5.1 Physical design and physical models2037.5.2 Denormalization of physical models2047.5.3 Maintain data integrity2077.5.4 Establish a physicalized naming convention2077.5.5 Physicalization of tables and fields2087.5.6 Use modelling software2107.5.7 Outputs of physical models2117.6 Cases of database design2117.6.1 Scenario descriptions2117.6.2 Regularization2117.6.3 Data types and lengths2147.6.4 Denormalization2157.6.5 Index selection2167.7 Summary2167.8 Exercises217
Chapter 8 Introduction to Huawei Database Product GaussDB2198.1 Overview of GaussDB database2208.1.1 GaussDB database family2208.1.2 Typical enterprise OLTP and OLAP databases2218.2 Introduction to relational database products2218.2.1 GaussDB (for MySQL)2218.2.2 GaussDB (openGauss)2288.2.3 GaussDB (DWS)2308.2.4 Data Studio2348.3 Introduction to NoSQL database products2368.3.1 GaussDB (for Mongo)2368.3.2 GaussDB (for Cassandra)2388.4 Summary of the chapter2398.5 Exercises239