Rainy Day

A columnar database is a database that stores data in columns instead of rows and may lead to faster analytical queries. It comes in handy if you have to scan a large number of records in a database, but only want to retrieve a small number of fields from each record. This can also be helpful in compression and storage space. It may be a practical option for reporting, dashboards and data analytics. For an analytics architecture, Datalance can also help to clarify the differences between the performance and behavior of various database designs for various workloads and data sets.