Database Principles and Oracle Applications

Author: Feng Fengjuan
Publisher:
Publish Date: 2006-03-01
Features: This book is divided into two parts: Database System Principles and Database System Applications. The Database System Principles part discusses the composition of database systems, the development history of database systems, the relational model, relational algebra operations, structured query language SQL (introducing SQL language based on Oracle database basics), data normalization, database design, and the principles and implementation techniques of the four protection measures of database systems (security, integrity, recovery, and concurrency). The Database System Applications part discusses the specific applications of the Oracle system, i.e., how to use Oracle to develop applications. It covers the architecture of the Oracle system, the installation and network configuration of Oracle, the startup and shutdown of Oracle, the basics of Oracle's database—SQL language, Oracle's application development language PL/SQL, how to use PL/SQL to develop stored procedures, functions, packages, and triggers, as well as the specific commands and methods to ensure security, integrity, concurrency control, backup, and recovery in the Oracle system. This book can be used as a textbook for database principles and application courses in higher education institutions, as well as a reference for technical personnel who develop applications using the Oracle system.