Database Design

Database Design Considerations

  1. Integrity(무결성): Data integrity is the overall accuracy, completeness, and consistency of data.

  2. Consistency(일관성): Database consistency is defined by a set of values that all data points within the database system must align to in order to be properly read and accepted.

  3. Recovery(회복): Recovery is the rebuilding of a database or table space after a problem such as media or storage failure, power interruption, or application failure.

  4. Security(보안): Security refers to the range of tools, controls, and measures designed to establish and preserve database confidentiality, integrity, and availability.

  5. Efficient(효율): Data efficiency refers to efficiency of the many processes that can be applied to data such as storage, access, filtering, sharing, etc., and whether or not the processes lead to the desired outcome within resource constraints.

  6. Expand(확장)


Database Design 5 steps

  • Name
    Analysis in Database Design
    Type
    #1
    Description

    (요구 조건 분석) Requirements analysis or requirements engineering is a process used to determine the needs and expectations of a new product. It involves frequent communication with the stakeholders and end-users of the product to define expectations, resolve conflicts, and document all the key requirements.

  • Name
    Conceptual database design
    Type
    #2
    Description

    (개념적 설계) Conceptual database design is part of the database design process, which consists of the activities requirements gathering and analysis, conceptual modeling, logical database design and database implementation.

  • Name
    Database logical design
    Type
    #3
    Description

    (논리적 설계) Logical database design is the process of determining the logical data structures that are required to support information resources within an organization. The logical design process helps you to implement a database that satisfies the requirements of your business organization.

  • Name
    Physical design in database
    Type
    #4
    Description

    (물리적 설계) The physical design of your database optimizes performance while ensuring data integrity by avoiding unnecessary data redundancies. During physical design, you transform the entities into tables, the instances into rows, and the attributes into columns.

  • Name
    Database implementation
    Type
    #5
    Description

    (구현) The process of installing database software, performing configuration and customization, running and testing the database and then integrating it with applications.