Web Application for the Dual Web Application for the Dual Web Application for the Dual Web Application for the Dual Readout Calorimeter Database Readout Calorimeter Database Readout Calorimeter Database Readout Calorimeter Database Jennifer Karkoska Fermilab SIST 2011 Supervisor: Hans Wenzel August 9, 2011 1 8/09/2011
Contents Contents ● Motivation ● Structured Query Language (SQL) ● Dual Readout Calorimeter Database ● The Web Application ● JavaServer Pages (JSP) ● JavaScript (JS) ● Example ● Future Work DR Cal Web App J. Karkoska 2 8/09/2011
Motivation: Dual Readout Calorimeter Project Motivation: Dual Readout Calorimeter Project ● International collaboration trying to improve the models used for a dual readout calorimeter ● A dual readout calorimeter measures the energy resolution of Cherenkov and scintillation light ● Current goal: find the right materials for the calorimeter so the results from the Geant4 simulations can be as accurate as possible ● The data is organized into a database and be easily found and displayed via a Web application DR Cal Web App J. Karkoska 3 8/09/2011
Structured Query Language (SQL) Structured Query Language (SQL) ● SQL is a computer declarative language that accesses and modifies a database using a set of statements ● There are three kinds of SQL statements, but this database uses prepared statements to insert, update, retrieve, delete, and find specific pieces of data Example prepared statement: INSERT INTO tags (name,value,iid) VALUES (?,?,?) DR Cal Web App J. Karkoska 4 8/09/2011
Dual Readout Calorimeter Database Dual Readout Calorimeter Database ● All of the data in the database is stored in a series of tables ● Every plot can be identified by an ID number, category , tag names , and tag values Plot ID: 206 Category: SiPM Tag Name: Value Detector Ham-025U_4 Date 110103 Property IV_forw_diode Scale log DR Cal Web App J. Karkoska 5 8/09/2011
DR Image Web Application DR Image Web Application ● Allows a user to find and display plots from the database , just by interacting with a Web page ● Originally, this application only allowed the user to select a plot based on an ID number Project goal : allow the user to select a plot by category, tags, and values Tag Values : Tag names : Categories : ● Full_fit ● Detector ● Ham-025U_4 ● Crystals ● Linear_fit ● Mode ● Transmission ● SiPM ● Crystal_type ● IV_forw_diode ● Emission ● Crystals_2011 ● Sample ● Lin ● Excitation ● Date ● Log ● BSO ● Method ● Vs_sample_10 ● F10 ● Property ● Vs_undoped ● F19 ● Scale ● Compare DR Cal Web App J. Karkoska 6 8/09/2011
JavaServer Pages (JSP) JavaServer Pages (JSP) ● JSP : a combination of Java (processes the information) and HTML (organizes the layout of the Web page) Client DR Cal Web App J. Karkoska 7 8/09/2011
JavaScript (JS) JavaScript (JS) JSP: useful for collecting user data, but not very user-interactive ● JS : run on the client's side and allows for more user interaction than JSP JS: JSP: ● User interaction ● User input ● Tooltips ● Text fields ● Image pop-ups ● Check boxes ● Dynamic tables ● Database connection ● Image zooming DR Cal Web App J. Karkoska 8 8/09/2011
DR ImageDB Home Page DR ImageDB Home Page DR Cal Web App J. Karkoska 9 8/09/2011
Example Example ● Category: Crystals DR Cal Web App J. Karkoska 10 8/09/2011
Example Example ● Category: Crystals ● Tags: Compare AND Crystal_type DR Cal Web App J. Karkoska 11 8/09/2011
Example Example ● Category: Crystals ● Tags: Compare AND Crystal_type ● Values: vs_sample_10 AND BSO DR Cal Web App J. Karkoska 12 8/09/2011
Example (cont) Example (cont) DR Cal Web App J. Karkoska 13 8/09/2011
Example (cont) Example (cont) Search all columns: BSO6_A DR Cal Web App J. Karkoska 14 8/09/2011
Example (cont) Example (cont) Sort by (multiple) columns: sort by sample in ascending order DR Cal Web App J. Karkoska 15 8/09/2011
Example (cont) Example (cont) Hover over plot ID number for a preview of the image DR Cal Web App J. Karkoska 16 8/09/2011
Final Examples Final Examples View individual plots with table of tags & values Zoom & pan on an image Open a plot as a pop-up to view multiple plots side-by-side DR Cal Web App J. Karkoska 17 8/09/2011
Conclusion & Future Work Conclusion & Future Work ● The Dual Readout Calorimeter Project is an international collaboration trying to find the best materials to use to make the DR Calorimeter as accurate as possible ● Hundreds of thousands of tests might eventually be run in Geant4, which will accumulate a great deal of data that needs to be stored DR Cal Web App J. Karkoska 18 8/09/2011
Conclusion & Future Work Conclusion & Future Work ● Ultimate goal: the database will become a knowledge base of information where all of the data collected over the next few years will be stored. ● If a physicist wants to use a specific type of crystal or detector, the knowledge base will know all of the information that needs to be put into a Geant4 simulation ● Additionally, the Web application is a general tool that can be used as a framework for other databases DR Cal Web App J. Karkoska 19 8/09/2011
Acknowledgements Acknowledgements ● Supervisor: Hans Wenzel ● Adam Para and the Simulation of Optical Processes Group ● Dr. James Davenport ● Linda Diepholz, Jamieson Olsen, Dianne Engram, and the entire SIST Committee ● Mentors: Dave Peterson & Elmie Peoples DR Cal Web App J. Karkoska 20 8/09/2011
" t p i l r o c o s T a / v s a j / j " p / t t p p x i A e r t c b " s e = a W ImageServiceAdapter ia = new SQL Databases e v p a e y j ImageServiceAdapterImpl(); g " > J t = a a t t m p v p e i a g i I r r S a R c c u s c s D / r < g < i n / p " > a t = " l c s j r . SELECT iid FROM s p i public.tags WHERE iid T L i s t < I n t e g A e r r > r a I y m L a i IN (%s) s g t e < L I n i s t t e g = e n r e > w ( ) ; SELECT * FROM Java Programming “public”.tags <form name="myform" action I N S E ="PlotFrame.jsp" method="post" R T I N ( n T a m O e t , a v g a s l u ( e ? , , i ? i , ? d ) ) V A L target="_blank"> U E S Java Servlets Geant4 simulations s Knowledge base e g a P r e v r e S a v a J DR Cal Web App J. Karkoska 21 8/09/2011
Recommend
More recommend
