Oracle Autonomous Data Warehouse

Oracle Autonomous Data Warehouse is being used by our organization to help our clients get the best out of their data which was earlier analyzed using Microsoft Excel. It is currently being used by one department of the company which caters to an Australian insurance giant. The clients want to better utilize the claims data in order to reduce the pathing cost and increase income from recoveries.

A manufacturing company recently asked my company to do a Business Intelligence project to improve and standardize the analysis of its users. Before the project, users used spreadsheets and local databases based on Access to perform management analysis.
For the project, we proposed them an Oracle cloud full-stack architecture based on:

• Object storage
• Oracle Autonomous Data Warehouse
• Oracle Analytics cloud

After a first as-is analysis, the project steps have been:

• Export of data from the company ERP on flat files
• Creation of a staging area layer
• Creation of PL/SQL procedures to import files on staging structures, performing formal checks, cleaning and standardization processes
• Creation of entity-relation models for some Data Marts
• Creation of ETL flows to load data from the staging area on the Data Marts
• Creation of a series of institutional reports, based on Data Marts
• Profiling of users to access to the reporting layer and for free ad hoc analysis

The project has recently been deployed and the architecture is currently being used by about fifty users.

The blockchain style for data storage and analysis. We have many different data formats from XML, HTML, JSON and this tool is very useful in organizing and querying all types of data at once. Getting all of our data centralized in one place and then only using one tool to look at all of it is hugely beneficial.

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.

We use Oracle Autonomous Data Warehouse for one specific application that store[s] alarm[s] and incidents as an historical database. It address business problem[s] with regard to preventive maintenance that analysts can query more than a billion rows very fast, to identify certain patterns. This historical database was migrated from an older Oracle database into the Autonomous Data Warehouse and now we don't need to think about upgrading the database and having machine/database available. Now the database is always available and if it is not need[ed] for some time, we just stop it, and when there is need to query the data I start it up again.