Schema

Schema - The complete description of a physical database design in terms of its tables or files, columns or fields, primary keys, relationships or structure, and integrity constraints. 

[Category=Data Quality ]

Source: Larry English, http://www.iaidq.com/main/glossary.shtml , 09-Feb-2009 11:11

---

These advertisers support this free service

---

Schema - 1) The database's metadata -- the structure of an entire database, which specifies, among other things, the tables, their fields, and their domains. In some database systems, the linking or join fields are also specified as part of the schema.

2) The description of a single table. Also called a Logical Schema.

[Category=Database Management ]

Source: Northwest Database Services, 14 November 2009 11:03:59, http://www.nwdatabase.com/database-glossary-s.htm

---

Schema - A diagrammatic representation of the structure or framework of something. It is the logical and physical definition of data elements, physical characteristics and interrelationships. In the context of Data Modeling, it refers to a specification for how a database is physically organized (also called the logical view of a database). It includes all the data elements in the databases and how these elements logically relate to each other.

[Category=Data Governance ]

Source: The Data Governance Institute, 24 December 2009 13:06:59, http://www.datagovernance.com/glossary-governance/

---

Schema - The logical organization of data in a database.

[Category=Data Warehousing ]

Source: SDG Computing Inc., 12 May 2010 11:15:15, SDG Computing, now offline

---

Schema - A diagrammatic representation of the structure or framework of something. It is the logical and physical definition of data elements, physical characteristics and interrelationships.

[Category=Information Management ]

Source: Information-Management.com, 06 July 2010 12:52:51, http://www.information-management.com/glossary/m.html

---

Schema - (1) A diagrammatic representation of the structure or framework of something. (2) The logical and physical definition of data elements, physical characteristics and inter-relationships.

[Category=Data Warehousing ]

Source: Sun.com, 11 August 2010 08:24:17, http://www.sun.com/third-party/dw/brochures/67198.Acrobat.pdf

---

Schema - A diagrammatic representation of the structure or framework of something. Its the logical and physical definition of data elements, physical characteristics and interrelationships.

[Category=Data Management ]

Source: DataMentors, 27 August 2010 09:12:44, http://www.datamentors.com/News-and-Resources/Glossary.html

---

Schema - An information model implemented in a database. A schema may be a logical schema, which will define, for example, tables, columns, and constraints, but which may not include any optimization. It may be a physical schema that includes optimization, for example, table clustering.

[Category=Data Warehousing ]

Source: Aexis Business Intelligence, 24 December 2010 08:55:13, http://www.aexis.eu/DataWarehouse-Glossary/

---

schema - A structured framework. A metadata schema specifies the order and types and labels of information elements describing a geodata set.

[Category=Geospatial ]

Source: Open Geospatial Consortium, 04 July 2011 09:05:34, http://www.opengeospatial.org/ogc/glossary

---

Schema - A description of the overall logical structure of a database expressed in a data definition language (such as the data definition component of SQL).

[Category=Data Quality ]

Source: DAMA UK, 19 July 2011 10:17:18, http://www.damauk.org/glossary.php

---

schema - 

(1) [computing] The structure or design of a database or database object, such as a table, view, Index_, stored procedure, or trigger. In a relational database, the schema defines the tables, the fields in each table, the relationships between fields and tables, and the grouping of objects within the database. Schemas are generally documented in a data dictionary. A database schema provides a logical classification of database objects.

(2) [computing] A set of rules, stored in a file, that describe the structure of an XML document. The number, type, and order of elements allowed in an XML document are described in the schema. An XML parser can compare XML documents against the schema. An XML document that uses open and close tags properly is said to be well formed; if it also follows the rules of its designated schema, it is said to be valid.

[Category=Geospatial ]

Source: esri, 10 August 2012 09:42:15, http://support.esri.com/en/knowledgebase/GISDictionary/term/abbreviation  

---

schema - 1) In computer programming, a schema (pronounced SKEE-mah) is the organization or structure for a database. The activity of data modeling leads to a schema. (The plural form is schemata. The term is from a Greek word for "form" or "figure." Another word from the same source is "schematic.") The term is used in discussing both relational databases and object-oriented databases. The term sometimes seems to refer to a visualization of a structure and sometimes to a formal text-oriented description.

Two common types of database schemata are the star schema and the snowflake schema.

2) In another usage derived from mathematics, a schema is a formal expression of an inference rule for artificial intelligence (AI) computing. The expression is a generalized axiom in which specific values or cases are substituted for each symbol in the axiom to derive a specific inference.

Related glossary terms: Binary Large Object (BLOB), data structure, catalog, data mart, ECMAScript (European Computer Manufacturers Association Script), Visual FoxPro, segment, block, flat file

[Category=Data Management ]

Source: WhatIs.com, 07 September 2013 08:40:13, http://whatis.techtarget.com/glossary/Data-and-Data-Management  

---

schema - The structure that defines the organization of data in a database system.

[Category=Big Data ]

Source: DataInformed, 09 November 2013 09:15:15, http://data-informed.com/glossary-of-big-data-terms/