Curriculum Design & instruction To Teach Database Systems

Curriculum Design and Instruction To Teach

Database Systems:


Author: Charles Hayes:


In computer science database

systems are the means, either

manual or automatic, of converting

data into action or decision

information, including the forms,

procedures, and processes which

together provide an organized and

interrelated means of recording,

communicating, processing, and

presenting information relative

to a definable function or activity.





Special Features Include:

Phases For Conducting a Needs Assessment:
Curriculum Design Supplement:
|a|. Subject-Questions-Answers:
Curriculum Design Plan:
Curriculum Design Goals:
Curriculum Design Objectives:
Instructional Goals:
Instructional Objectives:
Instructional Activities:
Instructional Evaluation Techniques:
Lesson Plans:
Standard Vocabulary:
Learning Objectives:
A Limited Glimpse:


Topics Include:

* Introduction:

@ Introduction To Database Systems:

1. Evolution of Computers and Computer

Data Processing:

2. What Is a Database?

3. Features of Data in a Database:

4. What Is a Database Management System?

5. Why Use a Database Management System?

6. Where Are Database Management Systems

Used?

7. Classes of Computer Systems and Database

Systems:

A. Distributed Database Management System:

B. Real-Time Database Management System:

C. Fault-Tolerant Database Management System:

D. Secure Database Management System:

E. Heterogenous Database Management System:

F. Multimedia Database Management System:

G. The Future Of Database Management:

8. Overview of the Subject:

* Introduction:

@ Computer Data Processing Hardware

Architecture:

1. Computer Hardware Architecture:

2. CPU Architectures:

A. Instruction Types:

B. Instruction Architectures:

C. Memory-Addressing Schemes:

D. Memory Architectures:

3. I/O Architectures:

4. Secondary Storage and Peripheral

Devices Architectures:

5. Tape Storage Devices:

6. Magnetic and Optical Disk Storage Devices:

7. Network Architectures:

A. Computer to Network Interface Elements:

B. Network Bridges:

8. Network Topologies:

A. Bus Topology:

B. Ring Topology:

9. Computer Architectures:

A. Central IOC Architectures:

B. Memory-Mapped Architectures:

C. Common Bus Architecture:

D. Dual Bus Architecture:

* Introduction:

@ Computer Systems Support Software

Architecture:

1. Operating Systems Architecture:

2. Interrupt Management and Semaphores:

3. Process Management:

4. Resource Management:

A. Memory Management:

B. File Management:

C. Protection:

D. Peripheral Device Management:

6. Network Control Software:

A. Client/Server Policies and Mechanisms:

B. Remote Procedure Call Policies and

Mechanisms:

7. Fault Detection and Recovery:

8. Summary:

* Introduction:

@ Database Management Systems

Architecture:

1. Introduction:

A. Database Definition Language:

B. Database Manipulation Language:

C. Database Control Language:

2. Components of a Database System:

3. Transaction Management:

A. Transaction Basics:

B. Transaction Formalization:

4. Transaction Processing Models:

5. Example Transaction Models:

A. Nested Transactions:

B. Long Duration Transactions:

C. Cooperative Transaction Hierarchy:

D. Distributed Object Model:

E. Open Publication Model:

F. Contract Model and Split Transaction Model:

G. Flexible Transaction Model:

H. ACTA Model:

I. Early Commit Model:

6. Concurrency Control Management:

A. Serializability:

7. Query Processing:

8. Relational Optimization and Properties:

9. Fault and Failure Recovery:

A. Undo/Redo:

B. No Undo and Redo:

C. Undo and No Redo:

D. No Undo and No Redo:

E. Recovery Improvements:

F. Forward Recovery:

10. Integrity Management:

11. Security Considerations:

A. Identification and Authorization:

B. Authorization:

12. Applications Interfaces:

* Introduction:

@ Database Design Models:

1. Requirements Analysis:

A. User Requirements:

B. Application Functionality:

C. Information Requirements:

D. Application Interfaces:

E. Application Resources:

F. Application Security Requirements:

G. Application Quality and Reliability:

