Practical Database Applications

Name: Practical Database Applications
ISBN: 9787121472299

张粤磊 / 刘未昕 / 胡振兴 / 杜艺含Publishing House of Electronics Industry · ChinaMar 2024

3.5

Word count: 135K words
Chapters: 117
ISBN: 9787121472299

Report an error Find this book

Summary

This book is divided into four parts. Part 1 provides an overview of database technologies. Part 2 covers the technical applications of relational databases, including MySQL, Oracle, SQL Server, and PostgreSQL. Part 3 covers the technical applications of NoSQL databases, including Redis, MongoDB, HBase, Hive, Cassandra, and Elasticsearch. Part 4 covers the technical applications of other types of databases, including SQLite, Neo4j, and TDengine. Each database is introduced using a consistent structure: first the business application scenarios, then the installation and configuration steps, followed by the architecture design and business application development, and finally Python operation examples. Because some data objects in the four relational databases are used in similar ways, each is introduced in only one database. For example, triggers and user-defined functions are covered only in Oracle, while stored procedures and cursors are covered only in SQL Server. NoSQL databases are not directly comparable to one another, so the book focuses on their distinctive usage.

Editor's review

This is a wide-ranging introductory book on database applications, notable for weaving more than a dozen databases into a consistent structure: business scenarios first, then installation and configuration, architecture design and application development, and finally Python examples. The relational section covers MySQL, Oracle, SQL Server, and PostgreSQL; the NoSQL section covers Redis, MongoDB, HBase, Hive, Cassandra, and Elasticsearch; and other databases such as SQLite, Neo4j, and TDengine are also included. To avoid repetition, triggers and user-defined functions are discussed only in Oracle, and stored procedures and cursors only in SQL Server, while NoSQL databases are presented through their distinctive features. This arrangement helps readers quickly build a cross-database understanding of which database fits which scenario, and to run the examples hands-on. It works well as a course companion or a first book for self-study, but its depth is limited; going further requires dedicated resources.

Who it's for

A good fit for

Computer science students who need one course to connect multiple databases
Beginners who have just moved into back-end development and want a quick overview of mainstream databases
Technical staff who need selection guidance and want to compare relational and NoSQL use cases
Self-learners who want to practice connecting to various databases with Python

Not a good fit for

Senior DBAs looking for in-depth tuning and performance optimization experience with a single database
Readers who want a systematic study of database theory and internal implementation principles
Complete beginners with no intention of installing environments and looking only for theory

Reading tips

Read in part order—relational first, then NoSQL—to build a comparative framework.
Complete the installation, configuration, and Python examples in each chapter; otherwise it is easy to stay at the conceptual level.
Treat the business scenarios at the start of each chapter as selection notes and build your own comparison table.

About the publisher

Publishing House of Electronics Industry China · Founded in 1982

The Publishing House of Electronics Industry is a comprehensive publisher distinguished by its focus on electronic information and related fields. Judging from the more than 3,000 titles in its catalogue, its publishing covers programming and design, artificial intelligence, computer science, finance and economics, photography, and social sciences, attending both to cutting-edge technology and to general readers. Representative titles include Factor Investing: Methods and Practice, x86 Assembly Language: From Real Mode to Protected Mode, The RISC-V Reader, Artificial Intelligence: Speech Recognition, Understanding and Practice, Phased Array Radar Technology, Radar Target Characteristics, and 100 Go Mistakes and How to Avoid Them, most of which centre on technical methods and engineering practice. Its authors include Shi Chuan, Li Zhong, Wang Xiaobo, David Patterson, Andrew Waterman, and Yu Zihao, among others from China and abroad. Owing to limited public information, no further publishing features are elaborated here.

版权信息
内容简介
编委会
丛书推荐序一数字经济的思维观与人才观
丛书推荐序二产教融合打造创新人才培养的新模式
专家推荐
前言
第1部分数据库技术概述
第1章数据库技术的时代背景和发展历史
1.1 基本概念
1.2 数据存储发展历史
1.3 技术与时代业务
1.4 非关系型数据库
1.5 小结
第2章数据库核心原理和架构设计
2.1 数据库模型
2.2 数据库模式
2.3 数据库存储设计
2.4 数据库计算引擎
2.5 数据库安全设计
2.6 数据库管理
2.7 数据库设计及上线
2.8 小结
第2部分关系型数据库技术应用
第3章 MySQL数据库实战
3.1 业务应用场景
3.2 安装配置
3.3 架构设计
3.4 业务应用开发
3.5 Python操作示例
3.6 小结
第4章 Oracle数据库实战
4.1 业务应用场景
4.2 安装配置
4.3 架构设计
4.4 业务应用开发
4.5 Python操作示例
4.6 小结
第5章 SQL Server数据库实战
5.1 业务应用场景
5.2 安装配置
5.3 架构设计
5.4 业务应用开发
5.5 Python操作示例
5.6 小结
第6章 PostgreSQL数据库实战
6.1 业务应用场景
6.2 安装配置
6.3 架构设计
6.4 业务应用开发
6.5 Python操作示例
6.6 小结
第3部分 NoSQL数据库技术应用
第7章 Redis数据库实战
7.1 业务应用场景
7.2 安装配置
7.3 架构设计
7.4 业务应用开发
7.5 Python操作示例
7.6 小结
第8章 MongoDB数据库实战
8.1 业务应用场景
8.2 安装配置
8.3 架构设计
8.4 业务应用开发
8.5 Python操作示例
8.6 小结
第9章 HBase数据库实战
9.1 业务应用场景
9.2 安装配置
9.3 架构设计
9.4 业务应用开发
9.5 Python操作示例
9.6 小结
第10章 Hive数据库实战
10.1 业务应用场景
10.2 安装配置
10.3 架构设计
10.4 业务应用开发
10.5 Python操作示例
10.6 小结
第11章 Cassandra数据库实战
11.1 业务应用场景
11.2 安装配置
11.3 架构设计
11.4 业务应用开发
11.5 Python操作示例
11.6 小结
第12章 Elasticsearch数据库实战
12.1 业务应用场景
12.2 安装配置
12.3 架构设计
12.4 业务应用开发
12.5 Python操作示例
12.6 小结
第4部分其他类型数据库技术应用
第13章移动端数据库SQLite实战
13.1 业务应用场景
13.2 安装配置
13.3 架构设计
13.4 业务应用开发
13.5 Python操作示例
13.6 小结
第14章图数据库Neo4j实战
14.1 业务应用场景
14.2 安装配置
14.3 架构设计
14.4 业务应用开发
14.5 Python操作示例
14.6 小结
第15章时序数据库TDengine实战
15.1 业务应用场景
15.2 安装配置
15.3 架构设计
15.4 业务应用开发
15.5 Python操作示例
15.6 小结

