永産システム開発がいかにClickHouse Cloudを活用し、POS分析を高速、低コストかつ信頼性の高いものにしたか

Eisan System Development has built a real-time ID-POS analytics platform for multiple retail clients to support large-scale basket analysis, cross-analysis, and personalized recommendations by transitioning from a QlikView-based BI stack to ClickHouse Cloud. This shift has improved reliability and performance while reducing licensing and infrastructure costs. The system currently processes hundreds of millions of records per client, with a clear path toward handling tens of billions in the future, driven by continuous optimization. Eisan System Development has a nearly 40-year history of developing specialized software across various precision-demanding industries, such as healthcare and IoT platforms. The transition to ClickHouse was prompted by increasing data volumes and the limitations of the existing QlikView system, which was costly, unreliable, and began to falter under the load. The adoption of ClickHouse has provided predictable performance even under high load and allowed for a more efficient use of resources, with ongoing testing and adjustments to optimize server specifications. The company plans to scale the system to handle 100 billion records and is exploring strategies such as shifting processing to off-peak hours and considering auto-scaling to improve resource utilization. ClickHouse serves as a foundation for future expansion, with operational challenges now focusing on smoothly running a large-scale real-time analytics system as data volumes and client expectations grow.