Put open source to work
July 16–17, 2018: Training & Tutorials
July 18–19, 2018: Conference
Portland, OR

Transforming legacy applications built on Hibernate into cloud-based translytical applications

Jonathan Bregler (SAP SE)
9:00am12:30pm Tuesday, July 17, 2018
Level: Intermediate
Average rating: *....
(1.00, 1 rating)

Who is this presentation for?

  • Developers and architects

Prerequisite knowledge

  • A basic understanding of Java, relational databases, SQL, and object-relational mapping frameworks

Materials or downloads needed in advance

  • A laptop with Java, Maven, and the code editor of your choice installed
  • A Google Compute Engine account
  • A GitHub account

What you'll learn

  • Understand the benefits of translytical data processing
  • Learn how to migrate an application to the cloud and enhance it with advanced analytical features like geospatial data processing while staying within familiar programming paradigms like object-relational mappers


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.

Photo of Jonathan Bregler

Jonathan Bregler


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.