Skip to Main Content

JSON: store it in oracle or hdfs ?

GS613May 9 2021

I would like to know your thoughts on when JSON is best stored in the oracle database or on hdfs?
The use case is Google Analytics data for a large retailer’s e-commerce site and other smaller landing page/sites.
There is quite a lot of event data being generated daily which could be summarised or aggregated and used for further campaign execution or reporting/analysis.
The initial argument so far is that this type of high volume, semi structured data best lives in hdfs on a hadoop cluster.
The alternative is to store the data directly in oracle, using all the features in 19c to query and use the data as required.
My preference is Oracle, for many reasons, but I would like to know your thoughts and which would be a more suitable storage / landing platform and why?

Post Details
Added on May 9 2021