Cube Dev > 实例探究 > 使用 Cube 提高仪表板性能：Jobber 的成功故事

使用 Cube 提高仪表板性能：Jobber 的成功故事

技术

应用基础设施与中间件 - 数据库管理和存储
基础设施即服务 (IaaS) - 云数据库

适用行业

建筑物
半导体

适用功能

产品研发
质量保证

用例

交通监控
交通模拟

服务

系统集成
测试与认证

关于客户

Jobber 是一家为小型家庭服务企业提供商业管理软件的领先提供商。他们支持 50 多个行业，并为超过 47 个国家的超过 1500 万个家庭提供服务。他们的平台帮助服务专业人员保持井然有序、与客户联系并发展业务。

登录后查看完整内容

挑战

随着业务规模扩大并积累了十年的数据，Jobber 团队的仪表板性能逐渐变慢。他们尝试了缓存、查询优化和数据库调整，但意识到还有更多工作要做。

登录后查看完整内容

解决方案

Jobber 开始使用灵活的分析平台 Cube 来提高仪表板性能。他们利用了 Cube 的两级缓存系统和外部预聚合功能。他们将 Cube 拆分为 API 服务器和计划刷新服务器，并进行相应配置。他们还将 Cube 纳入其 CI 管道并执行性能测试以优化资源使用。

登录后查看完整内容

运营影响

The implementation of Cube in Jobber's system has significantly improved the performance of their dashboards. The two-level caching system of Cube has eliminated the need for Jobber to maintain their own optimization code, simplifying their operations. The external pre-aggregations capability of Cube has also been beneficial, as it allows Jobber to build pre-aggregations inline within their read-only source database. Furthermore, Jobber's active engagement with Cube's open-source community has not only accelerated their own development but also provided valuable insights to the Cube Dev team on actual use cases in production environments. The successful deployment of Cube has led Jobber to explore other areas where Cube can reduce engineering costs while delivering great features for their customers.

登录后查看完整内容

数量效益

Jobber supports over 50 industries and has serviced over 15 million households in more than 47 countries.
More than 100,000 service professionals use Jobber's platform.
Jobber's architecture involves a single PostgreSQL database backend, a read-only replica of the database to populate the rollup pre-aggregations database.

登录后查看完整内容

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

相关案例.

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.

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.

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

Rainwater Harvesting

The Twin Oaks branch of the Austin Public Library wanted to upgrade its existing rainwater harvesting system to improve its wet-weather performance.

KINESYS Semiconductor Factory Automation Software

KINESYS Software provides both Integrated Device Manufacturer (IDM) and Original Equipment Manufacturer (OEM) customers world-class software products and solutions for advanced wafer and device traceability and process management. KINESYS offers state of the art database technology with a core focus on SEMI standards. KINESYS’ challenge was to make back-end processing failure-free and easy to use for clients while supporting licensing models more adaptable to changing industry needs.

Commercial Building Automation Boosts Energy Efficiency

One of the challenges to building automation is the multitude of non-interoperable communications protocols that have evolved over the years. Buildings have several islands of automation. Bridging the islands of different automation without losing the considerable investment in each specialized control network is the main focus in this solution.

© 2015-2024 IoT ONE Limited | 隐私条款

联系我们

欢迎与我们交流!

感谢您的信息！
我们会很快与你取得联系。