[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Cost-effective Time-series database with VB access

Posted on 2004-10-08
10
Medium Priority
?
404 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

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 …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL several years ago, it seemed like now was a good time to update it for object-oriented PHP.  This article does that, replacing as much as possible the pr…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

656 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