Physical Design Process(The Big Picture).

Today, I am going to explain physical design process.

Purposes of this article creation

• To be able to create DB tables in MySQL in Ruby on Rails on my own.
• To be able to do physical design.

Physical Design Process

In this case, I will create physical data model for a SNS task management application on Cacoo as a deliverable.

【What is Physical Design?】

• Physically optimize the data model to match the DBMS to be used.
• Implement the database by setting specific data types, constraints, etc.

※The physical data model shows that DB can be implemented.

【Physical Design Process】

1. Table Definition (Determine data types, assign constraints)
2. Check Capacity And Performance Requirements
3. Calculate Amount Of Data Required And Data Area
4. Reliability Design
5. Performance Design
6. Operation and Maintenance Design
7. Determine File Placement

1. Table Definition (Determine data types, assign constraints)

URL:https://rubicon44-techblog.com/programming/db/physical-design/table-definition/

2. Check Capacity And Performance Requirements

URL:https://rubicon44-techblog.com/programming/db/physical-design/check-capacity-and-performance-requirements-and-calculate-amount-of-data-required-and-data-area/

※「2. Check Capacity And Performance Requirements」 and 「3. Calculate Amount Of Data Required And Data Area」 are explained in the same article.

3. Calculate Amount Of Data Required And Data Area

URL:https://rubicon44-techblog.com/programming/db/physical-design/check-capacity-and-performance-requirements-and-calculate-amount-of-data-required-and-data-area/

※「2. Check Capacity And Performance Requirements」 and 「3. Calculate Amount Of Data Required And Data Area」 are explained in the same article.

4. Reliability Design

URL:https://rubicon44-techblog.com/programming/db/physical-design/reliability-design/

※This concept is mainly necessary when selecting a DB in a cloud such as AWS.

※This section explains what you should consider in Reliability Design.

5. Performance Design

URL:https://rubicon44-techblog.com/programming/db/physical-design/performance-design/

※「Denormalization」, 「Indexing」, 「Tuning SQL to be issued」, etc. will be explained.

6. Operation and Maintenance Design.

URL:https://rubicon44-techblog.com/programming/db/physical-design/operation-and-maintenance-design/

※This concept is necessary when selecting, operating and maintaining a DB mainly in a cloud such as AWS.

※This section explains what you should consider in Operation and Maintenance Design.

7. Determine File Placement

URL:https://rubicon44-techblog.com/programming/db/physical-design/determine-file-placement/

※This concept is mainly necessary when creating DB in AWS or other cloud computing.

Deliverables(Physical Data Model)

• URL：<物理データモデルURL(Cacoo)>

References

[Physical Data Model]

• 「データ中心設計(DOA)に基づいたデータモデリング」：https://thinkit.co.jp/article/17291

Word Explanation

【About Conceptual, Logical, and Physical Data Models】
[Conceptual Data Model]
A data model that is independent of the means of implementation and describes the data required by the company and the relationships among the data.

[Logical Data Model]
A data model that describes the structure of the data (data structure of the conceptual data model) organized according to the DBMS.

[Physical Data Model]
A data model that describes the structure organized to physically store (the data structure of the logical data model).

Summary/What I learned this time

NONE.