3 ms·
F1 isn't strictly OLTP though. Even the paper says it: > F1 also provides a full-fledged SQL interface, which is used for low-latency OLTP queries, large OLAP
by elvinyung 9y ago
F1 isn't strictly OLTP though. Even the paper says it:
> F1 also provides a full-fledged SQL interface, which is used for low-latency OLTP queries, large OLAP queries, and everything in between.
- ddorian43 9y agook see "row store vs columnar store"
- elvinyung 9y agoF1 does not itself have a storage engine, and can use a variety of them. Spanner is actually now columnar [1] in a way that's similar to Parquet: > Ressi stores a database as an LSM tree, whose layers are periodically compacted. Within each layer, Ressi organizes data into blocks in row-major order, but lays out the data within a block in column-major order (essentially, the PAX layout). [1] https://static.googleusercontent.com/media/research.google.com/en//pubs/archive/46103.pdf https://static.googleusercontent.com/media/research.google.c...