16-11-2012, 02:10 PM
Lecture Notes For DBMS and Data Mining and data Warehousing
Lecture Notes For DBMS.pdf (Size: 43.98 KB / Downloads: 47)
Instances and Schema:
Database schema: Overall design of the database. An analogy to the programming language
could be the definition of various variables with their data types. In case of relational database
management system the definition of table names, and their fields with data types will be the
database schema.
Database Instance: The collection of information stored in the database at a particular moment is
called database instance. An analogy to the programming languages would be the values stored
in the variables during the execution of programs. In case of relational database management
system the data stored in various tables at a particular time is the instance of the database.