What is a Schema ?

Systematic arrangement of tables is known as schema

They are
1.Star
2.Snowflake
3.Galaxy

Cheers,
Sithu

Three type of schema.....

 

Star schema

A single fact table with N number of Dimension

 

Snowflake schema

Any dimensions with extended dimensions are know as snowflake schema

 

Multiple Star (galaxy)

If the schema has more than one fact table then the schema is said to be Multiple star

 

Cheers,

Sithu

A schema is a collection of components and database objects under the control of a given database user. Each Oracle Portal application maps to an Oracle database schema. The schema stores the components owned by the application. In addition, the schema can store the database objects on which the components are based.

You can map an application to schemas currently in the Oracle database where Oracle Portal is installed. When you create the schema, you must select the Application Schema check box to designate that applications can be built in the schema.

Schema is collection of database object.

Schema is a set of objects own by a Particular user..