Difference between revisions of "Change: Database"

From HiveTool
Jump to: navigation, search
(Created page with "Background:")
 
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
Background:
+
'''Background:'''
 +
 
 +
 
 +
'''Problems with the current approach:'''
 +
 
 +
#Redundant weather data - Data plan usage can be greatly reduced.
 +
 
 +
 
 +
'''Feature Requests:'''
 +
 
 +
# Be able to rebuild the local database on the hive computer from the public webserver in case of theft or computer failure.
 +
# Be able to send the hive parameters on the local hive to the public database when they are changed locally, and the opposite:
 +
# Be able to send the hive parameters on the public database to the local hive when they are changed in the public database on the public web server.  (This allows changing hive parameters and calibration without going in the remote yard or opening a port for access.)
 +
 
 +
'''Proposed changes:'''
 +
# Add apiary table. Hives can be moved and tracked between apiaries
 +
# Add comment table and UI for beekeeper notes to explain manipulation changes (adding or removing equipment) that affect weight..
 +
# Add weather station data table (linked to apiary, not hive).
 +
# Don't upload weather station data from the hive to the server, instead let the server fetch it.
 +
# Add transactional methods and capture all hive parameters each time they change.
 +
# Enforce foreign key constraints
 +
# Simplify raw data table and do no data conversion on it during input.
 +
# Separate data collection and analysis/visualization to be able to handle as many hives as possible. Periodically (daily, hourly, 5 minutes?) transfer the raw data to the data warehouse and convert raw data table to other tables (metric, imperial, filtered, delta, daily) for viewing.

Latest revision as of 13:11, 9 June 2017

Background:


Problems with the current approach:

  1. Redundant weather data - Data plan usage can be greatly reduced.


Feature Requests:

  1. Be able to rebuild the local database on the hive computer from the public webserver in case of theft or computer failure.
  2. Be able to send the hive parameters on the local hive to the public database when they are changed locally, and the opposite:
  3. Be able to send the hive parameters on the public database to the local hive when they are changed in the public database on the public web server. (This allows changing hive parameters and calibration without going in the remote yard or opening a port for access.)

Proposed changes:

  1. Add apiary table. Hives can be moved and tracked between apiaries
  2. Add comment table and UI for beekeeper notes to explain manipulation changes (adding or removing equipment) that affect weight..
  3. Add weather station data table (linked to apiary, not hive).
  4. Don't upload weather station data from the hive to the server, instead let the server fetch it.
  5. Add transactional methods and capture all hive parameters each time they change.
  6. Enforce foreign key constraints
  7. Simplify raw data table and do no data conversion on it during input.
  8. Separate data collection and analysis/visualization to be able to handle as many hives as possible. Periodically (daily, hourly, 5 minutes?) transfer the raw data to the data warehouse and convert raw data table to other tables (metric, imperial, filtered, delta, daily) for viewing.