Database Database Assembly LineAssembly Line

SIRxsSIRxs

Connect to Columbia ServerConnect to Columbia Server

CitrixCitrix Web based applicationWeb based application Runs SIRxs on ServerRuns SIRxs on Server

SIR or SIRXSSIR or SIRXS

SIRXS icon takes me to SIRXS ATC and DBsSIRXS icon takes me to SIRXS ATC and DBs SIR icon takes me to SIR2002 ATC and DBsSIR icon takes me to SIR2002 ATC and DBs

ATC (Air Traffic Controller)ATC (Air Traffic Controller)

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

Counting DatabaseCounting Database

Central Location for DCC Database InfoCentral Location for DCC Database Info New Databases RegisteredNew Databases Registered

Export SIR2002 DBExport SIR2002 DB

Rename Export file: JCP to JCPXSRename Export file: JCP to JCPXS

DCC Import DB ToolDCC Import DB Tool

Use DCC drop down from SIR sessionUse DCC drop down from SIR session Standard DCC Tools Available to all DBsStandard DCC Tools Available to all DBs ‘‘Import database’ Handles Conversion to SIRXSImport database’ Handles Conversion to SIRXS

New SIRXS DatabaseNew SIRXS Database

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

New Database Fully IntegratedNew Database Fully Integrated

Registered in COUNTINGRegistered in COUNTING Connectable through Citrix and the ATCConnectable through Citrix and the ATC Part of the DCC backup routinePart of the DCC backup routine Codebook createdCodebook created SPSS files automatically created nightlySPSS files automatically created nightly SearchableSearchable Modifiable (using DCC Restructure tool)Modifiable (using DCC Restructure tool)

Other DCC ToolsOther DCC Tools

CodebookCodebook SPSS FilesSPSS Files Main MenuMain Menu Modify SchemasModify Schemas Search FunctionalitySearch Functionality

CodebookCodebook

All schema definitionsAll schema definitions HTML: linkable browser friendly pagesHTML: linkable browser friendly pages

SPSS FilesSPSS Files

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

Main MenuMain Menu

Generic Default Navigational ScreenGeneric Default Navigational Screen

Modify SchemasModify Schemas

Automatic RestructuringAutomatic Restructuring

Search FunctionalitySearch Functionality

Seach valuesSeach values Search schemaSearch schema

The EndThe End

Data Coordinating CenterData Coordinating Center www.dccny.orgwww.dccny.org