JACoW Team Meeting JACoW Database Scientific Program Management - PowerPoint PPT Presentation

JACoW Team Meeting JACoW Database Scientific Program Management System (SPMS) Conference System Functionality Matt Arena, Fermi National Accelerator Laboratory

System Requirements • Oracle 9i Database – • File Server Standard Edition. – File upload script; minimal logic. – Any OS supported by Oracle. – Apache (may use Oracle/Apache). – Inter Media (advanced search functionality) – Backup & Recovery – Backup & Recovery – RAID – Disk RAID – Exports JACoW Team Meeting, Sincrotrone Trieste, Italy, M. Arena 2

Installation • DDL and Source Codes Scripts run from a single master script. • Specific DDL for PAC and EPAC. • Initial data load automatically follows. • 1 st synchronization. • Batch startup for email and sync. JACoW Team Meeting, Sincrotrone Trieste, Italy, M. Arena 3

Customization • Virtually no hard-coded information. • Demo: System Parameters • Demo: Maintenance Tables • PAC vs. EPAC – Presentation – Classification (Main) Classification – Sub-classification – Parent/Child Many to many JACoW Team Meeting, Sincrotrone Trieste, Italy, M. Arena 4

Logging • Contributions – logging since PAC01 • Profiles – New to JACoW SPMS • Synchronization – all times stored in UTC. • User-specified date/time format and conversion. JACoW Team Meeting, Sincrotrone Trieste, Italy, M. Arena 5

Abstract Submission • Demo – note favorite authors. JACoW Team Meeting, Sincrotrone Trieste, Italy, M. Arena 6

Conference Program • Automatic generation of Session ID – based on date, type (oral vs. poster) and location. • Automatic generation of Paper ID – based on Session plus sequencing algorithm. – PAC – sub-classification, affiliation, speaker – EPAC – country, affiliation, name • Oral papers number manually. JACoW Team Meeting, Sincrotrone Trieste, Italy, M. Arena 7

Paper Submission • Meta data collected by SPMS. • Coordination of meta data and file upload. • Upload script independent of Oracle. • Better reporting statistics. JACoW Team Meeting, Sincrotrone Trieste, Italy, M. Arena 8

Editing • Expanded logging. – Editor trail. – Status trail • Active papers. • Paper reassignment. • Demo. JACoW Team Meeting, Sincrotrone Trieste, Italy, M. Arena 9

Proceedings Production • One scripts generates: – Keywords (no longer entered by authors) – HTML pages • TOC • Author index • Keyword index • Various text files used to process PDF files. – SPIRES export file JACoW Team Meeting, Sincrotrone Trieste, Italy, M. Arena 10