Concept

Comparison of relational database management systems

Related lectures (32)

SQL Client-Server Architecture + IDE

Covers the architecture of a typical DBMS and SQL interfaces like SQL Developer and DataGrip.

Data modeling: Geographic Information Systems

Introduces data modeling in the context of Geographic Information Systems, covering the added value and methods used.

Conditional Queries: Overview

Covers the functioning of conditional queries based on the WHERE clause.

Views: SQL Queries Simplification

Explores how views simplify query writing and are key in data warehouses.

Efficient GPU Join Optimization

Covers efficient GPU-accelerated join optimization for complex queries, focusing on improving optimization times and heuristic plan quality.

Data Streams and Approximation

Explores data stream management, real-time analytics, data stream models, and processing challenges.

Introduction to Streams

Covers data streams, real-time analytics, challenges, data stream model, and efficient management.

Query Fusion, Nested Queries

Covers query fusion, nested queries, and SQL operators in a geographical context.

Relational Model: Basics

Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.

DBMS Principles and Operators

Covers the fundamentals of DBMS, relational algebra operators, and their importance in managing large datasets.

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.

Data Management: Efficient Storage and Indexing

Covers efficient data storage, indexing, and management in databases.

Concurrency Control & Recovery in Databases

Delves into transaction management, concurrency control, and recovery in databases to ensure data integrity and system resilience.

Indexing in Database Systems

Explores indexing in database systems, covering storage, files, and efficient data retrieval techniques using various types of indexes.

Relational Databases: Fundamentals

Covers relational and spatial databases, including storage, management systems, ACID properties, historical typologies, primary and foreign keys, and spatial functions.

Architecture of CockroachDB

Explores the architecture of CockroachDB, focusing on transaction management, concurrency control, and scalability.

Block-oriented Execution: Query Processing in Database Systems

Explores block-oriented query processing in databases, emphasizing materialization challenges and optimized execution for data-intensive applications.

Data Perturbation: Protecting Privacy in Database Systems

Explores data perturbation for privacy protection in database systems, including aggregate reconstruction and its application in data mining.

Query Optimization: Improving Database Performance

Discusses query optimization in database systems, emphasizing the impact on performance and the decisions involved in improving database performance.

NoSQL Databases: Origins and Types

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