L23 ch14

Information about L23 ch14

Published on October 3, 2007

Author: Esteban

Source: authorstream.com

Content

Welcome to CMPE003 Personal Computers: Hardware and Software:  Welcome to CMPE003 Personal Computers: Hardware and Software Dr. Chane Fullmer Fall 2002 UC Santa Cruz Exams:  Exams Exams now on-line….. http://www.cse.ucsc.edu/classes/cmpe003/Fall02/ Must have your own Scantron form to determine test version you took Assignments:  Assignments Assignment #6 – The Last One  Due November 22, 2002 This Friday…don’t be late.. Using Spreadsheets – (M$ Excel) Generate a personal monthly budget spreadsheet Must printout in color if you use color for the conditional in part #10 http://www.soe.ucsc.edu/classes/cmpe003/Fall02/hw6_spreadsheet.html Database Management: Getting Data Together:  Database Management: Getting Data Together Chapter 14 Objectives:  Objectives Describe the hierarchy of data Explain the differences between files and databases List the four database models Describe the concept of data integrity Describe the functions of a database management system Describe the process of creating a database in general terms Compare and contrast relational and object-oriented databases Explain what a data warehouse is an how it differs from a database Computer Databases:  Computer Databases Track information Allows higher productivity as a result of better information Hierarchy of Data:  Hierarchy of Data Field Smallest meaningful unit of data Group of one or more characters that has a specific meaning Used as “key” to locate records Record Set of fields containing all information known about one entity Each record contains the same fields in the same sequence File Collection of related records Hierarchy of Data:  Hierarchy of Data File Processing:  File Processing File processing Data redundancy Database models reduce redundancy Saves storage space Saves update effort Time Accuracy Data (From Chapter 6) Organizing and Accessing:  Data (From Chapter 6) Organizing and Accessing Design (plan) for way data is Received Organized Stored how it will be processed Plan determined by programmer and/or systems analyst Data Getting Organized:  Data Getting Organized Character Field Record File Database Data Access Methods:  Data Access Methods Application determines how data must be accessed by users Data is organized based upon access method Organization method limits choice of storage medium Sequential:  Sequential Records are stored and accessed in order All records prior to the one requested must be read Magnetic tape storage Direct / Random Access:  Direct / Random Access Records are not physically stored in any order Go directly to the record to read Hashing – apply a formula to the key to produce the address of the record Collision – same address from different keys Updating in place Read, change, and return a record to the same place on disk DASD – Direct-Access Storage Device needed ie, Disk Drive Indexed:  Indexed Records are stored sequentially Index is generated that contains key and address Can be read in order = sequential Can be read out of order = random Processing Stored Data:  Processing Stored Data Batch Transaction Terminology Transaction – updates a record Master file – contains all the data Batch Processing:  Batch Processing Collect transactions into a transaction file and perform periodic updates Process Transactions are sorted by key field Computer matches the master and transaction keys Performs requested action – add, revise, delete New master file created Error report is printed Master file only current immediately after processing Batch Processing Stored Data:  Batch Processing Stored Data Transaction Processing:  Transaction Processing Processed upon request Real-time – process handled immediately Disk storage Direct access to desired record needed Immediate access to stored data Immediate updating of stored data Batch and Transaction:  Batch and Transaction Computer system may use both processing types based upon the application Transaction Activities relating to current needs Batch Updates per schedule Applications:  Applications Motor Vehicle Dept Transaction Police check for stolen car report Batch Motor vehicle records of owner information Retail – POS Transaction Item price Inventory updates as sale is made Batch Produce daily and weekly sales reports Banks Transaction Check balance Record cash withdrawal Batch Deposit left in the deposit drop Bank statement Database Models:  Database Models Database Types Relational Object-oriented Hierarchical Network Each type structures, organizes and uses data differently RDBMS Relational Database Management System:  RDBMS Relational Database Management System Organizes data into related tables (files) Table consists of rows and columns Tables linked based upon a common field (key) RDBMS Key:  RDBMS Key Primary key A field whose value uniquely identifies a record Foreign key Primary key of another table Used as link to other table May have duplicate values OODBMS Object-Oriented Database Management System:  OODBMS Object-Oriented Database Management System Manipulates object-oriented databases Object – represents a real-world entity Attributes / properties Data about the entity Methods / Actions Operations that work the data OODBMS Object-Oriented Database Management System:  OODBMS Object-Oriented Database Management System Compared to RDBMS More complex Steeper learning curve Skilled employees needed who earn high pay Combined Object/relational DBMS Relational database that incorporates some complex data types Data Integrity:  Data Integrity Degree to which data is accurate and reliable Integrity constraints – rules Acceptable values for a field Primary key values Foreign keys Integrity constraints must be enforced when data is entered or data is unreliable GIGO (Garbage in, garbage out) DBMS Database Management System:  DBMS Database Management System Levels of software Sophisticated Mainframe Expensive – tens of thousands of dollars Complex Planned and managed by computer professionals Simple PC Inexpensive – few hundred dollars User can set up and use the database DBMS Database Management System:  DBMS Database Management System Basic functions Create a database Enter data Modify the data as required Retrieve information from the database DBMS Create a Database:  DBMS Create a Database Data Dictionary / Catalog Stored data about the tables and fields within the database Per table Table name Relationships Per field Field name Data type Field size Validation rules DBMS Enter and Modify Data:  DBMS Enter and Modify Data Operations Adding new data Modifying data Deleting data Methods User interacts directly with DBMS Programs written by professional programmers access the data using special commands built into the DBMS DBMS Data Retrieval:  DBMS Data Retrieval Extracting the desired data from the database Primary forms Queries Reports Query:  Query Ask a question about the data Present criteria that selects data from the database Results in smaller portion of the database Query Language Prepare your query using English-like statements Proprietary query language in DBMS Query:  Query SQL Structured Query Language Entered directly by user Included in programs QBE Query-by-Example Graphical interface to specify your criteria Report:  Report Formatted presentation of data from the database Normally printed Designed using a report generator The DBMS Process:  The DBMS Process Enter the data Review the data and edit until accurate Describe the data The DBMS Process:  The DBMS Process The Plan… The Report… Concurrency Control:  Concurrency Control Databases are used concurrently by many users Problem if several users attempt to update the same record at the same time Record locking First user requests record Others are locked out for update Concurrency Control:  Concurrency Control Security:  Security Data is stored in a central location Problem: unauthorized access is major concern Benefit: easier to apply security measures Features User ID and password Privileges assigned to each user Read-only Update Backup and Recovery:  Backup and Recovery Why? Data can be accidentally damaged or destroyed Hardware can fail Forces of nature can cause physical damage Software or human errors can corrupt data Backup – copy made periodically Recovery – replaces the damaged database with the good backup Looking at the Data OLTP – Online Transaction Processing:  Looking at the Data OLTP – Online Transaction Processing Supports day-to-day database activities Little support for data analysis Looking at the Data Data Warehouses:  Looking at the Data Data Warehouses Databases designed to support ongoing operations Data is captured from the db over time Summary form Scheduled basis Period of time May include data from external sources Looking at the Data Data Warehouses:  Looking at the Data Data Warehouses Online Analytical Processing (OLAP) Analyzes the data Produces information for managers Data mining Statistical and artificial intelligence techniques Look for otherwise unrecognized -- Patterns Relationships Correlations Trends Helps managers make strategic business decisions

