{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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 Dept of Computer Science & Engineering Arizona State University
Background image of page 1

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

View Full Document Right 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 Indexes & query optimizations  Integrity and Consistency Integrity constraints Minimize redundancy and therefore potential data inconsistency Management of Concurrency and Reliability Transactions & recovery
Background image of page 2
CSE 412 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 Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}