Re: oracle design question

Haiyun Wang wrote:

> I am a application developer but recently my boss asked me to
> build up a database in oracle 8i.
>
> Data:
> 1)financial data information which has around 15 different
> categories.They all have same data fields such as name,
> timestamp, price... 2)The data is kept updated. But the data
> don't come regularly. First second maybe 3, next second maybe
> 0. I guess the timestamp can't be primary key. 3)Each
> categories will have around average 60 records in a minute.
>
> I wonder how to build up the table.(what is primary key? do i
> have to seperate them into different tables according to the
> categories or times?)
>
> I don't know if I make it clear. Thanks again for your help.
>
>
>
>

        I think it is clear that any organization needing a database that has to handle 900 transactions a minute should employ the services of a DBA with experience in logical and physical database design.

        Based on the information you have provided (plus my assumption that you don't have a DBA to physically manage your database) your best bet is to have a single table for all categories and just add a category column to the table.

        Just use an Oracle sequence to generate the primary keys for your table.

-- 
Jerry Gitomer
Once I learned how to spell DBA, I became one