from DSSResources.com


What is an enterprise-class translytical database?

by Daniel J. Power
and Ciara Heavin

Translytical is a portmanteau word, in that parts of the words transaction and analytical are combined to form a new word and concept. A translytical database is an in-memory, multi-model database that places data into system memory for processing. Compared to traditional database management systems (DBMS), in-memory databases have many fewer disk I/O operations which results in improved performance and response times. According to Forrester, translytical databases provide very high performance levels for both transactions and analytics. Translytical databases are a new and emerging database category. An enterprise-class translytical database increases the speed of real-time data analysis with big data sets common in large enterprises and organizations.

Mike Gualtieri, Forrester analyst, apparently coined the term Translytics. Oracle uses a similar term Exalytics. According to Gualtieri, Translytics refers to a “single unified database that supports transactions and analytics in real time without sacrificing transactional integrity, performance, and scale.” Gualtieri combined transactions and analytics to coin the term Translytics. In a similar manner, one can combine transactions and analytical to form the term Translytical. Translytical database management systems (DBMS) like VoltDB were intentionally designed to support an in-memory database.

Oracle Exalytics In-Memory Machine enables consolidation of multiple analytic applications on a single platform. According to an Oracle Whitepaper (2014), "Oracle Exalytics In-Memory Machine is an engineered system pre-integrated to reduce the cost and complexity of an organization’s IT infrastructure, while dramatically increasing productivity and performance." It is not clear that Oracle Exalytics provides the transaction processing ACID guarantees of Atomicity, Consistency, Isolation, and Durability. Oracle Exalytics support seems limited to reporting, dashboards, ad hoc querying, OLAP analysis and performance scorecards. Rather Oracle Exadata Database Machine provides high performance for both data warehousing and online transaction processing (OLTP) applications. So the two products would need to be connected to provide an enterprise-class translytical database.

Daniel Schneiss (2017) argued "SAP HANA has so-called translytical capabilities, meaning that it supports transactional and analytical workloads in real time on a single unified database without giving up integrity, performance, and scale." Schneiss, Senior Vice President SAP Hana, also argues "Digital transformation has become imperative for all businesses, no matter the size or industry." Translytical capabilities enable organizations to collate, analyze and deliver real-time data insights to support the data and information needs of modern decision makers.

Dash (2015) notes "Streaming analytics (real time) require a database that can do in-memory streaming for near-zero latency for complex data and analytical operations. ... The only database claiming to be Translytical is VoltDB with functions such as: in-memory processing, scale-out with shared nothing, ACID compliance for transactional integrity, reliability and fault tolerance. It also has real time analytics built in combined with integration with Hadoop ecosystem."

In 2015, Peter Vescuso, CMO at VoltDB and Mike Gualtieri, Principal Analyst at Forrester, discussed "The State of Streaming Analytics: The Need for Speed and Scale." They noted "Streaming analytics filter, aggregate, enrich, and analyze a high throughput of data from disparate live data sources to identify patterns, detect urgent situations, and automate immediate actions in real-time." Translytical was defined as "A single, unified database that supports transactions and analytics in real-time without sacrificing transactional integrity, performance, and scale." They further noted "In-memory streaming provides near-zero latency for complex data and analytical operations."

Oracle Exalytics, SAP HANA, TIBCO® Graph Database, and VoltDB all have capabilities that would lead to classifying them as translytical database products.

Enterprise-class translytical databases may help large organizations accomplish real-time digital transformation. To be really useful these databases must be both reliable and scalable across multiple uses in a large, geographically distributed organization. Both proprietary and open-source, multi-model, in-memory DBMS products can help achieve digital business goals and objectives. Technologists need to monitor many new information technologies to help drive change and create innovative solutions.

References

Dash, J., "Translytical Database,"Jnan Dash’s Weblog, September 25, 2015 at URL https://swtrends.wordpress.com/2015/09/25/translytical-database/

Oracle White Paper, "Oracle Exalytics In-Memory Machine: A Brief Introduction," 2014 at URL http://www.oracle.com/us/solutions/ent-performance-bi/business-intelligence/exalytics-bi-machine/overview/exalytics-introduction-1372418.pdf

Schneiss, D., "The Past, Present and Future of Database Platform Innovation," Blogs SAP Hanna, March 8, 2017 at URL https://blogs.saphana.com/2017/03/08/the-past-present-and-future-of-database-platform-innovation/ and at URL https://news.sap.com/the-past-present-and-future-of-database-platform-innovation/.

Vescuso, P. and M. Gualtieri, "The State of Streaming Analytics: The Need for Speed and Scale," published September 25, 2015 at URL https://www.slideshare.net/VoltDB/the-state-of-streaming-analytics-the-need-for-speed-and-scale

VoltDB Staff, "VoltDB accelerates access to Translytical database with Enterprise Lab Program," VoltDB Press Release, Sept. 21, 2017 at URL http://dssresources.com/news/4826.php

Last update: 2017-10-02 02:05
Author: Daniel Power

Print this record Print this record
Show this as PDF file Show this as PDF file

Please rate this entry:

Average rating: 0 from 5 (0 Votes )

completely useless 1 2 3 4 5 most valuable

You cannot comment on this entry





DSS Home |  About Us |  Contact Us |  Site Index |  Subscribe | What's New
Please Tell Your Friends about DSSResources.COMCopyright © 1995-2015 by D. J. Power (see his home page).
DSSResources.COMsm is maintained by Daniel J. Power. Please contact him at djpower1950@gmail.com with questions. See disclaimer and privacy statement.


Google
 
Web DSSResources.com

powered by phpMyFAQ 1.5.3