I need your help in understanding one of the scenarios which we are trying to use for one of our customers.

The customer builds electric water pump instruments for their end customer.

We are proposing SQLA as a database that can store the data (output) from pumps (machines). Need help to understand on how the analog data is converted and stored in a DB.

SQLA has been used in similar scenarios.. http://www.sybase.com/detail?id=1025004

Regards, Pritam

asked 11 Mar '14, 08:32

pritamsahoo's gravatar image

pritamsahoo
16112
accept rate: 0%

edited 11 Mar '14, 11:29

Mark%20Culp's gravatar image

Mark Culp
22.9k9129269

2

IMHO this is a project requiring substantial engineering efforts for data acquisition and conversion. SQLA may be used to store the data reliably and effective, but without any information wrt the data types, amount and frequency I doubt you'll get much information from this forum.

(11 Mar '14, 09:39) Reimer Pods

Do a Google search on analog to digital data acquisition. That will give you an idea of (a) what it is and (b) what is available out there for (say) U$49... the world is FILLED with analog-to-digital acquisition, it's EVERYWHERE, in every automobile, every hospital, every telephone, and soon... every glasshole :)

Then, you probably have to determine who is going to be responsible for picking/designing/implementing the data acquisition solution. You? Your client? The pump manufacturer?

No matter what the digital data looks like, SQL Anywhere can handle it... but not the analog data, not directly, not the waveforms.

I'll bet someone already has a data acquisition solution in mind, you just need to ask the right questions of the right people :)

Once you find out what physical equipment is going to be used to produce the digital data, then you can find the documentation that describes what the data looks like and how the interface to a digital computer works and what software utilities or SDKs are provided or available to use on the computer, and then you can design a program to (a) receive/read the digital data from the interface and (b) INSERT it to a SQL Anywhere database.

For the record, water meters exist that were buried in the ground many years ago, together with SQL Anywhere 5.5 databases to record and transmit data, and AFAIK they are still operating today... so if you're looking for low maintenance, SQL Anywhere's your choice :)

permanent link

answered 11 Mar '14, 15:18

Breck%20Carter's gravatar image

Breck Carter
25.6k427586844
accept rate: 20%

edited 11 Mar '14, 15:37

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×13
×4
×1

question asked: 11 Mar '14, 08:32

question was seen: 2,956 times

last updated: 11 Mar '14, 15:37