Ch11 Database Performance Tuning-and Query Optimization
Database Performance Tuning and Query Optimization
This chapter focuses on the factors that directly affect database performance. Because performancetuning techniques can
Introduction to Structured Query Language (SQL)
Several points are worth emphasizing:
We have provided the SQL scripts for both chapters 7 and 8. These scripts are intended to
Chapter 14 Database Connectivity and Web Technologies
Database Connectivity and Web Technologies
Begin by making sure that the students are familiar with the basic vocabulary. The following two
questions are a good place to sta
Chapter 12 Distributed Database Management Systems
Distributed Database Management Systems
Discuss the possible data request scenarios in a distributed database environment.
1. Single request accessing a single remote database.
Chapter 13 The Data Warehouse
Business Intelligence and Data Warehouses
Start by discussing the need for business intelligence in a highly competitive global economy. Note
that Business Intelligence (BI) describes a comprehensi
Chapter 15 Database Administration and Security
Database Administration and Security
The following discussion sequence is designed to fit the chapter objectives:
Illustrate the value of data as a corporate asset to be managed.
Chapter 8 Advanced SQL
flow of the material presented to the class. However, given the comments made by our
Chapter .10 Transaction Management and Concurrency Control
Transaction Management and Concurrency Control
Why does a multi-user database environment give us a special interest in transaction management
and concurrency control?
Chapter 9 Database Design
What is the relationship between a database and an information system, and how does this
relationship have a bearing on database design?
An information system performs three sets of serv
Ch06-Advanced Data Modeling
Advanced Data Modeling
Your discussion can be divided into three parts to reflect the chapter coverage:
The first part of the discussion covers the Extended Entity Relationship Model.
a. Start by expl
Chapter 4 Entity Relationship (ER) Modeling
Entity-Relationship (ER) Modeling
We have used Microsoft Visio Professional to create the ERDs in the text and in this manual. Note
that ERDs are done at the conceptual level. However,
Although all of the topics covered in this chapter are important, our students have given us consistent
feedback: If you can write precise business rules from a description of operations, database
The Relational Database Model
How often have your students heard that you have only one chance to make a good first impression?
Thats why its so important to sell the importance of databases and the desirability of go