Hybrid transactional/analytical processing

In the 1960s, computer use in the business sector began with payroll transactions and later included tasks in areas such as accounting and billing. At that time, users entered data, and the system processed it at a later time. Further development of instantaneous data processing, or online transaction processing (OLTP), led to widespread OLTP use in government and business-sector information systems.

Bog, Anja. [https://books.google.com/books?id=fV0NAAAAQBAJ&dq=hybrid+transactional%2Fanalytical+processing&pg=PA7 Benchmarking Transaction and Analytical Processing Systems: The Creation of a Mixed Workload Benchmark and Its Application] Springer-Verlage Berlin Heidelberg. 2014

Online analytical processing (OLAP) covers the analytical processing involved in creating, synthesizing, and managing data. With greater data demands among businesses,{{citation needed|date=November 2016}} OLAP also has evolved. To meet the needs of applications, both technologies are dependent on their own systems and distinct architectures.Pezzini, Massimo; Feinberg, Donald; Rayner, Nigel; Edjlali, Roxane. [https://www.gartner.com/doc/2657815/hybrid-transactionanalytical-processing-foster-opportunities "Hybrid Transaction/Analytical Processing Will Foster Opportunities for Dramatic Business Innovation."] Gartner. 28 January 2014 As a result of the complexity in the information architecture and infrastructure of both OLTP and OLAP systems, data analysis is delayed.{{qn|date=November 2016}}

There are various interpretations of HTAP other than Gartner's original definition; an "emerging architecture". These interpretations suggest different advantages, one being a database functionality. Recent advances in research, hardware, OLTP and OLAP capabilities, in-memory and cloud native database technologies,{{Cite web|url=https://azure.microsoft.com/en-us/blog/azure-analytics-clarity-in-an-instant/|title=Azure Analytics: Clarity in an instant|website=azure.microsoft.com|date=19 May 2020 |access-date=2020-06-20}} scalable transactional management and products enable transactional processing and analytics, or HTAP, to operate on the same database.Wolpe, Toby. [https://www.zdnet.com/article/sql-and-nosql-fine-but-how-does-the-hybrid-database-fit-in/ "SQL and NoSQL? Fine, but how does the hybrid database fit in?"] ZDNet. 12 May 2014

However, Gartner's most recent reports suggest broader advantages than a single unified database can offer. Traditional application architectures separated transactional and analytical systems. Digital business, and the need to respond to business moments, means that using "after the fact" analysis is no longer adequate. Business moments are transient opportunities that must be exploited in real time. If an organization is unable to recognize and/or respond quickly to a business moment by taking fast and well-informed decisions, then some other organization will, resulting in a missed opportunity (or a new business threat). HTAP allows advanced analytics to be run in real time on "in flight" transaction data, providing an architecture that empowers users to respond more effectively to business moments.{{Cite web|url=https://www.gartner.com/doc/3352419/enable-digital-business-innovation-hybrid|title=How to Enable Digital Business Innovation via Hybrid Transaction/Analytical Processing|website=www.gartner.com|access-date=2017-04-15}}

The main technical challenges for an HTAP database are how to be efficient both for operational (many small transactions with a high fraction of updates) and analytical workloads (large and complex queries traversing large number of rows) on the same database system and how to prevent the interference of the analytical queries over the operational workload. This kind of operational workload is also commonly referred to as Operational Analytical Processing.

HTAP solves the issue of analytic latency in several ways, including eliminating the need for multiple copies of the same data and the requirement for data to be offloaded from operational databases to data warehouses via ETL processes.

Most applications of HTAP are enabled by in-memory technologies that can process a high volume of transactions and offer features such as forecasting and simulations. New HTAP technologies use scalable transactional processing, and do not need to rely on keeping the whole database in-memory. HTAP has the potential to change the way organizations do business by offering immediate business decision-making capabilities based on live and sophisticated analytics of large volumes of data. Government and business leaders can be informed of real-time issues, outcomes, and trends that necessitate action, such as in the areas of public safety, risk management, and fraud detection.Baer, Tony. [https://web.archive.org/web/20120418234408/http://www.zdnet.com/blog/big-data/fast-data-hits-the-big-data-fast-lane/309 "Fast Data hits the Big Data fast lane."] ZDNet. 16 April 2012

Some challenges for HTAP include limited industry experience and skills, as well as undefined best practices.

In 2020, the first paper in the industry was published by the team of PingCAP describing the practical implementation of a distributed Hybrid Transactional/Analytical Processing (HTAP) database: TiDB: A Raft-based HTAP Database.{{Cite journal |title=TiDB: A Raft-based HTAP Database |url=https://www.vldb.org/pvldb/vol13/p3072-huang.pdf |journal=Proceedings of the VLDB Endowment |volume=13 |issue=12 |pages=3072 |doi=10.14778/3415478.3415535 |s2cid=221666363 |issn=2150-8097}}

{{Reflist}}

{{DEFAULTSORT:Hybrid Transactional Analytical Processing (HTAP)}}

Category:Business intelligence terms

Category:Types of databases