Contents
Creating and Populating the View Ridge Database Tables 10A-24
Creating the View Ridge Database Table Structure 10A-24 • Transaction COMMIT in
Oracle Database 10A-27 • Reviewing Database Structures in the SQL Developer GUI
Display 10A-28 • Indexes 10A-31 • Populating the VRG Tables 10A-32 •
Creating Views 10A-38
Application Logic 10A-44
Oracle PL/SQL 10A-45 • Stored Procedures 10A-47 • Triggers 10A-54
Concurrency Control 10A-68
Read-Committed Transaction Isolation Level 10A-69 • Serializable Transaction
Isolation Level 10A-69 • Read-Only Transaction Isolation 10A-70 •
Additional Locking Comments 10A-70
Oracle Backup and Recovery 10A-70
Oracle Recovery Facilities 10A-70 • Types of Failure 10A-71
Topics Not Discussed in This Chapter 10A-72
Summary 10A-72 • Key Terms 10A-73 • Review Questions 10A-73 • Project
Questions 10A-75 • Marcia’s Dry Cleaning 10A-76 • Morgan Importing 10A-76
ONLINE CHAPTER: SEE PAGE 448 FOR INSTRUCTIONS
Chapter 10B: Managing Databases with MySQL 5.5 10B-1
Chapter Objectives 10B-1
The MySQL 5.5 DBMS 10B-2
Installing and Updating MySQL 10B-3
Configuring MySQL 10B-4 • MySQL Storage Engines 10B-6
The MySQL GUI Utilities 10B-6
Creating a Workspace for the MySQL Workbench Files 10B-8
Creating and Using a MySQL Database 10B-8
Creating a Database in MySQL 10B-8 • Setting the Active Database in MySQL 10B-12
MySQL Utilities 10B-13
MySQL Command-Line Client 10B-13 • MySQL GUI Displays 10B-14 •
MySQL SQL Statements and SQL Scripts 10B-14
Creating and Populating the View Ridge Database Tables 10B-17
Creating the View Ridge Database Table Structure 10B-17 • Reviewing Database
Structures in the MySQL GUI Display 10B-20 • Indexes 10B-21 • Populating
the VRG Tables with Data 10B-26 • Transaction COMMIT in MySQL 10B-27 •
Creating Views 10B-27
MySQL Application Logic 10B-38
MySQL Procedural Statements 10B-38 • Stored Procedures 10B-41 •
Triggers 10B-47 • A Last Word on MySQL Stored Procedures and Triggers 10B-61
Concurrency Control 10B-61
MySQL 5.5 Security 10B-62
MySQL Database Security Settings 10B-64
MySQL 5.5 DBMS Backup and Recovery 10B-68
Backing Up a MySQL Database 10B-68 • Restoring a MySQL Database 10B-71
Topics Not Discussed in This Chapter 10B-72
Summary 10B-71 • Key Terms 10B-72 • Review Questions 10B-73 • Project
Questions 10B-74 • Marcia’s Dry Cleaning 10B-75 • Morgan Importing 10B-76
PART 5 • DATABASE ACCESS STANDARDS 449
Chapter 11: The Web Server Environment 449
Chapter Objectives 450
The Web Database Processing Environment 451
The ODBC Standard 453
ODBC Architecture 453 • Conformance Levels 454 • Creating an ODBC Data
Source Name 456