Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2007
    Posts
    4

    DB Scheme for small data segments

    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.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    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?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Oct 2007
    Posts
    4
    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.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Do you need to search for individual segments, or just by person?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Oct 2007
    Posts
    4
    Both. I want search for individual segments and by person too.

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    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.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •