midterm review

midterm review - M i dter m Revi ew Yi Chen Dept of...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Midterm Review Yi Chen Arizona State University
Background image of page 1

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

View Full DocumentRight Arrow Icon
CSE 412 2 Why DBMS? Generality and Declarativity --  Database Abstraction Logical structure: program or query interface overall database design; seen by the DB designer views  that various users get to see Physical structure: Organization on disk, indexes, etc. Efficiency and Scale Integrity and Consistency Integrity constraints Minimize redundancy and therefore potential data inconsistency Management of Concurrency and Reliability Transactions & recovery
Background image of page 2
3 PHASE DATA PROCESSING 1. Requirements Collection & Analysis Data Requirements Processing Requirements 2. Data Modeling / Conceptual Design (DBMS independent) Conceptual Schema Design Processing Design 3. Choice of DBMS 4. Logical Design Mapping Data Models to Schemas of a Specific DBMS 5. Physical Design Choosing storage
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/11/2009 for the course CSE 412 taught by Professor Davulcu,h during the Fall '08 term at ASU.

Page1 / 12

midterm review - M i dter m Revi ew Yi Chen Dept of...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online