Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    5

    Question Unanswered: Storing Data Logger data

    Hi all,
    First of all thank you for taking your time to help!

    I have a comma separated file from data logger that I need to store in the database so that I could retrieve the data for any given day or hour or whatever and plot it on a web page. I decided to do it in the following way:

    datalogger_Data
    ----------------
    dataId uniqueidentifier
    UserId uniqueidentifier
    date timestamp
    data text

    Each day will be identified by date and have its own record. Each day will have data text column that will keep data logger data in the following format:
    hour,temperature,pressure\n
    hour,temperature,pressure\n
    hour,temperature,pressure\n
    hour,temperature,pressure\n...

    My question is if this is a right way of storing this kind of data. Should I use separate record for each hour (# of rows will then be huge)?

    Thanks in advance!
    -Eugene

  2. #2
    Join Date
    Sep 2005
    Posts
    161
    You should definitely have a separate row for each hour. You should also have a separate field for each item.... hour, temperature, and pressure.

    Don't worry about the large number of rows. Database engines are designed to handle a large number of rows.

Posting Permissions

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