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
About the challenges that hybrid database engines are facing and how this information might help you in deciding the best database for your workload, whether it is operational/transactional or analytical. Needs some background in different DBMSs to get the most of it.