You are here

Data Warehouse

Opsview Data Warehouse (ODW)

The Opsview Data Warehouse, or ODW, is the long term storage for monitoring data. It converts the data from the Runtime database into an OLAP (On Line Analytical Processing) datawarehouse format. When generating reports, the data comes from the Opsview Data Warehouse.

A core requirement for a datawarehouse is to not normalise the data too much, yet still allow queries to be easily created. As you'll see, hopefully we will have reached this target.

Overview

The datawarehouse pulls data in once an hour. It works out if there have been any configuration changes and stores those if required. It then saves various Runtime information before calculating the summary statistics.

Distributed Monitoring

ODW calculates information based on the central Opsview Runtime database. Any Collectors monitoring remote sites will automatically send their information to the Orchestrator which updates the central database, and hence will be captured in ODW as well.

Easily store long term monitoring data

More like this

opsview monitor 5.4
Blog
By Tom Hayes, VP of Marketing

Too many tools and too many inconsistencies? Here are three keys to monitoring IT from a single pane of glass. 

AWS Monitoring
Blog
By Josh Kirkwood, Pre-Sales Engineer

A look at the advantages of monitoring AWS on top of CloudWatch, particularly for data capture, metrics and service checks. 

SQL Server Monitoring
Blog
By Eric Bernsen, Marketing Analyst

Oracle performance tuning advice that goes beyond the obvious. Discover how you can make the most from your system settings.