Transcript Muriel
REMODECE MEETING January, the 29th 2007 Database Design Structure overview WEB Query parameters Query analyzer SQL string Web server Generated HTML file Answer USER Recordset Data base software 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 Answer USER (Data base Software) 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 ? Available in the database •CIEL •Ecodrôme 1 and 2 •ECUEL •Eureco DK, IT, PT and GR Planned to be import •Standby •Czech households •French Guyana •Irise •French lightning •Swedish campaign •Remodece •German data Format to •Databank VITO SETEC (Be) be defined •Remodece survey … ENERTECH REMODECE Database Design What’s next ? Log on Interface (statistical purpose) Result Page Query interface Raw data Download page (for advanced research) 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…). Household number 1000 1000 1000 … ENERTECH Appliance number 12 12 12 … Date Time Data1 Data2 … 20/01/2007 20/01/2007 20/01/2007 … 01:30 01:40 01:50 … 25 20 12 … 232 230 232 … … … … … 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 Lamp type Number of Power per Lamp type Number of Power per Lamp type Number of Power per 1 lamp 1 lamp 1 2 lamp 2 lamp 2 3 lamp 3 lamp 3 INC INC INC FLUO FLUO FLUO CFL CFL CFL … … … Stand-by Household Appliance number number 1000 12 … … ENERTECH Stand-by power 2,5 … Stand-by rate 0,62 … WHAT ELSE ??? 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 Survey number A1 A2-1 A2-2 A2-3 A2-4 A3 … I3-1 I3-2 I3-3 I3-4 1 2 … 26160 69125 … 1 0 … 0 0 … 2 0 … 0 2 … No degree University … … … … 0 1 … 0 1 … 1 0 … 0 1 … 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