day+2+1+page

day+2+1+page - S307: Data Management Introduction Vijay...

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

View Full Document Right Arrow Icon
S307: Data Management Introduction Vijay Khatri January 14, 2010 S307 Spring – 2010 1 Introduction
Background image of page 1

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

View Full DocumentRight Arrow Icon
Database Environment Data Management ntroduction Database Environment Introduction Design Definitions: Data Vs. Information, Metadata Database System Conceptual Database Hardware DBMS People Logical Physical Implementation Phases of Database Design Database vs. File System S307 Spring – 2010 2 Introduction Evolution of Database System
Background image of page 2
Database System y The database system consists of four major components: – Database • Collection of integrated and shared 4 data – Software Database Management System (DBMS) pplication programs 2 Application programs – Hardware Processor: CPU Memory: primary, secondary and tertiary y – People • Administrators, Designers, Developers, End Users 1 ard are S307 Spring – 2010 3 Introduction 3 Hardware
Background image of page 3

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

View Full DocumentRight Arrow Icon
Phases of Database Design g Process Output Requirements Analysis Requirements Specification onceptual Schema Conceptual Design Conceptual Schema Logical Design Logical Schema Physical Design Physical Schema DBMS-Specific DBMS-Independent Implementation Database S307 Spring – 2010 4 Introduction Maintenance Evolving Database
Background image of page 4
Database Environment Data Management ntroduction Database Environment Introduction Design Definitions: Data Vs. Information, Metadata Database System Conceptual Database Hardware DBMS People Logical Physical Implementation Phases of Database Design Database vs. File-based System S307 Spring – 2010 5 Introduction Evolution of Database System
Background image of page 5

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

View Full DocumentRight Arrow Icon
Example of a File-based System p y Field : Group of characters ith meaning File : Collection of related records customer.txt Alfred D'Onfrio, 312-000-8435, 215 Blue St, Chicago John Doe, 812-844-2784, 315 Green St, Bloomington Jane Doe, 317-222-2784, 415 Red St, Indianapolis with meaning , ,, p Record : Logically connected set of one or Order Application more fields S307 Spring – 2010 6 Introduction
Background image of page 6
Example of a File-based System [2] p y[ ] dd Field customer.txt Alfred D'Onfrio, 312-000-8435, 215 Blue St , Chicago, Betty D Onfrio h D 8 1 2 44 784 315 G t Bl i t S D Add Field John Doe, 812-844-2784, 315 Green St , Bloomington, Sam Doe Jane Doe, 317-222-2784, 415 Red St , Indianapolis, Betty D Onfrio Order Application Change Order Application S307 Spring – 2010 7 Introduction gp p
Background image of page 7

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

View Full DocumentRight Arrow Icon
Example of a File-based System [3] p y[ ] customer.txt lfred D'Onfrio 312 00 435 215 Bl e t Chicago Bett D nfrio Personnel Application Alfred D'Onfrio, 312-000-8435, 215 Blue St , Chicago, Betty D Onfrio John Doe, 812-844-2784, 315 Green St , Bloomington, Sam Doe Jane Doe, 317-222-2784, 415 Red St , Indianapolis, Betty D Onfrio Order Application S307 Spring – 2010 8 Introduction
Background image of page 8
Example: Simultaneous Access p 10:11 AM – 10:24 AM read customer.txt customer.txt lfred D'Onfrio 312 00 435
Background image of page 9

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

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

This note was uploaded on 02/02/2010 for the course BUS-S 307 taught by Professor Vijay during the Spring '10 term at Indiana.

Page1 / 30

day+2+1+page - S307: Data Management Introduction Vijay...

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

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