Database Development and Application cover

Database Development and Application

Rating 3.3
Word count
112K words
Chapters
48
ISBN
9787566834966

Tags

Summary

This book closely centers on the needs of commercial operations to emphasize the practical application of data in business activities, adopting a project-driven approach and using hands-on training as a guide to deepen the study of database-related knowledge points. Throughout, the book uses an online bookstore sales management system as its example, systematically presenting across nine chapters a series of related work that begins with system application requirements analysis and proceeds through database design, database implementation, web database development, and database management program development—all originating from the need to meet commercial requirements and following the thread of database development and application. This consistent approach to learning enhances the sense of achievement and purpose in study and helps improve understanding and mastery of new management practices and new technological developments.

Editor's review

Database Development and Application, co-authored by Zhou Hongren and Li Jianwei and published by Jinan University Press, is a practical textbook for introducing and applying database technology. The book systematically introduces the basic principles, design methods, and development techniques of databases, covering the complete process from conceptual models to physical implementation, and explains the application of SQL and database management systems (such as MySQL) through practical cases. Author Zhou Hongren has a deep research background in information technology, while Li Jianwei has extensive teaching and practical experience; their collaboration ensures a balance between theoretical rigor and practical guidance.

In terms of content value, the book is especially suitable as a textbook or self-study reference for university students in computer-related majors. It avoids overly abstract theoretical exposition and instead uses a clear logical structure and concrete operational examples to help readers build an overall understanding of database systems. Its explanation of relational database design normal forms is particularly excellent and can guide readers to understand the practical significance of data normalization. At the same time, for common development scenarios such as query optimization and transaction processing, the book offers pragmatic solutions that help readers directly apply what they learn in subsequent projects.

Overall, this is a solid and comprehensive introductory guide to databases. Although its discussion of cutting-edge technologies (such as NoSQL and distributed databases) is relatively limited, its core content is sufficient to help readers lay a solid foundation in data management. For readers who wish to systematically learn database technology and seek a smooth transition from theory to practice, this book offers considerable reading value.

Who it's for

A good fit for

  • Students majoring in computer science or software engineering, especially suitable as a companion textbook for database courses
  • Beginners new to database development who need to systematically learn SQL and relational database design
  • In-service staff in data analysis, back-end development, and similar positions who wish to consolidate their foundational database knowledge
  • Enthusiasts interested in data management who plan to self-study database technology and complete small projects

Not a good fit for

  • Senior engineers who have already mastered advanced database features (such as performance tuning and distributed architectures)
  • Readers who wish to explore non-relational databases or the latest big data technologies in depth

Reading tips

  1. It is recommended to read the chapters in order, focusing on understanding the basic concepts in Chapter 3 (Data Models) and Chapter 5 (SQL Queries)
  2. In conjunction with the book's examples, install MySQL or a similar database system locally for synchronized practice to deepen understanding
  3. When reading, mark the chapters related to design normal forms and transaction processing; these contents are frequently applied in actual development

About the publisher

Jinan University Press China · Founded in 1989

Jinan University Press is a comprehensive university press known for publishing in language and writing, history and culture, and medicine. Judging from the 2,481 titles in the database, its publishing focuses on language and writing research, the compilation of unearthed documents, Chinese culture and Eastern philosophy, traditional Chinese medicine, and grassroots medical standards. Representative books include the Chinese Dictionary (Second Edition), the series on the collected interpretation and modern translation of Warring States documents from the Language Services Series and the series on the language of unearthed documents, Chinese Cultural Psychology (6th Edition), Illustrated Compendium of Traditional Chinese Medicine Processing Techniques, and Construction and Technical Standards for Standardized Bronchoscopy Rooms in Primary-Level Pediatrics. In terms of authors, scholars such as Zhu Cheng, Zhang Yujin, Wang Fengyan, Zheng Hong, Cao Hui and Ma Zhiguo form its author base in language and documents, cultural psychology, and traditional Chinese medicine. In terms of publishing characteristics, the press emphasizes the collected interpretation and modern translation of unearthed documents and language service research, while also systematically organizing cultural psychology and medical techniques. Public information on specific matters such as overseas Chinese-language education is limited and is therefore not elaborated here.

