Review two--Database system architecture

Source: Internet
Author: User
ANSI/SPARC Architecture

Three-level mode structure + two-level image.

Level three mode refers to the

  • External mode: A view of a single user, which is the data interface between the user and the database system. For a single user, the external mode is the database.
  • Conceptual mode: Public view of all users, one database with only one conceptual mode .
  • Internal mode: A storage view inside a database, which is a description of the physical structure and storage of the data. For example, the storage of records: Sequential storage, B-tree organization or hash storage, how the index is organized: sort or hash, whether the data is encrypted, whether the storage is compressed. a database has only one internal mode .

Secondary image refers to the

  • External mode/Pattern Image: Defines the correspondence between the outside mode and the conceptual mode. Properties in the outer mode may be calculated by multiple attributes in the pattern. When the conceptual pattern changes, only the image can be modified to keep the external mode intact- the logical independence of the data .
  • Mode/Internal mode image: Same. The physical independence of the data is embodied.
External architecture of the database system
  • Single-User structure
  • Master-Slave structure
  • Distributed architecture
  • Client/server architecture (c/s)
  • Browser/server architecture

Review two--Database system architecture

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.