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.

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

Relational Algebra

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

Latent semantic indexing: inverted files

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

Queries with for

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

Vectorization: Optimizing Query Processing in Database Systems

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

Ground Station: Data Processing

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

Information Retrieval Basics

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

Optimizing Recursive Queries

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

Advanced Metaprogramming Queries: Code Volume & Complexity

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

JIT Compilation: The Hyper Approach

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

Relational Query Optimization

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

Query Processing with Relational Operations

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

Data Definition and Manipulation Languages: Views

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

SQL Queries and Syntax

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

Data Warehouses and Decision Support Systems

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

NoSQL Databases: Origins and Types

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

Query Operators: Part 1

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

Database Management Systems: Fundamentals

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