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.


Related Terms

Margaret Rouse

Margaret Rouse is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical, business audience. Over the past twenty years her explanations have appeared on TechTarget websites and she's been cited as an authority in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine and Discovery Magazine.Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages. If you have a suggestion for a new definition or how to improve a technical explanation, please email Margaret or contact her…