Use Case Pattern For Modern Data Discovery Sandbox
Data Discovery Sandboxes A data discovery sandbox is generally meant as a non-operational environment where business analysts and data scientists can test ideas, manipulate data and model what-if scenarios. It has a finite life expectancy and when timer runs out the sandbox is deleted. The associated discoveries are then either incorporated into the warehouse or simply abandoned. The driver is to use a 'fail-fast" approach built around Autonomous Database and its wide range of in-database smart analytics - machine learning, graph, spatial, semantic analytics...
Data Warehouse Use Case Patterns
Pattern for Data Discovery Sandboxes
Stage 1 - PROVISION
Autonomous Data Warehouse
Oracle Autonomous Data Warehouse provides an easy-to-use, fully autonomous database that scales elastically, delivers fast query performance and requires no database administration.
Fully-managed cloud service that makes it very simple to provision a data warehouse, quickly and easily load data and query that data using built-in web-based tools such as notebooks.
Get more information...
- Watch this video to hosted by Oracle SVP Çetin Özbütün to get an overview of Oracle Autonomous Data Warehouse and understand how it offers automated "load and go" management and tuning, high performance, and instant elasticity, click here
- Learn more about what is an Autonomous Data Warehouse, click here
- Watch this tutorial to learn more about getting started and provisioning your first Autonomous Data Warehouse click here
Stage 2 - Clone
Create A Sandbox
The cloning feature of autonomous data warehouse makes it possible to make exact copies of your data warehouse in a few mouse clicks, either including or excluding the actual data depending on your precise needs.
Get more information...
- Learn how to clone an Autonomous Data Warehouse instance, click here
- Notes for cloning for more information about the cloning operation and the resulting cloned database when you clone an Autonomous Data Warehouse - click here
Stage 3 - SECURE
Data Safe
Oracle Data Safe helps organizations to accelerate Cloud adoption, achieve data privacy and compliance by discovering, classifying, and masking sensitive data. It also helps them establish IT internal controls for their database infrastructure in the cloud. Audit information is consolidated from multiple sources and alerts/reports are generated to meet security and regulatory requirements.
Get more information...
- For a general overview of Data Safe - click here
- To learn how to enable Oracle Data Safe in a region of your tenancy - click here
- For more information about the key concepts and terminology - click here
- For more information about registering ADW with Data Safe - click here
Stage 4 - TRAIN-DISCOVER
Machine Learning Notebook
Oracle Machine Learning is a SQL notebook interface for data scientists to perform machine learning in the Oracle Autonomous Data Warehouse (ADW). Notebook technologies support the creation of scripts while supporting the documentation of assumptions, approaches and rationale to increase data science team productivity.
Oracle Machine Learning SQL notebooks, based on Apache Zeppelin technology, enable teams to collaborate to build, evaluate and deploy predictive models and analytical methodologies in the Oracle ADW.
Get more information...
- For more information on getting started with Machine Learning SQL notebooks - click here
- For more information about the machine learning example templates - click here
- For more information about data analysis and data visualization with OML - click here
Stage 5 - VISUALIZE
Oracle Analytics Desktop
Oracle Analytics Desktop provides standalone data exploration and visualization in a per-user desktop download. Oracle Analytics Desktop is the tool for quick exploration of sample data from multiple sources or for analyses and investigation of your own local data sets.
Oracle Analytics Desktop enables you to visualize your data so you can focus on exploring data patterns. Just upload data files or connect to Oracle Applications or a database, select the elements that you’re interested in, and let Oracle Analytics Desktop find the best way to visualize it. Choose from a variety of visualizations to look at data in a specific way.
Get more information...
- For more information on getting started with Analytics Desktop - click here
- For more information about connecting ADW to Analytics Desktop - click here
- For more information about exploring and visualizing your data - click here
Oracle Analytics Cloud
Oracle Database is able to efficiently leverage all hardware resources - multiple CPUs, multiple IO channels, multiple storage units, multiple nodes in a cluster. The Oracle Optimizer can automatically decide if a query should run in parallel and the degree of parallelism to use based on the resource requirements of the statement.
Get more information...
- For more information on getting started with Analytics Cloud - click here
- For more information about connecting ADW to Analytics Cloud - click here
- For more information about exploring and visualizing your data - click here