Real-Time Reporting

Enable High-Volume Data Movement for Real-Time Reporting

Our solution enables your company to access accurate and up-to-date data without the headaches that can come with moving large volumes of data.

24 x 7 access to real-time data means better decision making for your company, giving it a competitive edge. But delivering that access is easier said than done.

Real-Time Data Challenges Include:

  • Latency inherent in high-volume data movement
  • Data movement between disparate sources and targets in complex environments

Lufthansa uses HVR to populate hundreds of distributed databases with continuously changing data pertaining to routes, flight paths, air traffic, flight restrictions, weather conditions and more in real-time.

 

We have been using HVR now more than ten years for our flight planning system business.
– Senior Database Software Architect, Lufthansa Systems Airlines Operations Solutions

Run Your Queries Fast on Up-to-Date Data

Our solution enables you to stay competitive by continuously analyzing changing data generated by transactional systems, machines, sensors, mobile devices, and websites.

Benefits of our Real-Time Reporting Solution Include:

  • Reduce OLTP overload
  • Move large volumes of data
  • Accelerate queries
  • Easily integrate with many different types of databases and applications

Large volumes of data are captured by our log-based change data capture capability in real-time out of commonly used OLTP source databases to a variety of analytical relational target databases. Our data compression functionality enables you to quickly run queries on up-to-date data in your data warehouse.

These features and more make data availability continuous and efficient for your business.

Example of how HVR can help you integrate data for real-time reporting

Real-Timer reporting

Lufthansa Uses HVR for Real-Time Reporting

About:

Lufthansa Systems, a division of Lufthansa Airlines, is one of the world’s leading providers of IT services in the airline industry. It serves roughly 300 national and international airlines comprising more than one-third of all airlines worldwide.  Among its many offerings, Lufthansa Systems offers Lido/FPLE (flight planning services), which determine the most effective flight routes in terms of cost, fuel and time.  By optimizing flight routes, Lido/FPLS generates millions of dollars in extra profits for its customers each year.

Challenges:

The data necessary for up-to-the-minute flight planning must be replicated to the central data repository at Lufthansa Systems. Optimized plans must be replicated back to the customer airlines.

Solution:

  • HVR replicates bi-directionally between the central source to hundreds of different target databases at customer sites all over the world – even over restricted network links.
  • Some customers use HVR for HA and reporting.

Read More about how Lufthansa solved this challenge using HVR and enabled real-time reporting for flight planning.

Different Use Cases, Different Platforms

Organizations Using HVR for Real-Time Reporting

IndustryCustomerReal-Time NeedDatabases Involved
ServicesEpsilonDeliver the right message at the right time to the right prospect. Real-time data consolidation into a data warehouseOracle production databases, Microsoft SQL Server-based data warehouse
Travel/AviationLufthansaReal-time flight Planning. Bi-Directional Data Movement. Real-time updates to a central repositoryIngres and Oracle
GovernmentUnited States Coast GuardReplicate data in real-time from the production system it uses to maintain its fleet of aircraft to a second database for use in reportingIngres and Oracle
Financial Services Investment Services FirmDeliver up-to-the minute stock info to customersOracle to Oracle Data Warehouse

 

Common Question We Receive:

Why Log-Based Change Data Capture for Real-Time Reporting?

Log-based CDC is generally considered the superior approach to change data capture that can be applied to all possible scenarios including systems with extremely high transaction volumes. Transactional databases store all changes in a transaction log in order to recover the committed state of the database should the database crash for whatever reason. Log-based CDC takes advantage of this aspect of the transactional database to read the changes from the log.

The biggest benefit of log-based change data capture is the asynchronous nature of CDC: changes are captured independently of the source application performing the changes.

HVR supports log-based CDC for all supported relational database sources. Trigger-based capture is still supported on most source databases for legacy reasons, or in scenarios when the source database does not provide the required functionality to perform log-based CDC (e.g. SQL Server Express Edition does not support supplemental logging of additional columns).

Log-Based CDC, a key feature of HVR, enables data to move efficiently between sources and targets for real-time reporting.

© 2017 HVR Software

Free Trial Contact Us