Part 8 — HPE Shadowbase Real-Time Business Intelligence Solutions

The previous web pages explained the evolution of RTBI, and the various technologies that have been used over the years to achieve it. Of these technologies, data replication is by far the most flexible, least disruptive, and easiest to implement. The HPE Shadowbase product suite provides the transactional replication needed for effective real-time business intelligence systems. These products also provide the infrastructure necessary to implement continuous availability architectures, including the HPE Shadowbase real-time data replication engine and the HPE Shadowbase Online Loading (SOLV) copy utility.

Figure 1 shows the evolution of the operational data store (ODS), from its early stages (top of the diagram) to present day data consolidation (bottom of the diagram). In its early stages, an ODS consisted of separate tactical and strategic systems, populated via periodic batch updates. These systems evolved into real-time systems, with ODS data being updated as it was changed on source systems. Separate tactical and strategic systems existed with multiple ODS databases; no single consolidated view of the enterprise existed. At the bottom of the figure, data from all of these multiple ODS sources is consolidated in real-time, into a single true ODS, which drives all of the tactical and strategic decision making across the enterprise.

Diagram of evolution of the operational data store

Figure 1 — Consolidation and Evolution of Business Intelligence

HPE Shadowbase Real-Time Replication

The Shadowbase data replication engine provides high-speed data replication among a variety of databases and platforms. With a history in the decades and hundreds of large, high-volume, mission-critical, enterprise-class installations worldwide, the Shadowbase engine is a proven performer and is an ideal solution for interconnecting enterprise systems with an RTBI system.

HPE Shadowbase Software:

Extreme Availability with HPE Shadowbase Active/Active Support

Many HPE Shadowbase installations around the world are active/active, geographically distributed systems. These systems achieve availabilities in excess of six 9s (less than thirty seconds per year of downtime). Shadowbase replication provides two functions in an RTBI environment: it synchronizes the operational systems with the RTBI system and ensures multiple RTBI systems surge on, via an active/active or Sizzling-Hot-Takeover configuration.

Running an RTBI system as an active/active system simply requires that the Shadowbase engine replicates database changes between the two geographically separated RTBI systems. If one system fails, the other system is immediately ready to take over the RTBI services. With an active/active RTBI system, it is fair to say that the effective uptime of RTBI services is measured in centuries.

HPE Shadowbase SOLV – Online Copying

The critical online copying function needed to bring an RTBI system into service is provided by the unique copying utility, HPE Shadowbase Online Loading (SOLV), which:

Another powerful feature of SOLV is inherent in its architecture. Since SOLV is not a utility separate from the HPE Shadowbase replication engine, it uses the Shadowbase replicator to move data from the source database to the target database. As a consequence, SOLV uses the same data transformation rules during the copy function that the Shadowbase engine uses during later data replication. This function avoids the problem of trying to conform the copy transformation rules with the replicator transformation rules so that both perform exactly the same. Rules are implemented only once because the same code is then used by both the load engine and the replication engine.

HPE Shadowbase Streams

Shadowbase Streams, another member of the Shadowbase product line, streams data generated by one application to other applications and facilities as well as target database environments. Shadowbase Streams for Data Integration and Application Integration provides the facilities for integrating existing applications at the data or event-driven level in order to create new and powerful functionality for the enterprise.

HPE Shadowbase Streams:

Related Business Intelligence Information:
Related Case Studies:
Related Use Cases:
Related White Paper: