Concept

Object–relational mapping

Related lectures (32)

Relational Databases: Fundamentals and ACID Properties

Covers relational databases, transactions, and data consistency in the context of historical database typologies.

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

Data: Clouds and Things

Covers the fundamentals of data, cloud storage, and the Internet of Things.

Data-Intensive Systems: Relational Model and Algebra

Introduces the relational model and algebra, essential for understanding data-intensive systems and effective database management.

Relational Databases: Fundamentals

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

Designing Learning Experiences: CS411 Class Project

Introduces the CS411 Class Project, where students design and test a lesson using learning theories.

Large-scale SQL Processing

Introduces data frames as a space-efficient data representation with an extensible SQL-like language.

Handling Data: Intro to Pandas

Introduces the fundamentals of handling data, emphasizing the importance of Pandas and data modeling for effective analysis.

Efficient Analytics: Adapting to Modern Data Challenges

Covers the adaptation of analytics systems to modern hardware and data challenges, focusing on efficiency and scalability through innovative approaches and hybrid systems.

Data Storage and Transmission: Metadata for Disks

Explores the importance of metadata in organizing media libraries and the challenges in retrieving specific works or artists efficiently.

Data Management: Efficient Storage and Indexing

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

Relational vs NoSQL: Evolution and Comparison

Explores the historical debate between relational and non-relational data models, covering key characteristics and examples of each.

Database Management Systems: Fundamentals

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

Relational Algebra and SQL: Foundations of Database Management

Introduces the relational model and relational algebra, focusing on SQL and its operations for effective database management.

Semantic Modelling: Tabular Data and RDF

Introduces semantic modelling through tabular data and RDF, covering relational databases, schema migration, future-proof schemata, SPARQL querying, and metaknowledge limitations.

Learning Models over Relational Databases

Explores learning models over relational databases, emphasizing prediction quality and the importance of structure-aware learning.

Query Processing with Relational Operations

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

Untitled

Efficient Graph Queries: Memory Constraints

Explores scaling pattern matching in large graphs and optimizing query execution under memory constraints using work-sharing and batch processing.

Database Systems: Overview

Introduces database systems, covering DBMS ecosystem, relational model, course overview, prerequisites, course outline, grading scheme, projects, and teaching methods.