streaming data Archives - Indium https://www.indiumsoftware.com/blog/tag/streaming-data/ Make Technology Work Fri, 09 Feb 2024 12:54:06 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.3 https://www.indiumsoftware.com/wp-content/uploads/2023/10/cropped-logo_fixed-32x32.png streaming data Archives - Indium https://www.indiumsoftware.com/blog/tag/streaming-data/ 32 32 Accelerating Data-Driven Decisions: Empowering Enterprises with Real-Time Insights using Striim https://www.indiumsoftware.com/blog/how-to-accelerate-decision-making-with-striim/ Wed, 28 Jun 2023 12:37:38 +0000 https://www.indiumsoftware.com/?p=14669 McKinsey’s report, ‘The Data-Driven Enterprise of 2025’, points out how though organizations apply data-driven approaches such as predictive analytics and AI-driven automation, it is still sporadic, ineffective, and time-consuming. By 2025, all employees will leverage data more uniformly using innovative data techniques that would help solve problems faster. This will help to effect continuous improvement

The post Accelerating Data-Driven Decisions: Empowering Enterprises with Real-Time Insights using Striim appeared first on Indium.

]]>
McKinsey’s report, ‘The Data-Driven Enterprise of 2025’, points out how though organizations apply data-driven approaches such as predictive analytics and AI-driven automation, it is still sporadic, ineffective, and time-consuming. By 2025, all employees will leverage data more uniformly using innovative data techniques that would help solve problems faster.

This will help to effect continuous improvement in performance and create differentiated experiences for customers and employees. It will also enable accelerated development of innovative new solutions.

McKinsey also identifies the current challenges to optimizing data sources as

  • Limited capabilities of legacy technologies
  • Challenges in modernizing the architecture.
  • Demand for high computational resources for real-time processing jobs

This results in only a small part of the data from connected devices being leveraged. As companies balance speed and computational intensity, they are unable to perform complex analyses or implement real-time use cases.

Getting the right data technologies to ingest, process, analyze, and visualize in real-time is going to be a game-changer in improving decision-making, enhancing customer experience, and accelerating growth.

Improved Decision Making

Real-time data is critical for conducting real-time analytics, which helps with faster decision-making. Data is collected from a variety of sources, including sensors, databases, operational systems, cameras, and social media feeds with minimal delay and processed and analyzed quickly. They could be alerts and notifications or inputs from user behavior.

Real-time data can be of two types:

  • Event Data: The generation of a collection of data points based on well-defined conditions within a system.
  • Stream Data: The continuous generation of a large volume of data without any identifiable beginning or end.

Easy access to data in real-time data enables a quick drawing of insights to make informed decisions and be responsive as events unfold. It helps with capturing trends, both past, and present, and can be analyzed in real-time to decide on the next course of action.

Some of the benefits of real-time data include

Being Proactive

In the absence of real-time data, there is a lag between insights and responses. This reactive approach can prove costly, resulting in losing customers or production-related issues escalating. Real-time data analytics allows enterprises to proactively approach developments and respond appropriately.

Enhance Customer Experience

Visibility and transparency have become key in several client-business relationships. It helps improve decision-making based on project status and enhances customer experience and retention. Responding to customer requirements and empowering them with information in real-time further strengthens the relationship between the two.

To know more about how Indium can help you, please check out more.

Unify Data

Different teams end up creating data silos to suit their requirements. This can distort the view when making strategic decisions at the enterprise level and delay the process. A cloud-based data streaming solution helps to provide a unified view in real-time while allowing different teams access to secure and permission-based data they need to make decisions for their department.

Improve Operational Excellence

Real-time data allows you to manage your organization’s assets proactively. It lets you plan downtimes for maintenance and repair, improves the life of the assets, and take timely steps to replace, where needed, with minimum disruption to operations. This naturally leads to a better quality of products and services and improved profit margins as it lowers overheads.

Striim Power For Real-time Data Analytics

