Huawei Technologies Co. - Database Principles and Technologies – Based on Huawei GaussDB

Jointly published with Posts & Telecom Press, Beijing, China

The print edition is not for sale in China (Mainland). Customers from China (Mainland) please order the print book from: Posts & Telecom Press.

Jointly published with Posts & Telecom Press, Beijing, China

Open Access This book is licensed under the terms of the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License ( http://creativecommons.org/licenses/by-nc-nd/4.0/ ), which permits any noncommercial use, sharing, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons license and indicate if you modified the licensed material. You do not have permission under this license to share adapted material derived from this book or parts of it.

The images or other third party material in this book are included in the book's Creative Commons license, unless indicated otherwise in a credit line to the material. If material is not included in the book's Creative Commons license and your intended use is not permitted by statutory regulation or exceeds the permitted use, you will need to obtain permission directly from the copyright holder.

This Springer imprint is published by the registered company Springer Nature Singapore Pte Ltd.

The registered company address is: 152 Beach Road, #21-01/04 Gateway East, Singapore 189721, Singapore

Nowadays, database technology has developed from the early stage of simply saving and processing data files to a rich, comprehensive discipline with data modeling and database management system as the core, as the foundation and core of modern computer application system. Entering the Internet era, the traditional database system began to show decadence in response to the storage needs of big data, and enterprise customers urgently need a new generation of database products, that is, products with dynamic expansion and contraction capacity, high throughput, low cost, and other characteristics. As a result, cloud computing-based databases have emerged and risen, showing the future-oriented trend of cloud-based, distributed, and multi-mode processing.

Based on Huawei's GaussDB (for MySQL) cloud computing-based database , this book focuses on various cloud computing-based features and application scenarios of cloud computing-based databases. The division of the books eight chapters is as follows:

Chapter mainly introduces databases, including database technology overview, database technology history, relational database architecture, and mainstream application scenarios of relational databases.

Chapter mainly teaches database basics, including the main responsibilities and contents of database management, and introduces some common and important basic concepts of databases.

Chapter introduces SQL syntax, including GaussDB (for MySQL) data types, system functions and operators , which aims to help beginners master get started with SQL syntax.

Chapter focuses on SQL syntax classification and further explains SQL statements accordingly, covering data query, data update, data definition, and data control .

Chapter focuses on database security fundamentals , including basic security management techniques for databases, such as access control , user management, permission management, object permissions , and cloud auditing services, which will be elaborated from basic concepts, usages, and application scenarios.

Chapter focuses on the database development environment, including the use of all the tools of GaussDB (for MySQL), for the convenience of users to learn and view.

Chapter mainly teaches database design fundamentals, detailing the specific work of requirements analysis, conceptual design, logical design and physical design in accordance with the New Orleans design methodology, and finally introducing the specific means of database design implementation with relevant cases.

Chapter mainly introduces the features of GaussDB database, involving Huawei relational database and Huawei NoSQL database.

This book is edited by Huawei Technologies Co., Ltd., thanks to Ma Ruixin for the specific writing and final compilation of the whole book. We welcome readers criticism and correction if there are any shortcomings in the book, due to the limited time for compilation.