Solved

Cost-effective Time-series database with VB access

Posted on 2004-10-08
10
393 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
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.

 
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
 

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
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…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

773 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