Analytic Database

What Does Analytic Database Mean?

An analytic database is a type of database built to store, manage and consume big data. It is designed to be used specifically with business analytics, big data and business intelligence (BI) solutions.

An analytic database stores business, market or project data used in business analysis, projections and forecasting processes.

Techopedia Explains Analytic Database

An analytic database has built-in features that enable data storage and retrieval for use with business analytics applications and services. These features include the ability to dynamically add columns and rows, modify schemas, search data through several attributes and conduct in-memory loading of data in a compressed format. An analytic database also provides faster query response times and is more scalable than standard databases.

Unlike a typical database, which stores data per transaction or process, an analytic database stores business metrics data. Several database applications use analytic database principles, including data warehouse appliance, columnar database, in-memory database, massively parallel processing (MPP) database and online analytical processing (OLAP) database.