Werezi Books Ecommerce

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 productsrange from digital data communication, cyber security, wireless technology, data storage, cloud computing, and smart computing to artificial intelligence.

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

Get Database Principles and Technologies – Based on Huawei GaussDB by at the best price and quality guaranteed only at Werezi Africa's largest book ecommerce store. The book was published by Springer Verlag, Singapore and it has pages.

Database Principles and Technologies – Based on Huawei GaussDB

Book Details

Delivery Location

Mind, Body, & Spirit

The Mamba Mentality

Shopping Cart

Digital Library
Coming Soon