DB Scheme for small data segments

Veolw · #1 (**permalink**) 10-08-07, 15:05

Hi all,

first sorry for my bad English

I solve following problem. I have 10 000 users and every user send to database 30 data segments (one segment = 1 byte) per minute. I need also using search. I have no idea what database scheme is best to save this data. Can you help me please? I use MSSQL 2005 server.

Thank you very much.

blindman · #2 (**permalink**) 10-08-07, 15:48

Always 30 segments? Are there sometimes less than 30 segments? Is there any possibility that there could be more than 30 segments?

What is a "segment", and what kind of data are you storing?

Veolw · #3 (**permalink**) 10-08-07, 17:19

Not always. Number of segments can be less or greater than 30 segments.
Segment is ONE byte - etc. 30 segments is packet whose size is 30B (I selected bad convention ... sorry

) Segment is simply one byte.

I am storing results of health measurement etc. ecg, heartbeat.

blindman · #4 (**permalink**) 10-08-07, 17:43

Do you need to search for individual segments, or just by person?

Veolw · #5 (**permalink**) 10-09-07, 10:46

Both. I want search for individual segments and by person too.

blindman · #6 (**permalink**) 10-09-07, 12:19

So you don't know all the measurements that may be taken (heartbeat, etc)?

Will data be received as complete packets, or will inserts/updates be made on individual segments?

This is a tough call, but based upon your data volume and search requirements, I'd recommend one record per packet, with 30+ columns to cover each segment.