News for hackers. Stuff that matters.
Re:Show HN: Egeria, a multidimensional spreadsheet for every... by go_prodev on Tuesday December 11, 2018 @04:32PM (#18659112)
That's interesting. How do you represent a star schema in key value structure? Does every measure have a key in every dimension?

And if users drill up/down does sqlite do the aggregation or is that done by your application?

I haven't used kv stores before

Re:Show HN: Egeria, a multidimensional spreadsheet for every... by egeria_planning on Tuesday December 11, 2018 @04:51PM (#18659273)
Cells are grouped into chunks (similar to Minecraft) and stored in binary form. There is a complex algorithm which decides how the data is partitioned. All the operations are done in memory and the KV store is only used as data storage.