Respond to the Questions in 100 words or less using APA format. Cite your work

Q1. Materialized ViewsNC 1957781 Oct 2, 2015 8:18 AM

Another use of materialized views is what Oracle calls Summary Management. According to Oracle (2015), "the use of summary management features imposes no schema restrictions, and can enable some existing DSS database applications to improve performance without the need to redesign the database or the application."

Summary management includes mechanisms to define materialized views, mechanisms to refresh materialized views such that they contain the latest data, the ability for a query rewrite to transparency, the SQL Access Advisor, as well as the ability to tune the materialized view using TUNE_MVIEW.

Oracle.(2015). Basic materialized views.Oracle Database Online Documentation 11g Release 1 (11.1). Retrieved from http://docs.oracle.com/cd/B28359_01/server.111/b28313/basicmv.htm

Q2 External TableDOId: 2738480 Oct 2, 2015 5:18 AM

An external table can be used to read and query data that resides in CSV or flat files, as if the files were based in an Oracle table. Oracle (2015) suggest that External Tables offer more convenience than SQL*Loader when loading data from flat files into the database as no control file or staging table is required to upload and then transform the data. It's all done in the same step. This provides the added advantage of efficiency, allowing the user to solely concentrate on the queries to perform the transformation.

Oracle (2015). External Tables: Frequently Asked Questions. Retrieved 2nd October 2015 from http://download.oracle.com/otndocs/products/database/enterprise_edition/utilities/pdf/external_tables_faq.pdf

Q3 Data PumpDO 2738480 Oct 2, 2015 6:17 AM

Kuhn (2013) suggests that one of the advantages of data pump is that it can be used to populate materialized views using prebuilt tables loaded using data pump. This can be useful for loading large data sets in data warehouse environments.

References

Kuhn, D. (2013). Pro Oracle database 12c administration (2nd ed.). New York: Apress.