• >
  • >
  • >
  • >
  • >
Rockset > Case Studies > Bringing Real-Time Analytics to Construction Logistics at Command Alkon

Bringing Real-Time Analytics to Construction Logistics at Command Alkon

Rockset Logo
Customer Company Size
Large Corporate
Region
  • America
Country
  • United States
Product
  • CONNEX
  • Rockset
  • Amazon DynamoDB
  • CONNEX Insights
Tech Stack
  • Serverless Architecture
  • DynamoDB Streams
  • SQL
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Productivity Improvements
  • Customer Satisfaction
  • Digital Expertise
Technology Category
  • Analytics & Modeling - Real Time Analytics
  • Platform as a Service (PaaS) - Data Management Platforms
  • Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries
  • Construction & Infrastructure
Applicable Functions
  • Logistics & Transportation
  • Business Operation
Use Cases
  • Real-Time Location System (RTLS)
  • Supply Chain Visibility
  • Process Control & Optimization
Services
  • Cloud Planning, Design & Implementation Services
  • System Integration
About The Customer
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.
The Challenge
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 Solution
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.
Operational Impact
  • 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.
Quantitative Benefit
  • 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

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that AGP may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from AGP.
Submit

Thank you for your message!
We will contact you soon.