Database Assembly Line

1
Database Assembly Line

• SIRxs

2
Connect to Columbia Server

• Citrix
• Web based application
• Runs SIRxs on Server

3
SIR or SIRXS

• SIRXS icon takes me to SIRXS ATC and DBs
• SIR icon takes me to SIR2002 ATC and DBs

4
ATC (Air Traffic Controller)

• Central Location for Connecting to a DB
• User and Password Authentification from Citrix
• See only the appropriate databases

5
Counting Database

• Central Location for DCC Database Info
• New Databases Registered

6
Export SIR2002 DB

• Rename Export file JCP to JCPXS

7
DCC Import DB Tool

• Use DCC drop down from SIR session
• Standard DCC Tools Available to all DBs
• Import database Handles Conversion to SIRXS

8
New SIRXS Database

• Extract new DB name from Export file
• Rename database in new Export file
• Remove password for SIRXS in new Export file
• Make database folder on the Columbia server
• Import file, creating SIRXS database
• If SYSTEM.ALLCALL exists, run it
• Otherwise, create new default PQL screens
• Call DIALOG.MAINMENU to see what you got
• Register database with COUNTING

9
New Database Fully Integrated

• Registered in COUNTING
• Connectable through Citrix and the ATC
• Part of the DCC backup routine
• Codebook created
• SPSS files automatically created nightly
• Searchable
• Modifiable (using DCC Restructure tool)

10
Other DCC Tools

• Codebook
• SPSS Files
• Main Menu
• Modify Schemas
• Search Functionality

11
Codebook

• All schema definitions
• HTML linkable browser friendly pages

12
SPSS Files

• SPSS Files for every record type
• ONEJCPXS.sav for key-less records

13
Main Menu

• Generic Default Navigational Screen

14
Modify Schemas

• Automatic Restructuring

15
Search Functionality

• Seach values
• Search schema

16
The End

• Data Coordinating Center
• www.dccny.org