IntelliHome - Domotica Arduino

IntelliHome allows the control of water consumption and electric power consumption through the analysis of online database information.
The ideal would be combine this application with an automatic smart home system that provide to get data and upload these in the online database: this system can be composed by sensors and motors controlled by Arduino UNO with WiFi shield or Arduino YUN.

IntelliHome calculates daily water consumption and daily electric power consumption by analysis the hourly rate consumptions in the database and then it draws a detailed graph.
Moreover, it provides the weekly consumption forecasts.

Following the instructions to build database:
• Find an online mysql database (example: db4free.net)
• Create an account with username and password
• Create a database called “intellihomedb”
• Create two tables called “WATER” and “POWER” into this database
• In each table create three fields in this order: “date”, “time”, “consumption”. “date” (type “DATE”) contains the date of the consumption’s measurements. “time” (type “TIME”) contains the time of the consumption’s measurements. The values in “consumption” (type “INT”) must be express like l/h (water) or kW/h (electric power).

To connect to online database you have to know the database’s URL and insert it in the proper application’s window. Following the instructions to compose this URL:

“jdbc:mysql://” + DATABASE’S WEB SITE + “:” + SERVER’S NUMBER + “/” + DATABASE’S NAME

If the server is 127.0.0.1:3306 the “server’s number” is 3306. For example, URL would be “jdbc:mysql://db4free.net:3306/intellihomedb”.