超级专栏：NANO Corp. 使用 ClickHouse 从实验到生产的旅程
技术
- 应用基础设施与中间件 - 数据库管理和存储
- 基础设施即服务 (IaaS) - 云数据库
适用行业
- 教育
- 电网
适用功能
- 维护
- 采购
用例
- 网络安全
- 时间敏感网络
服务
- 网络安全服务
- 硬件设计与工程服务
关于客户
NANO Corp. 是一家法国初创公司，由前国防人员于 2019 年创立。该公司是围绕创始人开发并获得专利的内部技术而建立的。他们的目标是彻底改变软件网络探测器的本质，使其变得多功能且轻量级，同时能够处理高达 100GBit/s 的带宽，而无需使用数据包切片或采样等任何技巧。他们的探测器完全在商用硬件上工作。 NANO Corp. 的产品可以用一个词来概括：可观察性。然而，这不是传统的“网络监控”类型。他们认为网络性能和网络安全是同一枚硬币的两个方面，只解决一个而忽略另一个是没有意义的。他们的主要目标是以线速高速分析复杂且不断变化的网络流量。
挑战
NANO Corp. 是一家成立于 2019 年的法国初创公司，其使命是彻底改变网络探测器。他们的目标是创建多功能、轻型探针，能够在商用硬件上处理高达 100GBit/s 的带宽。他们的愿景是提供一种新的可观察性，将网络性能和网络安全结合起来。然而，为了充分利用网络探测器的潜力，他们需要一个强大的数据库。数据库必须处理快速且持续的插入，运行定期查询以进行警报和由多个用户启动的自定义查询，并有效管理大量数据。它还需要有一个热/冷数据缓冲系统，易于维护和部署，并且高效地使用 RAM。他们的主要工程师在之前的职业生涯中使用过的传统 RDBMS 无法胜任这项任务。当整体性能成为问题时，他们过于依赖更新速度并需要集群。 NANO Corp. 需要一个像他们的探测器一样具有开创性的数据库。
解决方案
在尝试了几种传统 OLTP 数据库并感到失望后，NANO Corp. 发现了 ClickHouse。 ClickHouse 被誉为市场上最快的数据仓库，能够处理 NANO Corp. 需要管理的大量数据。它提供了快速的多次插入、快速的索引、强大的物化视图和出色的 MergeTree 功能。 ClickHouse 的批量插入理念特别适合 NANO Corp. 的技术，因为他们自己制作中间批次以获取所有数据。 ClickHouse 中的数据摄取更简单，对资源的负担也更少，并且允许非常快速的查找查询。 ClickHouse 还原生支持 JSON 格式文件，这是一个显着的优势。尽管考虑了 Druid 或 Pinot 等其他 OLAP 数据库，NANO Corp. 还是选择了 ClickHouse，因为它的效率高且易于维护。
运营影响
数量效益
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
相关案例.
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.
Case Study
Hydro Utility Builds Foundation for Powerful Efficiencies and Protection
As the main British Columbia electric distributor, BC Hydro provides 1.9 million residential, commercial, and industrial customers with energy. The hydro utility transformed to a digital business with Cisco connected networking, security, and smart grid solutions. • Deliver reliable, high-quality services • Enable remote automation and monitoring • Connect applications over a common networking infrastructure
