Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

difference between instance and schema in dbms  RSS feed

 
Vinod Vinu
Ranch Hand
Posts: 217
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi, please tell the what are instance and schema incase of dbms? please explain me with some e.g.
i googled for schema, it says no. of records, data type, attributes, etc... does it mean that schema is another name of table?
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36396
453
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No. A schema is a group of tables owned by the same user. For example I could have "vinod" schema and "jeanne" schemas in the same database instance. Each could have a "test" table because the schema gives a different namespace. Like a package does in Java.

A database instance is even higher level. Kind of like a separate database except it shares the same binaries. You can have the "vinod" schema in both database instances because they are separate.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!