Important alternative solutions 10 recommended

Info icon This preview shows pages 41–62. Sign up to view the full content.

View Full Document Right Arrow Icon
Important alternative solutions 1.0 Recommended solution and rationale 1.0 Detailed overview of proposed system design 7.0 How will it work? (use case, usage scenarios, personas) What changes from as-is (DFD/ERD/Logic) Specific design considerations (UI, program, system) Potential problems and resolutions (from feasibility) Schedule to completion 12min present, 7min Q&A, 1min transition
Image of page 41

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Presentation Signups x
Image of page 42
Data Design Logical ERDs from analysis depict the “business view” of the data, but omit implementation detail Having determined the data storage format in your system design, physical data models are created to show implementation details and to explain more about the “how” of the final system ERDs contain the same components for both logical and physical models But, physical ERDs contain references to how data will be stored and that much more metadata are defined
Image of page 43

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Data Design
Image of page 44
Data Design Master file – core information repository Look-up file – static values, cached query results Transaction file – updates to master file Audit file – “before” and “after” images to see change History file – record of past transactions
Image of page 45

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Database Types Hierarchical – (legacy) graph based relationships Networked – (legacy) linked lists / pointers Relational – (current common) tables with primary & foreign keys, referential integrity (all links resolve correctly) Object Oriented - (emerging) attributes and behaviors Structured Query Language (SQL) – means to access DB
Image of page 46
Relational Databases
Image of page 47

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Relational Databases
Image of page 48
Multidimensional Databases
Image of page 49

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Transition to Physical ERDs
Image of page 50
Transition to Physical ERDs
Image of page 51

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Transition to Physical ERDs
Image of page 52
Denormalization Update CRUD matrix Storage efficiency VS. Speed of access Denormalization (replication & redundancy) Clustering (intra-file vs. inter-file) Indexing (mini-table lookup) Hardware optimization (estimate size & trajectory)
Image of page 53

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Denormalization
Image of page 54
Indexing
Image of page 55

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Volumetrics
Image of page 56
Optimization Update CRUD matrix Storage efficiency VS. Speed of access Denormalization / Replication Clustering Indexing Hardware optimization
Image of page 57

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
System Implementation Project Identification & Selection Maintenance Implementation Physical Design Logical Design Analysis Project Initiation & Planning
Image of page 58
System Implementation Development and Integration Testing Standards Documentation Installation/conversion Training Support Evolution
Image of page 59

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Development and Integration Start with the design products Data flow diagrams, ERDs, structure charts, logic models, UML models, interface and database designs Produce the computational components Write from scratch Buy packaged and adapt Generate from CASE tools and optimize Integrate the components Parameterize and tailor the components Write wrappers and glueware
Image of page 60
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern