The Top 10 Benefits of an Operational Data Warehouse for 2021

The previous blogs in this series discussed the top 5 pitfalls of traditional operational data warehouses and defined the Operational Data Warehouse (ODW) as a potential solution.  Below is a list of my Top 10 desirable benefits of an effective ODW:

Current. Continuous data updates via “micro-batches” or streamed singleton updates throughout the day provide the most current information for analytics-based decision-making.

Fast. Changes to ODW data need to be made with the lowest performance penalty. Columnar data blocks that maintain their min-max value metadata eliminate the overhead of creating indexes that need to be updated with every change, as traditional row-based databases do. The ability to make better business decisions faster can translate into multiple data warehouse benefits.

Scalable. An effective enterprise data warehouse must be scalable in two dimensions. Vertical scalability enables workloads to take advantage of more CPU and storage capacity on a single system. When you have saturated the hardware capacity of a single system, the ability to scale horizontally to a cluster of systems provides the ability to grow the ODW to handle larger databases and more users. The ability to increase capacity as demand grows is a key advantage of a modern data warehouse.

Secure. The explosive growth of cybercrime and increased regulation of data privacy means that even “internal” systems must be secured. A good ODW must offer built-in support for advanced encryption, auditing, role-based security and data masking.

Flexible. The days when an organization could standardize on a single computing platform are over. The ODW needs to offer the flexibility to be deployed on-premises (on Linux, Windows, or Hadoop Clusters) or in the cloud (on AWS, Microsoft Azure and beyond).

Consistent. Some databases sacrifice query integrity for speed. A good ODW needs to provide row-level locking and full read consistency for running queries even as the underlying data changes.

Robust. A key advantage of a modern data warehouse is the ability to deliver enterprise-level resiliency and manageability. This translates to having an ODW with solid back-up, recovery, failover and replication capabilities.

Wirtschaftlich. Mehrere Faktoren können die Gesamtbetriebskosten (TCO) für eine bestimmte Datenbanktechnologie beeinflussen, die zur Unterstützung eines bestimmten Geschäftsfalls eingesetzt wird. Einer davon ist die Möglichkeit, Standard-Server zu betreiben, um esoterische Anwendungen zu vermeiden. Andere Faktoren sind flexible Deployment-Modelle, die sich an unterschiedliche Geschäftsanforderungen anpassen lassen, die Möglichkeit, die Leistung je nach Bedarf zu erhöhen oder zu verringern, und die Option, Komponenten unterschiedlicher Größe (Rechenleistung, Speicher) zu verwenden, um die Betriebseffizienz zu optimieren.

Interoperable. A good ODW needs to provide open application programming interfaces (APIs) such as those that support Open Database Connectivity (ODBC) and American National Standards Institute Structured Query Language (ANSI SQL). These are necessary to enable the data warehouse to work with the multitude of query tools an organization might use. Many organizations use more than 20 different visualization and query tools.

Connected. The ability to ingest data at high speed is a critical ODW requirement. If you cannot load your data in a reasonable time, the result is having to work with summary data or worse, using stale data.

I would be very interested to hear which benefits you value the most or others I could have included? Email me at Pradeep.bhanot@actian.com if you would like to share your views.

About Actian Corporation

Actian empowers enterprises to confidently manage and govern data at scale, streamlining complex data environments and accelerating the delivery of AI-ready data. The Actian data intelligence approach combines data discovery, metadata management, and federated governance to enable smarter data usage and enhance compliance. With intuitive self-service capabilities, business and technical users can find, understand, and trust data assets across cloud, hybrid, and on-premises environments. Actian delivers flexible data management solutions to 42 million users at Fortune 100 companies and other enterprises worldwide, while maintaining a 95% customer satisfaction score.