Interested to Buy Any Domain ? << Click Here >> for more details...
How Materialized Views are linked with Oracle DataWare
house?
- 1 Answers
- 6545 Views
- Kirloskar, I also Faced
- E-Mail Answers
Answer Posted / satya
Materialized views are schema objects that can be used to
summarize, precompute, replicate, and distribute data. E.g.
to construct a data warehouse.
A materialized view provides indirect access to table data
by storing the results of a query in a separate schema
object. Unlike an ordinary view, which does not take up any
storage space or contain any data.
The existence of a materialized view is transparent to SQL,
but when used for query rewrites will improve the
performance of SQL execution. An updatable materialized view
lets you insert, update, and delete.
You can define a materialized view on a base table,
partitioned table or view and you can define indexes on a
materialized view.
A materialized view can be stored in the same database as
its base table(s) or in a different database.
Materialized views stored in the same database as their base
tables can improve query performance through query rewrites.
Query rewrites are particularly useful in a data warehouse
environment.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Why is dimensional normalization not required?
Explain the differences between normalizer and normalizer transformation?
How can we run the graph? What is the procedure for that?
Where the applications and where ware house management system is used?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
Explain the difference between oltp and olap?
Explain the definition of normalized and denormalized view?
Explain what are the various methods of getting incremental records or delta records from the source systems?
What is data stream and data adaopter?
What are the data types present in bo?
What is Active Datawarehousing?
What is normalization, first normal form, second normal form, third normal form?
What are situations where snowflake schema is better than star schema when the opposite is true?
What is the data type of the surrogate key?
Explain what is power center repository?
