Kevin's Week 2 Report

Kevin’s Week 2 Report:  This week I continued testing the database.  The database now continues to take in data every second and this data is stored into a datatemp table in the database.   It averages the second data every minute and stores this into the dataminute table.  This data will be used to display information for the hourly and daily data.

Once the second data is averaged, the datatemp table is cleared to preven the table from growing too large.  This same concept will be applied to clearing the minute data every day.  It will also clear daily data every month.  A bit more simulating needs to be done to make sure that this clearing is sufficient and that the database won’t get too full.  This won’t be an initial problem when the user is first using the system.  Once the system has been plugged in for a year or so, if no clearing is done there may be too much data in the database.

I also set up the initial interface the user will see when they first use the system.  The user needs to just enter in their information in the text boxes, hit “Start Logging Data” and then the system begins to store information.  Below is a screenshot of the initial window.  The debug button is used solely as testing right now.

I also decided to use the MS chart control for graphing the data and displaying it on the webpage.  It is compatible with the .NET framework and seems to be a good tool.  I also decided to use the MS chart control for graphing the data and displaying it on the webpage.  It is compatible with the .NET framework and seems to be a good tool.  http://weblogs.asp.net/scottgu/archive/2008/11/24/new-asp-net-charting-control-lt-asp-chart-runat-quot-server-quot-gt.aspx

Next Week:  Start working with MS chart control and make some basic graphs of the data collected so far.