Hi,
I am developing a columnar database. I want to made my database do expand and compress based on which columns ares most accessed. Example, if i have a table with 5 columns like, name, state, coutry, age, profession and I see that most of the queries are based on state and name, I would like to store this columns In a uncompressed way and the others columns in a compressed way.
My intention is to do that while the database is working, like a polymorphic database.
Does anyone know a database that do this?
In your opinion, does it make sense?
Thanks!