1 / 17

Case study on data modelling: Creating the FlexSIS data model

13 November 2007. Case study on data modelling: Creating the FlexSIS data model. 2. Objectives of presentation. Share data modelling experienceAssist attendees to decide how data modelling might be of benefit to themDescribe an effective method for data modellingPresent an interpretation of the Data Architecture" function.

juro
Download Presentation

Case study on data modelling: Creating the FlexSIS data model

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. Case study on data modelling: Creating the FlexSIS data model Enterprise Architecture Symposium 2007

    2. 13 November 2007 Case study on data modelling: Creating the FlexSIS data model 2 Objectives of presentation Share data modelling experience Assist attendees to decide how data modelling might be of benefit to them Describe an effective method for data modelling Present an interpretation of the “Data Architecture” function

    3. 13 November 2007 Case study on data modelling: Creating the FlexSIS data model 3 About FlexSIS Suite of applications supporting student administration: Core desktop application Reporting portal Student self service portal Batch processes Interfaces Built and maintained in-house Development started in 1996

    4. 13 November 2007 Case study on data modelling: Creating the FlexSIS data model 4 Rationale for creating the data model Document the “as is” system To support: Strategic planning Roadmap development for student administration Development Ongoing development and maintenance activity Ad hoc reporting Empower specialist staff

    5. 13 November 2007 Case study on data modelling: Creating the FlexSIS data model 5 Rationale – Expected benefits Common understanding Reduce key-person dependency Produce better systems Simpler designs More aligned to the University needs Reduce development timelines, costs and risk

    6. 13 November 2007 Case study on data modelling: Creating the FlexSIS data model 6 Process overview Select tools Analyse/profile the data Create data model: Reverse engineer Group tables logically Add table logical names Add table relationships Create E-R diagrams Create data dictionary: Determine scope Add table and column descriptions Publish (HTML)

    7. 13 November 2007 Case study on data modelling: Creating the FlexSIS data model 7 The FlexSIS data model (“as is”)

    8. 13 November 2007 Case study on data modelling: Creating the FlexSIS data model 8 FlexSIS data dictionary

    9. 13 November 2007 Case study on data modelling: Creating the FlexSIS data model 9 Some statistics

    10. 13 November 2007 Case study on data modelling: Creating the FlexSIS data model 10 Tools – Data modelling Tool used: PowerDesigner Key strengths: Reverse engineering Model synchronisation Diagramming Data dictionary support Generating reports Metadata extensions VB Script to build custom functionality Intuitive user interface

    11. 13 November 2007 Case study on data modelling: Creating the FlexSIS data model 11 Tools – Data profiling

    12. 13 November 2007 Case study on data modelling: Creating the FlexSIS data model 12 Tools – Table dependency analysis

    13. 13 November 2007 Case study on data modelling: Creating the FlexSIS data model 13 Data dictionary - Approach Determine scope Do diagram at a time Diagrams define high level chunks of work Document tables and columns of diagram Use template to guide content Follow standard style Review and sign-off descriptions Publish model regularly Track progress regularly Accept feedback after sign-off Engage business analysts and developers

    14. 13 November 2007 Case study on data modelling: Creating the FlexSIS data model 14 Data dictionary – Tracking progress

    15. 13 November 2007 Case study on data modelling: Creating the FlexSIS data model 15 Some key points Model is “source of truth” for: data structure designs data element descriptions Data dictionary published as report extracted from the data model Model driven approach to: the data dictionary problem data architecture Paves a path to enterprise modelling…

    16. 13 November 2007 Case study on data modelling: Creating the FlexSIS data model 16 Enterprise modelling…

    17. 13 November 2007 Case study on data modelling: Creating the FlexSIS data model 17 Outcomes Model being used by business analysts, developers and some specialist staff for: Development, data migration, data cleansing, reporting, training provision Model maintained in a single repository: easily accessible knowledge base supporting greater collaboration Standard data modelling approach defined Model seen as valuable resource for migration to future student admin system Supporting tactical and strategic needs

    18. 13 November 2007 Case study on data modelling: Creating the FlexSIS data model 18 What next ? Conceptual data model Application interfaces documentation Support SOA initiative Wider rollout of standard data modelling practice Metadata initiatives Other…

More Related