The DataBee and DBATool tutorials are interactive "movies" which show
you how to use a DataBee software component or technique.
Viewing a tutorial is like sitting with an instructor - you see the mouse move
and the buttons press and each step is explained in detail as you progress through
the tutorial.
The tutorials are entirely Java or Flash based - no plugins are required! All you need is a reasonably recent
Internet Explorer or Netscape browser. The tutorials can be viewed online by clicking on the links below or, if desired, downloaded and
viewed offline.
Many of the tutorials on this page form part of the activities in the DataBee Quick Start Guide.
The Quick Start Guide provides a step-by-step introduction to DataBee and is the fastest
and easiest way to learn how to create referentially correct subsets of large Oracle databases.
The tutorials are quite small given the complexity of what they do. However, they are each several hundred
Kb in size. If you do view them online you might experience a short delay while they get started - we appreciate your
patience.
DataBee Tutorials
General DataBee Overview
- A General Overview of the DataBee Extract and Load Process
[view from web (java version)]
[view from web (flash version)]
- This tutorial demonstrates the extract and load process using the sample schema and the DataBee sample2.set Extraction Set.
Application Overviews
- An Overview of the DataBee Set Designer Application
[view from web (java version)]
[view from web (flash version)]
- This tutorial illustrates the uses of the DataBee Set Designer application. Also provided is a discussion of the various components of the Set Designer and a basic introduction into creating new Extraction Set rules.
- An Overview of the Set Extractor Application
[view from web (java version)]
[view from web (flash version)]
- This tutorial illustrates the usage and tools in the DataBee Set Extractor application. A referentially correct subset of data is extracted from a sample source schema as an example.
- An Overview of the Set Loader Application
[view from web (java version)]
[view from web (flash version)]
- This tutorial illustrates the usage and tools in the DataBee Set Loader application. A referentially correct subset of data generated from a sample source schema is loaded into a target schema as an example.
Extraction Set Design
- Before you Begin: Plan Your Set
[view from web (java version)]
[view from web (flash version)]
- This tutorial takes you through the steps in using the Set Planner tool to produce a written report detailing the tables to be included in the Extraction Set.
- Creating a New Extraction Set
[view from web (java version)]
[view from web (flash version)]
- This tutorial is a tour of the DataBee Set Designer Wizard tool. By the end of the tutorial the user will have the ability to use the Set Designer application to create a basic Extraction Set from source schema information.
Set Designer Tools: In-Depth
- Manually Adding Rules to DataBee Extraction Sets
[view from web (java version)]
[view from web (flash version)]
- It is a simple process to add a rule to an Extraction Set which defines a table-to-table relationship. This tutorial shows you how.
- Using the Set Designer Chain Finder Tool
[view from web (java version)]
[view from web (flash version)]
- This tutorial illustrates the use of the Set Designer Chain Finder tool. An example of the discovery of table relationships and rule creation is presented.
- Using the Set Designer Index Follower Tool
[view from web (java version)]
[view from web (flash version)]
- This tutorial illustrates the use of the Set Designer Index Follower tool. An example of the discovery of table relationships based on common index columns is presented.
- Using the Set Designer Column Finder Tool
[view from web (java version)]
[view from web (flash version)]
- This tutorial illustrates the use of the Set Designer Column Finder tool. An example of the discovery of table relationships based on mutual column names is given.
- Using the Set Designer Who-Loads-What Tool
[view from web (java version)]
[view from web (flash version)]
- This tutorial illustrates the use of the Set Designer Who-Loads-What tool to browse through the table relationships in an Extraction Set.
- Using the Set Designer Bulk Rule Generator
[view from web (java version)]
[view from web (flash version)]
- This tutorial shows you how to use a single template rule to create multiple Extraction Set rules.
