Database Principles and Technologies - Based on Huawei GaussDB

1. Auflage 2023
ISBN: 978-981-19-3031-7
Verlag: Springer Nature Singapore

Buch, Englisch, 314 Seiten, Format (B × H): 155 mm x 235 mm, Gewicht: 499 g

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.

Zielgruppe

Lower undergraduate

Autoren/Hrsg.

Huawei Technologies Co., Ltd.

Fachgebiete

• Mathematik | Informatik EDV | Informatik Daten / Datenbanken

Inhaltsverzeichnis

Chapter 1 Introduction to Database 11.1 Overview of database technology 21.1.1 Data 21.1.2 Records 31.1.3 Databases 31.1.4 Database management systems 41.1.5 Database systems 51.2 Development history of database technology 51.2.1 The emergence and development of database technology 51.2.2 Comparison of the three stages of data management 61.2.5 Hierarchical model, network model and relational model 81.2.6 Structured Query Language 111.2.7 Characteristics of relational database 121.2.8 History review of relational database products 121.2.9 Other data models 141.2.10 New challenges in data management technology 151.2.11 NoSQL database 161.2.12 NewSQL 181.2.13 Database ranking 191.3 Architecture of relational database 191.3.1 Development of database architecture 191.3.2 Standalone architecture 201.3.3 Packet architecture – active/standby 211.3.4 Packet architecture – master/slave 221.3.5 Packet architecture – master/master 221.3.6 Shared storage multi-site architecture 231.3.7 Sharding architecture 241.3.8 Non-sharing architecture 241.3.9 Massively parallel processing architecture 251.3.10 Comparison of the characteristics of database architecture 261.4 Main stream application scenarios of relational database 271.4.1 Online transaction processing 271.4.2 Online analytical processing 271.4.3 Measurement indicators of database performance 281.5 Summary of the chapter 291.6 Exercises 30
Chapter 2 Database Fundamentals 312.1 Introduction to database management 322.1.1 Database management and its scope of work 322.1.2 Object management 332.1.3 Backup and recovery management 342.1.4 Security management 382.1.5 Performance management 412.1.6 Operation and maintenance management 432.2 Important concepts of database 462.2.1 Database and cases of database 462.2.2 Database connection and session 472.2.3 Schema 482.2.4 Tablespace 492.2.5 Table 502.2.6 How tables are stored 512.2.7 Partition 522.2.8 Data distribution 542.2.9 Data types 552.2.10 View 572.2.11 Index 582.2.12 Constraints 592.2.13 Transaction 612.4 Exercises 66Chapter 3 Introduction to SQL Syntax...673.1 Overview of SQL statement 683.1.1 Introduction to SQL statement 683.1.2 Comprehensive application of SQL statement 693.2 Data types 693.2.1 Common data types 703.2.2 Uncommon data types 723.2.3 Cases of data types 723.3 System functions 733.3.1 Numeric computation functions 733.3.2 Character handling functions 753.3.3 Date and time functions 783.3.4 Type conversion functions 803.3.5 System information functions 813.4 Operators 813.4.1 Logical operators 823.4.2 Comparison operators 833.4.3 Arithmetic operators 833.4.4 Test operators 843.4.5 Other operators 863.5 Summary 863.6 Exercises 86
Chapter 4 Classification of SQL Syntax…884.1 Data queries 894.1.1 Simple queries 894.1.2 Remove duplicate values 904.1.3 Query column selection 904.1.4 Conditional queries 924.1.5 Join queries 954.1.6 Subqueries 994.1.7 Merge result set 1004.1.8 Differential result set 1024.1.9 Data packet 1024.1.10 Data sorting 1044.1.11 Data limit 1054.2 Data update 1054.2.1 Data insertion 1054.2.2 Data modification 1074.2.3 Data deletion 1084.3 Data definition 1104.3.1 Database objects 1104.3.2 Create a table 1104.3.3 Modify table properties 1124.3.4 Delete a table 1134.3.5 Index 1134.3.6 View 1164.4 Data control 1184.4.1 Transaction control 1184.4.2 Commit a transaction 1184.4.3 Rollback transaction 1184.4.4 Transaction savepoints 1194.5 Other 1204.5.1 The show command 1204.5.2 The set command 1214.6 Summary of the chapter 1224.7 Exercises 122
Chapter 5 Database Security Fundamentals 1255.1 Overview of data base security features 1265.1.1 Overview of database security management 1265.1.2 Database security framework 1265.1.3 Overview of database security features 1265.2 Access control 1275.2.1 Overview of IAM 1275.2.2 IAM features 1275.2.3 IAM authorization 1295.2.4 Relationship between IAM and GaussDB (for MySQL) application 1295.2.5 Process of IAM using GaussDB (for MySQL) 1305.2.6 Detailed explanation of SSL 1305.3 User permission control 1315.3.1 Concepts of permission 1315.3.2 Users 1325.3.3 Modification of users 1335.3.4 Deletion of users 1345.3.5 Roles 1345.3.6 Authorization 1355.3.7 Permission revocation 1375.4 CTS auditing 1385.4.1 Overview of CTS auditing 1385.4.2 Key operations to support the auditing 1395.5 Summary of the chapter 1405.6 Exercises 140
Chapter 6 Database Development Environment 1416.1 GaussDB database drivers 1426.1.1 Introduction to the concept of drivers 1426.1.2 JDBC 1426.1.3 ODBC 1456.1.4 Others 1506.2 Database tools 1526.2.1 DDM 1526.2.2 DRS 1576.2.3 DAS 1626.3 Client tools 1706.3.1 zsql 1706.2.2 gsql 1786.2.3 Data Studio 1806.2.4 MySQL Workbench 1826.3 Summary of the chapter 1836.4 Exercises 183
Chapter 7 Database Design Fundamentals 1857.1 Overview of database design 1867.1.1 Difficulties in database design 1867.1.2 Goals of database design 1867.1.3 Methods of database design 1877.2 Requirement analysis 1877.2.1 Significance of requirement analysis 1877.2.2 Tasks of requirement analysis phase 1887.2.3 Methodology of requirement analysis phase 1887.2.4 Data dictionary 1897.3 Conceptual design 1897.3.1 Conceptual design and conceptual models 1897.3.2 E-R methodology 1907.4 Logical design 1917.4.1 Logical design and logical models 1917.4.2 IDEF1X method 1927.4.3 Entities and properties in the logical model 1927.4.4 Normal Form 1977.4.5 Notes for logical design 2037.5 Physical design 2037.5.1 Physical design and physical models 2037.5.2 Denormalization of physical models 2047.5.3 Maintain data integrity 2077.5.4 Establish a physicalized naming convention 2077.5.5 Physicalization of tables and fields 2087.5.6 Use modelling software 2107.5.7 Outputs of physical models 2117.6 Cases of database design 2117.6.1 Scenario descriptions 2117.6.2 Regularization 2117.6.3 Data types and lengths 2147.6.4 Denormalization 2157.6.5 Index selection 2167.7 Summary 2167.8 Exercises 217
Chapter 8 Introduction to Huawei Database Product GaussDB 2198.1 Overview of GaussDB database 2208.1.1 GaussDB database family 2208.1.2 Typical enterprise OLTP and OLAP databases 2218.2 Introduction to relational database products 2218.2.1 GaussDB (for MySQL) 2218.2.2 GaussDB (openGauss) 2288.2.3 GaussDB (DWS) 2308.2.4 Data Studio 2348.3 Introduction to NoSQL database products 2368.3.1 GaussDB (for Mongo) 2368.3.2 GaussDB (for Cassandra) 2388.4 Summary of the chapter 2398.5 Exercises 239

Über Autor(innen)

Huawei Technologies Co., Ltd. Founded in 1987, Huawei is a leading global provider of information and communications technology (ICT) infrastructure and smart devices. We have approximately 197,000 employees and we operate in over 170 countries and regions, serving more than three billion people around the world. 

Huawei’s mission is to bring digital to every person, home and organization for a fully connected, intelligent world. To this end, we will: drive ubiquitous connectivity and promote equal access to networks to lay the foundation for the intelligent world; provide the ultimate computing power to deliver ubiquitous cloud and intelligence; build powerful digital platforms to help all industries and organizations become more agile, efficient, and dynamic; redefine user experience with AI, offering consumers more personalized and intelligent experiences across all scenarios, including home, travel, office, entertainment, and fitness & health.