Data Module

Components of the Data Controller:

1. Real-Time database: Contains only 24 hours' worth of data for faster queries
2. Current database: Contains 1 year of data for queries that are not highly time sensitive (such as billing and attendance)
3. Historical database: Contains all historical data except for the data in the Real-Time database. Used for charting historical trends
4. Sensor Controller (S.C.) Data Receiver: Receives data from S.C. and sends it to the S.C. Data Formatter
5. S.C. Data Formatter: Formats data from S.C. and loads the data onto the Real-Time database and the Current database
6. Historical database Updater: Updates the Historical database with the data from the Real-Time database, and then wipes the Real-Time database
7. Interface Controller (I.C.) Interpreter: Takes data requests from the I.C. and responds with appropriate data
8. Data Request Formatter: Formats queries from the I.C. Interpreter into SQL queries, formats the returned data into usable format, and sends the data to the I.C. Interpreter