Google Answers Logo
View Question
 
Q: Time-series database application with programming interface ( No Answer,   2 Comments )
Question  
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
Answer  
There is no answer at this time.

Comments  
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

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

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 Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy