Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am writing an application that monitors and archives the values of hundreds of thousands of variables. Since they change infrequently, only updates are recorded after the initial value.

Three primary types of queries are expected:

  1. Return the values of a set of variables at a given time:

    | var_name_1 | time_stamp | value |
    | var_name_2 | time_stamp | value |
      .
      .
    

    For each var_name, the listed time_stamp is the last time the value changed before or at the given time.

  2. Compare the values of a set of variables between two given times:

    | var_name_1 | time_stamp_1 | value | time_stamp_2 | value |
    | var_name_2 | time_stamp_1 | value | time_stamp_2 | value |
      .
      .
    

    For each var_name, time_stamp_1 is the last time the value changed before or at the first given time and time_stamp_2 is the last time the value changed before or at the second given time.

  3. Return all the values of a set of variables between two given times:

    | var_name_1 | time_stamp_1 | value |
                 | time_stamp_2 | value |
                   .
                   .
                 | time_stamp_m | value |
    
    | var_name_2 | time_stamp_1 | value |
                 | time_stamp_2 | value |
                   .
                   .
                 | time_stamp_n | value |
      .
      .
    

    For each var_name, the first time_stamp is the last time the value changed before or at the first given time and the last time_stamp is the last time the value changed before or at the second given time.

The set of var_names returned is determined by a text matching search.

I would also like to indicate that a var_name was not being recorded for a requested time if the application had not been running then.

There is more information stored for each var_name for a given time_stamp than just the value, and it should be returned as well, but this should give the basic idea.

I was wondering what kind of database type might be best suited for this kind of application? Does a custom database already exist?

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.