1 / 7

Census Bureau

Census Bureau. System IPT Decennial Systems Database Modernization Support. CCP03 Review “NRFU POC”. Date: 09/12/2007. CCP03 Background. History Mainframe applications supporting DRIS function have proven reliability and performance to support decennial activities

Download Presentation

Census Bureau

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Census Bureau System IPT Decennial Systems Database Modernization Support CCP03 Review “NRFU POC” Date: 09/12/2007

  2. CCP03 Background • History • Mainframe applications supporting DRIS function have proven reliability and performance to support decennial activities • Future systems architecture will leverage Oracle RDBMS in places where mainframe computing has been used • Initial efforts to convert specific business functions to Oracle have failed to provide required performance, and have negative implications to adoption strategy for new technology • CCP03 chartered to conduct POC on specific functions (NRFU) in support of Oracle adoption effort for DRIS team

  3. CCP03 Completed Efforts System/Application Study • Evaluate Existing/Initial Implementation on Oracle • Determine performance drivers on initial development platform • Evaluate Physical Design as Initially Deployed • Migrate Specific Functions to Enterprise RDBMS Platform (UC&M and UECT) • Load data • Validate • Performance tuning

  4. CCP03 Completed Efforts Functions • Build UC&M data application • Update Logical Data model for use on RDBMS • Create Physical Data Model (DDL creation) • Deploy to both old and new Oracle platforms • Execute performance comparisons between platforms • UECT creation from UC&M • Update Data model and create DDL • Data extract based on State • UECT Validation/Compare • Partitioning approaches • Full data extract for 2000 (state level) • Simulate for 2008 run (LCO level) • Execute performance comparisons between platforms

  5. CCP03 Ongoing Efforts • Create RPS Processes • Analysis and design • Update Data model and create DDL • Study Functions and create extracts • Execute performance comparisons between platforms

  6. Major Tasks for RPS… • Data Conversion • Census 2000 T13 data to Universal Response Database Schema • Post external interface data import and processing • Preceding data to be used to refine the RPS table design • URdbS response data tables will be further utilized as input to derive processing component metrics. • Performance and tuning will be done for RPS applications.

  7. THE END 7

More Related