Відео

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.

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?

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.

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.

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 ?

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.

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!

Sie haben die Kunst des einfachen Erklärens echt gemeistert. Ein herzliches Danke!