News for hackers. Stuff that matters.
Re:Things to know about databases by electricshampo1 on Monday June 27, 2022 @07:08PM (#31902104)
" Like many modern analytical engines [18, 20], Procella does not use the conventional BTree style secondary indexes, opting instead for light weight secondary structures such as zone maps, bitmaps, bloom filters, partition and sort keys [1]. The metadata server serves this information during query planning time. These secondary structures are collected partly from the file headers during file registration, by the registration server, and partly lazily at query evaluation time by the data server. Schemas, table to file mapping, stats, zone maps and other metadata are mostly stored in the metadata store (in Bigtable [11] and Spanner [12])."

https://storage.googleapis.com/pub-tools-public-publication-...

Re:Things to know about databases by hashmash on Monday June 27, 2022 @07:55PM (#31902459)
> modern analytical engines

What about relational databases? Most are best suited for OLTP workloads.