|
Oracle Workspace Manager What-If Analysis
These three samples illustrate how Workspace Manager can create variations
on a common dataset to evaluate choices and determine the best alternative.
A separate workspace is created for each choice, changes are made to the
data and analyzed without affecting the production data. The best choice
can be merged with the production data.
Workspace Manager provides a transactionally consistent view of all the
data in the database. This means a user in a workspace sees the latest
version of any data changed in the workspace as well as unchanged data
in parent workspace(s). Users outside the workspace do not see the changed
data until it is merged with the production data..
Download the sample
Product and Shipping Price Optimization - An online store wants
to explore the relationship between shipping price, product price and
the impact on revenue.
Restaurant Site Selection - A seafood restaurant chain explores
the possibility of opening a new store in one of two locations.
It would like to determine which of the potential locations will attract
the greatest number of customers and generate the most revenue.
Team Staffing Optimization - A basketball team's management considers
the replacement of three players to optimize the team's skill set relative
to its salary expense.
Prerequisites
Oracle 8.1.6 (or later)
Oracle Workspace Manager (automatically installed with Oracle9i)
An Oracle username and password
SQL*Plus (to execute the SQL script)
Installation
- Unzip the appropiate file
- Invoke SQL*Plus from the same directory as the script and connect
to the Oracle database
- Execute the script:
| Price Optimization sample: |
@no_shipping_demo.sql |
| Site Selection sample: |
@new_store_demo.sql |
| Staffing Optimization sample: |
@bball_demo.sql |
|
Bookmark