ClickHouse Case Studies TrillaBit Leverages ClickHouse for Enhanced Analytics and Reporting

Edit This Case Study Record

	TrillaBit Leverages ClickHouse for Enhanced Analytics and Reporting ClickHouse

TrillaBit Leverages ClickHouse for Enhanced Analytics and Reporting

ClickHouse

Technology Category	Application Infrastructure & Middleware - Data Exchange & Integration Platform as a Service (PaaS) - Application Development Platforms
Applicable Industries	Equipment & Machinery Retail
Applicable Functions	Warehouse & Inventory Management
Use Cases	Inventory Management Picking, Sorting & Positioning
Services	Cloud Planning, Design & Implementation Services System Integration
Challenge	TrillaBit, a dynamic SaaS platform for reporting and business intelligence, initially used Apache Solr as its data backend. However, they soon encountered several challenges. Solr, being a key-value store, was more suited to search than high-volume non-linear aggregation or data compression for performance. Its query language wasn’t as mature as SQL and it didn’t handle joins effectively. When implementing real company data from various sources, TrillaBit found that more flexibility was required in different scenarios. They needed a solution that could be managed at a low cost and could be implemented within their environment for hands-on experience and understanding. However, popular contenders like Snowflake were too expensive and didn’t allow for full on-prem implementation. Read More
About Customer	TrillaBit Quick Intelligence is a dynamic SaaS platform for reporting and business intelligence. It is an end-to-end, enterprise-grade platform that handles multi-tenancy and security, while allowing for dynamic data exploration on big data. It can integrate with ClickHouse wherever it is deployed. TrillaBit is a search-driven analytics platform, capable of handling data from various sources and providing flexibility in different scenarios. It aims to provide a cost-effective solution to the BI Assembly line problem, allowing users to ask questions in a search bar and get immediate visual answers. TrillaBit scales to IoT and network-level traffic volumes of data, easily handling trillions of rows while providing real-time analytics. Read More
Solution	TrillaBit turned to ClickHouse, an open-source column-oriented database management system that allows generating analytical data reports in real time. ClickHouse offered fast performance and low cost, making it an excellent alternative. Setting up ClickHouse on-premise/self-managed (AWS) allowed TrillaBit to gain fast, hands-on experience to understand how it fit into their environment. ClickHouse's integration engines made data ingestion easier, with table engine features that allowed for direct connections to other relational stores like MySQL or Postgres. TrillaBit also utilized ClickHouse's data management engines, primarily the ReplacingMergeTree, to remove duplicates based on a sort key. For client integrations where the movement of data was required, TrillaBit utilized Airbyte. As TrillaBit grew, they moved to ClickHouse Cloud, offloading the cluster management to the cloud to focus on their product. Read More Log in to view content
Contents

Technology Category

Application Infrastructure & Middleware - Data Exchange & Integration

Platform as a Service (PaaS) - Application Development Platforms

Applicable Industries

Equipment & Machinery

Retail

Applicable Functions

Warehouse & Inventory Management

Use Cases

Inventory Management

Picking, Sorting & Positioning

Services

Cloud Planning, Design & Implementation Services

System Integration

Challenge

TrillaBit, a dynamic SaaS platform for reporting and business intelligence, initially used Apache Solr as its data backend. However, they soon encountered several challenges. Solr, being a key-value store, was more suited to search than high-volume non-linear aggregation or data compression for performance. Its query language wasn’t as mature as SQL and it didn’t handle joins effectively. When implementing real company data from various sources, TrillaBit found that more flexibility was required in different scenarios. They needed a solution that could be managed at a low cost and could be implemented within their environment for hands-on experience and understanding. However, popular contenders like Snowflake were too expensive and didn’t allow for full on-prem implementation.

About Customer

TrillaBit Quick Intelligence is a dynamic SaaS platform for reporting and business intelligence. It is an end-to-end, enterprise-grade platform that handles multi-tenancy and security, while allowing for dynamic data exploration on big data. It can integrate with ClickHouse wherever it is deployed. TrillaBit is a search-driven analytics platform, capable of handling data from various sources and providing flexibility in different scenarios. It aims to provide a cost-effective solution to the BI Assembly line problem, allowing users to ask questions in a search bar and get immediate visual answers. TrillaBit scales to IoT and network-level traffic volumes of data, easily handling trillions of rows while providing real-time analytics.

Solution

TrillaBit turned to ClickHouse, an open-source column-oriented database management system that allows generating analytical data reports in real time. ClickHouse offered fast performance and low cost, making it an excellent alternative. Setting up ClickHouse on-premise/self-managed (AWS) allowed TrillaBit to gain fast, hands-on experience to understand how it fit into their environment. ClickHouse's integration engines made data ingestion easier, with table engine features that allowed for direct connections to other relational stores like MySQL or Postgres. TrillaBit also utilized ClickHouse's data management engines, primarily the ReplacingMergeTree, to remove duplicates based on a sort key. For client integrations where the movement of data was required, TrillaBit utilized Airbyte. As TrillaBit grew, they moved to ClickHouse Cloud, offloading the cluster management to the cloud to focus on their product.

Impact #1	The implementation of ClickHouse resulted in several operational benefits for TrillaBit. The integration engines of ClickHouse simplified the process of data ingestion, connecting directly to other relational stores like MySQL or Postgres. This speeded up the integration process. The data management engines, particularly the ReplacingMergeTree, helped in removing duplicates based on a sort key, thus maintaining the accuracy of data without duplication and with minimal code. The move to ClickHouse Cloud allowed TrillaBit to offload cluster management, enabling them to focus more on their product. The cloud also provided an excellent security profile, giving clients further peace of mind. Overall, the use of ClickHouse has enabled TrillaBit to get everything up and running quickly, starting with open-source.

Impact #1

The implementation of ClickHouse resulted in several operational benefits for TrillaBit. The integration engines of ClickHouse simplified the process of data ingestion, connecting directly to other relational stores like MySQL or Postgres. This speeded up the integration process. The data management engines, particularly the ReplacingMergeTree, helped in removing duplicates based on a sort key, thus maintaining the accuracy of data without duplication and with minimal code. The move to ClickHouse Cloud allowed TrillaBit to offload cluster management, enabling them to focus more on their product. The cloud also provided an excellent security profile, giving clients further peace of mind. Overall, the use of ClickHouse has enabled TrillaBit to get everything up and running quickly, starting with open-source.

Benefit #1	TrillaBit can handle trillions of rows of data, providing real-time analytics.
Benefit #2	ClickHouse's fast performance and low cost provided a cost-effective solution for TrillaBit.
Benefit #3	ClickHouse's data management engines reduced duplication and minimized custom coding and processing.

Benefit #1

TrillaBit can handle trillions of rows of data, providing real-time analytics.

Benefit #2

ClickHouse's fast performance and low cost provided a cost-effective solution for TrillaBit.

Benefit #3

ClickHouse's data management engines reduced duplication and minimized custom coding and processing.

Download PDF Version

Overview

TrillaBit Leverages ClickHouse for Enhanced Analytics and Reporting

Operational Impact

Quantitative Benefit