Skip to main content

Schema and Instance in DBMS

Schema and Instance in DBMS

1. Instances :
Instances are the collection of information stored at a particular moment. The instances can be changed by certain 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.

Example –
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 and Instance in DBMS


Schema is of three types: Logical Schema, Physical Schema and view Schema.
  1. Logical Schema – It describes the database designed at logical level.
  2. Physical Schema – It describes the database designed at physical level.
  3. View Schema – It defines the design of the database at the view level.

Example –
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 :


Schema
  • It is the overall description of the database.
  • Schema is same for whole database.
  • Does not change Frequently.
  • Defines the basic structure of the database i.e how the data will be stored in the database.

Instance
  • It is the collection of information stored in a database at a particular moment.
  • Data in instances can be changed using addition, deletion, updation.
  • Changes Frequently.
  • It is the set of Information stored at a particular time.
Labels:

Comments

Post a Comment

Please do not enter any spam link in the comment box.

Popular posts from this blog

SQL Constraints, NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, DEFAULT, CREATE INDEX

SQL Constraints (Image by - Sharma Guides | Subham232330) Constraints   |   |- CHECK   |   |- NOT NULL   |   |- UNIQUE   |   |- PRIMARY KEY   |   |- DEFAULT   |   |- FOREIGN KEY   |   |- INDEX * These constraints are also known as Integrity Constraints . * SQL Constraints:- Constraints are the rules and restrictions applied to the data in a table. * NOT NULL:- Value cannot be Null in a column. * UNIQUE:- Value cannot be the same in a column. * PRIMARY KEY:- Used to uniquely identify a row. * FOREIGN KEY:- References a row in another table. * CHECK:- Satisfies a specific condition. * DEFAULT:- Set default value. * CREATE INDEX:- Used to speed up the reading process.
Post a Comment
Read more

Authentication vs Authorization

Authentication vs Authorization - Authentication and authorization are the two words used in the security world. They might sound similar but are completely different from each other. Authentication is used to authenticate someone's identity, whereas authorization is a way to provide permission to someone to access a particular resource. These are the two basic security terms and hence need to be understood thoroughly. In this topic, we will discuss what authentication and authorization are and how they are differentiated from each other. What is Authentication? Authentication is the process of identifying someone's identity by assuring that the person is the same as what he is claiming for. It is used by both server and client. The server uses authentication when someone wants to access the information, and the server needs to know who is accessing the information. The client uses it when he wants to know that it is the same server that it claims to be. The authentication by t...
Post a Comment
Read more

Implement Echo client and Echo server using TCP Sockets

Implement Echo client and Echo server using TCP Sockets EchoServer.java import java.net.*; import java.io.*; public class EServer { public static void main(String args[]) { ServerSocket s=null; String line; DataInputStream is; PrintStream ps; Socket c=null; try { s=new ServerSocket(9000); } catch(IOException e) {} try { System.out.println(e); c=s.accept(); is=new DataInputStream(c.getInputStream()); ps=new PrintStream(c.getOutputStream()); while(true) { line=is.readLine(); ps.println(line); }} catch(IOException e) { System.out.println(e); }}} EchoClient.java import java.net.*; import java.io.*; public class EClient { public static void main(String arg[]) { Socket c=null; String line; DataInputStream is,is1; PrintStream os; try { InetAddress ia = InetAddress.getLocalHost(); c=new Socket(ia,9000); } catch(IOException e) {} try { System.out.println(e); os=new PrintStream(c.getOutputStream()); is=new DataInputStream(System.in); is1=new DataInputStream(c.getInputStream()); while(true) { Sys...
Post a Comment
Read more