Skip to main content
Graph
Search
fr
en
Login
Search
All
Categories
Concepts
Courses
Lectures
MOOCs
People
Practice
Publications
Startups
Units
Show all results for
Home
Course
CS-422: Database systems
Graph Chatbot
Lectures in this course (104)
OLAP Queries: Aggregations, Cube Operator, and Optimizations
Explores OLAP queries, cube operator, super-aggregates, and optimization techniques.
Views: Simplifying SQL Queries
Explores views in SQL, covering creation, materialization, maintenance, cube building, and top-k queries optimizations.
Query Optimization: Improving Database Performance
Discusses query optimization in database systems, emphasizing the impact on performance and the decisions involved in improving database performance.
Data Wrangling: ETL Process and Wrangling Issues
Explores the ETL process, data wrangling stages, and common issues.
Relational Algebra Equivalences: Optimization Techniques
Explores relational algebra equivalences for optimizing query performance through efficient tuple generation and join operations.
Data Structuring: Intrarecord and Interrecord Techniques
Covers data structuring techniques, error detection, and functional dependencies within records.
Optimization Heuristics: Example of INGRES Database System
Explores heuristic-based optimization using the INGRES database system example.
Cost-based Query Optimization
Explores cost-based query optimization in database systems, covering cost estimation, selectivity estimation, and join cardinality.
Entity Resolution: Techniques and Applications
Explores entity resolution techniques for identifying and aggregating different entity profiles across datasets, covering challenges and solutions.
Apache Spark Ecosystem: Basics and Operations
Provides an overview of the Apache Spark ecosystem, covering basics, operations, and key components.
System-R Optimizer: Query Optimization and Cost Estimation
Explores the System-R Optimizer, query optimization, cost estimation, join orderings, and cardinality challenges in database systems.
Big Data: Processing and Management
Explores big data challenges, characteristics, declustering techniques, and failure management strategies in data processing and management.
Query Optimization: Multi-query Optimization
Explores database query optimization, discussing static versus dynamic optimization, scan sharing, and the impact on DBMS performance.
Data Warehouses and Data Lakes
Covers data warehouses, data lakes, OLTP vs. OLAP, data quality, and the Data Lakehouse concept.
Hadoop Ecosystem: Architectural Choices & MapReduce Programming
Explores the Hadoop ecosystem's architecture and MapReduce programming model, emphasizing strengths and limitations.
OLAP Data Model: Multidimensional and Relational Approaches
Explains OLAP data models, focusing on multidimensional and relational approaches.
Scheduling Decisions: Data Locality and Multitenancy
Explores data locality in scheduling decisions for multi-tenant platforms and discusses Hadoop's architecture, execution engine optimizations, and fault tolerance strategies.
OLAP Queries and Optimizations
Covers OLAP queries, examples of comparisons, ranking, and optimizations for query performance.
Near Neighbors Retrieval: Efficient Techniques
Covers techniques for efficiently retrieving similar items using similarity search queries.
Spark Ecosystem: Architectural Choices
Explores the Spark ecosystem's architectural choices, including RDDs and fault tolerance.
Previous
Page 3 of 6
Next
