This topic contains a solution. Click here to go to the answer

Author Question: What is a view? What will be an ideal response?[br][br][b][color=green]Question ... (Read 80 times)

ashley

  • Hero Member
  • *****
  • Posts: 584
What is a view?
 
  What will be an ideal response?

Question 2

Explain the term retrieval of analytical information in the following data warehouse definition:The data warehouse is a structured repository of integrated, subject-oriented, enterprise-wide, historical, and time-variant data.
 
  The purpose of the data warehouse is the retrieval of analytical information. A data warehouse can store detailed and/or summarized data.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

nixon_s

  • Sr. Member
  • ****
  • Posts: 359
Answer to Question 1

A view is a mechanism in SQL that allows the structure of a query to be saved in the RDBMS. A view, which is also known as a virtual table, is not an actual table and does not have any data physically saved. Every time a view is invoked, it executes a query that retrieves the data from the actual tables. A view can be used in SELECT statements just like any other table from a database.

Answer to Question 2

A data warehouse is developed for the retrieval of analytical information, and it is not meant for direct data entry by the users. The only functionality available to the users of the data warehouse is retrieval. The data in the data warehouse is not subject to modifications, insertions, or deletions by the end users. New data in the data warehouse is periodically loaded from the operational data sources and appended to the existing data in an automatic fashion. The data that eventually gets older than the required time horizon is automatically purged from the data warehouse (and possibly archived and/or summarized). However, the data in the data warehouse is not subject to changes. That is why the data in the data warehouse is referred to as nonvolatile, static, or read-only.




ashley

  • Member
  • Posts: 584
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review


ashely1112

  • Member
  • Posts: 347
Reply 3 on: Yesterday
Great answer, keep it coming :)

 

Did you know?

The highest suicide rate in the United States is among people ages 65 years and older. Almost 15% of people in this age group commit suicide every year.

Did you know?

Bacteria have been found alive in a lake buried one half mile under ice in Antarctica.

Did you know?

Warfarin was developed as a consequence of the study of a strange bleeding disorder that suddenly occurred in cattle on the northern prairies of the United States in the early 1900s.

Did you know?

Approximately one in four people diagnosed with diabetes will develop foot problems. Of these, about one-third will require lower extremity amputation.

Did you know?

GI conditions that will keep you out of the U.S. armed services include ulcers, varices, fistulas, esophagitis, gastritis, congenital abnormalities, inflammatory bowel disease, enteritis, colitis, proctitis, duodenal diverticula, malabsorption syndromes, hepatitis, cirrhosis, cysts, abscesses, pancreatitis, polyps, certain hemorrhoids, splenomegaly, hernias, recent abdominal surgery, GI bypass or stomach stapling, and artificial GI openings.

For a complete list of videos, visit our video library