CS122aSlides02

CS122aSlides02 - ICS122A / EECS116 Introduction to Data...

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

View Full Document Right Arrow Icon
1 ICS122A / EECS116 Introduction to Data Management Spring 2009 Prof. Mike Carey Bren School of ICS UC Irvine Slides based on previous CS122a lecture notes as well as  material borrowed from U-Wisconsin, Stanford, & Berkeley
Background image of page 1

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

View Full DocumentRight Arrow Icon
ICS122A/EECS116 Notes 02 2 Announcements HWs and projects This is your “easy week” – so enjoy it Please get yourself registered with Gradience ( Note: See the class mailing list for info on getting Gradiance and/or getting the textbook as an e-book) Discussion section meetings Every Friday morning, beginning with next week (note that this means there’s no meeting tomorrow!) We’ll use Friday sessions for HW- and project- Lectures Any lingering questions / logistics from the first lecture? (BTW, the web site now lists readings, too) NOTE: Please make this class interactive!
Background image of page 2
ICS122A/EECS116 Notes 02 3 Outline Database Design Process I have an application in mind How do I model my data…? Entity-Relationship Model Primitive notions Constraints Weak entity sets Multiway relationships Superclass/subclass relationships Aggregation (aggregate entity sets) Good design principles/practices
Background image of page 3

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

View Full DocumentRight Arrow Icon
ICS122A/EECS116 Notes 02 4 Choosing a DBMS Conceptual design Logical schema (from a DBMS independent data model to that of the chosen DBMS) Schema design (produce DBMS-independent high level data model by examining data requirements) Data requirements of the users Functional requirements (e.g. operations) Implementations •Physical schema (focusing on performance) •Criteria (response time, space utilization, transaction throughput) Requirement Analysis Database Design Process Logical design Physical design Iterative Refinement Loops Transaction design (high level specification s from examining application requirements, e.g. retrieval,s updates, and mixed transactions) specifications document produce  e.g. E/R data model type of DBMS (e.g.  relational, …) establish DBMS vendor selection (considering technical, economic, and organizational factors) transform set of DDL for chosen DBMS choose storage structures and  access paths (indexes) Database  create •Compilation and execution of DDL •Population of the database •Implementation of application programs (with embedded DML statements)
Background image of page 4
ICS122A/EECS116 Notes 02 5 Database Design Tools Help partially automate the design cycle Graphical interface to specify conceptual schemas Partially automated techniques to map to logical (DBMS dependent) model Features of a good design tool: Iterative : errors/shortcomings of original design found later can be corrected without full restart Interactive : any design choices made by system during design should be based on interaction with designer Feedback : a designer’s change made at logical and/or physical levels should be automatically translated to changes at higher levels
Background image of page 5

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

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

Page1 / 36

CS122aSlides02 - ICS122A / EECS116 Introduction to Data...

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

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