Data CoE - Guide - Current State Analysis



[pic]

Defence Equipment & Support

Data Centre of Excellence

Template

Current State Analysis

|written by: |Lawrence Grech, Dinyar Cooper |approved by: | |

|unit: |Glue Reply, Data Management |doc ID: | |

| |Practice | | |

|review: | |issue date: | |doc. model | |

|Privacy notes | |

State of the document

|Review |date |changes |(approved by) |

| | | | |

| | | | |

| | | | |

| | | | |

| | | | |

| | | | |

Changes summary

|Main changes list compared to the previous version:| |

| | |

| | |

| | |

| | |

| | |

| | |

| | |

| | |

| | |

| | |

| | |

| | |

Attachments:

Plan

1 Schedule

[pic]

2 Durations

[pic]

3 Involvement

[pic]

Contextual Current State Analysis

1 Documentation

|Title |Document curator |Location/reference |Date Created |Date updated |Comment |

| |contact info | | | | |

2 Functional purpose

[pic]

3 Financial valuation of data repository

[pic]

4 Organisational Context

|Dept/team |Data producer/consumer |Applications/interfaces involved |Process steps involved |

|Data Owner | | | |

|Data Steward | | | |

|Data Administrators | | | |

|Data Modellers | | | |

|Etc. | | | |

5 Business Process Context

[pic]

6 Business rules

[pic]

7 Projects and Change Management

Date on which projects where listed (dd-mmm-yyyy):

|Programme name |Project name |Programme manager |Project manager |Start date |Completion date |

8 Data Exports

|Source of data |Target |Data transmission |Data Format (e.g. flat |Purpose |Description of import |

| | |technology (FTP, |file, XML etc.) | |process |

| | |Informatica etc.) | | | |

9 Enterprise Data Architecture Context

[pic]

10 Standards, Methods, Tools Used

|Name |Standard, Method, Tool |References to further description |Purpose |

| | | | |

11 Technical Context

Do not reveal details that could constitute a security breach. If in doubt consult Security.

Describe;

• Hosting hardware with versions

• Disk space

• Capacity analysis of storage and its consumption trends by the data repository

• Operating systems with versions

• Database Management software specification

• Licensing details and restrictions

• Operating team contact

• Database Administrator team contact

• Infrastructure Access to the hosting hardware

12 Performance Service Levels

[pic]

13 Operational Context

[pic]

14 Backup and Archival Context

[pic]

15 Special Security Considerations

[pic]

16 Anecdotal Evidence

[pic]

17 Data Challenges

[pic]

Structural Current State

The resultant structural profiling will be held in the data profiling tool.

1 Existing design documents

|Location |Description |Modelling tool (Erwin, Visio |Type (Architectural, |Subject areas |

| | |etc.) |Conceptual, Logical, Physical | |

| | | |etc.) | |

| | | | | |

2 Instances of Data Repository

|Instance type |Size (Gb) |Availability for |Number of records | | |

|(Production, Backup, | |profiling (comment) | | | |

|Read only, extract, | | | | | |

|redo logs etc.) | | | | | |

3 Full or Partial Profiling Requirement

• List of tables/files/fields that can be excluded.

• Temporary tables/files that can be excluded

• Decision on whether to take a statistical sample or complete scan of the records/rows

• Details of any pre-processing required (e.g. XML documents to be loaded into relational tables for profiling)

4 Commence Profile

See templates for Request for Information and Commencement Notice

Delta Profiling

The resulting data repository profiling will be held in the data profiling tool.

1 Delta Profiling Plan

|Processing windows available|Type of delta profiling |If data which tables/files? |Will the profiling operate |Does the profiling terminate|

| |required | |within the allotted |if it exceeds the processing|

| |(Structural/Data/Both | |processing window (Benchmark|window? |

| | | |may be required) | |

| | | | | |

2 Commence Delta Profile

See templates for Request for Information and Commencement Notice

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download