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

Introduction to Database Management

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.
Showing pages  1  -  2  of  14
The preview of this document ends here! Please or to read the full document or to download it.
Document information
Embed this 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

Docsity is not optimized for the browser you're using. In order to have a better experience please switch to Google Chrome, Firefox, Internet Explorer 9+ or Safari! Download Google Chrome