Transactional (or operational) and analytical workloads have generally been processed by separate systems—a best practice to prevent analytical workloads from interfering with operational processing. The drawback of this design is that data must be replicated to the analytical system, resulting in data duplication and outdated data in the analytical system.
Recently, database vendors have started to break down the separation of transactional and analytical workloads by creating data platforms capable of running transactional and analytical workloads in one system against a single copy of the data. Such systems, named translytical data platforms by Forrester, combine the advantages of transactional and analytical systems (e.g., the consistency guarantees of a transactional system and the advanced analytical features of an analytical system) while eliminating the disadvantages(e.g., data duplication and performing analytics on outdated data).
Using an example application that processes geospatial data to extract valuable information along with the publicly available San Francisco Police Reports dataset, Jonathan Bregler details how a transactional on-premises application that uses the Hibernate framework to handle interactions with the database can be migrated to the cloud. The application will be deployed to the Google App Engine and connected to a SAP HANA Express Edition database instance running on the Google Compute Engine. Once the application is running in the cloud, Jonathan explains how analytical features can be added by leveraging the advanced analytical capabilities of the SAP HANA database, thereby transforming the application into a translytical application while still using familiar and proven frameworks like Hibernate for interacting with the database.
Jonathan Bregler is a software engineer at SAP, where he works on the SAP HANA database. Jonathan’s interests range from database security to performance optimizations and architecture topics, and he is a contributor to the Hibernate ORM framework, focusing mainly on SAP HANA support. When he’s not busy hacking, he plays the French horn in the SAP symphony orchestra.
©2018, O'Reilly Media, Inc. • (800) 889-8969 or (707) 827-7019 • Monday-Friday 7:30am-5pm PT • All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners. • firstname.lastname@example.org