H. Application Documentation Needs:

I. Characteristics of the Requirements:

2. Information Modeling:

A. Data Entities:

B. Data Attributes:

C. Data Associations:

D. Entity List:

E. Data Schema Map:

F. Logical Data Model Key Structures:

G. Logical Data Model Constraint Definition:

3. Data Partitioning Models:

A. Location Constraints:

B. Relationship Constraints:

4. Functional Dependencies:

A. Functional Dependencies:

* Introduction:

@ Semantic Modeling and The

Entity-Relationship Model:

1. The ER Model:

2. Mapping to the Implementation Model:

A. Mapping to the Relational Model:

B. Mapping to the Object-Oriented Models:

3. Summary:

@ The CODASYL or Network Database

Structuring Model:

1. History of CODASYL:

2. DBTG Architecture:

3. Basic Elements:

4. Execution Model:

A. CODASYL Verbs:

B. Network Navigation:

C. Pros and Cons of the CODASYL Model:

* Introduction:

@ The Relational Data Structuring

Model:

1. Basic Features of Relations:

2. Data Types Supported:

A. Functional Dependencies:

3. Data Relationships Supported:

4. Execution Model:

A. Select:

B. Projection Operator:

C. Union Operator:

D. Difference Operator:

E. Intersect Operator:

F. Cartesian Product Operator:

G. Join Operator:

5. Summary:

* Introduction:

@ The Object-Oriented Data

Structuring Model:

1. Basic Concepts:

A. Objects, Methods, and Messages:

B. Types, Classes, and Encapsulation:

C. Encapsulation and Types:

D. Object Identity:

E. Inheritance:

F. Overloading and Late Binding:

2. Object-Oriented Database Model:

A. Database Fundamentals:

B. Object Representation:

C. Type Hierarchy:

D. Collection Type:

E. Object Relationships:

F. Object Constraints:

G. Query Processing:

F. Versions:

G. Active Objects:

H. Transactions in Object-Oriented

Database:

3. Object Orientation and the

Client/Server Model:

A. Passive Object Storage:

B. Active Object Storage:

C. Object/Server Architecture

Alternatives:

D. Object/Server Approach:

E. Page/Server Approach:

F. File/Server Architecture Approach:

* Introduction:

@ Distributed Database Management

Systems:

1. Distributed Databases:

A. Advantages of Distribution:

B. Disadvantages of Distribution:

2. Distributed Database Architecture:

3. Distributed Database Design:

4. Distributed Query Processing:

5. Update Synchronization:

6. Distributed Recovery:

* Introduction:

@ Real-Time Database Systems:

1. Real-Time Systems:

A. Real-Time System Requirements:

B. Scheduling:

2. Real-Time Database Requirements:

A. Temporal Consistency:

B. Bounded Imprecision:

C. Predictability:

D. Transactions:

E. Summary of Real-Time Database

Requirements:

3. Real-Time Database Models:

A. Ramamritham Model:

B. Kim/Son Model:

C. RTSORAC Model:

4. Real-Time Database Systems and

Standards:

A. The Zip Real-Time Database System:

B. The EagleSpeed Real-Time Database System:

C. Real-Time Extensions to the Open Object-

Oriented Database System:

D. Real-Time SQL:

5. Real-Time Database Research:

A. Priority Assignment Policies:

B. Concurrency Control Mechanisms:

6. Summary:

* Introduction:

@ Interoperating and Integrating

The Multidatabase Systems:

1. The Database Problem:

A. The Database Problem versus the Large

Organization:

B. Two Factors Causing the Problem:

2. Solutions for Solving the Database

Problem:

A. Solution One: The Massive Many-to-One

Conversion:

B. Solution Two: The Two-Way Midware:

C. Solution Three: The Some-Conversion

and Some-Midware Solution:

D. Solution Four: The Multiple-Interface

and Single-Kernel DBS:

3. Summary:

* Introduction:

@ Multilevel Database Security:

Milestones and Issues:

1. Secure Relational Data Models:

A. Multilevel Relations:

