Hybrid Transaction and Analytics Processing (HTAP): State of the Art

Dr. C. Mohan

IBM Fellow, IBM Almaden Research Center (San Jose, USA)

Distinguished Visiting Professor, Tsinghua University (Beijing, China)

Abstract: Traditionally, database processing has been broadly classified into two categories: online transaction processing (OLTP) and online analytical processing (OLAP). OLTP systems preceded the emergence of relational database management systems (RDBMSs). OLAP, which was enabled by the arrival of RDBMSs and SQL, and enhancements to them, has gained even more attention in the last decade or so with the emergence of column stores and Big Data technologies like Map/Reduce, Hadoop and Spark. Data generated by OLTP systems are periodically moved in a batched fashion into OLAP systems for analytical processing.  In the last few years, increasingly organizations want to be able to base their decisions on the latest set of raw data and the real-time analytics derived from them. This has meant that the capabilities of OLTP and OLAP have had to be combined in a single system with essentially a single copy of the data being used for both purposes. The term HTAP is being used to refer to such Hybrid Transaction and Analytics Processing systems. Currently, there is intense focus on HTAP systems in industry and academia. In this talk, I will discuss the problems, technologies and systems that relate to HTAP. 

Dr. C. Mohan has been an IBM researcher for 37 years in the database and related areas, impacting numerous IBM and non-IBM products, the research and academic communities, and standards, especially with his invention of the well-known ARIES family of database locking and recovery algorithms, and the Presumed Abort distributed commit protocol. This IBM (1997), ACM (2002) and IEEE (2002) Fellow has also served as the IBM India Chief Scientist (2006-2009). In addition to receiving the ACM SIGMOD Innovations Award (1996), the VLDB 10 Year Best Paper Award (1999) and numerous IBM awards, Mohan was elected to the US and Indian National Academies of Engineering (2009) and named an IBM Master Inventor (1997). This Distinguished Alumnus of IIT Madras (1977) received his PhD at the University of Texas at Austin (1981). He is an inventor of 50 patents. He is currently focused on Blockchain, Big Data and HTAP technologies (http://bit.ly/CMbcDB, http://bit.ly/CMgMDS). For 2 years, he has been an evangelist for private blockchains and the myth buster of public blockchains. Since 2016, Mohan has been a Distinguished Visiting Professor of China’s prestigious Tsinghua University. He has served on the advisory board of IEEE Spectrum, and on numerous conference and journal boards. Mohan is a frequent speaker in North America, Europe and Asia, and has given talks in 40 countries. He is very active on social media and has a huge network of followers. More information can be found in the Wikipedia page at http://bit.ly/CMwIkP