Re: 3 dimensional Oracle database

John F. Regus wrote:
> Back to HansF question on what type of data and what am I trying to do that
> requires a 3-d database:
>
> I want to design a 3-D database which the cells are arrayed with data from
> different sources (1st reason for the 3-d
> structure). It is present and historical and can be duplicate information
> if the data came from a different sources, specifically data warehouses at
> different locations which collect information on the same subject but in
> different formats as noted below. The 2nd reason for 3-dimensions it can
> also be data that is either alphameric, .jpeg (any picture format), .wav (or
> any audio/video format), but in the end all of the data concerns a explicit
> and specific subject (3d reason for three dimensions).

I'm with IANAL_VISTA on this. You seem fixated on the solution.

So before you increase the cost, effort, and complexity consider one built-in solution: Workspace Management.

http://www.psoug.org
click on Morgan's Library
click on Workspace Manager.

The DBMS_WM built-in package allows for keeping multiple versions of the same row of data in a table. Just make each workspace equivalent to a dimension and I suspect your work is done.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)