Oracle Autonomous Data Warehouse + Oracle Analytics Cloud + Oracle Blockchain Platform = 🥰
November 03, 2020

Oracle Autonomous Data Warehouse + Oracle Analytics Cloud + Oracle Blockchain Platform = 🥰

Peter Merkert | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Autonomous Data Warehouse

We use ADW in conjunction with the Oracle Blockchain Platform, as it provides an easy way to inspect, analyze, and reuse information stored in a blockchain style. The ADW has basically the same functionality as the Oracle Autonomous Transaction Processing - and they have a massive toolset of useful things!
Let's start with the most engineer-y one: JSON or SQL? It does not matter. Basically, the DB hides the fact if data is in SQL or JSON structure and allows you to easily make queries independently of the actual data structure. This is extremely useful as in our case the Blockchain provides structures in JSON and we needed to digest the information without wanted to dump everything into a strict SQL table! And that works out of the box.
  • Connecting to Oracle Blockchain Platform out of the box
  • JSON or SQL? ADW makes handling both as if they are the same!
  • The basic setup comes with quite some power. The power is often too much for a data warehouse which is used to aggregate data just a dozen times per day and is due to caching not queries for the data sets that often. A smaller shape - yet bigger than the always free - would be great!
  • Oracle Autonomous Data Warehouse is approx 100 times faster spin up than manual setup of an Oracle DB.
  • 3h annual maintenance for big version releases (18c to 19c) compared to est. 500h annual maintenance with manual database updates.
We use ADW to stash data long term from the Oracle Autonomous Transaction Processing and also to digest and process data in a fast manner from the Oracle Blockchain Platform.