The Striim unified real-time data integration and streaming platform unifies data across multiple sources and targets. It offers built-in adapters and supports more than 125 sources and targets, enabling the management of multiple data pipelines in a Striim cluster. Striim 4.1 offers features such as OJet to let customer applications read multi-terabytes of data per day and a high-performance Oracle Change Data Capture (CDC) reader. It also sends real-time alerts and notifications to identify emerging workload patterns and facilitates collaboration between developers and database administrators.

Striim users can build smart real-time data pipelines quickly for streaming large volumes of events daily. It is scalable and secure, and the features are highly available. It is easy to maintain and allows the rapid adoption of new cloud models, infrastructure modernization, and digitalizing legacy systems.

Striim enables data integration using a streaming-first approach, supporting incremental, real-time views in the cloud database and the streaming layer. It includes Streaming SQL to facilitate real-time analytics of data, as also train machine learning models in real-time.

Business analysts, data scientists, and data engineers can use Streaming SQL to build data pipelines quickly and without the need for custom coding. Striim also allows data movement in real-time, because of which stream processing applications need to operate continuously for years. These further speeds up decision-making as insights can be drawn quickly, without latency between receiving the data and running analytics on it.

Check out our case study on real-time data analytics

Case and Point: Simplifying Healthcare Predictions in 3 Expert Steps

Understanding Symptom Patterns: Our first step involves data acquisition and thorough analysis of historical patient data. We tap into the treasure trove of symptoms, medical records, and outcomes to discern intricate patterns that might remain hidden from traditional analysis.

Feature Engineering with Domain Knowledge: With a team of domain experts, we transform raw symptom data into meaningful features. These features are carefully curated to capture the nuances of various symptoms, their interplay, and potential implications. Our domain knowledge empowers us to create a robust feature set that forms the foundation of accurate predictions.

Advanced Machine Learning Models: Equipped with a rich feature set, we employ advanced machine learning models. From ensemble methods to deep learning architectures, we evaluate and fine-tune models that can effectively map symptoms to probable outcomes. This step requires rigorous experimentation to ensure optimal model performance. 

The utilization of Symptom Pattern Analysis, Feature Engineering, and Advanced Machine Learning Models in the healthcare domain, along with Indium’s implementation of Striim for real-time data migration and processing, brings substantial and quantifiable business value to the table.

Healthcare Providers: Reduced diagnosis time through rapid predictions – from days to hours, thereby accelerating patient care. Enhanced efficiency with streamlined operations leads to quicker decisions and resource allocation. Improved patient care is achieved through early intervention based on predictions, resulting in improved treatment outcomes. Informed resource allocation provides predictive insights that optimize staff schedules, room usage, and equipment availability. Optimized treatment plans driven by personalized treatments yield better outcomes and patient satisfaction. The Cost savings achieved through fewer hospital stays, reduced redundant tests, and efficient resource use contribute to lowering costs. This not only benefits the patients but also benefits the providers by optimizing their resources.

Healthcare Payers and Insurance Companies: The implementation offers a competitive edge for healthcare providers, attracting patients and enhancing the providers’ reputation due to quick and accurate diagnoses. This, in turn, leads to efficient resource utilization, potentially reducing the overall cost of treatments. Cost savings arising from reduced hospital stays and redundant tests contribute to lower healthcare expenditures, benefiting healthcare payers and insurance companies. Healthcare payers such as insurance companies can also reduce fraudulent claims as they will have access to patient diagnosis history in real-time.

Medical Researchers and Innovators: The curated data fosters research opportunities, facilitating medical insights and potential innovation generation. The advanced analytical capabilities of Symptom Pattern Analysis and Machine Learning Models open avenues for new discoveries and improvements in medical practices, benefiting the broader healthcare research community.

Overall, the integration of advanced technologies, real-time data processing, and predictive analytics in the healthcare domain offers benefits that extend to healthcare providers, payers, patients, and the research community. This synergy drives efficiency, quality of care, and cost-effectiveness, ultimately transforming healthcare delivery and outcomes.