Related presentations


Other presentations created by Esteban

Chapter 15 Knee Conditions
28. 11. 2007
0 views

Chapter 15 Knee Conditions

S WATER
09. 10. 2007
0 views

S WATER

ELearning Conf collins
12. 12. 2007
0 views

ELearning Conf collins

Istvan Bilik
29. 10. 2007
0 views

Istvan Bilik

The Rise of Mussolini in Italy
01. 11. 2007
0 views

The Rise of Mussolini in Italy

intro cicero
01. 11. 2007
0 views

intro cicero

titanic
05. 11. 2007
0 views

titanic

00 18 pp7
05. 11. 2007
0 views

00 18 pp7

defence ficci
05. 11. 2007
0 views

defence ficci

bisnovatiykogan
13. 11. 2007
0 views

bisnovatiykogan

firm
22. 11. 2007
0 views

firm

UDSL Pres 4
26. 11. 2007
0 views

UDSL Pres 4

Insomnia
29. 11. 2007
0 views

Insomnia

ag environment
28. 12. 2007
0 views

ag environment

SAS781 016ArticleSlideShow
01. 01. 2008
0 views

SAS781 016ArticleSlideShow

Friendship Quotes
02. 01. 2008
0 views

Friendship Quotes

Lesson 16 Leader of Russia
26. 10. 2007
0 views

