Compare the Difference Between Similar Terms

Difference Between

Home / Technology / IT / Database / Difference Between Database and Schema

Difference Between Database and Schema

June 9, 2011 Posted by Indika

Database vs Schema

A system intended for easily organizing, storing and retrieving large amounts of data, is called a database. In other words, a database holds a bundle of organized data (typically in digital form) for one or more users. Databases, often abbreviated DB, are classified according to their content, such as document-text, bibliographic and statistical. On the other hand, database schema is the formal description of the organization and the structure of data in the database. This description includes the definitions of tables, columns, data types, indexes and much more.

Database

A database may contain different levels of abstraction in its architecture. Typically, the three levels: external, conceptual and internal make up the database architecture. External level defines how the users view the data. A single database can have multiple views. The internal level defines how the data is physically stored. The conceptual level is the communication medium between internal and external levels. It provides a unique view of the database regardless of how it is stored or viewed. There are several types of databases such as Analytical database, Data warehouses and Distributed databases. Databases (more correctly, relational databases) are made up of tables and they contain rows and columns, much like spreadsheets in Excel. Each column corresponds to an attribute, while each row represents a single record. For example, in a database, which stores employee information of a company, the columns could contain employee name, employee Id and salary, while a single row represents a single employee. A DBMS (Database Management System) is used to manage all the databases in a database system. Typically, the structure of a database is too complex to handle without a DBMS. Popular DBMS products are Microsoft SQL Server, MySQL, DB2, Oracle, and Microsoft Access.

Schema

A database schema of a database system describes the structure and the organization of data. A formal language supported by the Database Management System is used to define the database schema. Schema describes how the database will be constructed using its tables. Formally, schema is defined as the set of formula that imposes integrity constraints on the tables. Furthermore, the database schema will describe all tables, column names and types, indexes, etc. There are three types of schema called the conceptual schema, logical schema and physical schema. Conceptual schema describes how concepts and relationships are mapped. Logical schema defines how entities, attributes and relations are mapped. Physical schema is a specific implementation of the aforementioned logical schema.

What is the difference between Database and Schema?

As a summery, a database is a collection of organized data, while database schema describes the structure and organization of data in a database system. The database holds the records, fields and cells of data. The database schema describes how these fields and cells are structured and organized and what types of relationships are mapped between these entities. Understandably, the schema of a database keeps constant once created, while the actual data in the database tables may change all the time.

Related posts:

Difference Between DBMS and Database Difference Between DBMS and RDBMS Difference Between RDBMS and OODBMS Difference Between DBMS and Data Warehouse Difference Between DBMS and Data Mining

Filed Under: Database Tagged With: Analytical database, Conceptual level, conceptual schema, Data warehouses, Database, database architecture, database schema, Databases, DB, DB2, DBMS, Distributed databases, External level, Internal level, logical schema, Microsoft Access, Oracle, physical schema, schema

About the Author: Indika

Indika, BSc.Eng, MSECE Computer Engineering, PhD. Computer Science, is an Assistant Professor and has research interests in the areas of Bioinformatics, Computational Biology, and Biomedical Natural Language Processing.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Request Article

Featured Posts

Difference Between Coronavirus and Cold Symptoms

Difference Between Coronavirus and Cold Symptoms

Difference Between Coronavirus and SARS

Difference Between Coronavirus and SARS

Difference Between Coronavirus and Influenza

Difference Between Coronavirus and Influenza

Difference Between Coronavirus and Covid 19

Difference Between Coronavirus and Covid 19

You May Like

Difference Between Metaphor and Metonymy

Difference Between Metaphor and Metonymy

Difference Between Male and Female Gametes

Difference Between Male and Female Gametes

Difference Between Motorola DEFY and Motorola DEFY+

Difference Between M&E and MIS

Difference Between Orthologous and Paralogous Genes

Difference Between Orthologous and Paralogous Genes

Latest Posts

  • What is the Difference Between Typhoid and Viral Fever
  • What is the Difference Between Interstitial Lung Disease and Pulmonary Fibrosis
  • What is the Difference Between Liquid and Powder Foundation
  • What is the Difference Between Apert and Crouzon Syndrome
  • What is the Difference Between Cordyceps Militaris and Cordyceps Sinensis
  • What is the Difference Between Penta and Hexa Vaccine
  • Home
  • Vacancies
  • About
  • Request Article
  • Contact Us

Copyright © 2010-2018 Difference Between. All rights reserved. Terms of Use and Privacy Policy: Legal.