Integrated Business Planning in the Cloud
Blueshift ONE combines the complexity of business planning, including commercial planning, sales forecasting and budgeting, along with supply chain planning, into an integrated cloud solution.
The integrated view of data gives Blueshift ONE customers a competitive edge with accurate reliable data that is shared across corporate functions during the business planning process. The integrated platform delivers a single consensus forecast across all functions, enabling ongoing strategic decision making.
The Risks of Analytic Performance for Cloud Applications
Every user of the Blueshift ONE platform enjoys the insights and reports commonly used for forecasting and budget planning. The expectation is that the reports will be accurate and responsive in order to support the variety of questions that commonly come up during the business planning process. A necessary consequence of a successful product is the increased strain on the analytic capabilities, driven by more data and users, and the effect this has on delivering a consistent and reliable experience to users.
Single Server Analytic Limitations
As the growth in data and customers continued to rise for the Blueshift ONE platform, the underlying Microsoft SQL Server implementation that powered the analytics began to show performance issues. Select power users and customers would periodically grumble about the query performance for different reports. The Blueshift team worked on a series of optimizations and scale-up configurations to SQL Server, only to recognize the customer growth challenges of a single node database would continue to be problematic.
A major factor of the degrading performance was the inability to shard data by customer, impacting aggregate views on a per customer basis. Each customer aggregation was delivered by inefficient table scans and difficult to configure query caches. This operations challenge led the Blueshift team to seek new solutions to their analytic challenges.
Distributed Data Processing for Faster Analytics
The Blueshift team evaluated a number of database solutions, including Cassandra, to address their analytic scalability issues. The team ultimately selected MemSQL due to the distributed data sharding support, support of ANSI SQL, and fast benchmark results.
The test results were able to prove MemSQL to be 100x faster than their existing SQL Server implementation. During additional stress tests of MemSQL, the data set was expanded by 100x to mimic substantial data growth and yet the analytics performed by MemSQL continued to blow past expectations.
Turning Analytics into a Competitive Advantage
The Blueshift ONE platform, now powered by MemSQL, is capable of delivering analytics on nearly 2 billion records with 60 measures in under 2 seconds. The fast performance gives the application a leg up on the competition as they grow their customer base and expand into new analytic capabilities that were previously not possible.
“MemSQL helps us “10X” our analytic capabilities, providing a much richer functionality going forward.”
Justin Stafford, CEO, Blueshift
Additional Database Resources for Cloud Application Vendors