04 - Database Storage II (CMU Databases Systems / Fall 2019)

[@Rene-tu3fc]

I've spent the last 2 years searching for content like this. low level systems explained by people with lots of experience. And the descriptions and diagrams make you almost see the code beneath it.

[@xinxunzeng9639]

这位教授会重复每个学生的提问，这点太棒了！

[@420_gunna]

These classes fly by -- so fun! Trying to pace myself to one a day for retention purposes. Great job, Andy :)

[@swaroopakadam1992]

Thank you for making your lectures public. Good and thorough refresher on the DBMS concepts. Thank you. I noticed at 7:47 the pointer from id=2 to the corresponding log entry is not correct.

[@aakashPotter]

This has got to be the coolest class I have ever seen!

[@arielpapuga8908]

At 1:04:22 with offset matching method, if given column values are span across multiple pages how can you tell which two pages should you match together?

[@amruthasomasundar6322]

at around 13:45 he says variable precision numbers are typically faster for computation, but in the demo, the floats take more time. what am I missing?

[@jerrycheung8158]

Great video! Anyone know why Oracle gives real number output anyway?

[@jamestayler3734]

how do you get the up key to work on Oracle??

[@greenfloatingtoad]

Rlwrap?

[@liushuaiyi]

Why haven't there been CPU instructions or standards for fixed precision numeric values?

[@sebastiannyberg3008]

My understanding is that it is too complex and niche to model as a specific digital circuit. As you saw in the code example, the calculations are far from trivial in terms of branching, sometimes require recursive calculations, and span multiple words of data.

[@1UniverseGames]

He's terminal interface is super cool and he's super faster to do the demo as well.... Not a easy task 🙂

[@1UniverseGames]

Q1#: How the DBMS represent the database in files on disk? Q2# How the DBMS manages it's memory and move data back and forth from disk? Anyone could provide the possible ans for these two questions appears in the slides? Thanks.

[@garfieldnate]

The production quality of these things is off the charts! Really enjoying them! Thanks for sharing. Re: the comment about MariaDB: was Andy implying he doesn't like MariaDB, or was a simple statement about "column store != fast"?

[@sandeshpatel2732]

what is the role of dj drop tables in class

[@andypavlo]

Keeping the beats fresh.

[@mateofleitas4536]

Thank you for publishing this videos. They are awesome.

[@alielzahaby3315]

the only sad thing is we're not implementing those things like them other than that topics are really cool

[@drevil7vs13]

38:00 _List all the tables in the student table_ - sounds strange. Perhaps it should be (1) list all the *columns* and (2) INFORMATION_SCHEMA. *COLUMNS* instead of INFORMATION_SCHEMA. *TABLES* ?

[@monfera]

Who does embedded ids in column stores at kzbin.info/www/bejne/j4i1iniOg95pf6c ? - I think MonetDB does it generally, although avoids having to physically store the id column whenever possible. IIRC it comes back with eg. cracking databases where different order is established across different columns during cracking. C-Store also has to represent the rowid, because it sorts per column and applies run-length encoding; without keeping track of rowids, the tuple couldn't be reconstructed. So it's quite prevalent if we step away from the rigid 2-ary tuple representation (eg. with RLE, a low cardinality ie. highly repeating value may be assigned a bitmap eg. Roaring bitmaps to identify tuples characterized by a specific value, or sometimes value range).

[@omarelsebaey9589]

Hello All, thanks a million for this valuable content. I have a question that I hope someone might help me with Is there any ways to access the homework , assignments and projects for this course ? I am taking this course very seriously and I would like to go step by step with it thanks a lot

[@andypavlo]

Assignments: 15445.courses.cs.cmu.edu/fall2021/assignments.html Grading: 15445.courses.cs.cmu.edu/fall2021/faq.html#q7

[@omarelsebaey9589]

@@andypavlo Oh, this is really impressive (I do like the auto grading idea!) I wish you a great day sir.

[@mrinvestor2627]

Terminal name - never trust TK

[@abdelaziz2788]

22:00 doesnt that mean Oracle is bad in banking ? becz it aproximate too much?

[@rabingaire]

Great lectures

[@peijunwu7354]

9:08

[@degraaffservices1194]

SQL Server provides rowstore and columnstore storage, ostensibly managed by the same storage manger or atleast the same product code base. And it is doing fine from what i hear. So having to manage both rowstore and columnstore in the same product/codebase might be complex but not undo-able. Perhaps too complex for opensource databases like postgres.

[@jenh3183]

Thanks for sharing these videos.

[@ananthasubramanian7355]

Thank you for the video...!!!

[@thndesmondsaid]

DJ Drop Tables' boy huffing whippits :'D

[@Max-my6rk]

WOOOOOOW