ⓘ Conceptual schema. A conceptual schema is a high-level description of a businesss informational needs. It typically includes only the main concepts and the main ..


ⓘ Conceptual schema

A conceptual schema is a high-level description of a businesss informational needs. It typically includes only the main concepts and the main relationships among them. Typically this is a first-cut model, with insufficient detail to build an actual database. This level describes the structure of the whole database for a group of users. The conceptual model is also known as the data model that can be used to describe the conceptual schema when a database system is implemented. It hides the internal details of physical storage and targets on describing entities, datatype, relationships and constraints.


1. Overview

A conceptual schema or conceptual data model is a map of concepts and their relationships used for databases. This describes the semantics of an organization and represents a series of assertions about its nature. Specifically, it describes the things of significance to an organization entity classes, about which it is inclined to collect information, and characteristics of attributes and associations between pairs of those things of significance relationships.

Because a conceptual schema represents the semantics of an organization, and not a database design, it may exist on various levels of abstraction. The original ANSI four-schema architecture began with the set of external schema that each represent one persons view of the world around him or her. These are consolidated into a single conceptual schema that is the superset of all of those external views. A data model can be as concrete as each persons perspective, but this tends to make it inflexible. If that persons world changes, the model must change. Conceptual data models take a more abstract perspective, identifying the fundamental things, of which the things an individual deals with are just examples.

The model does allow for what is called inheritance in object oriented terms. The set of instances of an entity class may be subdivided into entity classes in their own right. Thus, each instance of a sub-type entity class is also an instance of the entity classs super-type. Each instance of the super-type entity class, then is also an instance of one of the sub-type entity classes.

Super-type/sub-type relationships may be exclusive or not. A methodology may require that each instance of a super-type may only be an instance of one sub-type. Similarly, a super-type/sub-type relationship may be exhaustive or not. It is exhaustive if the methodology requires that each instance of a super-type must be an instance of a sub-type. A sub-type named other is often necessary.


2. Example relationships

  • Each EMPLOYEE may have a supervisor who is also an EMPLOYEE.
  • Each PERSON may be the vendor in one or more ORDERS.
  • Each ORDER must be from one and only one PERSON.
  • PERSON is a sub-type of PARTY. Meaning that every instance of PERSON is also an instance of PARTY.
  • integrity constraints later There is only one conceptual schema per database. The internal schema at the lowest level contains definitions of the stored
  • image is part of our self - schema The body image includes the following: The perceptual experience of the body The conceptual experience of the body - what
  • the model. Simply described, a conceptual schema is the first step in organizing the data requirements. Logical schema describes the structure of some
  • of the conceptual schema design procedure. Robert Meersman extended the approach by adding subtyping, and introducing the first truly conceptual query
  • In psychology and cognitive science, a schema plural schemata or schemas describes a pattern of thought or behavior that organizes categories of information
  • Entity Framework, which simplifies the job of mapping a conceptual schema to the relational schema and specifying which properties of an entity type correspond
  • image schema is considered an embodied prelinguistic structure of experience that motivates conceptual metaphor mappings. Evidence for image schemas also
  • A conceptual space is a geometric structure that represents a number of quality dimensions, which denote basic features by which concepts and objects can
  • Information Systems and a member of ISO TC97 SC5 WG3 working group on Conceptual Schemas During the period of 1982 to 1989 Nijssen was a full - time professor
  • In Kantian philosophy, a transcendental schema plural: schemata from Greek: σχῆμα, form, shape, figure is the procedural rule by which a category

Users also searched:

conceptual database design,