技术
- 应用基础设施与中间件 - 区块链
- 平台即服务 (PaaS) - 应用开发平台
适用行业
- 水泥
- 建筑与基础设施
适用功能
- 维护
- 产品研发
用例
- 施工管理
- 基础设施检查
服务
- 系统集成
- 培训
关于客户
Coinpaprika 是领先的加密货币市场数据平台,提供对数百个交易所的众多加密货币的价格数据、历史趋势、市值、交易量和其他相关指标的全面见解。该平台使用开放 API 直接连接近 370 个交易所,并积极致力于整合去中心化交易所。 Coinpaprika 旨在为开发者、投资者和企业提供加密货币领域用户友好、透明且可靠的信息来源。他们的系统设计由分布在公共和私有基础设施中的许多服务组成,大多数 CPU 和磁盘密集型部分托管在本地,面向消费者的接口分布在全球公共云基础设施中。
挑战
Coinpaprika 是领先的加密货币市场数据平台,其现有数据管理系统面临着挑战。他们使用 InfluxDB 存储时间序列数据,使用 MySQL 存储事务数据。然而,随着数据量的增长,他们遇到了 InfluxDB 的几个问题。该团队发现很难从系统中提取有用的指标,并且延长查询时间通常会导致服务器过载。由于合并数据块,他们还遇到了响应时间问题。 InfluxDB 的开源版本缺乏内置的复制和可扩展性,而这对于 Coinpaprika 的基础设施至关重要。 Coinpaprika 需要一个能够处理不断增长的数据量、提供有用指标并提供改进的性能和可扩展性的解决方案。
解决方案
在评估了其他几个选项后,Coinpaprika 决定改用 ClickHouse 作为他们的时间序列数据库。该决定基于多个因素,包括 ClickHouse 的单一二进制架构、积极的新闻报道、培训材料的可用性、支持性社区、令人印象深刻的绩效指标、销售团队参与度和成熟的技术堆栈。过渡到 ClickHouse 显着提高了性能、查询并发性和可扩展性。 Coinpaprika 能够在短短三个月内使用 ClickHouse 开发出其产品的初始版本。他们尝试了不同的编解码器和优化的数据结构,在成功完成初始设置后,他们将所有数据迁移到 ClickHouse。 Coinpaprika 还将 ClickHouse 与其现有的 Go 和 Gorm 基础设施集成,这使他们能够更有效地构建和维护其解决方案。
运营影响
数量效益
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
相关案例.

Case Study
System 800xA at Indian Cement Plants
Chettinad Cement recognized that further efficiencies could be achieved in its cement manufacturing process. It looked to investing in comprehensive operational and control technologies to manage and derive productivity and energy efficiency gains from the assets on Line 2, their second plant in India.

Case Study
IoT System for Tunnel Construction
The Zenitaka Corporation ('Zenitaka') has two major business areas: its architectural business focuses on structures such as government buildings, office buildings, and commercial facilities, while its civil engineering business is targeted at structures such as tunnels, bridges and dams. Within these areas, there presented two issues that have always persisted in regard to the construction of mountain tunnels. These issues are 'improving safety" and "reducing energy consumption". Mountain tunnels construction requires a massive amount of electricity. This is because there are many kinds of electrical equipment being used day and night, including construction machinery, construction lighting, and ventilating fan. Despite this, the amount of power consumption is generally not tightly managed. In many cases, the exact amount of power consumption is only ascertained when the bill from the power company becomes available. Sometimes, corporations install demand-monitoring equipment to help curb the maximum power demanded. However, even in these cases, the devices only allow the total volume of power consumption to be ascertained, or they may issue warnings to prevent the contracted volume of power from being exceeded. In order to tackle the issue of reducing power consumption, it was first necessary to obtain an accurate breakdown of how much power was being used in each particular area. In other words, we needed to be able to visualize the amount of power being consumed. Safety, was also not being managed very rigorously. Even now, tunnel construction sites often use a 'name label' system for managing entry into the work site. Specifically, red labels with white reverse sides that bear the workers' names on both sides are displayed at the tunnel work site entrance. The workers themselves then flip the name label to the appropriate side when entering or exiting from the work site to indicate whether or not they are working inside the tunnel at any given time. If a worker forgets to flip his or her name label when entering or exiting from the tunnel, management cannot be performed effectively. In order to tackle the challenges mentioned above, Zenitaka decided to build a system that could improve the safety of tunnel construction as well as reduce the amount of power consumed. In other words, this new system would facilitate a clear picture of which workers were working in each location at the mountain tunnel construction site, as well as which processes were being carried out at those respective locations at any given time. The system would maintain the safety of all workers while also carefully controlling the electrical equipment to reduce unnecessary power consumption. Having decided on the concept, our next concern was whether there existed any kind of robust hardware that would not break down at the construction work site, that could move freely in response to changes in the working environment, and that could accurately detect workers and vehicles using radio frequency identification (RFID). Given that this system would involve many components that were new to Zenitaka, we decided to enlist the cooperation of E.I.Sol Co., Ltd. ('E.I.Sol') as our joint development partner, as they had provided us with a highly practical proposal.

Case Study
Splunk Partnership Ties Together Big Data & IoT Services
Splunk was faced with the need to meet emerging customer demands for interfacing IoT projects to its suite of services. The company required an IoT partner that would be able to easily and quickly integrate with its Splunk Enterprise platform, rather than allocating development resources and time to building out an IoT interface and application platform.

Case Study
Bridge monitoring in Hamburg Port
Kattwyk Bridge is used for both rail and road transport, and it has played an important role in the Port of Hamburg since 1973. However, the increasing pressure from traffic requires a monitoring solution. The goal of the project is to assess in real-time the bridge's status and dynamic responses to traffic and lift processes.

Case Study
Bellas Landscaping
Leading landscaping firm serving central Illinois streamlines operations with Samsara’s real-time fleet tracking solution: • 30+ vehicle fleet includes International Terrastar dump trucks and flatbeds, medium- and light-duty pickups from Ford and Chevrolet. Winter fleet includes of snow plows and salters.