Integration of Oracle and Hadoop: hybrid databases affordable at scale

For CHEP

2016 (San Francisco, Oct 2016)

Author(s)

Luca Canali, Zbigniew Baranowski, Prasanth Kothuri

Back to...

Abstract

This work reports on the activities of integrating Oracle and Hadoop technologies for CERN database services and in particular in the development of solutions for offloading data and queries from Oracle databases into Hadoop-based systems. This is of interest to increase the scalability and reduce cost for some our largest Oracle databases. These concepts have been applied, among others, to build offline copies of controls and logging databases, which allow reports to be run without affecting critical production and also reduces the storage cost. Other use cases include making data stored in Hadoop/Hive available from Oracle SQL, which opens the possibility for building applications that integrate data from both sources.

 

You are here