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