What is Schema and its types?
Printable View
What is Schema and its types?
A database schema is a way to logically group objects such as tables, views, stored procedures etc. Think of a schema as a container of objects. You can assign a user login permissions to a single schema so that the user can only access the objects they are authorized to access.
XML schema
Flat file schema
Envelope schema
Property schema
A schema is nothing but a collection of objects
Types of schemas:
-- Star schema
-- Snow flake schema
-- Galaxy schema (or)integrated schema (or) constellation schema
there are lots of types available for schema but i know some types i.e Snow flake schema,Star schema etc
A group of objects is known as schema.