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
psmsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.