slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
REMODECE MEETING January, the 29th 2007 PowerPoint Presentation
Download Presentation
REMODECE MEETING January, the 29th 2007

Loading in 2 Seconds...

play fullscreen
1 / 13

REMODECE MEETING January, the 29th 2007 - PowerPoint PPT Presentation


  • 98 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'REMODECE MEETING January, the 29th 2007' - vince


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

REMODECE MEETING

January, the 29th 2007

slide2

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

slide3

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

slide4

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

slide5

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

slide6

Database Design

What’s next ?

Log on

Interface

(statistical

purpose)

Result Page

Raw data

Download page

(for advanced research)

Query interface

ENERTECH

REMODECE

slide7

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

slide8

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

slide9

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

slide10

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

slide11

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

slide12

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

slide13

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