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.
Received on Sat Jul 28 2001 - 07:23:03 CEST
