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
Table of contents
-
In Search of Database Nirvana
- The Swinging Database Pendulum
- HTAP Workloads: Operational versus Analytical
- Query versus Storage Engine
- Challenge: A Single Query Engine for All Workloads
- Challenge: Supporting Multiple Storage Engines
- Challenge: Same Data Model for All Workloads
- Challenge: Enterprise-Caliber Capabilities
- Assessing HTAP Options
- Conclusion
Product information
- Title: In Search of Database Nirvana
- Author(s):
- Release date: August 2016
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781491959039
You might also like
article
Reinventing the Organization for GenAI and LLMs
Previous technology breakthroughs did not upend organizational structure, but generative AI and LLMs will. We now …
article
Splitting Strings on Any of Multiple Delimiters
Build your knowledge of Python with this Shortcuts collection. Focusing on common problems involving text manipulation, …
article
Use Github Copilot for Prompt Engineering
Using GitHub Copilot can feel like magic. The tool automatically fills out entire blocks of code--but …
article
Run Llama-2 Models
Llama is Meta’s answer to the growing demand for LLMs. Unlike its well-known technological relative, ChatGPT, …