May 1, 2024
3 minute read
Physical Design is the process of creating a physical database schema from a conceptual or logical data model. It involves selecting the appropriate data structures, storage mechanisms, and access methods to optimize the performance and reliability of the database. Physical Design is an important step in the database development process, as it can have a significant impact on the performance and scalability of the database application.
Why Learn Physical Design?
There are many reasons why you might want to learn Physical Design. Perhaps you're a database administrator or developer who wants to improve the performance of your databases. Or maybe you're a student who is interested in learning more about the theory and practice of database design. Whatever your reasons, learning Physical Design can be a valuable skill.
How to Learn Physical Design
thhkhy|
Find a path to becoming a Physical Design. Learn more at:
OpenCourser.com/topic/thhkhy/physical
Reading list
We've selected nine books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Physical Design.
Covers all aspects of physical database design with a focus on the relational approach. It is suitable for those interested in this topic in general.
Covers all aspects of physical database design and is suitable for those interested in this topic in general. It provides a balance of theory and practice, with extensive coverage of relational databases.
A practical guide to physical database design, this book is most appropriate for those interested in designing and implementing high-performance databases.
Covers all aspects of database design and tuning for high performance, including physical database design.
Covers all aspects of tuning SQL Server for high performance, including physical database design.
Is specifically focused on physical database design for SQL Server and will be most useful for those interested in this topic in this context.
Is specifically focused on physical database design for Oracle and will be most useful for those interested in this topic in this context.
Is specifically focused on physical database design for MySQL and will be most useful for those interested in this topic in this context.
Is specifically focused on physical database design for PostgreSQL and will be most useful for those interested in this topic in this context.
For more information about how these books relate to this course, visit:
OpenCourser.com/topic/thhkhy/physical
Save
