The data held in a data warehouse is described as being subject-oriented, integrated, time-variant, and non-volatile (Inmon, 1993).
•Subject-oriented as the warehouse is organized around the major subjects of the organization (such as customers, products, and sales) rather than the major application areas (such as customer invoicing, stock control, and product sales). This is reflected in the need to store decision-support data rather than application-oriented data.
•Integrated because of the coming together of source data from different organization-wide applications systems. The source data is often inconsistent using for example, different data types and/or formats. The integrated data source must be made consistent to present a unified view of the data to the users.
•Time-variant because data in the warehouse is only accurate and valid at some point in time or over some time interval. The time-variance of the data warehouse is also shown in the extended time that the data is held, the implicit or explicit association of time with all data, and the fact that the data represents a series of snapshots.
•Non-volatile as the data is not updated in real-time but is refreshed from operational systems on a regular basis. New data is always added as a supplement to the database, rather than a replacement. The database continually absorbs this new data, incrementally integrating it with the previous data.
kalvinspartan answered the question on July 4, 2018 at 16:35
-
Explain why it is necessary to select the target DBMS before beginning the physical database design phase.
(Solved)
Explain why it is necessary to select the target DBMS before beginning the physical database design phase.
Date posted:
July 4, 2018
.
Answers (1)
-
Discuss the relationship between the information systems lifecycle and the database system development lifecycle.
(Solved)
Discuss the relationship between the information systems lifecycle and the database system development lifecycle.
Date posted:
July 4, 2018
.
Answers (1)
-
Define the two principal integrity rules for the relational model. Discuss why it is desirable to enforce these rules.
(Solved)
Define the two principal integrity rules for the relational model. Discuss why it is desirable to enforce these rules.
Date posted:
July 4, 2018
.
Answers (1)
-
Describe the functions that should be provided by a modern full-scale multi-user DBMS.
(Solved)
Describe the functions that should be provided by a modern full-scale multi-user DBMS.
Date posted:
July 4, 2018
.
Answers (1)
-
Describe the problems with the traditional two-tier client-server architecture and discuss how these problems were overcome with the three-tier client-server architecture.
(Solved)
Describe the problems with the traditional two-tier client-server architecture and discuss how these problems were overcome with the three-tier client-server architecture.
Date posted:
July 4, 2018
.
Answers (1)
-
Describe the five components of the DBMS environment and discuss how they relate to each other
(Solved)
Describe the five components of the DBMS environment and discuss how they relate to each other
Date posted:
July 4, 2018
.
Answers (1)
-
Explain how an interactive DVD can be used to train users of an information system
(Solved)
Explain how an interactive DVD can be used to train users of an information system
Date posted:
July 3, 2018
.
Answers (1)
-
Create a function called reverse() that takes two parameters. The first parameter called str, is a pointer to a string that will be reversed upon...
(Solved)
Create a function called reverse() that takes two parameters. The first parameter called str, is a pointer to a string that will be reversed upon return from the function. The second parameter is called count, and it specifies how many characters of str to reverse(). Give count a default value that, when present, tells reverse() to reverse the entire string.(use C++ language)
Date posted:
June 8, 2018
.
Answers (1)
-
Explain the factors determining the methods of data processing
(Solved)
Explain the factors determining the methods of data processing
Date posted:
June 7, 2018
.
Answers (1)
-
What are the disadvantages of computers
(Solved)
What are the disadvantages of computers
Date posted:
June 7, 2018
.
Answers (1)
-
The two primary objectives of Operating System
(Solved)
The two primary objectives of Operating System use
Date posted:
June 6, 2018
.
Answers (1)
-
Explain two roles of a computer driver
(Solved)
Explain two roles of a computer driver.
Date posted:
June 4, 2018
.
Answers (1)
-
List three categories of operating systems
(Solved)
List three categories of operating systems.
Date posted:
May 26, 2018
.
Answers (1)
-
Define the following terms as used in computer programming: (a.) A compiler (b.) A debugger (c.) An algorithm
(Solved)
Define the following terms as used in computer programming: (a.) A compiler (b.) A debugger (c.) An algorithm
Date posted:
May 26, 2018
.
Answers (1)
-
Create a C++ class called stopwatch that emulates a stopwatch that keeps track of elapse time. Use a constructor to initially set the elapse time...
(Solved)
Create a C++ class called stopwatch that emulates a stopwatch that keeps track of elapse time. Use a constructor to initially set the elapse time to 0.Provide two member function called start() and stop() that turns on and off the timer, respectively. Include a member function called show() that displays the elapsed time.Also, have the destructor function automatically display elapsed when stopwatch object is destroyed.
Date posted:
May 5, 2018
.
Answers (1)
-
How does computer technology threaten the privacy of our data?
(Solved)
How does computer technology threaten the privacy of our data?
Date posted:
April 28, 2018
.
Answers (1)
-
1.(i) Define WIMP
(ii) Explain the elements of WIMP (windows, icons, menus, pointer)
(Solved)
1.(i) Define WIMP
(ii) Explain the elements of WIMP (windows, icons, menus, pointer)
Date posted:
April 24, 2018
.
Answers (1)
-
Explain the meaning of information and communication technology (ICT)
(Solved)
Explain the meaning of information and communication technology (ICT).
Date posted:
April 19, 2018
.
Answers (1)
-
Differentiate between a macro and a module as used in computer applications.
(Solved)
Differentiate between a macro and a module as used in computer applications.
Date posted:
April 3, 2018
.
Answers (1)
-
Explain the disadvantages of digitizers in transferring of spatial data to GIS.
(Solved)
Explain the disadvantages of digitizers in transferring of spatial data to GIS.
Date posted:
March 29, 2018
.
Answers (1)