1 / 16

The Pisa Tracker construction database system implementation analysis of first laboratory

The Pisa Tracker construction database system implementation analysis of first laboratory measurements and comparison with HPK data DB walkthrough. System features. relational DB engine : MS Jet Access user interfaces linked to data ( back-end DB)

mercedes-horn
Download Presentation

The Pisa Tracker construction database system implementation analysis of first laboratory

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. The Pisa Tracker construction database • system implementation • analysis of first laboratory measurements and comparison with HPK data • DB walkthrough 1 Luca Latronico - Tracker technical meeting – Pisa 14/11/01

  2. System features • relational DB engine : MS Jet Access • user interfaces linked to data (back-end DB) • direct connection to lab instrumentation (LabView – DDE) • distributed on local NT network • core data db upgradeable to SQL-Server for real client/server architecture • security : NT accounts/permissions + DB project accounts • backups on command – possible automation? • read-only web interface implemented: ASP querying scripts on an IIS(W2K-server) connected to a data server copy through ODBC DSN • documentation at http://www.pi.infn.it/glast 2 Luca Latronico - Tracker technical meeting – Pisa 14/11/01

  3. backup User Interface I/O data server Data1 (SSD man) Data2 (SSD lab) Data1 Data1 Data2 Data2 Data3 Data3 Server interface Data3 (Ladders) DataBase architecture central repository Clean room User Interface I/O Instrumentation (DDE) Users offices replicas I/O Interface 1 production and quality monitoring Web client (ODBC) Interface 2 3 Luca Latronico - Tracker technical meeting – Pisa 14/11/01

  4. Tables relationships 4 Luca Latronico - Tracker technical meeting – Pisa 14/11/01

  5. Pisa DB local DB exchange DB exchange DB exchange table exchange table Data transfer scheme Local Institute/Manufacturer Pisa import SQL query export SQL query ftp exchange table • requests for manufacturers: • MSAccess2000 • run export query • upload Pisa server • requests for institutes: • local DB supporting SQL and ODBC • set up a server (Pisa, SLAC) • Currently 2 working examples using Access as local DB: • ladder assembly from local supplier • TMCM from UCSC 5 Luca Latronico - Tracker technical meeting – Pisa 14/11/01

  6. Hot development areas • finalize import of manufacturers data and lab tests: • import Excel/text data files – define data format • define data transfer between institutes: • connection to Oracle (SLAC) • possibly converge on MS Access • refine periodic reports • enrich web access • automatize statistical analysis (no native graphical tools) • straight export to Excel • work on excel macros (provide to everybody) 6 Luca Latronico - Tracker technical meeting – Pisa 14/11/01

  7. 17 SSD Lab vs HPK - current measurements 7 Luca Latronico - Tracker technical meeting – Pisa 14/11/01

  8. Lab vs HPK - current measurements 8 Luca Latronico - Tracker technical meeting – Pisa 14/11/01

  9. 17 SSD Lab vs HPK - capacitance measurements 9 Luca Latronico - Tracker technical meeting – Pisa 14/11/01

  10. Lab vs HPK - capacitance measurements 10 Luca Latronico - Tracker technical meeting – Pisa 14/11/01

  11. Lab vs HPK - capacitance measurements 11 Luca Latronico - Tracker technical meeting – Pisa 14/11/01

  12. Lab vs HPK - capacitance measurements 12 Luca Latronico - Tracker technical meeting – Pisa 14/11/01

  13. Lab vs HPK – depletion voltage 13 Luca Latronico - Tracker technical meeting – Pisa 14/11/01

  14. Lab geometrical measurements avrg 1.3 stdv 2.2 avrg –1.6 stdv 2.1 avrg 2.2 stdv 1.6 avrg –2.1 stdv 1.5 avrg 2.4 stdv 2.2 avrg 0.6 stdv 2.3 avrg –1.3 stdv 1.8 avrg 1.2 stdv 1.7 14 Luca Latronico - Tracker technical meeting – Pisa 14/11/01

  15. Lab geometrical measurements avrg 1.7 stdv 1.5 avrg -1 stdv 1.5 15 Luca Latronico - Tracker technical meeting – Pisa 14/11/01

  16. DB walkthrough ..\TkrGlastDB_Dev_nb.mdb Web interface walkthrough http://nbglast01/dbmain.html 16 Luca Latronico - Tracker technical meeting – Pisa 14/11/01

More Related