Willie Chieukam

1
Item 9 Subtask 1 Performance Database
Willie Chieukam Ulrike Jahn 4th Task 2
Meeting, Vancouver 27 28 March 2006
2
Subtask 1 Performance Database
3
Database User Incentives

• Comparison of Components Quality
• Cost of Systems and Components
• Yield Prediction
• Long-Term Operation Results
• Analytical Calculations
• Checking of Design Tools

4
Number of PV plants in the Database (total 431)
5
Number of PV plants in the Database (total 431)
6
Number of PV plants in the Database (total 431)
7
Number of PV plants in the Database (total 431)
8
Number of monthly Datasets in the Database (total
9514)
9
1st Option
Web Server
User
Web Browser
FZ Jülichwww.iea-pvps-task2.org

• Online Database
• Database server
• Dynamic website generation

10
Task 2 Member
original Database
Data delivery
Updated database
Database on Web Server
Database user
Online access
11
Updated database

• On the web server
• PHP queries
• ? afford communication between database and
  web browser
• No online calculations on the web server
• No stored procedures and SQL queries
• Only Text, integer and float database fields
• Photo files on hard disk

12
2nd Option
Web Server
User
FZ Jülichwww.iea-pvps-task2.org
Web Browser

• Online Database
• Database server
• Servoy server Smart client
• Dynamic website generation

13
original Database
Task 2 Member
Data delivery
Updated database
Web server
Database user
Online access

• SQL Database
• Servoy server
• Servoy smart client

14
Servoy server handles

• Database server connection
• Servoy client concurrency
• Client server communication
• Intelligent data Broadcasting
• -gt allows users to see the most recent
  version of the data on their screen without
  having to press a refresh button
• Automatic deployment of the servoy smart client
• Keeps custom solution up-to-date
• No SQL required

15
Servoy server and servoy smart client

• On the web server
• No online calculations on the web server
• Only Text, integer and float database fields
• Photo files on hard disk
• But
• License needed
• As many licenses as concurrent users

16
Web database tables

• Country
• Year of installation
• Type of Plant
• Mounting
• Typical use
• Plant information
• Array information
• Inverter and DC/DC control information
• Backup and Storage information
• Monthly results
• Annual results

17

• Filter criteriacountry, type of plant, mounting,
  nominal power
• Generate list of available PV systems
• Selection of an list item will display table with
  general plant information, photo and remarks
• Data button will open new page with diagram of
  monthly results and data table for one year
• Next and previous button or list of available
  monitoring years for navigation
• Contents of data tableAMD, Hi, Tam, EIO, ETU,
  Yr, Yf, Lc, Ls, PR

18
Website layout proposal
19
1. Plants
2. Plant data
4. Diagram
3. Operational data
Expert
Home PVPS Our work Survey Database
Specifications Online-version Download full
version Publications Links Events
Contacts Languagedeutsch englishfrançais
italianojapaneseswedish
Enter a plant name or browse by using the filter
option.
Search by plant name
Filter plants
Year of installation
Country
Type of plant
Nominal Power at STC
Mounting
Press ltCTRLgt to choose several options.
20
1. Plants
2. Plant data
4. Diagram
3. Operational data
Expert
Home PVPS Our work Survey Database
Specifications Online-version Download full
version Publications Links Events
Contacts Languagedeutsch englishfrançais
italianojapaneseswedish
Enter a plant name or browse by using the plant
filter option.
Search by plant name
Filter plants
Country
Type of plant
Nominal Power at STC
Year of installation
Mounting
Press ltCTRLgt to choose several options.
Search results (324 hits) Plant A Plant B Plant
C ..
Page 1, 2, 3, 33
21
1. Plants
2. Plant data
4. Diagram
3. Operational data
Expert
Home PVPS Our work Survey Database
Specifications Online-version Download full
version Publications Links Events
Contacts Languagedeutsch englishfrançais
italianojapaneseswedish
Plant name
Country Type of plant Nominal power at STC Year
of installation Mounting Nominal area
Azimuth angle Tilt angle Module type Inverter
type Latitude Longitude
Photo
Select year for operational data
get further information / click here to visit
plant website
Year
Show operational data
Search results (324 hits) Plant A Plant B Plant
C ..
Page 1, 2, 3, 33
22
1. Plants
2. Plant data
4. Diagram
3. Operational data
Expert
Home PVPS Our work Survey Database
Specifications Online-version Download full
version Publications Links Events
Contacts Languagedeutsch englishfrançais
italianojapaneseswedish
Plant name
Year
Period
Select different year or period for operational
data
1 year 2 years 3 years max
Year X or period
Select diagram type for this period
Parameter 1
Parameter 2
Euse,PV
23
1. Plants
2. Plant data
4. Diagram
3. Operational data
Expert
Home PVPS Our work Survey Database
Specifications Online-version Download full
version Publications Links Events
Contacts Languagedeutsch englishfrançais
italianojapaneseswedish
Plant name
Change diagram
Year
Period
Parameter 1
Parameter 2
Show diagram
1 year 2 years 3 years max
Year X or period
Parameter 1
Parameter 2
Diagram
Jan Feb Mar Apr May Jun
Jul Aug Sep Oct Nov Dec
24
Diagram example
25
Next steps

• Website layout and PHP scripts for server based
  database access
• Installation on public web server

26
Quarterly registrations and downloads, 28th
February 2006
27
Registrations by sector, 28th February 2006
28
Registrations by country, 28th February 2006
29
Registrations by country, 28th February 2006, Top
15
30

• State of 28th February 2006
• 3402 online registrations
• 90 countries
• 2736 downloads 80
• 598 downloads of database updates
• gt 650 distributed CD-ROMs
• Installation support for 55 users

31
Installation problems
32
Data collection for next update (1) Due date 1
May 2006

• AUT 3 SAS
• CAN 1 new
• EU FP4 5 6 Eastern EU
• FRA
• DEU 10 BIPV 5 large PVS
• ITA 1 hybrid 1 long-term

33
Data collection for next update (2) Due date 1
May 2006

• JPN 20 new residential GCS
• SWE
• CHE 3 new systems 5-12 ongoing
• UK
• USA 14 new GCS 12 ongoing 2 new systems