Case study: Online Catalog Modernization

BI Modernization

Challenge

A leading provider and publisher of business insight, analytics and expertise was embarking on a pilot-to-production big data project, moving to the cloud, and investigating search improvement options for its parts catalog offering.

Solution

DataStax, an Azure Big Data ISV Partner, turned to Cloudwick to get the company from proof-of-concept (POC) to production in 120 days. The first project was the catalyst for the company to move more than 300 online enterprise catalogs from on-premises to Azure.

Benefits

Cloudwick worked with DataStax to provide the organization with professional services, migrating to DataStax DSE (Cassandra), providing performance tuning, and ensuring the initial catalog was up and running. Cloudwick also helped improve search accuracy and search performance has gone from 15 seconds to under 100 ms, making it the preferred database for the multi-billion dollar global business. Finally, Cloudwick helped move the catalog to Azure for flexibility, agility and cost savings.

Modernizing to NoSQL to Gain Competitive Advantage

A leading provider of business information, insight and analytics chose Cloudwick to modernize its online catalog using Cassandra to realize larger scale and expanded revenue opportunities. The company selected DataStax DSE for its online catalog and management offering, storing and serving up parts numbers, information and inventory availability.

In order to provide optimal search performance and accuracy for this catalog, the company needed Solr to provide full-text search capabilities, distributed search, rich document search and handling (Word, PDF), index replication, real-time indexing, and fault tolerance. This solution, DataStax DSE Search, would enable customers to quickly and accurately obtain parts information, data sheets and availability to enhance business efficiency and reduce procurement costs.

Searching for Expertise

Like most enterprises, the company lacked internal resources to build this next-generation online catalog and search functionality. Cloudwick is the leading Azure and DataStax Big Data-as-a-Service provider and worked closely with both account teams to take the company from pilot-to-production in just three months.

Cloudwick deployed DataStax DSE (Cassandra), DataStax Search (Solr), and fine-tuned and indexed the company’s database so search results would be prioritized according to preferred parameters (exact match, prefix wildcard, etc.).

The solution provides the company’s customers with a powerful database and catalog service with highly enhanced search results as well as significantly improved performance and accuracy. Customers can quickly and accurately obtain parts information, data sheets and availability to enhance business efficiency and reduce procurement costs.

The initial Cloudwick project was the catalyst for the company to move more than 300 online enterprise catalogs from on-premises to Azure.

Results

Cloudwick accelerated Pilot-to-Production development for the company, increasing the cluster by a factor of two

Cloudwick built the company’s DSE Search index, performed data cleanup, removing unwanted data, and fine-tuned it for optimal performance

The company’s search performance is reduced from 15 seconds to under 100 ms (7500% improvement) and accuracy is highly improved

Cloudwick enabled the company to meet its production go-live business objective, which is a win for the company as well as DataStax and Azure

Click below to download the PDF of the case study.