1 / 13

REMODECE MEETING January, the 29th 2007

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

vince
Download Presentation

REMODECE MEETING January, the 29th 2007

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. REMODECE MEETING January, the 29th 2007

  2. 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

  3. 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

  4. 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

  5. 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

  6. Database Design What’s next ? Log on Interface (statistical purpose) Result Page Raw data Download page (for advanced research) Query interface ENERTECH REMODECE

  7. 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

  8. 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

  9. 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

  10. 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

  11. 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

  12. 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

  13. 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

More Related