HOME

TheInfoList



OR:

A conceptual schema is a high-level description of informational needs underlying the design of a database. 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, datatypes, relationships and constraints.


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 its characteristics (''attributes'') and the associations between pairs of those things of significance (''relationships''). Because a conceptual schema represents the semantics of an organization, and not a
database design Database design is the organization of data according to a database model. The designer determines what data must be stored and how the data elements interrelate. With this information, they can begin to fit the data to the database model.Teorey, ...
, it may exist on various levels of abstraction. The original ANSI four-schema architecture began with the set of ''external schemata'' that each represents one person's 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 person's perspective, but this tends to make it inflexible. If that person's 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
instance Instantiation or instance may refer to: Philosophy * A modern concept similar to ''participation'' in classical Platonism; see the Theory of Forms * The instantiation principle, the idea that in order for a property to exist, it must be had by ...
s 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 class's ''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.


Example relationships

* 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.) * Each EMPLOYEE may have a ''supervisor'' who is also an EMPLOYEE.


Data structure diagram

A data structure diagram (DSD) is a data model or diagram used to describe conceptual data models by providing graphical notations which document entities and their relationships, and the constraints that bind them.


See also

* Concept mapping *
Conceptual framework A conceptual framework is an analytical tool with several variations and contexts. It can be applied in different categories of work where an overall picture is needed. It is used to make conceptual distinctions and organize ideas. Strong conceptu ...
*
Conceptual graphs A conceptual graph (CG) is a formalism for knowledge representation. In the first published paper on CGs, John F. Sowa used them to represent the conceptual schemas used in database systems. The first book on CGs applied them to a wide range of t ...
* Conceptual model (computer science) *
Data modeling Data modeling in software engineering is the process of creating a data model for an information system by applying certain formal techniques. Overview Data modeling is a process used to define and analyze data requirements needed to suppo ...
* Entity-relationship model * Object-relationship modelling * Object-role modeling *
Knowledge representation Knowledge representation and reasoning (KRR, KR&R, KR²) is the field of artificial intelligence (AI) dedicated to representing information about the world in a form that a computer system can use to solve complex tasks such as diagnosing a medic ...
* Logical data model * Mindmap * Ontology * Physical data model * Semantic Web * Three schema approach


References


Further reading

* Perez, Sandra K., & Anthony K. Sarris, eds. (1995) Technical Report for IRDS Conceptual Schema, Part 1: Conceptual Schema for IRDS, Part 2: Modeling Language Analysis, X3/TR-14:1995, American National Standards Institute, New York, NY. * Halpin T, Morgan T (2008) Information Modeling and Relational Databases, 2nd edn., San Francisco, CA: Morgan Kaufmann.


External links

* A differen
point of view
as described by the
agile Agile may refer to: * Agile, an entity that possesses agility Project management * Agile software development, a development method * Agile construction, iterative and incremental construction method * Agile learning, the application of incremen ...
community {{DEFAULTSORT:Conceptual Schema Data modeling Concepts