Solved

Cost-effective Time-series database with VB access

Posted on 2004-10-08
10
392 Views
Last Modified: 2008-02-01
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
Comment
Question by:psms
  • 5
  • 3
10 Comments
 
LVL 7

Expert Comment

by:petoskey-001
ID: 12270960
sounds interesting... any MySql problems?  ;o)

0
 
LVL 7

Expert Comment

by:petoskey-001
ID: 12270972
As far as database storage, here is a good article on how to do it...
http://c2.com/cgi/wiki?TimeSeriesInSql 
0
 
LVL 7

Expert Comment

by:petoskey-001
ID: 12270988
programming.  
Sounds like you want a database with triggers.  MySql v5 is adding that support MSSQL, Oracle and PostgreSQL already have it.
0
 
LVL 7

Expert Comment

by:petoskey-001
ID: 12271061
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:psms
ID: 12271372
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
 
LVL 7

Expert Comment

by:petoskey-001
ID: 12271396
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
 

Author Comment

by:psms
ID: 12271523
Thanks petroskey-001
0
 

Author Comment

by:psms
ID: 12339536
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
 

Accepted Solution

by:
modulo earned 0 total points
ID: 13739060
PAQed with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now