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.
Contributor(s): Mark Roberts
This was last updated in September 2005
Email Alerts
Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy
Dig Deeper
-
SQL Server Data Quality Services is Microsoft’s newest data-cleansing tool. Expert Denny Cherry examines the upcoming SQL Server 2012 feature and delves into its components and processes.
-
In this Q&A, Microsoft’s Mark Kromer discusses the company’s preview of SQL Server connectors for Hadoop and the shift to the Open Database Connectivity interface for data access.
-
SQL Server Developer Tools, also known as Project Juneau, made its debut in this summer’s Denali preview. Read up on five SSDT features.
-
People who read this also read...
-
Resources from around the Web