Contents

  1. 版权信息
  2. 前言
  3. 第1章 数据库系统概述
  4. 1.1 数据库的基本概念
  5. 1.2 数据模型
  6. 1.3 数据库系统结构
  7. 1.4 数据库管理系统
  8. 第2章 关系数据库理论
  9. 2.1 关系模型
  10. 2.2 关系代数
  11. 2.3 关系数据库的完整性
  12. 2.4 范式理论
  13. 第3章 数据库设计
  14. 3.1 数据库设计概述
  15. 3.2 需求分析
  16. 3.3 概念结构设计
  17. 3.4 逻辑结构设计
  18. 3.5 物理结构设计
  19. 第4章 关系数据库标准语言SQL
  20. 4.1 SQL概述
  21. 4.2 数据定义
  22. 4.3 数据查询
  23. 4.4 数据更新
  24. 4.5 数据控制
  25. 4.6 存储过程
  26. 4.7 触发器
  27. 第5章 数据库管理系统与应用
  28. 5.1 主流数据库管理系统介绍
  29. 5.2 分布式数据库管理系统介绍
  30. 5.3 MySQL的安装使用
  31. 第6章 数据库连接技术
  32. 6.1 ODBC技术
  33. 6.2 ADO技术
  34. 6.3 JDBC技术
  35. 6.4 PyMySQL技术
  36. 第7章 数据分析与商务应用
  37. 7.1 Python语言基础
  38. 7.2 数据分析基础
  39. 7.3 数据可视化与应用
  40. 第8章 数据库管理
  41. 8.1 数据库网络安全
  42. 8.2 数据库并发控制
  43. 8.3 数据库恢复技术
  44. 第9章 网上书店综合设计案例
  45. 9.1 数据库设计
  46. 9.2 数据库实现
  47. 9.3 数据库连接
  48. 9.4 Web程序开发示例

FAQ

Is this book suitable for readers with absolutely no background?
Yes. The book starts from basic database concepts and proceeds step by step, with numerous examples, making it friendly to readers with no background. However, readers need some basic computer operating skills.
Which database management system are the cases in the book based on?
The demonstrations are mainly based on MySQL, but the SQL syntax and design principles involved are generally applicable to most relational database systems.
Does this book include exercises or lab guidance?
As a textbook, this book usually includes chapter summaries and exercises to help readers consolidate knowledge; please refer to the book's table of contents for specifics.

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

Zhou Hongren is an author for whom limited public information is available. Only one work by this author can currently be confirmed, namely Database Development and Application, which is commonly classified under general computer science. Judging from the title and category, the author's writing focuses on the practical development and everyday application of database technology, and is likely aimed at readers who wish to master basic database operations and project implementation. Although reliable records are lacking regarding the author's nationality, dates of birth and death, educational background, and professional experience, the choice of subject suggests that the author has some technical grounding and practical experience in the database field and tends to organize content around application rather than general theoretical discussion. Based on the available material, this work is the main basis for understanding the author's writing, offering readers an introductory guide and operational reference for database development.

李健威 Author

Li Jianwei is an author about whom little public information is currently available; apart from the work attributed to him, Database Development and Application, no further biographical details can be verified. The available clues suggest that his writing focuses on the broad field of computer science, particularly the development and practical application of databases. Books of this kind are typically aimed at database learners and developers, emphasizing the integration of technical principles with hands-on operation to help readers understand the basic methods of database design and application. As the only known work by this author in the collection, it serves as the main basis for understanding his writing orientation: the content leans toward technical practice, with clear and precise language suited to teaching or engineering reference. Because records of the author's education, professional experience, and other writings are lacking, a full assessment of his overall body of work and influence remains difficult, and readers may judge his professional focus further from the specific chapters of the book.

Top rated in the same category