Saturday, 7 June 2014

Schema & Types of Schemas

Schema

       A schema is a collection of objects such as tables, views, indexes, synonyms. It simply explains the logically diagram of Database and relation between tables by using key attributes. It includes the name and description of records of all record types including all associated data-items and aggregates.

There are four types of schemas are available in data warehouse.


No comments:

Post a Comment