λ°μ΄ν° λͺ¨λΈμ λ°μ΄ν°λ€μ 체κ³μ μΌλ‘ μ μνκ³ κ΅¬μ‘°ννμ¬ νννκΈ° μν΄μ λ§λ€μ΄μ§ κ°λ μ λλ€.
μ¬λ¬ κ°μ§ λͺ©μ μ λ°λΌ λ€μν ννμ λ°μ΄ν° λͺ¨λΈμ΄ μ¬μ©λλ©°, μ΄λ¬ν λͺ¨λΈμ λ°μ΄ν° κ΄λ¦¬μ νμ©μ ν¨μ¨μ±μ μ¦μ§μν€λ©°, μ 보 μμ€ν μ μ€κ³νκ³ μ΄μνλ λ° νμμ μΈ λκ΅¬λ‘ μ¬μ©λ©λλ€.
1) Conceptual Data Model (Entity-Relationship Model)
Conceptual Data Modelμ λΉμ¦λμ€ μꡬμ¬νμ λνλ΄κΈ° μν κ³ μμ€μ λ°μ΄ν° ννμΌλ‘, μ 무 νλ‘μΈμ€μ μν°ν° κ°μ κ΄κ³λ₯Ό μ€μ¬μΌλ‘ μ€κ³λ λͺ¨λΈμ λλ€. μ΄ λͺ¨λΈμ λΉμ¦λμ€ μ©μ΄λ₯Ό μ¬μ©νμ¬ λ°μ΄ν°μ μλ―Έμ κ΄κ³λ₯Ό μΆμμ μΌλ‘ νννλ©°, ꡬ체μ μΈ λ°μ΄ν°λ² μ΄μ€ μ€κ³μ μ§μ μ μΌλ‘ μμ‘΄νμ§ μμ΅λλ€.
- μΌλ° μ¬μ©μλ€μ΄ μ½κ² μ΄ν΄ν μ μλ κ°λ λ€λ‘ μ΄λ£¨μ΄μ§ λͺ¨λΈ
- μΆμν μμ€μ΄ κ°μ₯ λμ
- ER Diagram μ¬μ©
2) Logical Data Model (λ Όλ¦¬μ λ°μ΄ν° λͺ¨λΈ)
λ Όλ¦¬μ λ°μ΄ν° λͺ¨λΈμ Conceptual Data Modelμμ μ»μ λΉμ¦λμ€ μꡬμ¬νμ λ°νμΌλ‘ μ€μ λ°μ΄ν°λ² μ΄μ€ μμ€ν μ ꡬννκΈ° μν μ€κ° λ¨κ³μ λͺ¨λΈμ λλ€. μ΄ λͺ¨λΈμ λ°μ΄ν°λ₯Ό ꡬ체μ μΌλ‘ μ μνκ³ νννμ¬ λ°μ΄ν°λ² μ΄μ€ λ΄μ ν μ΄λΈ, μ΄, κ΄κ³ λ±μ μ μν©λλ€.
λ€μν λ Όλ¦¬μ λ°μ΄ν° λͺ¨λΈλ€μ΄ μμ§λ§ κ°μ₯ μ λͺ ν건 κ΄κ³ν λ°μ΄ν° λͺ¨λΈ (Relational Data Model)μ λλ€. κ΄κ³ν λ°μ΄ν° λͺ¨λΈμ λ°μ΄ν°λ₯Ό ν μ΄λΈμ΄λΌλ μ΄μ°¨μ κ΅¬μ‘°λ‘ νννκ³ , ν μ΄λΈ κ°μ κ΄κ³λ₯Ό μ μνλ λ°μ΄ν° λͺ¨λΈμ λλ€.
κ΄κ³ν λ°μ΄ν° λͺ¨λΈ(RDBMS)μ κΈ°λ³Έ κ΅¬μ± μμ
1) ν
μ΄λΈ(Table): λ°μ΄ν°λ₯Ό νκ³Ό μ΄μ ννλ‘ νννλ κ°μ₯ κΈ°λ³Έμ μΈ λ¨μ
2) ν(Row): ν
μ΄λΈ λ΄μ κ° λ μ½λ λλ λ°μ΄ν° νλͺ©.
3) μ΄(Column): ν
μ΄λΈ λ΄μ κ° μμ±(Attribute)
4) ν€(Key): λ°μ΄ν°λ₯Ό κ³ μ νκ² μλ³νλ λ° μ¬μ©λλ μ΄ λλ μ΄μ μ§ν© (ex. primary key)
5) κ΄κ³(Relationship): ν
μ΄λΈ κ°μ μ°κ²°μ λνλ΄λ©°, μ΄κ²μ΄ κ΄κ³ν λ°μ΄ν° λͺ¨λΈμ ν΅μ¬
6) μ κ·ν(Normalization): λ°μ΄ν° μ€λ³΅μ μ΅μννκ³ λ°μ΄ν°μ μΌκ΄μ±μ μ μ§νκΈ° μν΄ ν
μ΄λΈμ ꡬ쑰ννλ κ³Όμ (μ 1 μ κ·ν, μ 2 μ κ·ν, μ 3 μ κ·ν)
κ΄κ³ν λ°μ΄ν° λͺ¨λΈμ μ§κ΄μ μ΄λ©° νμ€νλ μ§μ μΈμ΄μΈ SQL(Structured Query Language)μ μ¬μ©νμ¬ λ°μ΄ν°λ₯Ό μ‘°μν μ μλ μ₯μ μ΄ μμ΅λλ€. μ΄λ‘ μΈν΄ λ°μ΄ν°μ ꡬ쑰νμ κ²μμ΄ ν¨μ¨μ μΌλ‘ μ΄λ£¨μ΄μ§λλ€.
3) Physical Data Model (물리μ λ°μ΄ν° λͺ¨λΈ)
물리μ λ°μ΄ν° λͺ¨λΈμ λ Όλ¦¬μ λ°μ΄ν° λͺ¨λΈμμ μ μλ ν μ΄λΈ, κ΄κ³, μΈλ±μ€ λ±μ μ€μ λ°μ΄ν°λ² μ΄μ€ μμ€ν μ ꡬννκΈ° μν λͺ¨λΈμ λλ€. μ΄ λͺ¨λΈμ λ°μ΄ν°μ μ μ₯ λ° μ κ·Ό λ°©μ, μΈλ±μ±, νν°μ λ, μ±λ₯ μ΅μ ν λ±κ³Ό κ°μ 물리μ μΈλΆ μ¬νμ λ€λ£Ήλλ€.
μ΄ λͺ¨λΈμ λ Όλ¦¬μ λ°μ΄ν° λͺ¨λΈμμ μΆμμ μΈ ννμ μ€μ λ‘ κ΅¬ννλ λ¨κ³λ‘, λ°μ΄ν°λ² μ΄μ€ μμ€ν μ μ±λ₯κ³Ό μμ μ±μ 보μ₯νκΈ° μν΄ μ€μν μν μ ν©λλ€.
Data Model: An abstract representation of how data is structured and organized, serving as a blueprint for designing databases or information systems.
Conceptual Data Model: A high-level representation focused on capturing business concepts and relationships between data entities, without delving into technical details.
Logical Data Model: An intermediate-level representation translating the conceptual model into a format understandable by the technical team, defining the structure of the data without specifying physical implementation details.
Physical Data Model: A detailed representation specifying how the logical model will be implemented in a specific database management system, considering technical aspects such as storage structures and indexing.
'Computer Science > Database' μΉ΄ν κ³ λ¦¬μ λ€λ₯Έ κΈ
6 Create(Insert), Update, Delete (1) | 2024.01.11 |
---|---|
5 CRUD (Create, Read, Update and Delete) + Practice tables (0) | 2024.01.08 |
4 Database Languages - DDL, DML, SQL (0) | 2024.01.08 |
3 Relational Database (feat. key, constraints) (1) | 2023.12.23 |
1 Data, Database, DBMS (0) | 2023.12.22 |
λκΈ