March 11, 2019 By Doug Dailey 3 min read

Though the enterprise data warehouse (EDW) has traditionally been the repository for historical data such as sales and financials, it is quickly evolving to meet the demands of new technologies.

These include artificial intelligence (AI), Internet of Things (IoT), mobile and social, which continue to drive greater data volume, velocity and variety. In addition, there is a growing need to drive near-real-time decision-making to advance predictive analytics, machine learning and data science.

Another way EDWs are meeting these needs is through disaster recovery solutions previously used to protect data from planned and unplanned outages and maintain regulatory compliance. These are being augmented with data replication, which helps meet analytical demands with continuous availability of data.

What has changed in the world of data

For most organizations, online transaction processing (OLTP), characterized by the high volume/concurrency and the low latency of shipping, billing, and customer relationship management (CRM), will not slow down.

What is changing is the need for online analytic processing (OLAP) that provides powerful technology for data discovery, facilitating business intelligence (BI), complex analytic calculations and predictive analytics. One of the main benefits of OLAP is the consistency of information and calculations it uses to drive data from machine learning to improve product quality, customer interactions and process improvements. Most organizations will eventually require support both OLTP and OLAP.

HTAP brings together OLTP + OLAP

For that reason, many are turning to hybrid transaction/analytic processing (HTAP) 1, a term coined by Gartner to describe an emerging application architecture that breaks the wall between OLTP and OLAP. This new architecture enables more informed and near-real-time decisions by incorporating the two in a single database.

Moreover, HTAP architectures go beyond the passive data copies used for OLTP failovers by enabling continuous availability. In this way, HTAP can satisfy not only disaster recovery, but high availability and workload balancing to support active applications as well.

Benefits of data replication and continuous availability for HTAP

IBM sees the value in an HTAP architecture with continuous availability and is using it in the EDW to help clients in industries including finance, healthcare and retail adopt leaner business processes, accelerate analytic insights and curtail disruptions to operations. Businesses could also see benefits from data replication and continuous availability such as the ability to:

  • Reduce concurrency by offloading operational workloads to replica servers. Deliver warehouse augmentation, shift workloads to one or more replicate servers, increase data accessibility, improve operations and lower overall costs.
  • Satisfy operational needs associated with BI, reporting and data science activities. Continuously replacing data on replica servers allows near-real-time data to be used for up-to-date-insights from line-of-business (LOB) users and data scientists using deep learning and predictive analytics.
  • Address industry and organizational regulatory and compliance requirements. Replication also helps create a secure, accurate, and accessible, near real-time archive for systems of record to help comply with GDPR, HIPPA, PCI DSS, FINRA and BCS guidelines.
  • Ensure availability of critical data in the event of a catastrophe. In the unfortunate event of a major data center outage or catastrophe, fast data recovery with minimal data loss is possible. This is achieved by replicating schemas and tables for critical data associated with Tier 1 applications to disaster recovery sites.
  • Reduce outage windows for planned and unplanned events. With continuous availability, data is available even during times when installations, upgrades and planned or unplanned maintenance is taking place.

IAS brings together data replication, continuous availability and HTAP

To make these benefits more accessible, IBM Data Replication for Continuous Availability is embedded in the IBM Integrated Analytics System (IAS) and available for both current and new users. It supports active-RW standby and both row and columnar based tables (such as data loads).

The world-class Q Replication technology also provides new streaming replication with low latency. This software-based replication supports active and stand-by replicas for workload balancing, shifting workloads during planned outages while also dramatically reducing the time to recovery for unplanned outages.

The IBM Integrated Analytic System is designed to help you get started quickly with a 90-day “try it now” license. Discover for yourself how data replication and continuous availability can help you get the most out of your analytics.

Read more about IAS and all of its capabilities or speak with one of our data warehouse experts.

Gartner, “Hybrid Transaction/Analytic Process Will Foster Opportunities for Dramatic Business Innovation”, Massimo Pezzini, Donald Feinberg, Nigel Rayner and Roxane Edjlali, April 28th, 2015

Was this article helpful?
YesNo

More from Business transformation

Integrating AI into Asset Performance Management: It’s all about the data

3 min read - Imagine a future where artificial intelligence (AI) seamlessly collaborates with existing supply chain solutions, redefining how organizations manage their assets. If you’re currently using traditional AI, advanced analytics, and intelligent automation, aren’t you already getting deep insights into asset performance? Undoubtedly. But what if you could optimize even further? That’s the transformative promise of generative AI, which is beginning to revolutionize business operations in game-changing ways. It may be the solution that finally breaks through dysfunctional silos of business units,…

Create a lasting customer retention strategy

6 min read - Customer retention must be a top priority for leaders of any company wanting to remain competitive. An effective customer retention strategy should support the company to maintain a healthy stable of loyal customers and bring in new customers. Generating repeat business is critical: McKinsey’s report on customer acquisition states (link resides outside of ibm.com) that companies need to acquire three new customers to make up the business value of losing one existing customer. Customer retention has become more difficult in…

The path to embedded sustainability

6 min read - Businesses seeking to accelerate sustainability initiatives must take an integrated approach that brings together all business and technology functions. Sustainability is no longer the responsibility of only the chief sustainability officer (CSO). It is not managed by a single department in a silo. Driving true sustainable impact, at scale, takes place when an enterprise is fully aligned to that transformation. To scale progress in combating climate change, this alignment and collaboration must happen across value chain partners, ecosystems, and industries.…

IBM Newsletters

Get our newsletters and topic updates that deliver the latest thought leadership and insights on emerging trends.
Subscribe now More newsletters