Lesson 16 Leader of Russia

Electronics 1 20 06
07. 11. 2007
0 views

Electronics 1 20 06

BATALIN FEB 13 04
07. 01. 2008
0 views

BATALIN FEB 13 04

Slides4c
07. 01. 2008
0 views

Slides4c

NRES322 14
08. 01. 2008
0 views

NRES322 14

Weese MRSA
19. 11. 2007
0 views

Weese MRSA

Shore Stephen
13. 12. 2007
0 views

Shore Stephen

Gerberding 07 AAIDD
24. 10. 2007
0 views

Gerberding 07 AAIDD

halloween history
05. 11. 2007
0 views

halloween history

june25 natural dhananjay
20. 02. 2008
0 views

june25 natural dhananjay

BEST03
24. 02. 2008
0 views

BEST03

ch9
27. 02. 2008
0 views

ch9

TrainingPanel
29. 02. 2008
0 views

TrainingPanel

080407
14. 03. 2008
0 views

080407

cares
27. 03. 2008
0 views

cares

UNIDO1
30. 03. 2008
0 views

UNIDO1

Praes WR Glaser DGfPs
16. 11. 2007
0 views

Praes WR Glaser DGfPs

Tireoidites CM 2006
28. 12. 2007
0 views

Tireoidites CM 2006

sommaruga
25. 10. 2007
0 views

sommaruga

Card Sort Indian Artifacts
19. 11. 2007
0 views

Card Sort Indian Artifacts

Exodus08
24. 10. 2007
0 views

Exodus08

Arthur Sadoff
28. 09. 2007
0 views

Arthur Sadoff

research industry partnerships
16. 11. 2007
0 views

research industry partnerships

Molvir Flavi Toga 01 19 06
24. 10. 2007
0 views

Molvir Flavi Toga 01 19 06

Chris Aalberts
25. 12. 2007
0 views

Chris Aalberts

mission mech garden intro
11. 12. 2007
0 views

mission mech garden intro

library agent
30. 10. 2007
0 views

library agent

FallOffDutySafety
06. 11. 2007
0 views

FallOffDutySafety

cours sts intro gen 2005
12. 11. 2007
0 views

cours sts intro gen 2005

JanConrad mar10 06
14. 11. 2007
0 views

JanConrad mar10 06

re nsdi06 slides
18. 12. 2007
0 views

re nsdi06 slides

AMC Italy Intro CMonticelli
31. 10. 2007
0 views

AMC Italy Intro CMonticelli

CROSSMARC Rome Intro
31. 10. 2007
0 views

CROSSMARC Rome Intro

Liz presentation
28. 12. 2007
0 views

Liz presentation

anheuser1
05. 11. 2007
0 views

anheuser1

AUST Overview for Website
06. 11. 2007
0 views

AUST Overview for Website

2b lanciotti
24. 10. 2007
0 views

2b lanciotti

OWK2006 Dixon SBDC
29. 10. 2007
0 views

OWK2006 Dixon SBDC

JAA etno maj 2005
01. 12. 2007
0 views

JAA etno maj 2005

Japansk encefalitt
24. 10. 2007
0 views

Japansk encefalitt

MM5 yhe
04. 01. 2008
0 views

MM5 yhe