NAVAL SEA LOGISTICS CENTER

1
NAVSEA Data Environment - Update
2
Navy Maintenance
Planning Configuration Management
Ship Maintenance
Fleet Readiness Supply Supportability
3
WHY NDE?

• Too many databases
• Redundant Data
• Different Data Structures
• Too many File Bridges
• Redundant Processes
• Lost Data
• Data Synchronization (or lack of)
• COST of Database Maintenance
• Complexity or Inability to See or Retrieve
  Complete Data View

4
Current Process (Partial)
NDE
Client
3M History
P-6/RMAIS
CDMD O/A
FMPMIS
Client
Client
Client
5
NDE
NDE
Client
Client
Client
Client
Client
Client
Client
Client
Client
6
NDE Update

• Data Modeling
• Adopted DoD 8320.1-M-1 Data Dictionary Standards
• Assigned a Data Librarian
• Completed Security Object Model (NDE)
• Java Objects
• Designed Security Object
• Reporting Objects
• Reviewing Silverstream/Crystal Report Writer
  Capability
• Started Security Plan (Risk Assessment)
• Client Design Teams
• FMPMIS - Logistics/Program/Execution
• CDMD-OA - Configuration Replication from Central
  to NDE
• CDMD-OA - Viewer Client
• MAINT (P6) - 2K Loader/Broker/Tracker
• MAINT SIMA Module - Execution
• 3M History Reports/Adhoc

7
NDE Design Process

• User/Customer Input
• Site visits during all design phases
• Develop Business Model for each process
• Develop a Design Spec for each business process
• Database Modeling Process
• Design Team submits changes/additions to
  Librarian and DB Architect for assimilation
• Librarian approves and submits changes to Design
  DBA
• Design DBA changes DB at PAC and LANT
• Configuration Management Plan
• In process of creating the CMP for NDE
• CMP will document the process of changing NDE
• Setting up Test and Production Silverstream and
  Oracle databases
• Need to establish a Senior Steering Group (SSG)
  to over see the NDE Configuration Control Boards
  (CCB) - FMP, CDMD-OA, MAINT, 3M-HIS.

8
NDE Java/Business Objects
3-Tier Architecture
Silverstream
Oracle (NDE) Userid/Pw Roles
1
2
DSO Data Source Objects
Business Objects
Application Level Business Rules
JAVA ScreenConstructor
HTML ScreenConstructor
3
Data Level Business Rules in Stored Procedures
HTML
J-Runner
Client Browser
8
9
NDE Security Model
Silverstream
Oracle Userid/Pw Roles/Objects
Security Business Object
HTML Page Contruct
Methods login object_construct other
HTML
Client Browser
9
10
NDE Security Database Model
nde_sec_obj
nde_userid
nde_sec_obj_userid
sec_obj_seq program option object
userid_seq sec_obj_seq
userid_seq
nde_userid_roles
nde_sec_obj_role
nde_sec_role
sec_role_seq role
userid_seq sec_role_seq
sec_role_seq sec_obj_seq
10
11
NDE Security Example
nde_userid
1, chris 2, mary 3, ute
nde_userid_roles
nde_sec_obj_userid
1, 1 1, 2 2, 2 3, 1
1, 1, VTrue 2, 1, VFalse 1, 2, UTrue 2, 1,
VFalse 3, 3, VFalse
nde_sec_obj
1, btn_back 2, avl.mdr 3, menu avl
nde_sec_obj_role
nde_sec_role
1,1, VFalse 2,1, VTrue
1, viewer 2, spm
11
12
NDE-Functional View
FMP
CM
MAINT
UFF-ECP
Alteration Planning
Work Packaging Kitting
JCF
Execution (AIM/Supship)
CDMD OA
Configuration Parts
NWPS
CSMP
JOBS
Alterations
Scheduling (AIPS)
IMA
BOM
2K
Program Alts
Avails
P1 ()
Funding Docs
12
13
NDE-Maintenance (Phase I)
2K is linked to configuration, assigned to a Port
Engineer (PE), and the record is checked for
valid data
2Ks can be entered online into NDE
Execution (AIM/Supship)
2K
PE/TYCOM Screening and Work Brokering
JOBS
IF_JOBS
CDMD OA
IMA
2K is transferred by SALTS, RADCOM, or Disk via
TYCOM
CDMD OA
2K
Planning Yard
2K may be assigned to Planning Yards for the 2ES
development if non existent. NDE has a 2ES
writer online.
Planning products are linked via CDMD-OA and NDE.
PE can view all products developed for a
component/sys
13
14
14
15
(No Transcript)
16
Actual FY 98 Expenditures
Item FY 98 Requirement MRMS -
P6 1700 Fleet Support and Training
700 RM AIS Proj Mgt 500 File
Bridges/Interfaces 406 JCALS 200 SE RMC
Transition 142 Gulf Coast MRP II Pilot
500 N43 Web Site 20 NAVSUP Cuts
41 Program Total 4209