Online analytical processing databases

This type of databases handles complex aggregations. They are often used for analytics, handle complex long-running ad hoc queries.