Database Administration

• Introduction
• An Example
• Characteristics of the Database Approach
• Actors on the Scene
• Workers behind the Scene
• Advantages of Using the DBMS Approach
• A Brief History of Database Applications
• When Not to Use a DBMS
• Data Models, Schemas, and Instances
• Three-Schema Architecture and Data Independence
• Database Languages and Interfaces
• The Database System Environment
• Centralized and Client/Server Architectures for DBMSs
• Classification of Database Management Systems
• Relational Model Concepts
• Relational Model Constraints and Relational Database Schemas
• Update Operations, Transactions, and Dealing with Constraint Violations

5 LiveLab in this lesson — see the labs panel →

• Relational Database Design Using ER-to-Relational Mapping
• Mapping EER Model Constructs to Relations
• Laboratory Exercises
• Overview of Database Programming Techniques and Issues
• Embedded SQL, Dynamic SQL, and SQL J
• Database Programming with Function Calls and Class Libraries: SQL/CLI and JDBC
• Database Stored Procedures and SQL/PSM
• Comparing the Three Approaches
• Overview of Object Database Concepts
• Object Database Extensions to SQL
• The ODMG Object Model and the Object Definition Language ODL
• Object Database Conceptual Design
• The Object Query Language OQL
• Overview of the C++ Language Binding in the ODMG Standard

3 LiveLab in this lesson — see the labs panel →

• Introduction
• Secondary Storage Devices
• Buffering of Blocks
• Placing File Records on Disk
• Operations on Files
• Files of Unordered Records (Heap Files)
• Files of Ordered Records (Sorted Files)
• Hashing Techniques
• Other Primary File Organizations
• Parallelizing Disk Access Using RAID Technology
• Modern Storage Architectures
• Types of Single-Level Ordered Indexes
• Multilevel Indexes
• Dynamic Multilevel Indexes Using B-Trees and B+-Trees
• Indexes on Multiple Keys
• Other Types of Indexes
• Some General Issues Concerning Indexing
• Physical Database Design in Relational Databases
• Translating SQL Queries into Relational Algebra and Other Operators
• Algorithms for External Sorting
• Algorithms for SELECT Operation
• Implementing the JOIN Operation
• Algorithms for PROJECT and Set Operations
• Implementing Aggregate Operations and Different Types of JOINs
• Combining Operations Using Pipelining
• Parallel Algorithms for Query Processing

17 LiveLab in this lesson — see the labs panel →

• Distributed Database Concepts
• Data Fragmentation, Replication, and Allocation Techniques for Distributed Database Design
• Overview of Concurrency Control and Recovery in Distributed Databases
• Overview of Transaction Management in Distributed Databases
• Query Processing and Optimization in Distributed Databases
• Types of Distributed Database Systems
• Distributed Database Architectures
• Distributed Catalog Management

• Introduction to Database Security Issues
• Discretionary Access Control Based on Granting and Revoking Privileges
• Mandatory Access Control and Role-Based Access Control for Multilevel Security
• SQL Injection
• Introduction to Statistical Database Security
• Introduction to Flow Control
• Encryption and Public Key Infrastructures
• Privacy Issues and Preservation
• Challenges to Maintaining Database Security
• Oracle Label-Based Security

3 LiveLab in this lesson — see the labs panel →