Login to filter by course Login to filter by course Reset
Introduction to Database SystemsCovers the fundamentals of database systems, including data modeling, information processing, and the challenges of managing large volumes of data.
Relational Model: BasicsIntroduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.
Relational Databases: FundamentalsCovers relational and spatial databases, including storage, management systems, ACID properties, historical typologies, primary and foreign keys, and spatial functions.
Data Wrangling with HadoopCovers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.
Parallel DatabasesExplores parallel and distributed databases, covering architectures, query optimization, data storage, and distributed transactions.
JIT Compilation: The Hyper ApproachExplores code generation approaches, operator abstractions, query compilation, data format adaptation, and operational systems in database query processing.
Database Systems: OverviewIntroduces database systems, covering DBMS ecosystem, relational model, course overview, prerequisites, course outline, grading scheme, projects, and teaching methods.
Query Operators: Part 1Explores query processing steps, physical plans, pipelined execution, and hashing for projections and joins.
Indexing in Database SystemsExplores indexing in database systems, covering storage, files, and efficient data retrieval techniques using various types of indexes.