Databases

Catalog description

Databases enable the efficient storage, retrieval, and management of vast amounts of structured and unstructured data, supporting critical applications in fields such as big data analytics, artificial intelligence, and enterprise systems. This course provides a comprehensive understanding of advanced database concepts, with a focus on the design and implementation of database management systems. Topics include data models (relational, document, key/value), storage models (n-ary, decomposition), query languages (SQL, stored procedures), storage architectures (heaps, log-structured), indexing (order preserving trees, hash tables), transaction processing (ACID, concurrency control), recovery (logging, checkpoints), query processing (joins, sorting, aggregation, optimization), and parallel architectures (multi-core, distributed).