Канал: Immanuel Trummer

Analyze Data with LLMs and Python

Analyze Data with LLMs and Python

Introducing my Book "AI-Assisted Data Science"

Introducing my Book "AI-Assisted Data Science"

Talk @MIT: Generative AI and Databases

Talk @MIT: Generative AI and Databases

Matthias Boehm (TU Berlin) on Data-Centric ML Pipelines

Matthias Boehm (TU Berlin) on Data-Centric ML Pipelines

Arun Kumar (UCSD) on "DBification of ML/AI"

Arun Kumar (UCSD) on "DBification of ML/AI"

Subarna Chatterjee (Harvard) on COSINE: A Self-Designing Key Value Store for the Cloud

Subarna Chatterjee (Harvard) on COSINE: A Self-Designing Key Value Store for the Cloud

Design of Data Markets - Raul Castro Fernandez (University of Chicago)

Design of Data Markets - Raul Castro Fernandez (University of Chicago)

Reinventing Cloud Analytics with Machine Learning by Ippokratis Pandis (Amazon)

Reinventing Cloud Analytics with Machine Learning by Ippokratis Pandis (Amazon)

CodexDB: Synthesizing Code for SQL Processing with GPT-3 Codex (VLDB'22)

CodexDB: Synthesizing Code for SQL Processing with GPT-3 Codex (VLDB'22)

Aécio Santos on Efficient Correlated Dataset Search

Aécio Santos on Efficient Correlated Dataset Search

UDO: Universal Database Optimizer (VLDB'22)

UDO: Universal Database Optimizer (VLDB'22)

XXL Language Models and Applications in Data Management (VLDB'22 Tutorial)

XXL Language Models and Applications in Data Management (VLDB'22 Tutorial)

Immanuel Trummer Live Stream

Immanuel Trummer Live Stream

Introducing DB-BERT and CodexDB @ Microsoft (2022 Talk)

Introducing DB-BERT and CodexDB @ Microsoft (2022 Talk)

DB-BERT (SIGMOD'22 Talk)

DB-BERT (SIGMOD'22 Talk)

DB-BERT Demo (SIGMOD'22)

DB-BERT Demo (SIGMOD'22)

Programming the Cloud - Talk by Joe Hellerstein (UC Berkeley)

Programming the Cloud - Talk by Joe Hellerstein (UC Berkeley)

Marius++ - Talk by Roger Waleffe (Wisconsin-Madison)

Marius++ - Talk by Roger Waleffe (Wisconsin-Madison)

Human-Data Interaction - Talk by Eugene Wu (Columbia University)

Human-Data Interaction - Talk by Eugene Wu (Columbia University)

Detecting COIs in Heterogeneous Data - Talk by Angelos-Christos Anadiotis (Ecole Polytechnique)

Detecting COIs in Heterogeneous Data - Talk by Angelos-Christos Anadiotis (Ecole Polytechnique)

Incremental Entity Embeddings - Talk by Laurel Orr (Stanford)

Incremental Entity Embeddings - Talk by Laurel Orr (Stanford)

Cleaning Knowledge Graphs - Talk by Davide Mottin (Aarhus University)

Cleaning Knowledge Graphs - Talk by Davide Mottin (Aarhus University)

Big Data Systems - Talk by Volker Markl (TU Berlin)

Big Data Systems - Talk by Volker Markl (TU Berlin)

Learned Query Scheduling - Talk by Ibrahim Sabek (MIT)

Learned Query Scheduling - Talk by Ibrahim Sabek (MIT)

Learned DBMS Components 2.0 - Talk by Carsten Binnig and Benjamin Hilprecht (TU Darmstadt)

Learned DBMS Components 2.0 - Talk by Carsten Binnig and Benjamin Hilprecht (TU Darmstadt)

Mining Database Tuning Hints from Text (DB-BERT)

Mining Database Tuning Hints from Text (DB-BERT)

Fast Recovery in ML Training with FLOR - Talk by Rolando Garcia Sanchez (UC Berkeley)

Fast Recovery in ML Training with FLOR - Talk by Rolando Garcia Sanchez (UC Berkeley)

Robust LSM-Based Key Value Stores - Talk by Manos Athanassoulis (BU)

Robust LSM-Based Key Value Stores - Talk by Manos Athanassoulis (BU)

CIDR'22: NLP-Enhanced Data Profiling

CIDR'22: NLP-Enhanced Data Profiling

Talk at UC Berkeley: Tuning Tools that "Read" the Manual

Talk at UC Berkeley: Tuning Tools that "Read" the Manual

Database Tuning Tools that "Read the Manual" (VLDB'21)

Database Tuning Tools that "Read the Manual" (VLDB'21)

Summarizing Data for Voice Querying - ICDE'21

Summarizing Data for Voice Querying - ICDE'21

39: Conclusion & Outlook

39: Conclusion & Outlook

38: Approximate Query Processing

38: Approximate Query Processing

37: R Trees, SQL for Spatial Data, BigQuery Geo Viz Demo

37: R Trees, SQL for Spatial Data, BigQuery Geo Viz Demo

36: ksqlDB Demo, Spatial Data, Region Quad-Trees, R Trees

36: ksqlDB Demo, Spatial Data, Region Quad-Trees, R Trees

1: Database Management Systems Intro

1: Database Management Systems Intro

35: Distributed Stream Processing, Apache Kafka, ksqlDB, Log-Structured Merge Trees

35: Distributed Stream Processing, Apache Kafka, ksqlDB, Log-Structured Merge Trees

34: Stream Data Management

34: Stream Data Management

33: Distributed Graph Processing, PageRank

33: Distributed Graph Processing, PageRank

32: Graph Databases, Neo4j Demo

32: Graph Databases, Neo4j Demo

31: NewSQL, H-Store, Google Spanner

31: NewSQL, H-Store, Google Spanner

30: Eventual Consistency, CAP Theorem, Apache Cassandra

30: Eventual Consistency, CAP Theorem, Apache Cassandra

29: Distributed DBMS, Distributed Joins and Transactions

29: Distributed DBMS, Distributed Joins and Transactions

28: Schema Normalization, Normal Forms, DB Design Example

28: Schema Normalization, Normal Forms, DB Design Example

27: Schema Normalization, Boyce Codd Normal Form

27: Schema Normalization, Boyce Codd Normal Form

26: Functional Dependencies, Database Schema Normalization

26: Functional Dependencies, Database Schema Normalization

25: Entity Relationship (ER) Diagrams, Database Design

25: Entity Relationship (ER) Diagrams, Database Design

24: Revision, Database Design Intro

24: Revision, Database Design Intro

23: Overview of Course Material Seen So Far

23: Overview of Course Material Seen So Far

22: Recovery Phase of ARIES

22: Recovery Phase of ARIES

21: Database Recovery via ARIES

21: Database Recovery via ARIES

20: Multi-Version Concurrency Control, Snapshot Isolation, Recovery

20: Multi-Version Concurrency Control, Snapshot Isolation, Recovery

19: Multi-Granularity Locking, Concurrency Control without Locks

19: Multi-Granularity Locking, Concurrency Control without Locks

18: Deadlocks, Index Locking, Phantoms

18: Deadlocks, Index Locking, Phantoms

17: Two-Phase Locking, Proof of Conflict Serializability

17: Two-Phase Locking, Proof of Conflict Serializability

16: Isolation, Two-Phase Locking

16: Isolation, Two-Phase Locking

15: Transactions Intro & Demo, ACID Guarantees, Isolation

15: Transactions Intro & Demo, ACID Guarantees, Isolation

14: Query Optimization, Optimizer Demo in Postgres

14: Query Optimization, Optimizer Demo in Postgres

13: Query Optimization, Cost Estimation

13: Query Optimization, Cost Estimation

12: More Operators and Query Plans

12: More Operators and Query Plans

11: Hash Join, Sort-Merge Join

11: Hash Join, Sort-Merge Join

10: Filtering Demo, Nested Loop Join Operators

10: Filtering Demo, Nested Loop Join Operators

9: Buffer Management, Query Plans, Standard Operators

9: Buffer Management, Query Plans, Standard Operators

8: Hash Indexes in Database Systems

8: Hash Indexes in Database Systems

7: Postgres Index Demo, Tree Index Refinements, Index Updates

7: Postgres Index Demo, Tree Index Refinements, Index Updates

6: Data Layout, Files, Tree Indexes, B+ Trees

6: Data Layout, Files, Tree Indexes, B+ Trees

5: Correlated SQL Sub-Queries, The Memory Hierarchy

5: Correlated SQL Sub-Queries, The Memory Hierarchy

4: Analyzing Game Sales with SQL, NULL Values, Outer Joins, Nested Queries

4: Analyzing Game Sales with SQL, NULL Values, Outer Joins, Nested Queries

3: Simple SQL Queries, Aggregation, Grouping

3: Simple SQL Queries, Aggregation, Grouping

2: Creating and Filling a Database

2: Creating and Filling a Database

Talk on SkinnerDB @ Snowflake 2020

Talk on SkinnerDB @ Snowflake 2020

Lecture 1 (Database Systems): Overview and Logistics

Lecture 1 (Database Systems): Overview and Logistics

Talk at Oracle on SkinnerDB

Talk at Oracle on SkinnerDB

Automated Fact Checking Talk @ Global Fact 7

Automated Fact Checking Talk @ Global Fact 7

Talk on BitGourmet @ CIDR 2020

Talk on BitGourmet @ CIDR 2020

Talk on Voice Querying @ NYC Open Data Week

Talk on Voice Querying @ NYC Open Data Week

Chatting with CiceroDB :-)

Chatting with CiceroDB :-)

Visualizing Intra-Query Learning (SkinnerDB)

Visualizing Intra-Query Learning (SkinnerDB)

SIGMOD'19: SkinnerDB

SIGMOD'19: SkinnerDB

SIGMOD'19: Voice-Based OLAP

SIGMOD'19: Voice-Based OLAP

SIGMOD'19: Exact Cardinality Optimization

SIGMOD'19: Exact Cardinality Optimization

SIGMOD'19: AggChecker

SIGMOD'19: AggChecker

CiceroDB: CIDR'19 Talk

CiceroDB: CIDR'19 Talk

VLDB 2018 Talk (Vocalization)

VLDB 2018 Talk (Vocalization)

Data Vocalization at VLDB 2017

Data Vocalization at VLDB 2017

Overview of Recent and Ongoing Work 2016

Overview of Recent and Ongoing Work 2016

Quantum Computing for Query Optimization (VLDB 2016 Talk)

Quantum Computing for Query Optimization (VLDB 2016 Talk)

SIGMOD 2016 Talk by Trummer: A Fast, Randomized Algorithm for Multi-Objective Query Optimization

SIGMOD 2016 Talk by Trummer: A Fast, Randomized Algorithm for Multi-Objective Query Optimization

VLDB 2015: Multi-Objective Parametric Query Optimization

VLDB 2015: Multi-Objective Parametric Query Optimization

Talk on Multi-Objective Query Optimization by Immanuel Trummer (EcoCloud 2015)

Talk on Multi-Objective Query Optimization by Immanuel Trummer (EcoCloud 2015)

SIGMOD 2015 Talk by Immanuel Trummer: Mining Subjective Properties from the Web

SIGMOD 2015 Talk by Immanuel Trummer: Mining Subjective Properties from the Web

SIGMOD 2015 Talk by Trummer: An Incremental Anytime Algorithm for Multi-Objective Query Optimization

SIGMOD 2015 Talk by Trummer: An Incremental Anytime Algorithm for Multi-Objective Query Optimization