|
|
Subject:
Time-series database application with programming interface
Category: Computers > Programming Asked by: psmsis-ga List Price: $5.00 |
Posted:
08 Oct 2004 17:24 PDT
Expires: 03 Apr 2005 00:36 PST Question ID: 412288 |
I am looking for a cost-effective solution for time-series database application that can be programmatically accessed by VB.NET. DATABASE - The database will store 1 minute data (real number) for 1000 tags (e.g. tag0001 to tag1000) for 2 months. Data compression will be a desirable feature for the time-series database. PROGRAMMING FEATURES - I should be able to calculate a new tag e.g. tag0999 just by writing a simple expression in VB like if tag001>tag002, then tag0999 = tag001-tag002 else tag0999=tag003+tag004. TRENDING - An excellent trending feature including for calculated tags is a must. I donot want to store a calculation just for trending i.e. I should be able to trend tag001+tag002 without storing this sum in a new tag first. WEB BASED - A web-based deployment of trends is highly desirable. All of the above can be done by www.osisoft.com's PI software, but I am looking for a much cheaper solution. One example would be (MySQL + Dundas Charts + VB.NET) but I am not sure if this can be done. Can someone please advise on a workable and cheap solution. psmsis |
|
There is no answer at this time. |
|
Subject:
Re: Time-series database application with programming interface
From: crythias-ga on 08 Oct 2004 20:16 PDT |
Since you broached it, MySQL would be a cheap way of handling it... With any database, you'd have to use an INSERT query to do this: ==========QUOTE========== PROGRAMMING FEATURES - I should be able to calculate a new tag e.g. tag0999 just by writing a simple expression in VB like if tag001>tag002, then tag0999 = tag001-tag002 else tag0999=tag003+tag004. ======END QUOTE========== whatever you get for tag0999, use the query to database: INSERT INTO tblname (tagcolumn, tagvalue) VALUES (tagname, tagvalue); (OR prepopulate with 1000 tags and use an UPDATE to update the appropriate one...) This is a free comment. |
Subject:
Re: Time-series database application with programming interface
From: psmsis-ga on 18 Oct 2004 08:39 PDT |
Hi I am now leaning towards using MATLAB for this application instead of MySQL. All other things remain the same. Could somone advise how to accomplish this. Thanks psmsis-ga |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
Search Google Answers for |
Google Home - Answers FAQ - Terms of Service - Privacy Policy |