day+3+on+1+page

day+3+on+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 19, 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-based System S307 Spring – 2010 2 Introduction Evolution of Database System
Background image of page 2
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 3 Introduction
Background image of page 3

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 [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 4 Introduction gp p
Background image of page 4
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 Customer Relationship 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 5 Introduction
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: Simultaneous Access p 10:11 AM – 10:24 AM read customer.txt customer.txt lfred D'Onfrio 312 00 435 215 Blue St Chicago Betty D nfrio Customer Relationship 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 6 Introduction
Background image of page 6
Example: Simultaneous Access [2] p[ ] 10:11 AM -- 10:24 AM read customer.txt customer.txt lfred 'Onfrio 312 00 435 215 Blue St Chicago Betty nfrio Customer Relationship Application Alfred D Onfrio, 312-000-8435, 215 Blue St, Chicago, Betty D Onfrio John Doe, 812-844-2784, 315 Amber St, Bloomington, Jack Willis Jane Doe, 317-222-2784, 415 Red St, Indianapolis, Betty D Onfrio Order Application 10:13 AM write customer.txt S307 Spring – 2010 7 Introduction Bottom Line: Difficult to share data
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: Program-Data Dependence pg p Change Personnel Application Customer Relationship Application customer.txt Alfred D'Onfrio, 312-000-8435, 215 Blue St, Chicago, IL 60601, Betty D Onfrio, 812-445-3456 John Doe, 812-844-2784, 315 Amber St, Bloomington, IN 47403, Jack Willis , 812-555-9999 Jane Doe, 317-222-2784, 415 Red St, Indianapolis, IN 46231, Betty D Onfrio, 812-445-3456 Order Application Add Field Change Order Application S307 Spring – 2010 8 Introduction Bottom Line: Excessive Program Maintenance
Background image of page 8
Example: Data Duplication pp Betty D’Onfrio” phone number Customer Relationship Application customer.txt Alfred D'Onfrio, 312-000-8435, 215 Blue St, Chicago, IL 60601, Betty D Onfrio, 812-445-3456 John Doe, 812-844-2784, 315 Amber St, Bloomington, IN 47403, Jack Willis , 812-555-9999 Jane Doe, 317-222-2784, 415 Red St, Indianapolis, IN 46231, Betty D
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 / 45

day+3+on+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