下载PDF
Rumble’s Real-Time Leaderboards: A Case Study on IoT and Healthier Lifestyles
技术
- 分析与建模 - 实时分析
- 基础设施即服务 (IaaS) - 云数据库
适用行业
- 水泥
- 电网
适用功能
- 维护
- 采购
用例
- 实时定位系统 (RTLS)
- 资产跟踪
服务
- 云规划/设计/实施服务
挑战
以色列公司 Rumble 开发了一款应用程序，可将用户的步数转换为奖励硬币，可用于购买独特的产品或服务。该公司最初使用 PostgreSQL 来处理包含用户步数的数据，并使用三个不同的表来跟踪每日、每周和每月的步数。然而，随着用户增长开始增加，PostgreSQL 性能开始下降，尤其是在高峰时段。应用程序的响应能力下降，每秒发出大约 20 个以上的请求，因为 PostgreSQL 无法维持为排行榜提供服务所需的延迟，并最终耗尽了 CPU 和内存。 Rumble 的用户以目标为导向，能够即时看到他们的步数并购买优惠券，鼓励他们保持积极的生活方式。因此，Rumble 需要提供实时、数据驱动的应用程序来满足这些需求。他们需要一个能够处理复杂查询、随着用户数量增长而轻松扩展、处理高并发、维持低延迟查询并且需要低操作的数据库。
关于客户
Rumble 是一家以色列公司，正在开发应用程序来鼓励和激励人们保持健康的日常习惯。他们的应用程序将用户的步数转换为奖励硬币，可用于在数百家商店和网站上购物。 Rumble 的用户以目标为导向，能够立即看到他们的步数并从公司购买优惠券，因为他们的健康习惯鼓励他们保持积极的生活方式。 Rumble 与用户的互动度很高，维持平台性能至关重要。他们最初拥有约 400,000 名用户，通过与 Clalit Health Services 和以色列劳工总联合会的合作，其用户群增加了两倍多。
解决方案
Rumble 评估了包括 Imply Cloud 和 Snowflake 在内的其他技术解决方案，但这些解决方案在操作、成本和延迟方面存在缺陷。随后他们发现了 Rockset，它能够满足 Rumble 的实时分析需求。创建帐户后 30 分钟内，Rumble 就能够使用 Write API 将数据写入 Rockset 来实时支持其排行榜。 Rockset 支持 ANSI SQL，对文档中的任何字段进行联接、聚合、排序和分组。为了在几毫秒内返回查询，Rockset 使用其 Converged Index™，它通过倒排索引、行索引和列索引对每个字段进行索引。这允许以最有效的方式执行查询。 Rumble 能够将 Rockset 集成到他们的产品中，随着他们的不断发展和扩张，他们将依靠 Rockset 无缝扩展，同时保持应用程序所需的高性能。
运营影响
数量效益
相关案例.
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
Hydro One Leads the Way In Smart Meter Development
In 2010, Ontario’s energy board mandated that time-of-use (TOU) pricing for consumers be available for all consumers on a regulated price plan. To meet this requirement, Hydro One needed to quickly deploy a smart meter and intelligent communications network solution to meet the provincial government’s requirement at a low cost. The network needed to cover Hydro One’s expansive service territory, which has a land mass twice the size of Texas, and its customers live in a mix of urban, rural, and remote areas, some places only accessible by air, rail, boat or snowmobile. Most importantly, the network needed to enable future enterprise-wide business efficiencies, modernization of distribution infrastructure and enhanced customer service. To meet these needs, Hydro One conceptualized an end-to-end solution leveraging open standards and Internet Protocols (IP) at all communication levels. The utility drew upon industry leaders like Trilliant to realize this vision.
Case Study
Selling more with Whirlpool
Whirlpool wanted to add connectivity to appliances and transform the company's relationship with customers. Traditionally, Whirlpool interaction with customers was limited to purchases made once every ten years. Connected washer and dryers provide exciting new features like remote management of start times and inter-machine communication.
Case Study
SAS® Analytics for IoT: Smart Grid
Companies face falling revenues, rising infrastructure costs, and increasing risk of outages caused by inconsistent energy production from renewable sources. Less money is coming in as more people and organizations take steps to curb their energy use. Utilities are paying more to maintain and build infrastructure due to increasing complexity, resulting from the rising number of intermittent and variable renewable energy sources connected in the distribution grid.
Case Study
Enel Secures Italian Power Generation Network
Electric energy operators around the world are working to increase the reliability and cyber resiliency of their systems. This includes Enel, a global power company that manages and monitors the Italian power grid. This grid:• Serves 31 million customers• Has a net installed energy capacity exceeding 31 gigawatts• Includes more than 500 power generation plants,including hydroelectric, thermoelectric, and wind• Is managed and monitored by Enel 24/7/365• Is operated by Terna, the Italian Transmission System Operator (TSO)Enel is responsible for the availability of the grid’s underlying ICS and industrial network. It also manages Regional Control Centers and Interconnection Centers which connect with the TSO. The TSO manages the flow of energy to the grid plus controls and remotely regulates the power generation of power plants, increasing and decreasing power production as required. The complex system of interaction and cooperation between Enel and the TSO has strong security implications as well as operational and business challenges.
Case Study
IoT based Energy Quality Availability Monitoring Solution
There were several challenges faced:Since this data would be in the public domain, accuracy and authenticity of this data were of paramount importance. It should be able to withstand scrutiny.It is challenging to build an appliance that can withstand a wide range of voltage fluctuations from as low at 90v to as high as 320v. Since the device would be installed in remote locations, its resilience was of paramount importance.The device would have to deal with poor network coverage and have the ability to store and re-transmit data if networks were not available, which is often the case in rural India. The device could store up to 30 days of data.The platform that deals with the data should be readily available and highly reliable and never lose a packet of data.
