DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
update driven approach
|
|
|
query driven approach
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Today’s data warehouse systems follow update-driven approach rather than the traditional approach discussed earlier. In update-driven approach, the information from multiple heterogeneous sources are integrated in advance and are stored in a warehouse. This information is available for direct querying and analysis.
Detailed explanation-2: -Query-Driven Approach This is the traditional approach to integrate heterogeneous databases. This approach was used to build wrappers and integrators on top of multiple heterogeneous databases. These integrators are also known as mediators.
Detailed explanation-3: -16. Which is the right advantage regarding the Update-Driven approach? The data in Update-Driven approach can be copied, integrated, summarized, and restructured in the semantic data store in advance.
Detailed explanation-4: -To update a table in a data warehouse by using a set of load output files, complete the following tasks: Set the options for the load utility control statements. Generate the load output files. Apply the load output files to the warehouse table.
Detailed explanation-5: -The end users of a data warehouse do not directly update the data warehouse. In OLTP systems, end users routinely issue individual data modification statements to the database. The OLTP database is always up to date, and reflects the current state of each business transaction.