Census BureauCensus Bureau

CCP03 ReviewCCP03 Review““NRFU POC”NRFU POC”

Date: 09/12/2007

System IPTSystem IPTDecennial Systems Database Modernization SupportDecennial Systems Database Modernization Support

CCP03 BackgroundCCP03 Background HistoryHistory

Mainframe applications supporting DRIS function have Mainframe applications supporting DRIS function have proven reliability and performance to support decennial proven reliability and performance to support decennial activitiesactivities

Future systems architecture will leverage Oracle RDBMS Future systems architecture will leverage Oracle RDBMS in places where mainframe computing has been usedin places where mainframe computing has been used

Initial efforts to convert specific business functions to Initial efforts to convert specific business functions to Oracle have failed to provide required performance, and Oracle have failed to provide required performance, and have negative implications to adoption strategy for new have negative implications to adoption strategy for new technologytechnology

CCP03 chartered to conduct POC on specific CCP03 chartered to conduct POC on specific functions (NRFU) in support of Oracle adoption functions (NRFU) in support of Oracle adoption effort for DRIS teameffort for DRIS team

22

CCP03 Completed EffortsCCP03 Completed Efforts

System/Application StudySystem/Application Study Evaluate Existing/Initial Implementation on Evaluate Existing/Initial Implementation on

Oracle Oracle Determine performance drivers on initial Determine performance drivers on initial

development platformdevelopment platform Evaluate Physical Design as Initially DeployedEvaluate Physical Design as Initially Deployed

Migrate Specific Functions to Enterprise RDBMS Migrate Specific Functions to Enterprise RDBMS Platform (UC&M and UECT)Platform (UC&M and UECT)

Load dataLoad data Validate Validate Performance tuningPerformance tuning

33

CCP03 Completed Efforts CCP03 Completed Efforts Functions Functions

Build UC&M data applicationBuild UC&M data application Update Logical Data model for use on RDBMSUpdate Logical Data model for use on RDBMS Create Physical Data Model (DDL creation)Create Physical Data Model (DDL creation) Deploy to both old and new Oracle platformsDeploy to both old and new Oracle platforms Execute performance comparisons between platformsExecute performance comparisons between platforms

UECT creation from UC&MUECT creation from UC&M Update Data model and create DDLUpdate Data model and create DDL Data extract based on StateData extract based on State UECT Validation/CompareUECT Validation/Compare Partitioning approaches Partitioning approaches

Full data extract for 2000 (state level)Full data extract for 2000 (state level) Simulate for 2008 run (LCO level)Simulate for 2008 run (LCO level)

Execute performance comparisons between platformsExecute performance comparisons between platforms

44

CCP03 Ongoing Efforts CCP03 Ongoing Efforts

Create RPS Processes Create RPS Processes Analysis and designAnalysis and design

Update Data model and create DDLUpdate Data model and create DDL Study Functions and create extractsStudy Functions and create extracts

Execute performance comparisons between Execute performance comparisons between platformsplatforms

55

66

 

   

Major Tasks for RPS…Major Tasks for RPS… Data ConversionData Conversion

Census 2000 T13 data to Universal Census 2000 T13 data to Universal Response Database SchemaResponse Database Schema

Post external interface data Post external interface data import and processingimport and processing

Preceding data to be used to refine Preceding data to be used to refine the RPS table design the RPS table design

URdbS response data tables will be URdbS response data tables will be further utilized as input to derive further utilized as input to derive processing component metrics.processing component metrics.

Performance and tuning will be Performance and tuning will be done for RPS applications. done for RPS applications.

THE END

77