Hybrid transactional/analytical processing: Difference between revisions

Revision as of 05:31, 4 October 2021

Revision as of 05:32, 4 October 2021

Line 2:

'''Hybrid transaction/analytical processing (HTAP),''' a term created by [[Gartner]] Inc. – an information technology research and advisory company, in its early 2014 research report ''Hybrid Transaction/Analytical Processing Will Foster Opportunities for Dramatic Business Innovation''.<ref name="Gartner 2014">{{cite web |title=Hybrid Transaction/Analytical Processing Will Foster Opportunities for Dramatic Business Innovation |website=Gartner |date=2014-01-28 |url=https://www.gartner.com/en/documents/2657815/hybrid-transaction-analytical-processing-will-foster-opp |access-date=2021-10-04}}</ref> As defined by Gartner: <blockquote>Hybrid transaction/analytical processing (HTAP) is an emerging application architecture that "breaks the wall" between transaction processing and analytics. It enables more informed and "in business real time" decision making.<ref>{{Cite web|url=https://www.gartner.com/doc/3599217/market-guide-htapenabling-inmemory-computing|title=Market Guide for HTAP-Enabling In-Memory Computing Technologies|website=www.gartner.com|access-date=2017-04-15}}</ref><<ref name="Gartner 2014" /></blockquote>

In more recent reports Gartner has begun referring to HTAP as "augmented transactions."<ref>{{Cite web|url=https://www.gartner.com/docen/documents/3955768/hype-cycle-for-data-management-2019|title=Hype Cycle for Data Management, 2019|website=Gartner}}</ref> Another analyst firm [[Forrester Research]] calls the same concept "Translytical"<ref>{{Cite web|url=https://www.forrester.com/report/The+-Forrester+-Wave+-Translytical+-Data+-Platforms+-Q4+-2019/-/E-RES144975|title=Forrester|website=Forrester}}</ref> while [[451 Group]] calls it "Hybrid operational and analytical processing" or HOAP.<ref>https://mariadb.com/wp-content/uploads/2020/09/enterprises-turn-to-hoap-for-oltp-workloads_analyst-report_1088.pdf</ref>

==Background==

Line 24:

Some challenges for HTAP include limited industry experience and skills, as well as undefined best practices.<ref name=Pezzini />

HTAP functionality is offered by database companies, such as [[MariaDB]] Enterprise,<ref>{{Cite web|url=https://mariadb.org/columnstore-native/|title=ColumnStore Native Part of MariaDB 10.5|first=Kaj|last=Arnö|date=26 June 2020}}</ref> MariaDB SkySQL,<ref>{{Cite web|url=https://www.businesswire.com/news/home/20210107005475/en/MariaDB-Releases-New-R2DBC-Connector|title=MariaDB Releases New R2DBC Connector|date=7 January 2021|website=www.businesswire.com}}</ref> [[Microsoft Azure SQL Database]], [[Microsoft Azure]] Synapse Link<ref>{{Cite web|url=https://www.zdnet.com/article/a-closer-look-at-azure-synapse-link/|title=A closer look at Azure Synapse Link|website=www.zdnet.com|access-date=2017-04-15}}</ref> for [[Cosmos DB]], DbAlibaba DRDS, LeanXcale,<ref>{{Cite web|url=https://www.bloorresearch.com/research/hybrid-real-time-data-processing/|title=Hybrid real-time data processing|last=Research.|first=Bloor|website=bloorresearch.com|language=en-us|access-date=2019-10-30}}</ref> [[TiDB]],<ref>{{Cite news|url=https://www.datanami.com/2018/02/22/hybrid-database-capturing-perishable-insights-yiguo/|title=The Hybrid Database Capturing Perishable Insights at Yiguo|date=2018-02-22|work=Datanami|access-date=2018-03-02|language=en-US}}</ref><ref>{{Cite news|url=https://www.infoworld.com/article/3313327/database/how-tidb-combines-oltp-and-olap-in-a-distributed-database.html|title=How TiDB combines OLTP and OLAP in a distributed database|last=Xu|first=Kevin|work=InfoWorld|access-date=2018-11-14|language=en}}</ref> Hubble, [[ArangoDB]], [[Aerospike (database)|Aerospike]], [[GridGain Systems|Apache Ignite/GridGain In-Memory Data Fabric]], [[IBM]] [[IBM_Db2]] IDAA,<ref>{{Cite [web|url=https://www-01.ibm.com/events/wwe/grp/grp004.nsf/vLookupPDFs/02%20-%20Dan%20Wardman%20%20-%20Real%20Time%20Analytics%20with%20IDAA%20and%20Big%20Data%20on%20System%20z/$file/02%20-%20Dan%20Wardman%20%20-%20Real%20Time%20Analytics%20with%20IDAA%20and%20Big%20Data%20on%20System%20z.pdf |title="Real Time Analytics with IDAA and Big Data on System z"]}}</ref> [[InterSystems]],<ref>{{Cite web|url=https://www.gartner.com/reviews/market/operational-dbms|title=Operational Database Management Systems (ODBMS) Software Reviews|last=Inc.|first=Gartner|website=Gartner|language=en-us|access-date=2018-02-14}}</ref><ref>{{Cite journal|last=Gartner|date=12 Feb 2018|title=Critical Capabilities for Operational Database Management Systems|url=https://www.gartner.com/doc/3855663?ref=SiteSearch&sthkw=Critical%20Capabilities%20for%20Operational%20Database%20Management%20Systems&fnl=search&srcId=1-3478922254|journal=Gartner}}</ref> [[Kdb+]], [[Microsoft SQL Server]], [[Neo4j]], [[TigerGraph]], [[Oracle 12c In-Memory]],<ref name="oracle.com 2018">{{cite web |title=Leading-edge Database technology now available in all environments |website=oracle.com |url=https://www.oracle.com/corporate/pressrelease/oracle-database-avail-everywhere-030617.html |archive-url=https://web.archive.org/web/20180828115603/https://www.oracle.com/corporate/pressrelease/oracle-database-avail-everywhere-030617.html |archive-date=2018-08-28 |url-status=dead}}</ref> [[SAP HANA]],<ref>{{Cite web|url = http://www.cioreview.com/cxoinsight/internet-of-everything-and-hybrid-transactional-analytical-processing--nid-12929-cid-49.html|title = Internet of Everything and Hybrid Transactional Analytical Processing|last = Review|first = CIO|website = CIOReview|access-date = 2016-03-26}}</ref><ref>{{Cite web|url = https://www.gartner.com/doc/reprints?id=1-2OW5H99&ct=151005&st=sb|title = Gartner Reprint|website = www.gartner.com|access-date = 2016-03-26}}</ref> [[MemSQL]], [[MongoDB]], [[VoltDB]], [[NuoDB]], [[OrientDB]], [[DataStax]], [[eXtremeDB]], [[Splice Machine]],<ref>{{cite web |title=The Splice Machine Data Platform |url=https://splicemachine.com/product/data-platform/ |website=Splice Machine}}</ref> [[EsgynDB]], [[Spanner (database)|Cloud Spanner]], HarperDB, [[Amazon Aurora]] (Parallel Query), BlobCity, [[Couchbase]],<ref>{{Cite web|url=https://www.datanami.com/2018/09/20/couchbase-to-deliver-parallel-json-analytics-without-the-etl/|title=Couchbase to Deliver Parallel JSON Analytics -- Without the ETL|date=20 September 2018|website=Datanami}}</ref> YugabyteDB<ref>{{Cite web|url=https://docs.yugabyte.com/latest/faq/general/|title=FAQs about YugabyteDB &#124; YugabyteDB Docs|first=Team|last=Yugabyte|website=docs.yugabyte.com}}</ref> and PostgreSQL.

==References==