1. Instances :
Instances are the collection of information stored at a particular moment. The instances can be changed by certain CRUD operations as like addition, deletion of data. It may be noted that any search query will not make any kind of changes in the instances.
Let’s say a table teacher in our database whose name is School, suppose the table has 50 records so the instance of the database has 50 records for now and tomorrow we are going to add another fifty records so tomorrow the instance have total 100 records. This is called an instance.
2. Schema :
Schema is the overall description of the database. The basic structure of how the data will be stored in the database is called schema.
Schema is of two types: Logical Schema, and Physical Schema.
- Logical Schema – It describes the database designed at logical level.
- Physical Schema – It describes the database designed at physical level.
Let’s say a table teacher in our database name school, the teacher table require the name, dob, doj in their table so we design a structure as :
Teacher table name: String doj: date dob: date
Above given is the schema of the table teacher.
Difference between Schema and Instance :
|It is the overall description of the database.||It is the collection of information stored in a database at a particular moment.|
|Schema is same for whole database.||Data in instances can be changed using addition, deletion, updation.|
|Does not change Frequently.||Changes Frequently.|
|Defines the basic structure of the database i.e how the data will be stored in the database.||It is the set of Information stored at a particular time.|
Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.
- Difference between Star Schema and Fact Constellation Schema
- Difference between Snowflake Schema and Fact Constellation Schema
- Difference between Star Schema and Snowflake Schema
- Relation Schema in DBMS
- Schema Integration in DBMS
- Strategies for Schema design in DBMS
- Difference between Schema and Database
- Difference between Document Type Definition (DTD) and XML Schema Definition (XSD)
- Difference between 1NF and 2NF in DBMS
- Difference between DDL and DML in DBMS
- Difference between 2NF and 3NF in DBMS
- Difference between RDBMS and DBMS
- Difference between BCNF and 4NF in DBMS
- Difference between 3NF and BCNF in DBMS
- Difference between Database and DBMS
- Difference between File System and DBMS
- Difference between Trigger and Procedure in DBMS
- Difference between Selection and Projection in DBMS
- Difference between Cursor and Trigger in DBMS
- Difference between Classification and Clustering in DBMS
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.