• >
  • >
  • >
  • >
  • >
Rockset > 实例探究 > Bringing Real-Time Analytics to Construction Logistics at Command Alkon

Bringing Real-Time Analytics to Construction Logistics at Command Alkon

Rockset Logo
公司规模
Large Corporate
地区
  • America
国家
  • United States
产品
  • CONNEX
  • Rockset
  • Amazon DynamoDB
  • CONNEX Insights
技术栈
  • Serverless Architecture
  • DynamoDB Streams
  • SQL
实施规模
  • Enterprise-wide Deployment
影响指标
  • Productivity Improvements
  • Customer Satisfaction
  • Digital Expertise
技术
  • 分析与建模 - 实时分析
  • 平台即服务 (PaaS) - 数据管理平台
  • 应用基础设施与中间件 - 数据交换与集成
适用行业
  • 建筑与基础设施
适用功能
  • 物流运输
  • 商业运营
用例
  • 实时定位系统 (RTLS)
  • 供应链可见性(SCV)
  • 过程控制与优化
服务
  • 云规划/设计/实施服务
  • 系统集成
关于客户
Command Alkon is a leading provider of cloud-based construction software, specializing in the logistics of construction materials. The company plays a crucial role in the construction industry by handling over 80% of concrete delivery tickets in North America and tracking millions of material and haul tickets daily. Command Alkon's software solutions are integral to the seamless orchestration of supply chain operations in construction projects, ensuring that the flow of building materials is efficiently managed. Their CONNEX platform is a key offering that surfaces data and analytics to users across the supply chain, helping to keep construction projects running smoothly. With a mission to digitize every aspect of construction materials logistics, Command Alkon launched CONNEX in 2019 to provide a SaaS application where suppliers, transportation providers, and contractors on job sites can collaborate on all the data collected by Command Alkon’s systems. The company is committed to providing real-time analytics and visibility into construction logistics, which is critical for the timely and efficient delivery of construction materials.
挑战
Providing real-time visibility into ticket data proved challenging for Command Alkon. Initially, it was not possible to retrieve data quickly enough to enable the real-time analytics that Command Alkon wanted and their users expected. As strong proponents of serverless architecture, the Command Alkon team had chosen Amazon DynamoDB as the transactional database for their application. While it was ideal for storing incoming ticket data, a different solution was required for analytics. Building secondary indexes would speed up specific queries, but given the multitude of ways users could query the ticket data, anticipating access patterns and optimizing for all of them was not a practical solution. Command Alkon had a product objective to support any type of data access at any time. However, the performance challenges associated with unanticipated user queries meant that the application could not deliver real-time views of ticket data. They needed to find a way past these performance issues to meet the demands of their largest customers and scale CONNEX usage.
解决方案
The team at Command Alkon considered using another database to serve real-time search and analytics. After researching several alternatives, they decided to use Rockset to index and analyze the data from DynamoDB. As experienced data practitioners, the team recognized early on that indexing could help accelerate queries and deliver the performance needed by the CONNEX application. Defining all the indexes needed to adequately support every access pattern was not possible, but in Rockset, they found a solution that indexed all its data, thus eliminating the need to configure any indexing. Rockset stores all data in its Converged Index™, which combines an inverted index, a columnar index, and a row index. This approach enables queries on new data to be available almost instantly and to perform incredibly fast. Since all fields, including nested fields, are indexed in multiple ways, Command Alkon could obtain good query performance regardless of how users accessed the data and how the data was structured. The flexibility that Rockset offered was the most significant benefit experienced by Command Alkon when building on Rockset. With Rockset, they were able to decouple access patterns from the schema design, so that queries would perform well without requiring upfront work to reshape data or define indexes. SQL access was another advantage Rockset provided, making it easier for developers to build features on CONNEX data.
运营影响
  • Command Alkon was able to deliver real-time analytics with minimal operational effort, thanks to Rockset's serverless architecture, which fit perfectly into their existing data stack.
  • The introduction of Rockset into their environment was described as 'magical' by Command Alkon, as it allowed them to connect Rockset to DynamoDB and run queries on the data in a matter of hours.
  • The flexibility provided by Rockset enabled Command Alkon to offer real-time search capabilities to their users, allowing them to search on any field, anywhere, and deliver real-time search months ahead of plan.
  • Command Alkon was able to compress development time significantly by incorporating Rockset into the CONNEX architecture, allowing them to build features faster than planned and pull in their product roadmap.
  • With Rockset being used in production to back real-time analytics, CONNEX now consistently delivers query responses in around 100 milliseconds on ticket data that is a few seconds old, greatly enhancing user experience.
数量效益
  • Over 80% of North America's concrete delivery tickets are generated from Command Alkon's systems.
  • Command Alkon tracks millions of material and haul tickets on any given day.
  • The introduction of Rockset allowed Command Alkon to deliver real-time search capabilities months ahead of plan.
  • Command Alkon estimated it would have taken 2 engineers 6 months to develop the equivalent functionality on Elasticsearch, which was avoided by using Rockset.

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

相关案例.

联系我们

欢迎与我们交流!
* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 Asia Growth Partners 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 Asia Growth Partners 的任何营销电子邮件。
提交

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