Tech moves fast! Stay ahead of the curve with Techopedia!
Join nearly 200,000 subscribers who receive actionable tech insights from Techopedia.
In-database analytics refers to a model of analysis where data processing is performed within a database to eliminate the overhead of moving large data sets to analytic applications. In such a model, the analytic logic is built into a database instead of in a separate application. Advantages of in-database analytics include parallel processing, scalability, analytic optimization and partitioning.
An in-database analytics system contains an enterprise data warehouse integrated with an analytic database platform. In-database analytics is used in applications that require intensive processing, primarily because datasets and data marts are effectively consolidated in an enterprise's data warehouse system, which facilitates and secures data analysis, processing and retrieval.
Advantages are as follows: