Difference Between Schema and Instance

DatabaseBig Data AnalyticsData Storage

In this post, we will understand the difference between a schema and an instance.

Schema

  • It is defined as the overall description of the database.

  • It remains the same for the entire database.

  • It doesn’t change frequently.

  • It is used to define the basic structure of the database.

  • It tells about how the data would be stored in a database.

Instance

  • It refers to the collection of information that is stored in the database at a specific moment.

  • Data in these instances can be changed.

  • This can be done using addition, deletion, and updating.

  • The instance changes frequently.

  • It is the set of Information that is stored at a particular time

raja
Published on 25-Mar-2021 06:00:51
Advertisements