All Things Database: Education, Best Practices,
Use Cases & More

Data Warehouse 101: Introduction

Sai Valluri
Product Marketing Manager

What Is a Data Warehouse?

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.

Sign Up for a Free Data Warehouse Trial

What's Inside an Autonomous Data Warehouse?

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.

How to Set up a Data Warehouse Trial

Let’s get started by setting up a free data warehouse trial:

  • You can quickly and easily sign up for a free trial account that provides:
    • $300 of free credits good for up to 3500 hours of Oracle Cloud usage
    • Credits can be used on all eligible Cloud Platform and Infrastructure services for the next 30 days
    • Your credit card will only be used for verification purposes and will not be charged unless you 'Upgrade to Paid' in My Services

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

  • When you login into the Cloud Console for Autonomous Data Warehouse you will have the option of choosing the REGION for your new data warehouse instance.

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

  • This workshop needs two desktop tools to be installed on your computer to do the exercises in this lab.

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.

2. Data Visualization Desktop 

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

In the next post, Data Warehouse 101: Provisioning, we will provision an autonomous data warehouse.

Written by Sai Valluri and Philip Li

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.