B. Multilevel Relational Integrity

Rules:

C. Polyinstantiation:

D. Decomposition into Standard

Relations:

E. Update Semantics for Multilevel

Relations:

2. Inference Control:

A. Overview:

B. Constraint Processing:

C. Inference Control During Query

Processing:

D. Constraint Processing During

Database Design:

E. Update Constraint Processor:

3. Secure Object-Oriented Databases:

4. Secure Distributed Databases:

5. Multilevel Secure Database

Concurrency Control:

A. Secure Concurrency Control:

B. Security, Concurrency Control, and

Real-Time Databases:

6. Summary:

* Introduction:

@ Fault-Tolerant Database Systems:

1. Basic Probability:

2. Fault Tolerance:

3. Fault-Tolerance:

A. Fault-Tolerance Basics:

B. Fault Avoidance:

C. Recovery and Restoration:

4. Hardware Redundancy as an Approach

To Fault Tolerance:

5. Software Redundancy as an Approach to

Fault Tolerance:

6. Summary:

* Introduction:

@ Multimedia Data Management Systems:

1. Architectures for an MMDBMS:

2. Functions of an MMDBMS:

A. Data Representation:

B. Data Manipulation:

C. Transaction Processing:

D. Metadata Management:

E. Data Distribution:

F. Storage Management:

G. Quality of Service:

H. Maintaining Data Integrety

and Security:

I. User Interface:

J. Heterogeneity:

K. Real-Time Processing:

* Introduction:

@ Multimedia Data Management Systems:

1. Architectures for an MMDBMS:

2. Functions of an MMDBMS:

A. Data Representation:

B. Data Manipulation:

C. Transaction Processing:

D. Metadata Management:

E. Data Distribution:

F. Storage Management:

G. Quality of Service:

H. Maintaining Data Integrety

and Security:

I. Uswe Interface:

J. Heterogeneity:

K. Real-Time Processing:

* Introduction:

@ Advanced Database System Concepts:

1. Active Databases:

A. Active Systems:

B. Transaction Processing in an Active

System:

C. Rule Processing Semantics:

D. Checking and Analysis Tools:

E. An Advanced Application

(Active Real-Time Systems):

F. Conclusion:

2. Flexible Transaction Processing:

A. Introduction:

B. Related Research:

C. Database and Transaction Model:

D. Transaction Structure:

E. Transaction Constraints:

F. Transaction Properties:

G. Transaction Recovery:

H. Summary:

3. Temporal Databases:

* Introduction:

@ Database Standards:

1. Database Standards:

A. Standards Process:

B. Useful Acronyms:

2. What Are Standards?

3. Why Standards?

4. Where Are Standards Developed?

A. International Organization for

Standardization (ISO):

B. American National Standards

Institute (ANSI):

C. Accredited Standards Committee (X3):

D. Database Standards Organizations:

5. Database Standards in X3:

A. Data Management:

B. Security:

C. Real-Time Data Management:

6. Need for Standardization Effort for

Database Management:

7. Frameworks and Consortia:

* Introduction:

@ Sample Database Management Systems

Products:

1. Network Database Management

Systems Products:

2. Relational Database Management

Systems Products:

A. ORACLE:

B. Microsoft:

C. Sybase:

3. Object-Oriented Database Products:

A. Borland:

B. 02 Technology:

4. Object Relational Database

Management Systems Products:

A. UniSQL:

B. Illustra:

C. Summary:

* STATE OF THE ART CURRICULUM DESIGN:

* NEW:

* ILLUSTRATIONS:

* DIAGRAMS:

* CHARTS:

* PHOTOS:

* REFERENCES:

* PAPERBACK:

* TRANSPARENT FRONT PAGE:

* BLACK-WHITE-RED OR BLUE BACK PAGE COVER:

* BINDED WIRE-0: BLACK-WHITE-RED OR BLUE:

* 500 WHITE PAGES: 8x11"

* ALLOW 4 TO 6 WEEKS TO RECEIVE ITEM:

* ORDER EARLY WHILE SUPPLIES LAST: