Overall progress report

1
WP-B2 Creation database (IPGRI)

• Overall progress report
• Strategy
• Data flow schema
• Database standardization and design
• Uploading mechanism lesson(s) learnt
• Other issues
• Conclusion

2
Overall progress report
MCPD
Database
WP-B2 Creation database (IPGRI)
Replication
Clearance
Web
Compilation
Database
Dec 2001
June2001
Dec2001
June2002
Dec2002
Original timetable
3
Overall progress report
MCPD2000
MCPD1999
Database
Web
Replication
WP-B2 Creation database (IPGRI)
Web
Compilation
Compilation
Database
Clearance
Dec 2001
June2001
Dec2001
June2002
Dec2002
Real timetable
4
Overall progress report
Recommendations
WP-B2 Creation database (IPGRI)
5
Strategy
K.I.S.S Strategy Keep It Simple Stupid.
WP-B2 Creation database (IPGRI)
6
Strategy
Data sources
Data packaging
National Level
Data processing
WP-B2 Creation database (IPGRI)
Data importing
Data checking
Data access
Central Level
7
Strategy
WP-B2 Creation database (IPGRI)
8
Data flow schema
National Inventory data file
FRA
NLD
NGB
ASCII Tab delimited format
First line contains the MCPD columns descriptors.
no order restrictions but has to follow the
exact name of the descriptors (I.e. INSTCODE)
WP-B2 Creation database (IPGRI)
Next lines contains the respective MCPD
descriptorsfor each accession submitted.
Essential fields required for each line NICOD
NI identifier ISO code From ? INSTCODE INST
identifier Who ? ACCNUMB ACC identifier What
? GENUS Taxa identifier Of ?
9
Data flow schema
National Inventory data file
WP-B2 Creation database (IPGRI)
10
Data flow schema
National Inventory import process
NICOD, INSTCODE, ACCNUMB, GENUS ?
ERROR
WP-B2 Creation database (IPGRI)
Descriptors with codes ?
ERROR/WARNING
Other descriptors
WARNING
11
Data flow schema
Restriction on NICOD, INSTCODE, GENUS, ACCNUMB
No restriction on other fields
WP-B2 Creation database (IPGRI)
What about priority descriptorsagainst
secondary descriptors
12
Database standardization and design
ACC
WP-B2 Creation database (IPGRI)