Đang chuẩn bị liên kết để tải về tài liệu:
Lecture Database design, application development and administration - Chapter 8: Physical database design

Chapter 8 - Physical database design. Chapters 5 to 7 covered the conceptual and the logical design phases of database development. You learned about entity relationship diagrams, data modeling practice, schema conversion, and normalization. This chapter extends your database design skills by explaining the process to achieve an efficient implementation of your table design. | Chapter 8 Physical Database Design Welcome to Chapter 8 on Physical Database Design. This is the final phase of the database development process. Physical database design transforms a table design from the logical design phase to database implementation. Objectives Describe the inputs, outputs, and objectives of physical database design List characteristics of sequential, Btree, hash, and bitmap index file structures Appreciate the difficulties of performing physical database design and the need for periodic review of physical database design choices Understand the trade-offs in index selection and denormalization decisions Understand the need for good tools to help make physical database design decisions Understand the choices made by a query optimizer and the areas in which optimization decisions can be improved Outline Overview of Physical Database Design File Structures Query Optimization Index Selection Additional Choices in Physical Database Design You need to understand Physical Database Design in order to achieve an efficient implementation of your table design. To become proficient in physical database design, you need to understand the process and environment. The process of physical database design includes the inputs, outputs, and objectives. The process works along with 2 critical parts of the environment, File Structures and Query Optimization. Index selection is the most important choice of physical database design. Additional Choices in Physical Database Design, this chapter presents denormalization, record formatting, and parallel processing as techniques to improve database performance. Overview of Physical Database Design Sequence of decision-making processes. Decisions involve the storage level of a database: file structure and optimization choices. Importance of providing detailed inputs and using tools that are integrated with DBMS usage of file structures and optimization decisions Overview of Physical Database Design Storage Level of . | Chapter 8 Physical Database Design Welcome to Chapter 8 on Physical Database Design. This is the final phase of the database development process. Physical database design transforms a table design from the logical design phase to database implementation. Objectives Describe the inputs, outputs, and objectives of physical database design List characteristics of sequential, Btree, hash, and bitmap index file structures Appreciate the difficulties of performing physical database design and the need for periodic review of physical database design choices Understand the trade-offs in index selection and denormalization decisions Understand the need for good tools to help make physical database design decisions Understand the choices made by a query optimizer and the areas in which optimization decisions can be improved Outline Overview of Physical Database Design File Structures Query Optimization Index Selection Additional Choices in Physical Database Design You need to understand .