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
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.

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.

Case Study
Condition Based Monitoring for Industrial Systems
A large construction aggregate plant operates 10 high horsepower Secondary Crusher Drive Motors and associated conveyor belts, producing 600 tons of product per hour. All heavy equipment requires maintenance, but the aggregate producer’s costs were greatly magnified any time that the necessary maintenance was unplanned and unscheduled. The product must be supplied to the customers on a tight time schedule to fulfill contracts, avoid penalties, and prevent the loss of future business. Furthermore, a sudden failure in one of the drive motors would cause rock to pile up in unwanted locations, extending the downtime and increasing the costs.Clearly, preventative maintenance was preferable to unexpected failures. So, twice each year, the company brought in an outside vendor to attach sensors to the motors, do vibration studies, measure bearing temperatures and attempt to assess the health of the motors. But that wasn’t enough. Unexpected breakdowns continued to occur. The aggregate producer decided to upgrade to a Condition Based Monitoring (CBM) sensor system that could continually monitor the motors in real time, apply data analytics to detect changes in motor behavior before they developed into major problems, and alert maintenance staff via email or text, anywhere they happened to be.A wired sensor network would have been cost prohibitive. An aggregate plant has numerous heavy vehicles moving around, so any cabling would have to be protected. But the plant covers 400 acres, and the cable would have to be trenched to numerous locations. Cable wasn’t going to work. The aggregate producer needed a wireless solution.