1-2-5 Physical Design of Databases · ITPEC FE Textbook

ITPEC Textbook

Reading settings

Text size 20 px

Line spacing 1.75

Theme

Reading mode

Guest settings stay on this device. Sign in to sync reader settings.

Chapter 4 · DatabasePractice

Highlighted text? Practice this concept. Highlighted passages and figures open related questions.

Practice related questions (2)Progress & bookmarks

Current section

1-2-5 Physical Design of Databases

p. 254

Practice this section 2 linked exam questions with default filters

Progress

Not marked complete

Related questions in this lesson 2

Index for improving database search access2

Progress and bookmarks

p. 254

1-2-5 Physical Design of Databases

Physical design of databases is the process of creating physical data models in consideration of the database product (e.g., database software) to be implemented. Here, the data type that is most appropriate for each attribute is selected from the available data types in the database product, and memory format or mapping on hard disk is reviewed. In addition, required disk capacity is estimated from the anticipated data volume, and performance evaluation, such as processing efficiency or access efficiency, is conducted. At that time, it is also necessary to consider defining index (i.e., search key) for improving access efficiency. When the size of the database is large, the search efficiency can be significantly increased by defining index for the attributes that are frequently used in search operation. However, it should be noted that disk capacity for recording index is required and the process of updating the attributes of index requires more time than the usual processing of attributes. · 2 questions

Section progress

Practice index for improving database search access (2)

Original chapter exercises

Original chapter exercises →

New FE Textbook Vol.1 · IT Fundamentals · First Edition, April 2015