FAQ

Can complete beginners read this book directly?

Yes, but hands-on practice is essential. The book starts with an overview of database technologies and provides installation, configuration, and sample code for each database, so the barrier is not high. Because the coverage is broad, however, beginners should first master basic SQL syntax and Python fundamentals, then work through the chapters step by step for a more solid result.

Why are some features covered in only one database?

Because MySQL, Oracle, SQL Server, and PostgreSQL use some data objects in similar ways. To avoid repetition, the author introduces triggers and user-defined functions in Oracle and stored procedures and cursors in SQL Server. Once readers understand one, they can transfer the knowledge to other relational databases, though the exact syntax still requires each database's documentation.

What level can readers reach after finishing the book?

They can gain an overall understanding of mainstream relational databases and common NoSQL databases, understand their application scenarios, basic architectures, and development approaches, and use Python to perform simple operations. This is an introductory, breadth-focused level. Deep tuning or large-scale applications on a particular database still require dedicated advanced materials for that database.

Comments

Find this book

This site is an index: you start “Search all sources” in your browser, and the entries it lists all point to third-party sites; please judge their availability yourself.

About the author

张粤磊 Author

Zhang Yuelei is an author whose publicly available information is currently limited; the name appears as the author credit on the programming and design book Database Application in Practice. Judging from the subject matter, the book addresses the practical use of database technology and belongs to hands-on technical writing rather than purely theoretical discussion. Books of this kind usually organize content around specific tasks and scenarios, emphasizing the translation of database knowledge into runnable examples and operational steps, and are suitable for readers who prefer learning by doing. Because reliable information about the author's background, professional training, and other writings is lacking, it is not possible to assess the full scope of his work or its specific influence among readers. Based on the available clues, Zhang Yuelei's writing focuses on database applications and programming practice and may serve readers interested in introductory and practical database exercises.

刘未昕 Author

Liu Weixin is a Chinese-language author of technical books active in the fields of programming design and artificial intelligence. Publicly available information about him is limited, and details such as his nationality, dates of birth and death, and English name remain unknown. Judging from the three works held in the collection, his writing focuses on turning technical knowledge into actionable practice: Build Your Own Big Data System (2nd Edition) guides readers in building a data system from scratch, Database Application in Practice centers on the practical use of databases, and From Python Basics to AI in Practice links language fundamentals with intelligent applications in one continuous path. Overall, these works are hands-on, step-by-step, and oriented toward real projects, making them suitable for beginners and intermediate readers who prefer learning by doing. They thus give him a fairly clear practice-oriented position among books on programming and artificial intelligence.

胡振兴 Author

Hu Zhenxing is a Chinese author of computer books, about whom publicly available information is currently limited. Judging from the two works held in the collection, Practical Database Applications and From Python Basics to Hands-On Artificial Intelligence, his writing focuses on programming design and artificial intelligence. The content is generally aimed at beginners and practical application, covering database operations and Python programming while extending to the implementation of artificial intelligence. Wording such as “practical” and “from basics to” in the titles suggests an approach that progresses from simple to advanced material and combines explanation with concrete operations, making the books suitable for beginners and self-learners who wish to get started quickly and learn by doing. Since the author's nationality, dates of birth and death, education, and professional background are not clearly documented, no speculation is made here; based solely on the existing works, the topics meet the practical needs of technology learners and offer useful reference value among introductory programming and applied artificial intelligence books.

杜艺含 Author · China

Du Yihan is a Chinese author about whom limited public information is available; the identity details that can be confirmed come mainly from her signed works. One title by her is included in the collection, Database Application in Practice, which is classified under programming and design and deals with the practical application of database technology for readers who want hands-on experience. Based on the available information, Du Yihan's writing leans toward technical practice, emphasizing the combination of database knowledge with concrete application scenarios rather than staying at the level of conceptual introduction. Since no public disclosure of her biography, education, or professional background has been found, this profile makes no speculation and presents her only as a technical writer through the subject matter and classification of her work. Readers seeking specific methods of database application may use her book as a reference for getting started and practicing; further details about her other experiences and future writing await more public information.