Data Warehouse

What is an Operational Data Warehouse and Why is it the Next Big Thing?

Actian Corporation

October 23, 2018

Data warehouses have been around for decades, and have established themselves as reliable reporting systems with consistent value. They have also evolved into data marts, specialized appliances, and EDW variants to meet emerging needs, but all of these solutions have their drawbacks when it comes to meeting today’s business demands. Some of the common pitfalls to avoid include stale data, slow query performance, long development cycles, and high costs associated with these variants. There is a better approach. An operational data warehouse (ODW) addresses the need for operational data analytics with the characteristics listed below, without any of the pitfalls:

1. Current:
As the demands for organizations to operate in real-time or in the moment increase, data warehouses need to deliver ever more current data. SQL Hadoop databases commonly fail to handle continuous streams of updates as the file system is optimized for infrequent batch updates, with a moving window of historical data. Lack of current data can mean businesses fail to respond to threats and opportunities fast enough to stay competitive.

2. Fast:
Built on an underlying architecture optimized for analytic query performance, requiring little or no tuning in anticipation of certain workloads (like indexing or aggregations), maximizing the variety of workloads it can support.

3. Scalable:
Scales to large data capacities with an economical and flexible storage layer, connecting to a variety of existing legacy and new sources of data.

4. Secure:
Offers multiple data protection mechanisms to meet enterprise security requirements and comply with tough regulatory environments.

5. Flexible:
Offers flexible deployment options, on-premises and multi-cloud options.

6. Robust:
Delivers enterprise-level resiliency and manageability.

Such an ODW solution provides a database system that can deliver near-real-time insights for ad hoc self-service data discovery and analytics using the most current operational data storage. If you’re looking for more information about this topic, get our free Operational Data Warehouse Guide for Dummies eBook while supplies last.

About Actian Corporation

Actian is helping businesses build a bridge to a data-defined future. We’re doing this by delivering scalable cloud technologies while protecting customers’ investments in existing platforms. Our patented technology has enabled us to maintain a 10-20X performance edge against competitors large and small in the mission-critical data management market. The most data-intensive enterprises in financial services, retail, telecommunications, media, healthcare and manufacturing trust Actian to solve their toughest data challenges.