Mediaspace scheduled maintenance: Aug 25, 2026 07:00 - 12:00 AM. During this time, videos will be temporarily unavailable. Check status updates.

Concept

Query language

Related lectures (32)

Data Wrangling with Hadoop: Storage Formats and Hive

Explores data wrangling with Hadoop, emphasizing storage formats and Hive for big data processing.

Data Wrangling with Hive: Managing Big Data Efficiently

Covers data wrangling techniques using Apache Hive for efficient big data management.

Querying a database: the SQL language MOOC: Geographical Information Systems 1

Covers the SQL language for interacting with databases through structured queries, including selecting, filtering, aggregating, and sorting data.

Queries with for

Explores the for notation for querying databases using examples with a mini-database of books.

Ground Station: Data Processing

Explains the operation of a ground station for data processing and querying databases for sensor values.

Optimizing Recursive Queries

Explores optimizing recursive queries in database systems using Datalog and semirings, discussing the challenges and solutions in data analytics.

Data Definition and Manipulation Languages: Views MOOC: Geographical Information Systems 1

Covers creating, modifying, and deleting tables, inserting, updating, and deleting data, and briefly discusses views.

SQL Queries and Syntax MOOC: Geographical Information Systems 1

Covers the basics of SQL, including components of the language and syntax of SELECT clause.

NoSQL Databases: Origins and Types MOOC: Geographical Information Systems 1

Covers the origins and types of NoSQL databases, focusing on MongoDB and CRUD operations.

Translation of for

Explains the translation of for-expressions in Scala using map, flatmap, and filter functions, with examples and a discussion on its generalization to different types.

Relational Algebra Log in to Mediaspace to watch this video

Introduces relational query languages, focusing on algebra operators and query optimization.

Latent semantic indexing: inverted files Log in to Mediaspace to watch this video

Explores term-offset indices in inverted files and relevance feedback solutions.

Vectorization: Optimizing Query Processing in Database Systems Log in to Mediaspace to watch this video

Explores the vectorization model in query processing for database systems, optimizing performance for OLAP queries.

Information Retrieval Basics Log in to Mediaspace to watch this video

Introduces the basics of information retrieval, covering text-based and Boolean retrieval, vector space retrieval, and similarity computation.

Advanced Metaprogramming Queries: Code Volume & Complexity Log in to Mediaspace to watch this video

Explores managing large codebases, higher abstraction levels, CodeDB, Datalog queries, and program analysis.

JIT Compilation: The Hyper Approach Log in to Mediaspace to watch this video

Explores code generation approaches, operator abstractions, query compilation, data format adaptation, and operational systems in database query processing.

Relational Query Optimization Log in to Mediaspace to watch this video

Covers relational query optimization, including logical and physical query plans, cost estimation, equivalences, and the System R strategy.

Query Processing with Relational Operations Log in to Mediaspace to watch this video

Covers query processing with relational operations, including query optimization and different join algorithms.

Data Warehouses and Decision Support Systems Log in to Mediaspace to watch this video

Explores data warehouses, decision support systems, OLAP, data lakes, multidimensional data models, and query optimizations.

Query Operators: Part 1 Log in to Mediaspace to watch this video

Explores query processing steps, physical plans, pipelined execution, and hashing for projections and joins.