Re: 3 dimensional Oracle database

"John F. Regus" <jfregus_at_ix.netcom.com> wrote in news:W3Rje.4193$X92.4021_at_newsread2.news.pas.earthlink.net:

> 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).

IMO, you appear to be fixated more on the dimensionality of the solution rather than any sound data base design criteria.

If a DB has data coming from AP, AR, Credit, Purchasing, and Warehouse does it need to a 5 dimension data base?

What happens when the data from different source give different results depending upon which source is queried? Which is the RIGHT answer? I guarentee you this WILL occur. GIGO!

So what if the DB stores 20 different datatypes, this does not mean you need or even should want a "20-dimension" DB.

Since you already know the answers, I wish you the best of luck at building and maintaining this Frankenstein monster.

HTH & YMMV! Received on Sat May 21 2005 - 20:31:24 CDT