Indium for Instant Decisions with Striim

Indium Software, a cutting-edge solution provider, has deep expertise in Striim implementation and can help businesses create exciting digital experiences for their customers.

A private sector bank offering specialized services to 9 million customers across various business verticals and with a presence global presence required data to be updated in real-time from its core banking systems to a reliable destination database for downstream analytics. By migrating the data from legacy systems to Striim in real time, Indium helped the customer improve its responsiveness and operational efficiency apart from other benefits.

Indium’s team of Striim experts have cross-domain experience and can provide custom-built solutions to meet the unique needs of our customers.

To know more about Indium’s Striim capabilities and solutions

Visit Here

FAQs

Is Striim an ETL tool?

The Striim platform offers customers the flexibility to use real-time ETL and ELT on data from multiple sources, including on-prem and cloud databases.

How does Striim use the database?

Striim ingests data from major enterprise databases using log-based change data capture (CDC). This lowers the performance load on the database while making data available even before it has been processed.

The post Accelerating Data-Driven Decisions: Empowering Enterprises with Real-Time Insights using Striim appeared first on Indium.

]]>
Spot Realtime SLA Breaches in Airline On-Boarding Process Using Striim https://www.indiumsoftware.com/blog/realtime-sla-breaches-airline-on-boarding-process-using-striim/ Wed, 15 Feb 2023 10:22:05 +0000 https://www.indiumsoftware.com/?p=14654 Post-COVID Travel plans have suddenly increased, and many people are visiting the places they had hoped to visit. The airway enables us to travel farther than we could otherwise go, and technology works in tandem with it to make travel easier. Due to increased travel and commuters, it is difficult to manage and track the

The post Spot Realtime SLA Breaches in Airline On-Boarding Process Using Striim appeared first on Indium.

]]>
Post-COVID Travel plans have suddenly increased, and many people are visiting the places they had hoped to visit. The airway enables us to travel farther than we could otherwise go, and technology works in tandem with it to make travel easier. Due to increased travel and commuters, it is difficult to manage and track the passengers to ensure that the on-boarding procedures are followed during flight boarding. The onboarding process is ensured from the initial stage of airport check-in to the passenger boarding a corresponding flight by combining the efforts of hardware sensors and online message queueing systems. We’ll see how Striim and the message queueing system work together to capture, process, and change the status of passengers as they go through a stage-by-stage preprocessing process within a SLA set for each one.

To learn more about Indium’s Striim solutions and capabilities

Go to

Problem Statement 

As we all know, going through each stage to board a flight at an airport can be stressful. As shown in the image, there are typically five steps in the processing process: obtaining a boarding pass, bagging, security inspection, immigration inspection, and finally boarding. To prevent boarding or flight delays, all five of these processes should be finished within a SLA established for each phase. Internally, airport authorities use the message queueing system to populate each stage of the event, but the challenge would be to spot SLA breaches in real-time and report them to address the delay.

Process of Boarding at the Airport

The procedure would be monitored using MQ systems, where each step emits an event with the flight and passenger information. Finding the stage that exceeds the SLA required to pass a certain stage of checking is the challenge here. If any of the processes were to miss the SLA cut-off, the following effects would result.

  1. Delaying the current flight and any subsequent flights
  2. Panic among the passengers
  3. Longer wait times.
  4. A process could be missing.
  5. There would be a security breach as a result.

The illustration below shows how MQ events are produced as passengers go through the airline’s onboarding procedure.

How does Striim contribute to process improvement?

Striim is a real-time replication tool that enables data streaming from a variety of source systems and aids in event migration to the target systems. Windowing technique is one of its key features, and it can hold data based on options like time, count, and fields to process on-the-fly. The best course of action in this situation is to hold/cache the event until the SAL/cut-off for the boarding process is determined. We can review the events that have occurred after the deadline to force the airport authorities to act right away from the cache. Assumedly, the events that are generated at each stage include the passenger’s boarding and flight information so that the specific passenger can be tracked throughout the boarding process.

