1 / 25

We made the base We get the data We have the database

We made the base We get the data We have the database. Palermo, may 2010 F.Doumaz, S.Vinci (INGV-CNT- Gruppo di telerilevamento ). Paroxysm DB architecture system. UR 1. UR 2. UR 3. UR n. XLS, TXT files. Common WEB Upload interface.

winona
Download Presentation

We made the base We get the data We have the database

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. We made the base We get the data We have the database Palermo, may 2010 F.Doumaz, S.Vinci (INGV-CNT- Gruppoditelerilevamento)

  2. Paroxysm DB architecture system UR 1 UR 2 UR 3 UR n XLS, TXT files Common WEBUpload interface Data can be retrieved and queried by all authorized users Data are controlled and inserted in the relational database Script layer for real-time automatic data conversion RDBMS XMLWOVOdat SQL ASCII fordynamicgraphics

  3. Paroxysm system deployment

  4. Data Providers

  5. Data collection ALL AUTOMATED • Ascii files (CSV) • Uploaded through Web interface (Asp.Net) • Files are process and checked for consistency (Python) • Creation of XML file on the file system (python) • The MySql DB is populated on the fly (Python) • Graphics are generated for an online check (Python, Java)

  6. The Rules

  7. For XLS files Da salvare in un altro file .xls

  8. ISO standard for date & time Conversione del formato data ISO 8601(aaaa-mm-gg) formato data corretto finale aaaa-mm-gg Formato non corretto gg/mm/aaaa Data nel formato corretto finale: 2009-03-16

  9. Howtoconvert Date and Time in ISO formato data +ora corretto aaaa-mm-ggThh:mmZ Formato non corretto gg/m/aa h.mm Conversione del formato data +ora aaaa-mm-ggThh:mmZ

  10. Things to avoid Formato del foglio non corretto formato foglio corretto

  11. 3b. In questo file di esempio le date sono tutte su una riga invece che sulla prima colonna e non in formato ISO.

  12. How to format the CSV files Correct format

  13. Rules for indexes • La terza e la quarta colonna devono contenere altri 2 parametri: • a) il valore indicizzato, in una scala da basso a molto alto; • 0.25, valore basso • 0.5, valore medio • 0.75, valore alto • 1, valore molto alto • b) un fattore di qualità, che esprime il grado di confidenza con il dato, anche questo espresso in una scala da basso a molto alto: • 0.25, qualità del dato bassa • 0.5, qualità del dato media • 0.75, qualità del dato alta • 1, qualità del dato molto alta

  14. How to insert instrumentation

  15. Used technologies ASCII CSV files Timeline Table vue SVG ScalableVectorGraphics Wovodat compliant

  16. The working interfaces http://kharita.rm.ingv.it/paraupload/

  17. Snapshot of the DB

  18. The WEB interface http://labtel2.rm.ingv.it/paroupload The Login The first page

  19. The Data policy and distribution • E-mail based private transaction • Already packed data and policy http://labtel2.rm.ingv.it/paroupload Let’s check

  20. Paroxysm derived products

  21. DatAbase for Italian Volcanoes DIVO

  22. The DatAbase of the databeses

  23. EWWI EarlyWarningWebInterface

  24. A real-time web interface

  25. Thank you شكرا Grazie

More Related