Data Volume and Usage Analysis - Database Management - Lecture Slides, Slides for Introduction to Database Management Systems. Himgiri Zee University
dharmaraaj
dharmaraaj3 November 2012

Data Volume and Usage Analysis - Database Management - Lecture Slides, Slides for Introduction to Database Management Systems. Himgiri Zee University

PDF (235 KB)
14 pages
3Number of download
1000+Number of visits
Description
Data Storage Concepts, Classification, Physical Storage Media, Speed of access, Cost per unit of data, Reliability, RAID, Multi Mirroring are the main points of this lecture.
20points
Download points needed to download
this document
Download the document
Preview3 pages / 14
This is only a preview
3 shown on 14 pages
Download the document
This is only a preview
3 shown on 14 pages
Download the document
This is only a preview
3 shown on 14 pages
Download the document
This is only a preview
3 shown on 14 pages
Download the document
Slide 1

Database Management

System

Lecture - 22 Docsity.com

Data Volume and Usage Analysis

Statistics about the size and usage of data plays critical role in data processing efficiency

Final step of logical DB design or first step in physical DB design

Docsity.com

Data Volume and Usage Analysis

Statistics collected during analysis phase from the users of the system

May not be accurate; give the tentative and relevant figures

Docsity.com

Data Volume and Usage Analysis

Docsity.com

Composite Usage Map

PART

1000

MANUFAC- TURED PART

PURCHASED

PART

O

QUOTATION

SUPPLIER

2500

40 % 70 %

50

140

200

60

40 80

75

(50) 40

70

700 400

Docsity.com

Designing Fields Field is smallest unit of application

data; corresponds to a simple attribute

Involves different decisions about fields

Docsity.com

Choosing Data Type Data type is defined as set of

values along with the operations that can be performed on them

Precisely depends on the particular DBMS

Docsity.com

Choosing Data Types

Involves four objectives – Minimize storage space – Represent all possible values – Improve data integrity – Support all data manipulation

Docsity.com

Coding Techniques

Values of the attributes with small domains can be replaced by codes

Codes can be stored in lookup table or can be hard coded, example

Docsity.com

Coding Example stId stName hobby

S1020 Sohail Dar Reading

S1038 Shoaib Ali Gardening

S1015 Tahira Ejaz Reading

S1015 Tahira Ejaz Movies

S1018 Arif Zia Reading

STUDENT

Docsity.com

Coding Example

stId stName hobby

S1020 Sohail Dar R

S1038 Shoaib Ali G

S1015 Tahira Ejaz R

S1015 Tahira Ejaz M

S1018 Arif Zia R

code Hobby

R Reading

G Gardening

M Movies

STUDENT HOBBY

Docsity.com

Controlling Data Integrity Concerns the possible values that

a field can assume

First such control is enforced by the data type

Some others are…

Docsity.com

Controlling Data Integrity Default value

Range control

Null values

Referential integrity

Handling missing data

Docsity.com

Database Management

System

Lecture - 22 Docsity.com

comments (0)
no comments were posted
be the one to write the first!
This is only a preview
3 shown on 14 pages
Download the document