![Prof. Dr. Jens Dittrich, Big Data Analytics](/img/default-banner.jpg)
- 313
- 2 964 775
Prof. Dr. Jens Dittrich, Big Data Analytics
Germany
Приєднався 12 січ 2011
databases, database lectures, database management, big data, big data analytics, data science, datenbanken, datenbanken grundlagen, inverted classrooms, flipped teaching, computer science
Profilbild: (c) Iris Maria Maurer für die Universität des Saarlandes
Profilbild: (c) Iris Maria Maurer für die Universität des Saarlandes
Відео
ACID and Concurrency Control (Part 2)
Переглядів 5262 місяці тому
Part of the lecture Big Data Engineering at Saarland University
SQLite: How it works, by Richard Hipp
Переглядів 7 тис.2 місяці тому
Guest Lecture at Saarland University, on June 25th, 2024
Developing Web Applications with Django, Project: Fame Social Network
Переглядів 4432 місяці тому
Part of the lecture Big Data Engineering at Saarland University, IMDb (Part 3)
Query Optimization (Part 2)
Переглядів 5642 місяці тому
Part of the lecture Big Data Engineering at Saarland University
Ethical Implications of Metadata Analysis
Переглядів 4373 місяці тому
part of the undergrad lecture Big Data Engineering
Entity Relationship Modelling and the Relational Model
Переглядів 7604 місяці тому
Part of the Lecture "Big Data Engineering" at Saarland University
Big Data Engineering: Introduction and Administrative Matters
Переглядів 7714 місяці тому
Big Data Engineering: Introduction and Administrative Matters
Data in the Wild (Databases at University vs Databases in Reality)
Переглядів 521Рік тому
slides: github.com/BigDataAnalyticsGroup/bigdataengineering/tree/master/slides
Data Journalism (Modelling and Querying Graphs in SQL vs Cypher)
Переглядів 748Рік тому
slides: github.com/BigDataAnalyticsGroup/bigdataengineering/tree/master/slides
Introduction to Django
Переглядів 504Рік тому
slides: github.com/BigDataAnalyticsGroup/bigdataengineering/tree/master/slides
Concurrency Control (Part 1)
Переглядів 687Рік тому
slides: github.com/BigDataAnalyticsGroup/bigdataengineering/tree/master/slides
Ethical Aspects of Metadata Analysis with SQL (NSA Part 2)
Переглядів 508Рік тому
Ethical Aspects of Metadata Analysis with SQL (NSA Part 2)
Entity-Relationship Modelling and the Relational Model (IMDb Part 1)
Переглядів 1,2 тис.Рік тому
Entity-Relationship Modelling and the Relational Model (IMDb Part 1)
Big Data Engineering: Introduction and Administrative Matters
Переглядів 1,6 тис.Рік тому
Big Data Engineering: Introduction and Administrative Matters
This happens when a University Professor Teaches a fifth-semester Lecture together with ChatGPT
Переглядів 1,2 тис.Рік тому
This happens when a University Professor Teaches a fifth-semester Lecture together with ChatGPT
Database Systems: Multi-Version Concurrency Control (MVCC)
Переглядів 1,5 тис.Рік тому
Database Systems: Multi-Version Concurrency Control (MVCC)
Database Systems: Crash Recovery (Part 2), Elasticity
Переглядів 395Рік тому
Database Systems: Crash Recovery (Part 2), Elasticity
Database Systems: Crash Recovery with ARIES (Part 1)
Переглядів 707Рік тому
Database Systems: Crash Recovery with ARIES (Part 1)
Database Systems: Query Processing (Part 2) and Query Optimization (Part 1)
Переглядів 826Рік тому
Database Systems: Query Processing (Part 2) and Query Optimization (Part 1)
Database Systems: Indexing (Part 3) & Query Processing (Part 1)
Переглядів 858Рік тому
Database Systems: Indexing (Part 3) & Query Processing (Part 1)
Database Systems for First Semester Students (Part 2)
Переглядів 356Рік тому
Database Systems for First Semester Students (Part 2)
Sehr gut
don't know how the T1 write set intersect T2 lifetime means
Pure gold! SQLite, one of the marvel of CS
great honor. Thank you for sharing it with communities.
In one server can I install more than one SQLite file. And at one time the file is written and read.
assuming your filesystem and disk allow simulatenous writes, yes you can
Grandios erklärt! Danke!
Can u share the slides also.. btw great lecture understood everything
Is it pages or blocks? I think it is more appropriate to say blocks since we are reading and storing data to a disk in blocks, whereas pages have to do with virtual memory.
It would be interesting to have a lecture on Apache Iceberg / Delta and Apache Parquet - Datamanagement Systems. As these are basically optimized CSV files with Meta / Semantic Data Structure on top. In comparision to classical SQL Database setup.
Very important talk, thank you!
Did he end up giving the testing talk?
yes, in our group, but no recording
@@jensdit Man, I've been in awe of the testing ever since I found that page in the docs, around 2016
why do random reads still exists? From what i understand from the video they don't bring any benefits but it has to be a caveat with the sequential reads considering random ones are still aroung.
Thank you so much for uploading this. Fantastic lecture.
Every engineer should watch this. This is amazing.
Incredible lecture. Thank you!
Really nice lecture. Thank you for uploading and making it public! :-)
Mit Kreisen der Mengen wie in den vorherigen videos wäre es viel besser zu verstehen. Wie in üblichen Vorlesungen wird zu schnell mit gerade erst neu gelernten Begriffen versucht andere neue Begriffe zu erklären. Aber trotzdem danke, die Videos sind sehr hilfreich.
Joins mit "Kreisen", also mit Mengen, zu erklären wäre einfach nur falsch. Leider sieht man diese Erklärungen hier und da, u.a. auf wikipedia. Für semi-joins sind diese Erklärungen ok, für joins nicht.
Danke für die gute Erklärung
Can you help me with how to calculate the costs?
still in 2024 benefiting from you video god bless you
In your illustration of logical logging, you log the before and after, does this apply to huge writes? e.g. update something where id > 1000 This can modify say 1000 rows. If we still log before and after, our logical logging will have 1000 rows. Then why do you say logical log size is smaller than physical log size? Cuz I feel like in both cases, all the data is fully fleshed out in the log.
very practical course
Yacht is pronounced “yot” as in “hot”.
🤓👆
😫😫😫😫😫😫
Hallo, was ist eigentlich der Unterschied zwischen Schwache Entitytyp und Komposition?
Great to have concrete examples!🙂
best Professor ever ! viel vielen Dank für so ein guten Content!
great lecture!
Tolle Videos! Die Erklärungen sind sehr einfach gestaltet, sodass man gut folgen kann und die Visualisierung ist perfekt! Vielen Dank. Sie bringen einen sehr großen Mehrwert beim Lernen! Werde die Videos meinen Kommilitonen empfehlen.
nix einfach, die vorherigen videos waren besser erklärt
relationale Algebra kann so einfach sein... wenn man sie ganz übersichtlich und mit geeigneten Beispielen erklärt. So wie Sie es tun! Vielen Dank Herr Prof. Dr. Dittrich :)
Morgen Datenbanken Prüfung... Du rettest mir gerade den Arsch :)
vielen Dank!
That was some top tier explanation.Ty
I didn't understand what's wrong with the given example... Both T1 and T2 have started, T2 have committed the transaction after which T1 have committed which is legit no? T1 is not overwriting while T2 is in progress....
Thanks. Experienced programmer trying to really understand storage. This is at about the right level for me.
super gute vorlesung alles wunderbar erklärt ohne das es langweilig und/oder monoton wird
Professor, Ihre Arbeit und Art und Weise, dieses Fach zu lehren und klären, ist einfach so wunderbar, dass Sie die Topics echt einfach zu verstehen machen. Vielen vielen Dank!
awesome
awesome lessons.
Bildung auf höchster Ebene kann auch kostenlos gehen. Vielen Dank und Hut ab!
Dear Prof , Could you please make a video on how columns are identified in columnar DB ? I came to know there are no indexes in columnar DB , in that case how data is picked from various columns for a given key ?
you may use indexes in column store, if you don't use indexes, you will have to scan the column; this is typically ok for analytical queries; however, if you have an OLTP-workload, you want to have indexes
Unofficial Timestamps: 0:00 Recap 6:24 SQL Motivation (NSA) 16: 32 Nationales Sicherheitsamt by Andreas Eschbach 24:08 SQL |- 26:24 Most Common SQL Mistakes |- 33:30 SQL-92 Queries |- 43:50 Joins |- 1:05:24 Grouping not allowed |- 1:11:04 Having 1:20:40 Closing & Foreshadowing
Interesting lectures sir
Ich liebe sie
Sehr gut erklärt!
thank you so much. I finally understood the replacement sort.
02:55 - It's wonderful to have a lecturer who shares a good laugh with his students! Thanks for this moment! <3
come here after bytebytego explaining discord sets raid01 to its new db
Hi Prof. Dr. Jens Dittrich, is there any order to the Database playlists in which they have to be studied. I mean, there is a playlist on motivation and introduction then there is layout, and then hardware storage. So what is the order in which these topics should be studied? Thanks in advance.
There is a much more recent version of this lecture available, just follow the order in the following playlist: ua-cam.com/play/PLC4UZxBVGKtd9yJMZ_WH25MWzvc0qH0_L.html
Thank you @@jensdit
Noch ein-zwei kurze Beispiele mit zwei oder mehr Gruppierungen wären hilfreich gewesen, sehe noch nicht ganz ob sich zeilenweise was ändert, außer dass die zusätzlichen Gruppierungen als Spalte dabei sind. Trotzdem danke für die Erklärung!
Hier gibt es noch mehr Beispiele: ua-cam.com/video/pxZy1Q1JwTc/v-deo.html
Sie haben die Kunst des einfachen Erklärens echt gemeistert. Ein herzliches Danke!