AS VENKATESH

• Aug 31st, 2005

 

RDBMS Schema 
* Used for OLTP systems 
* Traditional and old schema 
* Normalized 
* Difficult to understand and navigate 
* Cannot solve extract and complex problems 
* Poorly modelled 
 
DWH Schema 
* Used for OLAP systems 
* New generation schema 
* De Normalized 
* Easy to understand and navigate 
* Extract and complex problems can be easily solved 
* Very good model

Sithu

• Dec 15th, 2005

 

Schema is nothing but the systematic arrangement of tables

 

• In OLTP it will be normalized
• In Data warehouse it will be denormalized  

Surya

• Jan 8th, 2006

 

The difference depends on the context.

Technically, if Oracle is used, a schema is a "user". In that context there is no difference between the schema's in OLTP or ROLAP.Although, denormalized/nortmalized tables are given as examples above, it is not the difference.

sithusithu

 Profile Answers by sithusithu 

• Jan 25th, 2006

 

RDBMS-normalized

Datawarehouse -Denormalized

senthil kumar B

• Feb 13th, 2006

 

Diff b.w OLTP and OLAP :
------------------------

OLTP Schema  :
* Normalized
* More no.of trans
* Less time for queries execution
* More no.of users
* Have Insert,delete and update trans.
 
OLAP (DWH) Schema  :

* De Normalized
* Less no.of trans
* Less no.of users
* More time for query exec
* Will not have more insert,delete and updates.

Sam Kolta

 Profile Answers by Sam Kolta 

• Apr 16th, 2010

 

User
It is just an account name for the user
Owns a schema
Have the same name
Create user command, create the user
User can be considered schema
User can created without schema
It is the account for the oracle database
It does include the right to control access over schema objects access control

Schema
It is a collection of database objects s.a. tables, views, sequences, stored procedures, synonyms, indexes, clusters and database links
Owned by user
Create schema command doesn’t create the schema but it creates multiple tables, views and perform multiple grants
Schema can be considered a user
Schema can’t created without a user
It is objects for the oracle database
It does not include the right to their access control