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.
Senior Database Software Architect, Lufthansa
Reduce OLTP overload
Move large volumes of data
Accelerate queries
Easily integrate with many different types of databases and applications
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 Analytics Solution Include:
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.
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.
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.
Read More about how Lufthansa solved this challenge using HVR and enabled real-time reporting for flight planning.
| Industry | Customer | Real-Time Need | Databases Involved |
|---|---|---|---|
| Services | Epsilon | Deliver the right message at the right time to the right prospect. Real-time data consolidation into a data warehouse | Oracle production databases, Microsoft SQL Server-based data warehouse |
| Travel/Aviation | Lufthansa | Real-time flight Planning. Bi-Directional Data Movement. Real-time updates to a central repository | Ingres and Oracle |
| Government | United States Coast Guard | Replicate data in real-time from the production system it uses to maintain its fleet of aircraft to a second database for use in reporting | Ingres and Oracle |
| Financial Services | Investment Services Firm | Deliver up-to-the minute stock info to customers | Oracle to Oracle Data Warehouse |
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).
In this post, I talk about the benefits of using log-based CDC for a real-time data warehouse…But first, let’s start with a short history of Data Warehouses Data warehouses have been around for decades. Teradata, the grandfather of the data...
Alternative Architectural Approaches to Implementing Real-Time Analytics In other posts, I’ve mentioned several different architectural approaches that can be employed to access and analyze near real-time operational data. Because this is a frequent topic of conversation that we have with customers...