Also Read: Use Cases for a Unified Data Integration and Streaming Platform like Striim

Striim Windowing Techniques

Real-time data is constrained within a window by time (for instance, five minutes), event count (for instance, 10,000 events), or both. The creation of a window is necessary for a replication flow to aggregate or process data, fill the dashboard, or send alerts when conditions deviate from expected ranges. An application can only evaluate and respond to individual events without a window to bind the data.

The three types of windows that Striim supports are sliding, jumping, and session windows. When a query’s contents change (sliding), expire (jumping), or there has been a lull in use activity, Windows sends data to the queries that follow (session). Jumping windows, which are regularly updated with an entirely new set of events, are the best fit for our use case out of these three types. Data sets for the hours of 8:00 am–8:04:59 am, 8:05 am–8:09 am, and so on would be produced, for instance, by a five-minute jumping window. A new data set would be produced by a 10,000-event jumping window after each 10,000 events. The window would output a new data set each time it accumulated 10,000 events or five minutes had passed since the previous data set was output if both five minutes and 10,000 events were specified. With the help of this Windows feature, we are putting forth an architecture that will both capture events coming from MQ systems and those that are approaching the cut-off time.

Proposed Architecture for the Airline On-Boarding System

With this suggested architecture, the airline onboarding processing can detect an SLA breach during passenger check-in for a flight with speed and accuracy. By storing the data in a designated window, it operates using the caching technique. The Striim partitioning feature enables us to classify every passenger according to their boarding pass number, allowing us to identify anyone having trouble during the flight. Striim’ s SQL-like queries are used to group and aggregate the events from jumping windows for each stage, from checking in to boarding flights.

CREATE OR REPLACE JUMPING WINDOW Boarding_Data_Window OVER admin.Boarding_Data_Win KEEP 2 ROWS WITHIN 90 SECOND PARTITION BY BoardingPassNo;

CREATE OR REPLACE CQ Passenger_Data_Boarding INSERT INTO admin.NotBoarded SELECT p.flightNo as flightNo, p.boardingPassNo as boardingPassNo , case when b.boardingPassNo is null then “Not Boarded” else “Boarded” END as BoardingStatus, b.boardingPassNo as bagBoardingPassNo FROM Boarding_Data_Window b right join PassengerDataWindow p on p.boardingPassNo = b.boardingPassNo;

CREATE OR REPLACE CQ NotBoarded INSERT INTO admin.NotBoardedResult SELECT * FROM NotBoarded n where BoardingStatus=”Not Boarded” group by n.boardingPassNo having count(*) <2 ;

Here are some benefits of using Striim as a replication tool in this scenario to record and modify SLA beaches during the flight boarding:

1. Real-time data collection that aids in processing the event at every stage.

2. Windowing the events until the designated interval to process and modify.

3. The dashboard and alerting system provides a nearly real-time progress of each passenger’s stages.

4. Quick fixes considerably shorter airport wait times and delays.

5. More accurate reporting.

An elaborate use case for Striim services: Striim-Powered Real-Time Data Integration of Core Banking System with Azure Synapse Analytics

Conclusion

The lengthy part of flying is waiting in line for the boarding process due to the densely populated airport. A more effective tracking system offers a practical way to track individual passengers for a comfortable journey. Using Striim’s windows technique, we can process and change airport authorities at any stage of the boarding process by holding every individual passenger detail in-memory directly from the real-time queuing system. Additionally, Striim aids in the migration of events to alternative target systems for better visual representations.

The Striim experts at Indium have cross-domain experience and can create solutions specifically for each of our clients’ individual needs.

The post Spot Realtime SLA Breaches in Airline On-Boarding Process Using Striim appeared first on Indium.

]]>