Download PDF
Driving Sustainable Data Management with ClickHouse: Introducing Stash by Modeo
Technology Category
- Application Infrastructure & Middleware - Database Management & Storage
- Infrastructure as a Service (IaaS) - Cloud Storage Services
Applicable Industries
- Buildings
- Electrical Grids
Applicable Functions
- Warehouse & Inventory Management
Use Cases
- Inventory Management
- Real-Time Location System (RTLS)
Services
- Data Science Services
- System Integration
The Challenge
Modeo, a French data engineering firm, faced the challenge of managing increasing data volumes while accurately measuring the real-time carbon emissions generated by data usage and storage. This was part of their Corporate Social Responsibility initiative focusing on climate change. The company needed a solution that would allow their customers to monitor and optimize their data platform's cost, carbon footprint, and usage. The challenge was to balance the growing data volumes with the need to minimize environmental impact, a complex issue in the field of data engineering.
About The Customer
Modeo is a pioneering French data engineering firm recognized for its robust data engineering infrastructures. Their services are trusted by industry leaders such as L'Oréal, Silvr, and ManoMano. Modeo is committed to sustainable data management and is actively involved in Corporate Social Responsibility initiatives focusing on climate change. They aim to provide solutions that allow their customers to monitor and optimize their data platform's cost, carbon footprint, and usage. Modeo is in the process of rolling out Stash as a beta and anticipates sharing more impact data as more customers start using it.
The Solution
Modeo introduced Stash, a solution designed to synchronize metadata and logs from customers' data platforms into ClickHouse. ClickHouse, known for its low latency, high throughput, and efficient storage capabilities, powers Stash to deliver an unparalleled service. Stash is integrated with ClickHouse Cloud. All logs and metadata are first loaded into object storage (Google cloud storage), then loaded and compressed into ClickHouse for efficient storage. ClickHouse was chosen for its unique structure that allows for fast data access and excellent data compression for efficient storage. It also offers comprehensive SQL support, which enables seamless integration with existing tools and facilitates easy manipulation of data for their developers.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Energy Saving & Power Monitoring System
Recently a university in Taiwan was experiencing dramatic power usage increases due to its growing number of campus buildings and students. Aiming to analyze their power consumption and increase their power efficiency across 52 buildings, the university wanted to build a power management system utilizing web-based hardware and software. With these goals in mind, they contacted Advantech to help them develop their system and provide them with the means to save energy in the years to come.
Case Study
Intelligent Building Automation System and Energy Saving Solution
One of the most difficult problems facing the world is conserving energy in buildings. However, it is not easy to have a cost-effective solution to reduce energy usage in a building. One solution for saving energy is to implement an intelligent building automation system (BAS) which can be controlled according to its schedule. In Indonesia a large university with a five floor building and 22 classrooms wanted to save the amount of energy being used.
Case Study
Powering Smart Home Automation solutions with IoT for Energy conservation
Many industry leaders that offer Smart Energy Management products & solutions face challenges including:How to build a scalable platform that can automatically scale-up to on-board ‘n’ number of Smart home devicesData security, solution availability, and reliability are the other critical factors to deal withHow to create a robust common IoT platform that handles any kind of smart devicesHow to enable data management capabilities that would help in intelligent decision-making
Case Study
Hydro One Leads the Way In Smart Meter Development
In 2010, Ontario’s energy board mandated that time-of-use (TOU) pricing for consumers be available for all consumers on a regulated price plan. To meet this requirement, Hydro One needed to quickly deploy a smart meter and intelligent communications network solution to meet the provincial government’s requirement at a low cost. The network needed to cover Hydro One’s expansive service territory, which has a land mass twice the size of Texas, and its customers live in a mix of urban, rural, and remote areas, some places only accessible by air, rail, boat or snowmobile. Most importantly, the network needed to enable future enterprise-wide business efficiencies, modernization of distribution infrastructure and enhanced customer service. To meet these needs, Hydro One conceptualized an end-to-end solution leveraging open standards and Internet Protocols (IP) at all communication levels. The utility drew upon industry leaders like Trilliant to realize this vision.
Case Study
Selling more with Whirlpool
Whirlpool wanted to add connectivity to appliances and transform the company's relationship with customers. Traditionally, Whirlpool interaction with customers was limited to purchases made once every ten years. Connected washer and dryers provide exciting new features like remote management of start times and inter-machine communication.
