Review of Relational Data Model and Relational Database Constraints:
Relational model concepts; Relational model constraints and relational database schemas; Update operations, anomalies, dealing with constraint violations, Types and violations.
Object and Object-Relational Databases:
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.
Disk Storage, Basic File Structures, Hashing, and Modern Storage Architectures:
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.
Distributed Database Concepts:
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.
NOSQL Databases and Big Data Storage Systems:
Introduction to NOSQL Systems, The CAP Theorem, Document-Based NOSQL Systems and MongoDB, NOSQL Key-Value Stores, Column-Based or Wide Column NOSQL Systems, NOSQL Graph Databases and Neo4j.
Big Data Technologies Based on MapReduce and Hadoop:
What Is Big Data? Introduction to MapReduce and Hadoop, Hadoop Distributed File System (HDFS), MapReduce: Additional Details Hadoop v2 alias YARN, General Discussion
Enhanced Data Models: Introduction to Active, Temporal, Spatial, Multimedia, and Deductive Databases:
Active Database Concepts and Triggers, Temporal Database Concepts, Spatial Database Concepts, Multimedia Database Concepts, Introduction to Deductive Databases.
Introduction to Information Retrieval and Web Search:
Information Retrieval (IR) Concepts, Retrieval Models, Types of Queries in IR Systems, Text Preprocessing, Inverted Indexing, Evaluation Measures of Search Relevance, Web Search and Analysis. Trends in Information Retrieval
Data Mining Concepts:
Overview of Data Mining Technology, Association Rules, Classification, Clustering, Approaches to Other Data Mining Problems, Applications of Data Mining, Commercial Data Mining Tools
Overview of Data Warehousing and OLAP:
Introduction, Definitions, and Terminology, Characteristics of Data Warehouses, Data Modeling for Data Warehouses, Building a Data Warehouse, Typical Functionality of a Data Warehouse, Data Warehouse versus Views, Difficulties of Implementing Data Warehouses.