1 / 13

European Shared Treasure Online system

European Shared Treasure Online system. Technical details on data management. EST Data Management. EST data can be searched or browsed from the EST European home page: http://www.europeansharedtreasure.eu. EST Data Management. EST Data are: stored in each NA server

renates
Download Presentation

European Shared Treasure Online system

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. European Shared Treasure Online system Technical details on data management

  2. EST Data Management EST data can be searched or browsed from the EST European home page: http://www.europeansharedtreasure.eu

  3. EST Data Management • EST Data are: • stored in each NA server • replicated in a central database • Each NA manage its EST national database and has complete information only about its beneficiaries • The central database is updated periodically (once per day) by each national database

  4. NA LLPLINK DB National database • Each NA pre-fill the national EST db using LLPLink2EST • Data come from the national LLPLink • When beneficiaries access their partnerships, they read/write accessing the national EST database • In particular, the partner list displayed in the input form comes from the national LLPLink and it is the snapshot of the partnership as it is in that moment and in that national LLPLink • 2008-1-IT2-COM06-00011-1 • PARTNER LIST • NA1 Partner • NA2 Partner • NA3 Partner LLPLink2EST NA1 EST DB

  5. Public search Central EST server <root> <t_project> <id_project>2008-1-AT1-COM06-00012-6</id_project> <nacode>NA2</nacode> ….. </root> • A daemon on public search server periodically queries local servers to update its data • EST Web Service retrieves XML files from local servers <root> <t_project> <id_project>2009-1-IT2-COM06-00012-6</id_project> <nacode>NA1</nacode> ….. </root> NA2 EST server NA2 EST server

  6. 2008-1-IT2-COM06-00011-2 Central EST DB 2008-1-IT2-COM06-00011-3 NA2 EST DB NA3 EST DB 2008-1-IT2-COM06-00011-1 NA1 EST DB Public search workflow • 2008-1-IT2-COM06-00011-1 • PARTNER LIST • NA1 Partner • NA2 Partner • NA3 Partner • Public search server: • retrieves data from each local server • rebuilds partner list and results and show them to the user

  7. Partner list mismatch • The strategy we use to populate the central EST db can lead to a mismatch between the partner list shown in the beneficiaries’ input page and the partner list displayed on the public search page • Why?

  8. Partner list mismatch • For example in the above partnership many partners are missing in the search page compared with the partner list on the input page • According to LLPLink, those partners have been rejected or cancelled after the export was performed.

  9. Partner list mismatch • One partner (let’s name it A) may have been approved and rejected (or cancelled or ..) sometime later • If the NA performs the export from LLPLink to EST when A is approved, it will be displayed in the partner list • If the NA performs the export AFTER A is rejected, A will not be shown on the public search page because the partnership is rebuilt by EST system • However A will be still visible in the partner list on the input page, until the coordinator NA performs a new export

  10. Partner list mismatch • Same problem can happen also for different reasons • For example: • Issues in LLPLink replication service • Local NA server temporarily down or not reachable

  11. 2008-1-IT2-COM06-00011-2 Public search DB NA2 EST DB NA3 EST DB 2008-1-IT2-COM06-00011-1 NA1 EST DB Not working server scenario • 2008-1-IT2-COM06-00011 • PARTNER LIST • NA1 Partner • NA2 Partner • NA3 Partner – MISSING! 2008-1-IT2-COM06-00011-3 • If NA3 server is not available: • Data (partnerships and results) from NA3 are not available in the public search DB • Partnerships with partners from NA3 are incomplete in the public search

  12. Proposal Eliminate the partner list from beneficiaries page.

  13. European Shared Treasure Online system Technical details on data management

More Related