Three-Schema Architecture

Why Trust Techopedia

What Does Three-Schema Architecture Mean?

Three-schema architecture is an idea in relational database design that breaks a database down into three different categories according to its use and structure, and to the roles played by system administrators, designers and end users.

Advertisements

Techopedia Explains Three-Schema Architecture

Developed in the 1970s, the three-schema architecture helps to evaluate a relational database from different vantage points. The first of the three levels is called the external level or user level. This is the view of the relational database that end users see, and it involves a high level of abstraction. The second level is the logical schema or conceptual level, where designers work. The third level is the physical schema or physical level, where programmers maintain a database on a hardware system. The three-schema architecture is generally attributed to the ANSI/SPARC group and is sometimes also called “ANSI/SPARC” architecture.

Part of the usage of the three-schema architecture is to look at how the design maintenance differs from the core system maintenance. For example, items dealing with database tables and queries belong in the conceptual or logical schema, where issues such as memory handling are looked at in the physical level. Some IT experts talk about the three-schema architecture in the context of changing levels without affecting other levels or in terms of data independence. In addition, the three-schema architecture also performs a breakdown of the core duties of database designers, network administrators or server maintenance teams.

Advertisements

Related Terms

Margaret Rouse
Editor

Margaret jest nagradzaną technical writerką, nauczycielką i wykładowczynią. Jest znana z tego, że potrafi w prostych słowach pzybliżyć złożone pojęcia techniczne słuchaczom ze świata biznesu. Od dwudziestu lat jej definicje pojęć z dziedziny IT są publikowane przez Que w encyklopedii terminów technologicznych, a także cytowane w artykułach ukazujących się w New York Times, w magazynie Time, USA Today, ZDNet, a także w magazynach PC i Discovery. Margaret dołączyła do zespołu Techopedii w roku 2011. Margaret lubi pomagać znaleźć wspólny język specjalistom ze świata biznesu i IT. W swojej pracy, jak sama mówi, buduje mosty między tymi dwiema domenami, w ten…