Download PDF
Leveraging Zing Data and ChatGPT for Mobile Querying and Real-Time Alerts in ClickHouse
Technology Category
- Analytics & Modeling - Real Time Analytics
- Sensors - GPS
Applicable Industries
- Equipment & Machinery
- Telecommunications
Applicable Functions
- Maintenance
Use Cases
- Intrusion Detection Systems
- Real-Time Location System (RTLS)
Services
- System Integration
The Challenge
Many companies use ClickHouse for its ability to power fast queries. However, the process of having an analyst write a query, create a dashboard, and share it throughout the organization can add significant delay to getting questions answered. This challenge is compounded by the fact that many business intelligence (BI) tools require someone at a computer to pre-create dashboards or limit users to certain filters. Furthermore, the need for real-time alerts and the ability to query based on a user's current location are increasingly important in today's fast-paced business environment.
About The Customer
The customers of Zing Data's ClickHouse integration are companies that use ClickHouse for fast queries but face challenges in quickly getting questions answered due to the need for an analyst to write a query and create a dashboard. These companies may also find limitations with other BI tools that require pre-created dashboards or limit users to certain filters. They need a solution that allows for natural language querying, visual querying, real-time alerts, and location-based querying. These customers could be data analysts, business users, or developers who need to unlock valuable insights from their data and make better decisions in real-time.
The Solution
Zing Data, a modern data analysis and business intelligence platform, offers a solution to these challenges. It is built to work on any device, including iOS, Android, and the web. With its new ClickHouse support, users can query with natural language (powered by OpenAI’s ChatGPT), visually query in just a few taps, set up real-time alerts, and even query based on their phone’s current location. Zing’s AI-powered query optimization suggests date handling, graph types, and handles long running queries, sending a notification when results are ready. Zing Data's mobile app provides a powerful yet simple interface for querying and visualizing ClickHouse data on the go. It supports a wide range of visualizations and complex data operations. For long running queries, Zing’s server persists a connection to ClickHouse to complete the query in the background, and sends a push notification when the results are ready.
Operational Impact
Related Case Studies.
Case Study
Smart Water Filtration Systems
Before working with Ayla Networks, Ozner was already using cloud connectivity to identify and solve water-filtration system malfunctions as well as to monitor filter cartridges for replacements.But, in June 2015, Ozner executives talked with Ayla about how the company might further improve its water systems with IoT technology. They liked what they heard from Ayla, but the executives needed to be sure that Ayla’s Agile IoT Platform provided the security and reliability Ozner required.
Case Study
IoT enabled Fleet Management with MindSphere
In view of growing competition, Gämmerler had a strong need to remain competitive via process optimization, reliability and gentle handling of printed products, even at highest press speeds. In addition, a digitalization initiative also included developing a key differentiation via data-driven services offers.
Case Study
Predictive Maintenance for Industrial Chillers
For global leaders in the industrial chiller manufacturing, reliability of the entire production process is of the utmost importance. Chillers are refrigeration systems that produce ice water to provide cooling for a process or industrial application. One of those leaders sought a way to respond to asset performance issues, even before they occur. The intelligence to guarantee maximum reliability of cooling devices is embedded (pre-alarming). A pre-alarming phase means that the cooling device still works, but symptoms may appear, telling manufacturers that a failure is likely to occur in the near future. Chillers who are not internet connected at that moment, provide little insight in this pre-alarming phase.
Case Study
Premium Appliance Producer Innovates with Internet of Everything
Sub-Zero faced the largest product launch in the company’s history:It wanted to launch 60 new products as scheduled while simultaneously opening a new “greenfield” production facility, yet still adhering to stringent quality requirements and manage issues from new supply-chain partners. A the same time, it wanted to increase staff productivity time and collaboration while reducing travel and costs.
Case Study
Integration of PLC with IoT for Bosch Rexroth
The application arises from the need to monitor and anticipate the problems of one or more machines managed by a PLC. These problems, often resulting from the accumulation over time of small discrepancies, require, when they occur, ex post technical operations maintenance.
Case Study
Robot Saves Money and Time for US Custom Molding Company
Injection Technology (Itech) is a custom molder for a variety of clients that require precision plastic parts for such products as electric meter covers, dental appliance cases and spools. With 95 employees operating 23 molding machines in a 30,000 square foot plant, Itech wanted to reduce man hours and increase efficiency.
