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

▶

Dec 25, 2023 215 likes •326 views

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.

SLIDE 1

JACoW Team Meeting

JACoW Database Scientific Program Management System (SPMS) Conference System Functionality

Matt Arena, Fermi National Accelerator Laboratory

SLIDE 2

JACoW Team Meeting, Sincrotrone Trieste, Italy, M. Arena 2

System Requirements

Oracle 9i Database –

Standard Edition.

– Any OS supported by Oracle. – Inter Media (advanced search functionality) – Backup & Recovery – Disk RAID – Exports

File Server

– File upload script; minimal logic. – Apache (may use Oracle/Apache). – Backup & Recovery – RAID

SLIDE 3

JACoW Team Meeting, Sincrotrone Trieste, Italy, M. Arena 3

Installation

DDL and Source Codes Scripts run from a

single master script.

Specific DDL for PAC and EPAC.
Initial data load automatically follows.
1st synchronization.
Batch startup for email and sync.

SLIDE 4

JACoW Team Meeting, Sincrotrone Trieste, Italy, M. Arena 4

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

SLIDE 5

JACoW Team Meeting, Sincrotrone Trieste, Italy, M. Arena 5

Logging

Contributions – logging since PAC01
Profiles – New to JACoW SPMS
Synchronization – all times stored in UTC.
User-specified date/time format and

conversion.

SLIDE 6

JACoW Team Meeting, Sincrotrone Trieste, Italy, M. Arena 6

Abstract Submission

Demo – note favorite authors.

SLIDE 7

JACoW Team Meeting, Sincrotrone Trieste, Italy, M. Arena 7

Conference Program

Automatic generation of Session ID – based
n 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.

SLIDE 8

JACoW Team Meeting, Sincrotrone Trieste, Italy, M. Arena 8

Paper Submission

Meta data collected by SPMS.
Coordination of meta data and file upload.
Upload script independent of Oracle.
Better reporting statistics.

SLIDE 9

JACoW Team Meeting, Sincrotrone Trieste, Italy, M. Arena 9

Editing

Expanded logging.

– Editor trail. – Status trail

Active papers.
Paper reassignment.
Demo.

SLIDE 10

JACoW Team Meeting, Sincrotrone Trieste, Italy, M. Arena 10

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.