130 likes | 249 Views
REMODECE MEETING January, the 29th 2007. Database Design Structure overview. WEB. Query parameters. Query analyzer. SQL string. Generated HTML file. Web server. Recordset. Data base software. Answer. USER. Query. Browser. ENERTECH. REMODECE. Database Design
E N D
REMODECE MEETING January, the 29th 2007
Database Design Structure overview WEB Query parameters Query analyzer SQL string Generated HTML file Web server Recordset Data base software Answer USER Query Browser ENERTECH REMODECE
Database Design Technologies overview WEB Query parameters PHP 5 (Query Analyzer) SQL string MS IIS 6 (Web server) Generated HTML file Recordset MySQL 5.0 (Data base Software) Answer USER Query IE6-Firefox (Browser) ENERTECH REMODECE
Database Design Interface overview 1 - MS IIS analyzes the parameters 2 - PHP generates the query 3 - MySQL generates the recordset 4 - PHP generates the Result page 5 - MS IIS sends the Result page Query interface Result Page ENERTECH REMODECE
Database Design Data status ? • CIEL • Ecodrôme 1 and 2 • ECUEL • Eureco DK, IT, PT and GR • French Guyana • Irise • French lightning Available in the database Planned to be import • Standby • Czech households • Swedish campaign • Remodece • German data • Databank VITO SETEC (Be) • Remodece survey • … Format to be defined ENERTECH REMODECE
Database Design What’s next ? Log on Interface (statistical purpose) Result Page Raw data Download page (for advanced research) Query interface ENERTECH REMODECE
Database Design What’s next ? Install the database on the project website with restricted access : 1- Validate the correct operation of the architecture 2- Test of the query engine by the partners 3- Changes according to partners comments 4- Addition of missing or non define modules (log-on interface, raw data download, survey) 5- Test/comments 6- Release of the final version Access opening to all users We need to contact the webmaster of the website ENERTECH REMODECE
Database Design Data format – monitoring campaign • Household and appliance number per file or per sheet • Each line contains : • Date : specify the format (dd/mm/yy) or (mm/dd/yy), • Time : specify if the time represent the begin or the end of the measurement period, • Data fields : specify the unit (Wh, V…). ENERTECH REMODECE
Database Design Data format – monitoring campaign • What other data do we want to insert in the REMODECE database ? • i.e. what other information will be needed for data treatment ? • Examples of tables : • Lighting • Stand-by • WHAT ELSE ??? ENERTECH REMODECE
Database Design Data format - surveys • How can we insert surveys (from Remodece and others…) in the database ? • Problem : Contrarily to monitoring campaign results, data format depends on the survey • Proposed solution : • For survey, only raw data will be available, no aggregated value • Each partner who wants to introduce data must provide • 1- A short summary of the survey • (to be inserted as description on the website) • 2- A more detailed document (.pdf or .doc file) that describes the hypothesis, the size of the sample… • (downloadable from the website) • 3- Survey data (.txt files) • (downloadable from the website) ENERTECH REMODECE
Database Design Data format – Remodece surveys • For REMODECE survey • We need for each country a single table that includes all the data • Format should be the same for all countries • Need of designing a tool that converts .xls survey sheet in a single table ENERTECH REMODECE
Database Design Summary of what we need from partners Contact with the webmaster of the website ISR First data from monitoring campaigns (appliances and stand-by) to validate the format All partners Format of the common table containing the survey’s data ADEME List of available data (from instrumentation sheet) useful for common data treatment to be inserted in the database SINTEF ENERTECH REMODECE
Software for cross-comparison of energy performance First idea : adapt the energybox tool to our project > Even if they participate to the project, working with S.A.F.E. will cost us money Solution : work in cooperation with the Swedish Energy Agency > cooperation agreement with STEM ENERTECH REMODECE