Oracle Autonomous Data Warehouse

I used to use it in my previous role when I was working as a Spatial Data Analyst. I mostly used it to query and model GIS data and to write spatial queries to extract meaningful information. We used a GIS product that was only compatible with oracle and TOAD. I had some fun learning/experiences with it.

Oracle Autonomous Data Warehouse was tested for specific reporting use cases. It was tested to see how efficient it is when compared to our current existing solution. Also, we have a requirement to keep the database up and running 24x7. The autonomous data warehouse setup and maintenance are very simple and easy, it will help to manage resources efficiently.

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.

It's used by a department, it moves and transforms data from transactional financial database into warehouse database, so that end users can generate the reports out of it.

Oracle Autonomous Data Warehouse is a fully managed database that’s tuned and optimized for data warehouse workloads, so we decided to give it a try with a POC. It combines the market-leading performance of Oracle Database with the ease of Autonomous Database and is self-driving, self-securing, and self-repairing. Our objective was to spend our time focusing on delivering applications to solve our business problems. One of the hurdles was the time spent in maintaining--upgrading, patching, installing new services. Oracle Autonomous Data Warehouse gave us the confidence to delegate the operational well-being of our database instances to the experts who designed it from the ground up.

It is used in multiple departments to build in-house analytics tools where we use Oracle as our main database.
The current purpose of using Oracle in our team is just for storing less data but highly index database for frequent data fetch which enable our operation to resolve customer tickets/complaint within SLA. Our current system is small which may we scale in the future (10-20 million records in main and we also create SCD type 1,2 and 3 ETL flow using Oracle).

Oracle Autonomous Data Warehouse is used by the IT department . It is an automated version of Oracle Database. It removes the mandate layer of a database administrator to manage the database.

Oracle Autonomous Data Warehouse is being used by our company to full manage our warehouse inventory. Time that was wasted previously doing repetitive tasks is now delegated and we did not have to worry about any database management.

I'm using the a Free Tier [Oracle] Autonomous Data Warehouse in a PoC / Test environment to centralize information from a wide range of sources in order to allow quick Reporting and OLAP analysis of data coming from our suite of tolling software. I'm integrating information from more than 30 databases (20 SQL Server, 5 Oracle and other like Postgres). This POC will try to demonstrate the ease of use and maintenance of Autonomous databases so we can recommend them to our customers.

<h3><span style="font-size: 15px; color: rgb(21, 21, 33); font-family: &quot;Source Sans Pro&quot;, sans-serif; font-weight: 500;">One of the biggest challenge is the scaling and provisioning of hardware &amp; software for any data ware house solution and also the associate problems like configuration, security and importantly tuning of the storing and fetching/querying data. For the same reason Oracle Autonomous Data Warehouse tool used for one of the project for the customer. It help overcome some of critical, complex, manual and time consuming tasks like hardware procurement, configuration, security, high availability and high performance all this with reducing administrative cost and no human error.</span></h3>

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.

We are using Oracle Autonomous Data Warehouse for storing our data from various fusion apps, marketing technology stack, and customer transaction data. We are stitching these disparate data sources/systems together so that eventually we can perform historical and OLAP analysis using Tableau.

We use the Oracle Autonomous Data Warehouse as my company central data warehouse where we store the different department's data in corresponding tables

Oracle Autonomous Data Warehouse is used in automation of provisioning and configuring a data warehouse. It is also used to tune and scale the data warehouse as needed. It is used across the whole organization.
Business problems that it addresses: Since the manual work is almost completely eliminated, the cost of administering a data warehouse is reduced significantly. Also, this is highly secured and reliable.

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.

Our organization uses Oracle Autonomous Data Warehouse to store, update, and, most importantly, automate tasks. It's very efficient when working with digital data, specifically online conversation data and transaction information.

One of our data warehouses is Oracle Autonomous Data Warehouse and it is being used for two years corresponding very well in terms of performance and reliability. Some of our data has been stored there and it's available to some departments to connect through it to pull data feeding their business intelligence tools.

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.

Oracle Autonomous Data Warehouse is the data warehousing tool for our company in cloud. It is currently being utilized by the transportation department, but we are in the process of expanding its adoption to other departments once the single sign-on issues with the connection to our core Oracle ERP Cloud is resolved. We have a need for many summary reports which could be a challenge from OTBI, hence we are planning to do summarization at the ADW level and then report out of ADW using Oracle Analytics Cloud.

Oracle Data Warehouse is being used across our entire organization. Although each department in our organization has its own individual use cases for maintaining a data warehouse, the overall problems that are being solved are the same. We are using Oracle Data Warehouse for business intelligence related queries, finding trends in periods of time using all the historical data, and for deep data exploration.

The autonomous data warehouse is being used as a test case currently. We are using it to test how much more efficient and reliable it can be compared to our current configuration. It is used solely in my department . It is used to address performance issues for the most part.

We use Oracle Data Warehouse for integrating all the dist data that gets generated from ERP systems to the warehouse and then use the normalized data for reporting purposes. We use Oracle BI reporting for the whole organisation. We deliver reports for all the verticals in our organisation starting from financials, HR, procurement, ridership and so on. There is also an other ERP that is called Maximo and the transaction data gets processed in Oracle Data Warehouse.

Reporting is one of the major requirements across the org and Oracle Data Warehouse helps us keep the history and dimensionality and scaling.

We used Oracle Autonomous Database for our warehouse reporting. It is a 50 TB huge database and reports are generated every day. It is pretty read intensive database. It's availability is required for 24 X 7. We have several thousands customers using it on a regular basis. The performance is phenominal.

We've recently adopted Exadata as our primary DW solution. It allows us to quickly store and query lots of data. The data is generally written in overnight batches and is constantly queried 24x7. It even supports some online business decisions to our customers. We use it company-wide. I am an administrator of the database, as well as a SQL Programmer.