View all newsletters
Receive our newsletter - data, insights and analysis delivered to you
  1. What Is
July 11, 2016updated 22 Sep 2016 12:44pm

What is schema?

Find out what can influence the schema.

By James Nunns

A schema in computer programming is the organisation or structure for a database.

It can also be used in regards to maths where a schema is a formal expression of an inference rule for artificial intelligence computing.

A schema is created through modelling and is used when talking about both relational databases and object oriented databases.

Basically a schema is the blueprint of how a database is constructed, although it can be said to be a set of formulas called integrity constraints imposed on a database. Integrity constraints are designed to ensure the compatibility between parts of the schema and all constraints are expressible in the same language.

Certain requirements can influence the detailed structure of schemas such as overlap preservation where each of the overlapping elements specified in the input mapping.

Extended overlap preservation sees that source specific elements that are associated with a source’s overlapping elements are passed through to the database schema.

Content from our partners
Infosecurity Europe 2024: Rethink the power of infosecurity
Rethinking cloud: challenging assumptions, learning lessons
DTX Manchester welcomes leading tech talent from across the region and beyond

Websites in our network
Select and enter your corporate email address Tech Monitor's research, insight and analysis examines the frontiers of digital transformation to help tech leaders navigate the future. Our Changelog newsletter delivers our best work to your inbox every week.
  • CIO
  • CTO
  • CISO
  • CSO
  • CFO
  • CDO
  • CEO
  • Architect Founder
  • MD
  • Director
  • Manager
  • Other
Visit our privacy policy for more information about our services, how Progressive Media Investments may use, process and share your personal data, including information on your rights in respect of your personal data and how you can unsubscribe from future marketing communications. Our services are intended for corporate subscribers and you warrant that the email address submitted is your corporate email address.