skip to main content
Close Icon We use cookies to improve your website experience.  To learn about our use of cookies and how you can manage your cookie settings, please see our Cookie Policy.  By continuing to use the website, you consent to our use of cookies.
Global Search Configuration


For real-time data or “fast data,” the perennial issue of resource management is of renewed importance, as inefficient queries conducted on live data can tie up processing resources for all, negating the insight benefits of a real-time environment.


  • As the number of data users in the enterprise increases, the level of control over that data also needs to scale out appropriately to ensure that underlying data resources remain available and useful as an input into analytics.
  • Limiting direct query access is one of the quickest ways to scale out the potential audience of data beneficiaries within the organization: expanding the scope of those that can interact with real-time metrics without disturbing the data itself.
  • Two leading brands were able to leverage MemSQL's database to architect custom environments which provided guided query access for data: maximizing the value of real-time insight within the enterprise and driving business value.

Features and Benefits

  • Compares the approaches taken by two major brands to handle resource management in real-time data environments.
  • Assesses the impact of the rise of the "self-service" analytics model on resource management and query optimization.
  • Identifies key strategies for ensuring that processing resources remain available in a real-time data analytics environment.
  • Identifies some possible ways that the SQL query process and optimization might evolve in the near future.

Key questions answered

  • How does the increase in enterprise analytics consumers impact the age-old challenge of resource management?
  • What are some real-world approaches that organizations are taking to optimize their real-time data analytics environments?
  • Why does real-time data require a renewed attention to the issue of resource management and query optimization?
  • How was the MemSQL database leveraged in real-world deployments to help address the issue of resource management?

Table of contents

Ovum view

  • Summary
  • Data-driven insight doesn't have to mean direct query access
  • Two major brands architect environments for increased insight and increased control
  • What might the future of query optimization hold?


  • Further reading
  • Author

Recommended Articles


Have any questions? Speak to a Specialist

Europe, Middle East & Africa team: +44 7771 980316

Asia-Pacific team: +61 (0)3 960 16700

US team: +1 212-652-5335

Email us at

You can also contact your named/allocated Client Services Executive using their direct dial.
PR enquiries - Email us at

Contact marketing -

Already an Ovum client? Login to the Knowledge Center now