Re: 3 dimensional Oracle database

Not all data has to be historical, it can be as real-time as real-time can possibly get.

But forget that. I laid out what I think are 3 dimensions, and you said not so.

Okay how do I stack the cells from different sources all pertaining to the same subject but in different formats, ie. .doc or .txt, audio, and .bmp or .wmf? All of which were captured at the same time but by different departments.

I know you will probably say well create three columns across a row to contain the data from the different sources. But what do I do about keeping the historical data along with the present data, because the present data will not be replaced when newer information comes along. Why? The historical data and most recent data will be used for statistical probability patterns.

But if you say I don't get it, after the above explanation I would like to know what it should look like.

"IANAL_VISTA" <IANAL_Vista_at_hotmail.com> wrote in message >>
>>>>
>>> NAME the three dimensions you think you see - I have seen none.
>>>
>>> Cells arrayed with data from different sources: 1 dimension, not
>>> three. Data being alphanumeric, or binary (there's no difference in
>>> video or sound!): 1 dimension.
>>> Data belonging to explicit and specific subjects (explain the
>>> difference!): 1 dimension.
>>>
>>> What cannot be solved in a (flat! 1 dimensional!) table with a
>>> structure like:
>>> Key Indicator | Subject | Data Type | Data
>>
>>
>> I think I said that the data was coming from multiple sources, but
>> they all relate to the same subject. The second dimension is aligning
>> .doc data with .doc data or .txt or just plain character data, or
>> audio or video data. The last dimension is historical. Each z axis
>> cell is a historical cell entry.

>
>
> Here is a free clue that you can/will also ignore.
> ALL the data in any database is HISTORICAL, when anyone queries it!
>
> Why are you utterly obessed with the silly notion of 3-D data?