Document
☰
📘 Facebook ▶️YouTube 📢 Telegram Channel 💬 Telegram Group
🔖 Bookmarks ⬆ Upgrade 🧩 More Apps | 🔗 Share ✉ Send Feedback ⭐ Rate App
← ✕
Logo

Engineering Labs

v2.2.1
←

Database Management Systems

Practical project ideas and implementations for hands-on learning

Active Databases & Triggers
Deductive Databases
Multimedia Databases
Spatial Databases
Temporal Databases
Additional Features of SQL
Basic Retrieval Queries
INSERT, DELETE, UPDATE Statements
Specifying Constraints in SQL
SQL Data Definition and Data Types
Applications of Data Mining
Association Rules
Classification
Clustering
Commercial Data Mining Tools
Other Data Mining Approaches
Overview of Data Mining Technology
Building a Data Warehouse
Characteristics of Data Warehouses
Data Modeling for Warehouses
Data Warehouse vs Views
Definitions and Terminology
Functionality of a Data Warehouse
Implementation Challenges
Centralized and Client/Server Architectures
Classification of DBMS
Data Models, Schemas, and Instances
Database Languages and Interfaces
Database System Environment
Three-Schema Architecture and Data Independence
Buffering Blocks
Dynamic Hashing
External Hashing
Heap Files
Internal Hashing
Secondary Storage Devices
Sorted Files
Storing Records on Disk
Distributed Architectures
Distributed Catalog Management
Distributed Concurrency Control
Distributed DB Concepts
Distributed Query Processing
Distributed Transaction Management
Fragmentation, Replication, Allocation
Types of Distributed DBs
Constraints on Specialization/Generalization
Data Abstraction and Ontologies
Specialization and Generalization
Specialization/Generalization in UML
Subclasses, Superclasses, Inheritance
UNION Types Using Categories
University EER Schema
Entity Types, Entity Sets, Attributes, Keys
ER Diagrams and Design Issues
High-Level Conceptual Data Models
Higher-Degree Relationship Types
Refining ER Design
Relationship Types, Roles, Structural Constraints
UML Class Diagrams for ER
Weak Entity Types
2NF and 3NF
Boyce–Codd Normal Form
Functional Dependencies
Informal Design Guidelines
Join Dependencies & 5NF
Multivalued Dependency & 4NF
B+-Trees
Dynamic B-Trees and B+-Trees
Multilevel Indexes
Search Trees
Single-Level Ordered Indexes
A Brief History of Database Applications
Actors on the Scene - Databases and Database Users
Advantages of Using the DBMS Approach
An Example - Databases and Database Users
Characteristics of the Database Approach
Databases and Database Users
When Not to Use a DBMS
Workers behind the Scene
Components of DBMS
Components of DBMS
Data Anomalies
Data Anomalies
Data Models
Data Models
Database Normalization
Database Normalization
Database System Terminologies
Database System Terminologies
ER Model
ER Model
File systems vs Database systems
File systems vs Database systems
Functional Dependencies Definition
Functional Dependencies Definition
Introduction to DBMS (Database Management Systems)
Introduction to DBMS (Database Management Systems)
Purpose of Database Systems
Purpose of Database Systems
Relational Algebra
Relational Algebra
Trust Management in Virtualized Data Centers
Trust Management in Virtualized Data Centers
Evaluation Measures
Inverted Index
IR Concepts
IR Trends
Retrieval Models
Text Preprocessing
Types of Queries in IR
Web Search & Analysis
ER-to-Relational Mapping
Mapping EER Constructs to Relations
Assertions and Triggers
More Complex SQL Retrieval Queries
Schema Modification Statements
Views (Virtual Tables)
Complex Type Structures
Encapsulation and Persistence
Object Identity and OODB Concepts
Object Query Language (OQL)
Object-Oriented Features
Object-Relational Extensions to SQL
ODMG Object Model and ODL
Type Hierarchies and Inheritance
Basic PHP Example
PHP DB Connectivity
PHP Language Features
DB Tuning Overview
Physical DB Design Factors
Physical Design Decisions
Choice of DBMS
Conceptual Database Design
Database Design and Implementation Process
Database Implementation and Tuning
Logical Database Design
Physical Database Design
Requirements Collection and Analysis
UML Diagrams for DB Design
Aggregate Operations and OUTER JOIN
Cost Estimation Techniques
External Sorting Algorithms
Heuristic Optimization
JOIN Algorithms
Pipelining
PROJECT & Set Operation Algorithms
SELECT Operation Algorithms
Translating SQL to Relational Algebra
ARIES Algorithm
Backup & Catastrophic Recovery
Deferred Update (NO-UNDO/REDO)
Immediate Update Recovery
Recovery Concepts
Shadow Paging
Additional Relational Operations
Binary Relational Operations: JOIN and DIVISION
Domain Relational Calculus
Examples of Relational Algebra Queries
Set Theory Operations in Relational Algebra
Tuple Relational Calculus
Unary Relational Operations: SELECT, PROJECT
Relational Model Concepts
Relational Model Constraints
Update Operations, Transactions, and Constraint Violations
Inference Rules and Minimal Cover
Nulls and Dangling Tuples
Properties of Decompositions
Schema Design Algorithms
Database Security Issues
Discretionary Access Control
Encryption & PKI
Mandatory Access Control
Privacy and Challenges
Role-Based Access Control
SQL Injection
Statistical DB Security
Cursors for Multi-Tuple Retrieval
Dynamic SQL
Embedded SQL
Function Calls: SQL/CLI & JDBC
SQLJ in Java
Stored Procedures and SQL/PSM
Introduction to Concurrency
Lock
Transaction Processing
Two-Phase Locking Techniques: The algorithm
B+-Tree Index Files
Data Mining
Data Warehouse
File Operations
Hashing
Indexing
Mobile Databases
Multi-dimensional Indexes
Physical Storage Media
RAID: Redundant Arrays of Independent Disks
Spatial Database Types of Spatial Data
Extracting XML from Relational DB
Storing and Extracting XML Data
Tree Data Model
XML Documents, DTD, XML Schema
XML Languages