We help IT Professionals succeed at work.

store weather information to database.

marrowyung
marrowyung used Ask the Experts™
on
hi,

I have  a question from property team that if they have temperature sensor to collect all temperature and all weather related data, how can we store those information from sensor to database so that we can gather a report easier ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ste5anSenior Developer

Commented:
Some one or some device must read the sensor value and store it in a database.

So, what is your real question?
marrowyungSenior Technical architecture (Data)

Author

Commented:
I mean by automated method ! the sensor should know how to send information to the database in the table suggested by the Sensor vendor ?

The daily information will keep going everyday and using human to read and enter information to the database is not possible.
ste5anSenior Developer

Commented:
Sorry, but this is not a question. It's a broad topic where an answer would span 40 pages and require one or two weeks of research.

In short: a sensor measures something. Then you need a device reading this value. Then you need a device capable of storing this value.

Whether this is a single sensor/device which can do it or two, solely depends on the concrete used components (e.g. Measuring Temperature with a Raspberry Pi Temperature Sensor (1-Wire)), which you haven't told us anything about it.
marrowyungSenior Technical architecture (Data)

Author

Commented:
sorry it is broad, but it is just like some friends asking if he want to measure the temperature outside of his shopping mall, and then draw report about it, what can he do ?

my first response is , the sensor should like a CC reader which read customer's CC and the insert the data automatically to a pre defined table in database server.

any other idea you can think of ?
Senior Developer
Commented:
Well, he should ask the mall administration whether and where he can place a temperature sensor and what security requirements must be met for it, e.g. IP level. He must check what kind of network connection is possible. WLAN, LAN, etc. Also a it is important how the sensor must be powerd, batteries, Power over Ethernet etc.
He also needs to tell you, where this "database" should be located and what kind of database he wants.

In short you need to gather the requirements..

Then you need to go shopping. Thus looking for sensors and devices fitting the requirements and the budget, like the previously mentioned Raspi approach (e.g. Samples for Azure IoT starter kits).
marrowyungSenior Technical architecture (Data)

Author

Commented:
he is the IT manager of the mall, so can do whatever connect he like.

"He also needs to tell you, where this "database" should be located and what kind of database he wants."

I think the sensor HW has the software say what OS platform and DB  software the Sensor software has to run on?

I am not sure any temperature selling on the street has this kind of additional feature ?

so it seems that he need to pick up a sensor has software support and LAN support so that it can upload data to database server ?
ste5anSenior Developer

Commented:
Well ask Columbia WS or Oregon Scientific. The may have out-of-the-shelf solution.
marrowyungSenior Technical architecture (Data)

Author

Commented:
so you mean direction is correct to ask provider about the SW and DB support of thier hardware? what if the HW do not have it , then he can't implement the solution at all ?
ste5anSenior Developer

Commented:
Columbia and Oregon are weather station manufactures. And as already posted, you can do it all your self (raspi, arduino).
marrowyungSenior Technical architecture (Data)

Author

Commented:
" you can do it all your self (raspi, arduino)."

so this means must use raspi or arduino which has the API, right?
ste5anSenior Developer

Commented:
Read the links I've provided..........
johnsoneSenior Oracle DBA
Commented:
Look at Weather Underground.  They have done all the legwork.  It is a massive network of people with weather stations.  They have links to weather stations and software.  One of the many solutions there probably already does what you are looking to do.
marrowyungSenior Technical architecture (Data)

Author

Commented:
Johnsone,

seems need to follow their buying guide : https://www.wunderground.com/pws/buying-guide

and then follow their procedure ? https://www.wunderground.com/pws/installation-guide 

and then register ? https://www.wunderground.com/member/devices 
?

ste5an,

https://azure-samples.github.io/azure-iot-starter-kits/seeed/1-temperature-sensor/

is that mean we can configure Raspberry Pi 3 as a LoT device to Azure hub and then do logic in Azure hub to get data from the device and then to database ?
johnsoneSenior Oracle DBA

Commented:
Registering would only be if you want to send them the data.  If you actually try to figure it out yourself, all the information should be here
marrowyungSenior Technical architecture (Data)

Author

Commented:
tks all.