A data warehouse is a relational database that is designed for queries and analytics rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources. It separates analytics workloads from transaction workloads and enables an organization to consolidate data from several sources.
So what's an Oracle Autonomous Data Warehouse?
With an Autonomous Data Warehouse, you no longer need specialized database administration skills. You could be a marketing manager, financial analyst or HRIS administrator, and start an analytics project in minutes without involving IT. Anyone can easily explore data for deeper business insights and transform analytics into visual stories to guide executive decision making.
Oracle Autonomous Data Warehouse is built on the market-leading Oracle database and comes with fully automated features that offload manual IT administration tasks and deliver outstanding query performance. This environment is delivered as a fully managed cloud service running on optimized high-end Oracle hardware systems. You don’t need to spend time thinking about how you should store your data, when or how to back it up or how to tune your queries.
We take care of everything for you.This video explains the key features in Oracle's Autonomous Data Warehouse:
This ongoing series of blogs provides you with a detailed, step-by-step guide on Oracle’s Autonomous Data Warehouse. With Oracle Autonomous Data Warehouse, we make it quick and easy for you to create a secure, fully managed data warehouse service in the Oracle Cloud which allows you to start loading and analyzing your data immediately.
We will provide you with step-by-step instructions on how to:
We’ll play with publicly available data sets and analyze them with the service, demonstrating the types of powerful visualizations you can create yourself.
Let’s get started by setting up a free data warehouse trial:
Click on the image below to go to the trial sign-up page which will allow you to request your free cloud account:
Once your trial account is created, you will receive a “Welcome to Oracle Cloud” email that contains your cloud account password along with links to useful collateral. To sign into the Oracle Cloud, click here.
Logging in to Oracle Cloud, Selecting a Data Center for your Workshop
To ensure you get the very best experience possible during this workshop, we recommend that when creating instances of Autonomous Data Warehouse in North America Data Region, please choose our data center in Phoenix. When creating instances of Autonomous Data Warehouse in EMEA and APAC, please choose our data center in Frankfurt.
For example the image below shows how you would select the us-phoenix-1 REGION.
If you do not see the US-Phoenix-1 region (or any other region), choose the menu item "Manage Regions". Subscribe to the region you want (e.g. US-Phoenix-1). It will become available for selection after you refresh your browser.
Lab Prerequisites – Required Software
1. SQL Developer
To download and install SQL Developer please follow this link, select the operating system for your computer. This page also has instructions on how to install SQL Developer on Windows, Mac OSX and Linux.
If you already have SQL Developer installed on your computer then please check the version. The minimum version that is required to connect to an Oracle Autonomous Data Warehouse Cloud is SQL Developer 17.4.
Oracle Data Visualization Desktop makes it easy to visualize your data so you can focus on exploring interesting data patterns. Choose from a variety of visualizations to look at data in a specific way. Data Visualization Desktop comes included with Autonomous Data Warehouse.
To download and install Data Visualization Desktop please follow this link and select the operating system for your computer. This page also has instructions on how to install DVD on Windows and Mac OSX.
If you already have Data Visualization Desktop installed on your computer then please check the version. The minimum version that is required to connect to an Oracle Autonomous Data Warehouse Cloud is 12c 126.96.36.199.0.
In the next post, Data Warehouse 101: Provisioning, we will provision an autonomous data warehouse.
Written by Sai Valluri and Philip Li