sithusithu

 Profile Answers by sithusithu 

• Jan 3rd, 2006

 

Systematic arrangement of tables is known as schema

They are
1.Star
2.Snowflake
3.Galaxy

Cheers,
Sithu

sithusithu

 Profile Answers by sithusithu 

• Jan 9th, 2006

 

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

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Aug 17th, 2007

 

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.

msabuu

 Profile Answers by msabuu 

• Nov 6th, 2007

 

Schema is collection of database object.

Sriniv@s..

• Jun 20th, 2012

 

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