• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 410
  • Last Modified:

Cost-effective Time-series database with VB access

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
0
psms
Asked:
psms
  • 5
  • 3
1 Solution
 
petoskey-001Commented:
sounds interesting... any MySql problems?  ;o)

0
 
petoskey-001Commented:
As far as database storage, here is a good article on how to do it...
http://c2.com/cgi/wiki?TimeSeriesInSql 
0
 
petoskey-001Commented:
programming.  
Sounds like you want a database with triggers.  MySql v5 is adding that support MSSQL, Oracle and PostgreSQL already have it.
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
petoskey-001Commented:
Trending and web based.. well your looking at custom development or once again expensive applications.  

Is this a stock market program of some sort?
0
 
psmsAuthor Commented:
Thanks for comments. This is not a stock market program. This is actually for monitoring of process plants.

Actually, it is very useful to have a compression algorithm. By compression I mean that if a value does not change for 900 timestamps then then the database keeps only 1 value rather than all 900 identical values.

I donot limit myself to MySQL. In fact, I have never used MySQL. I just want to pick up the best and cheapest database and work with it.
0
 
petoskey-001Commented:
The first article describes how to create a database so you can get the latest time stamp by checking one record.

I've never used time-series databases, but I do find several commercial applications.  No idea on prices / functionality though.  I think this is all the help I can give.
0
 
psmsAuthor Commented:
Thanks petroskey-001
0
 
psmsAuthor Commented:
I am now leaning towards using MATLAB as the main calculation engine. What is the best mechanism to store the data if Matlab is being used as the calculation/ trending engine.

psms
0
 
moduloCommented:
PAQed with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now