O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

In Search of Database Nirvana

Book Description

The database pendulum is in full swing. Ten years ago, web-scale companies began moving away from proprietary relational databases to handle big data use cases with NoSQL and Hadoop. Now, for a variety of reasons, the pendulum is swinging back toward SQL-based solutions. What many companies really want is a system that can handle all of their operational, OLTP, BI, and analytic workloads. Could such an all-in-one database exist?

This O’Reilly report examines this quest for database nirvana, or what Gartner recently dubbed Hybrid Transaction/Analytical Processing (HTAP). Author Rohit Jain takes an in-depth look at the possibilities and the challenges for companies that long for a single query engine to rule them all.

With this report, you’ll explore:

  • The challenges of having one query engine support operational, BI, and analytical workloads
  • Efforts to produce a query engine that supports multiple storage engines
  • Attempts to support multiple data models with the same query engine
  • Why an HTAP database engine needs to provide enterprise-caliber capabilities, including high availability, security, and manageability
  • How to assess various options for meeting workload requirements with one database engine, or a combination of query and storage engines