技术
- 应用基础设施与中间件 - 数据库管理和存储
- 基础设施即服务 (IaaS) - 云存储服务
适用行业
- 水泥
- 建筑与基础设施
适用功能
- 销售与市场营销
- 仓库和库存管理
用例
- 库存管理
- 时间敏感网络
服务
- 数据科学服务
- 系统集成
关于客户
Admixer 是一家独立的广告技术公司,开发全栈程序化解决方案生态系统。该公司为品牌、广告代理商、媒体公司、出版商、广告网络和其他寻求有效广告管理的买方和卖方行业参与者提供构建广告产品基础设施所需的所有组件。 Admixer的产品包括供应方平台、需求方平台、广告交易平台和数据管理平台。该公司成立于 2008 年,至今已在全球拥有 100 多家供需合作伙伴、3,000 多名客户和 200 多名员工。他们在乌克兰、白俄罗斯、哈萨克斯坦、摩尔多瓦、格鲁吉亚设有办事处,并在英国和德国设有法人实体。
挑战
Admixer 是一家广告技术公司,在管理其广告交换平台上不断增加的负载方面面临着重大挑战。最初,该平台基于外部DSP销售本地库存,但随着它开始聚合外部SSP的流量,其处理和存储的负载显着增加。截至2016年底,外部库存占比从3%上升至90%以上,请求量从1亿增加到30亿。现有的关系数据库无法处理大量涌入的统计记录插入。此外,该公司使用Azure表存储来存储和发布统计数据,但随着交易数量和数据量的增加,由于交易数量和数据量的费用,该解决方案变得次优。 Admixer 需要一种解决方案,能够显示实时广告交易统计数据、处理大量插入数据、聚合收到的数据、随着请求的增长扩展数据仓库,并提供对成本的完全控制。
解决方案
Admixer 转向 ClickHouse 来解决他们的挑战。 ClickHouse 不绑定任何平台,这使得 Admixer 可以从云端迁移。构建的集群每秒可以接收多达一百万次插入,并具有跨表聚合和分发数据的内置机制。它还提供了出色的数据压缩和读取速度,使得可以直接在用户界面中实时显示统计数据。 ClickHouse 还具有 SQL 方言,可提供构建任何报告的能力以及用于处理统计数据的多种高级功能。它还内置HyperLogLog,用于存储粗略数据和数据采样。 Admixer 组装了一个包含 15 台服务器的集群,用于接收、处理和存储来自 ADX 的数据,以及一个包含 6 台相同服务器的用于唯一用户的存储集群。 ClickHouse 还允许 Admixer 通过一份报告中的大量键对唯一用户进行计数,这比之前的系统有了重大改进。
运营影响
数量效益
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.