Data Wrangling with HadoopCovers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.
Introduction to Database SystemsCovers the fundamentals of database systems, including data modeling, information processing, and the challenges of managing large volumes of data.
Relational Databases: FundamentalsCovers relational and spatial databases, including storage, management systems, ACID properties, historical typologies, primary and foreign keys, and spatial functions.
Database Systems: OverviewIntroduces database systems, covering DBMS ecosystem, relational model, course overview, prerequisites, course outline, grading scheme, projects, and teaching methods.
Query Operators Part 2Covers query processing with relational operations, focusing on different join methods and the impact of buffering.
Efficient GPU Join OptimizationCovers efficient GPU-accelerated join optimization for complex queries, focusing on improving optimization times and heuristic plan quality.