1 / 21

Chapter 9 & 10 Database Planning, Design and Administration

Chapter 9 & 10 Database Planning, Design and Administration. Database Application Lifecycle DBMS Selection Database Administration. Database Application Lifecycles. Database planning Systems definition Requirements collection and analysis Database design DBMS selection Application design

johndecker
Download Presentation

Chapter 9 & 10 Database Planning, Design and Administration

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. Chapter 9 & 10Database Planning, Design and Administration • Database Application Lifecycle • DBMS Selection • Database Administration

  2. Database Application Lifecycles • Database planning • Systems definition • Requirements collection and analysis • Database design • DBMS selection • Application design • Prototyping • Implementation • Data conversion and loading • Testing • Operational maintenance

  3. Database Planning • Business goals and plans • Information systems needs • Corporate data model • user needs • legal requirement

  4. System Definition • Scope & boundaries • Applications

  5. Requirement collection • Interview • Questionnaires • Observation • Documentation • Experience

  6. Requirement Analysis • Data centered approach • Entity-Relationship (ER) diagram • Normalization • Process center approach • Structured Analysis and Design (SAD) • Data Flow Diagram (DFD) • Hierarchical Input Process Output (HIPO)

  7. Database Design • Approaches • Top-down • Bottom-up or inside-out • Mixed • Components • Logical • Physical

  8. Logical Database Design • Steps • Conceptual data model • Logical data model (normalized & specific data model) • Global logical data model • Approaches • Centralized • View integration

  9. Optimal Logical Data Model • Structure validity • Simplicity • Expressability • Nonredundancy • Shareability • Extensibility • Integrity • Diagrammatic representation

  10. Physical Database Design • Storage structure • Access method • Security protection

  11. Application Design • Transactions • Retrieval • Update • Mixed • User interface (forms & reports) • Logical • Simple • Error handling • Help • Meaningful • Consistency • Status

  12. CASE Tools • Computer-Aided Software Engineering (CASE) • Types • Upper-Case: planning to design • Lower-Case: implementing, test, performance • Integrated-Case • Benefits: Productivity (effectiveness and efficiency) • Standard • Integration (repository) • Support structured methods • Consistency • Automation

  13. Prototyping • Working model • Pros • Define user’s requirements • Quick • Feasibility test • Low cost and risk, new technology • Cons • Costs

  14. Implementation • Data definition language (DDL) • Data manipulation language (DML) or embedded DML • Security & integrity control

  15. Data Conversion and Loading • Actual data conversion • Bridge

  16. Testing • Top-down • Bottom-up • Thread • Stress

  17. Operational Maintenance • Monitoring • Tuning • Upgrading

  18. DBMS Selection Criteria • Development or end-user language • Data structure • Flexibility • Security & Privacy • Restart & Recovery • Integrity • Hardware & software requirements • Performance • Monitoring • Ease of use • Data dictionary • Teleprocessing • Design tools • Vendor support • Costs • Future

  19. Database Administration Role • Physical database design • Security & integrity control • Performance monitoring • Tuning database

  20. Data Administration Role • Planning • Developing and maintaining standard • Developing policy & procedure • Design conceptual and logical database

  21. Assignment • Review chapter 9-10 • Read chapter 11-12

More Related