Ashley Abare The Integrated Science Education Initiative ISEI

Зарегистрируйтесь, чтобы просмотреть полный документ!

Ashley Abare “The [Integrated Science Education Initiative] ISEI program maintains three weather stations that collect meteorological data and transmit it to [St. Lawrence University] every fifteen minutes. The stations are placed in three distinct environments around Canton, NY; one in an open field near the ESL House [68], one in a wooded environment on the Little River Nature Area [woods] and the other approximately 5 miles south of campus on Waterman Hill [waterman]. ” - http: //www. stlawu. edu/isei/rtwd. html Advisor: Ed Harcourt An example of the PHP code: An example My. SQL command corresponding table: $q = 'INSERT INTO '. $table. ' VALUES ('; for ($i = 0; $i != $array_size; ++$i) { if ($i == 0 ) { $q. = $info_array[$i]; } else { // MUST USE. = !!!!! $q. = ", ". $info_array[$i]; } } $q. = ')'; mysql> SELECT * FROM watermanh; Collected data is transmitted to the Logger. Net program. "TOA 5", "waterman", "", "", "Hourly" "TIMESTAMP", "RECORD", "BP_mb", "Air. TC_AVG", "RH", "WS_kph_AVG", "WS_kph_S_WVT", "Wind. Dir_ D 1_WVT", "Wind. Dir_SD 1_WVT", "WS_kph_MAX", "WS_kph_Time_MAX", "Rain_mm_TOT", "VW", "Solar _Wm 2_AVG", "Td. C_AVG", "WC_C_AVG“, "TS", "RN", "", "", "", """", "", "", "", "" "2006 -03 -06 15: 00", 0, 991, -0. 958, 43, 8. 06, 13. 8, 95. 9, 17. 85, "2006 -03 -06 14: 55: 40. 375", 0, 0. 511, 501. 2, -11. 89, -3. 616 "2006 -03 -06 16: 00", 1, 991, -1. 02, 42. 6, 9. 01, 24. 28, 102. 8, 16. 44, "2006 -03 -06 15: 21: 40. 375", 0, 0. 511, 399. 3, -12. 23, -4. 055 "2006 -03 -06 17: 00", 2, 992, -1. 321, 50. 58, 7. 109, 16. 05, 73. 23, 16. 09, "2006 -03 -06 16: 49: 35. 375", 0, 0. 51, 206. 9, -11. 68, -3. 629 A Relational Database Management System (RDBMS) is used to better manage the data. “RDBMS - A database management system (DBMS) with the ability to access data organized in tabular files that can be related to each other by a common field. An RDBMS has the capability to recombine the data items from different files, providing powerful tools for data usage. ” - web 2. gov. mb. ca/mli/glossary/m_z. html Logger. Net runs a batch file. The batch file executes a PHP file. The PHP file automatically populates the My. SQL database. +-------------+----------+--------+------------+ | TIMESTAMP | Record | BP_mb | Air. TC_AVG | RH | WS_kph_AVG | +-------------+----------+--------+------------+ | 2007 -04 -09 12: 56: 02 | 33 | 2 | 3 | 4 | 5 | -----------------------------------------------+-----------------------+-------------+----------+ |WS_kph_S_WVT | Wind. Dir_D 1_WVT | Wind. Dir_SD 1_WVT | WS_kph_MAX | +-----------------------+-------------+----------+ | 6 | 7 | 8 | 9 | -----------------------------------------------+-------------+----------+--------------+----------------+ | WS_kph_Time_MAX | Rain_mm_TOT | VW | Solar_Wm 2_AVG | Td. C_AVG | WC_C_AVG | +-------------+----------+--------------+----------------+ | 04: 13: 01 | 11 | 12 | 13 | 14 | 15 | -------------------------------------------------------- Conclusion: Administrators and everyday users will benefit from this new relational database since it will improve the visibility and increase the accessibility of data through the use of tables which can be merged, updated, and archived much better than the previous primitive system which had to be updated manually. In the future, a website can be generated with the My. SQL database information using PHP, My. SQL, and html. I have written and included a manual to assist in the use of the My. SQL database and some general code for a printer-friendly style sheet (CSS). I have also trained the current system’s manager in basic My. SQL commands.

Скачать презентацию Ashley Abare The Integrated Science Education Initiative ISEI

0eee2475c9b57b16bbea863fc429fe80.ppt

Количество слайдов: 1