实例探究 > 使用 Cube 改进自定义报告和成本效率：FeedMe 案例研究

使用 Cube 改进自定义报告和成本效率：FeedMe 案例研究

技术

适用行业

适用功能

用例

服务

关于客户

FeedMe 是东南亚食品和饮料行业的销售点 (POS) 系统提供商。他们向客户提供报告服务，包括销售报告、营销分析和库存管理。他们的后端系统是用 JavaScript 编写的，并在客户端 POS 系统中使用 CouchDB。

挑战

FeedMe 希望提供一个强大的报告系统，允许用户生成自己的自定义报告。然而，他们之前基于 SQL 查询和 JavaScript 来处理 MongoDB、CouchDB 和 BigQuery 数据的解决方案变得越来越难以维护和扩展。

解决方案

FeedMe 通过 Google 搜索找到了 Cube，并决定采取分阶段的方式部署 Cube。在第一阶段，他们使用 Cube 的动态架构创建迁移了部分数据架构。在下一阶段，他们迁移了其余的数据模式并实现了更高级的功能，例如预聚合和多维数据集存储。

运营影响

The implementation of Cube has significantly improved FeedMe's reporting system. The company now has a more flexible caching mechanism, which allows them to customize refreshKey and rollup definitions. This has not only reduced their BigQuery cost but also improved the speed of data queries. The data that used to take several minutes to query can now be accessed in less than 10 seconds when cached and pre-aggregated. This has greatly enhanced the user experience for their customers. Furthermore, the FeedMe team has found the Cube community to be very collaborative, especially on Slack, as they were navigating different features such as rollupJoin, pre-aggregations, and Cube Store. They have also been able to provide feedback to the Cube Dev team, contributing to the continuous improvement of the system.

数量效益

FeedMe’s BigQuery cost is down by about ⅔ with the implementation of Cube pre-aggregations and Cube Store.
Without pre-aggregations, it could take several minutes for their customers to query several months of sales data. When the data is cached and pre-aggregated, a similar query would take less than 10 seconds.

Case Study missing?

Start adding your own!

Add New Record