News for hackers. Stuff that matters.
Re:Database Fundamentals by bogomipz on Friday December 15, 2023 @08:21PM (#38660890)
>"I agree with this. B-trees vs hash indices, I/O hierarchy, process model, etc."

I'm familiar with all of the concepts in the context of databases except "process model." Is this the same as data model? Could you elaborate if not?

Re:Database Fundamentals by linl on Saturday December 16, 2023 @01:23AM (#38662186)
There are several types of process models that's suitable for a DBMS: 1 process per DBMS worker, 1 thread per DBMS worker, a lightweight thread pool, a process pool, etc.

Hellerstein, Stonebraker and Hamilton (2007) is a great introduction on this.