CS-422: Database systems

About
Privacy
Disclaimer

Graph Chatbot

Lectures in this course (104)

Database Management Systems: Overview

Covers database management systems principles, design, implementation, and storage options like flat CSV files.

Data Lakes: Structure and Optimization

Explores data lakes, data structure, and optimization for effective querying.

Database Systems: Overview

Introduces database systems, covering DBMS ecosystem, relational model, course overview, prerequisites, course outline, grading scheme, projects, and teaching methods.

Relational Model: Basics

Covers the basics of the relational model in database management systems, including data models, primary and foreign keys.

Teaching Structure and Learning Styles

Covers the course structure, pre-recorded lectures, and the importance of individual learning styles.

Data Warehousing and Decision Support

Explores data warehousing, decision support systems, and the importance of statistics in data analysis.

Database Management Systems: Fundamentals

Introduces the fundamentals of database management systems, covering relational model, storage options, data integrity, queries, and data manipulation languages.

Relational vs NoSQL: Evolution and Comparison

Explores the historical debate between relational and non-relational data models, covering key characteristics and examples of each.

Distributed Computing: Challenges and Solutions

Explores challenges in distributed computing, data growth, and data types, emphasizing the battle against the three Vs in big data.

CS422 Project: Iterator Model (Volcano)

Covers the CS422 project on the iterator model and relational operators.

DBMS Principles and Operators

Covers the fundamentals of DBMS, relational algebra operators, and their importance in managing large datasets.

The Gamma Parallel Database Machine: Data Clustering and Declustering

Explores The Gamma Parallel Database Machine, data clustering, and declustering tradeoffs.

Storage Technologies Overview

Covers the basics of storage technologies and database system architecture.

Database Systems: Data Storage

Discusses data storage in database systems, emphasizing efficiency and access times for different storage types.

Distributed Computing Execution Models: Spark Ecosystem

Explores the spark ecosystem in distributed computing and critiques the limitations of MapReduce.

Programming Models: Overview and Examples

Explores programming models for big data processing, including Spark's RDDs and optimizations.

Storage Technologies: Memory Hierarchy and Disk Storage

Explores memory hierarchy, CPU caches, SSD, HDD, and disk storage anatomy.

Buffer Management and Page Layout

Explores magnetic disk anatomy, cache organization, file organizations, buffer management, and page layout in DBMS.

Efficient Storage for Analytics: Columnar Storage & Compression Techniques

Explores columnar storage, compression techniques, DSM properties, and PAX advantages for analytics.

Resource Management and Fault Tolerance

Explores design choices, resource management, fault tolerance, and job recovery in Big Data systems.

Page 1 of 6