Gupta, Pranshu Department of Mathematics and Computer Science, DeSales University, Center Valley, Pennsylvania.
Mata-Toledo, Ramon A. Department of Computer Science, James Madison University, Harrisonburg, Virginia.
Last reviewed:January 2020
- Data warehousing
- Designing a data warehouse
- Building a data warehouse
- Monitoring a data warehouse
- Data warehouse versus operational systems
- Related Primary Literature
- Additional Reading
A data warehouse is an automated warehouse where related information is stored. Users can have access to large amounts of consistent, organized, and related information in a data warehouse. It is advantageous to have access to information from different sources at a centralized location because it is easy to analyze the data at one location, as compared to analyzing data in separate locations. The data can be cleansed, integrated, and organized resulting in generation of historical data, which can be analyzed for patterns that can help in making important business decisions. One of the main advantages of a data warehouse is that it supports decision support system applications. Multiple decision-support environments pose a problem of redundancy because, while they can be operated independently, each environment requires much of the same data. Also, a data warehouse supports data mining, as it can store massive, detailed, and historical data that can be analyzed for known and unknown patterns in different domains. See also: Data mining
The content above is only an excerpt.
for your institution. Subscribe
To learn more about subscribing to AccessScience, or to request a no-risk trial of this award-winning scientific reference for your institution, fill in your information and a member of our Sales Team will contact you as soon as possible.
to your librarian. Recommend
Let your librarian know about the award-winning gateway to the most trustworthy and accurate scientific information.
AccessScience provides the most accurate and trustworthy scientific information available.
Recognized as an award-winning gateway to scientific knowledge, AccessScience is an amazing online resource that contains high-quality reference material written specifically for students. Contributors include more than 10,000 highly qualified scientists and 46 Nobel Prize winners.
MORE THAN 8700 articles covering all major scientific disciplines and encompassing the McGraw-Hill Encyclopedia of Science & Technology and McGraw-Hill Yearbook of Science & Technology
115,000-PLUS definitions from the McGraw-Hill Dictionary of Scientific and Technical Terms
3000 biographies of notable scientific figures
MORE THAN 19,000 downloadable images and animations illustrating key topics
ENGAGING VIDEOS highlighting the life and work of award-winning scientists
SUGGESTIONS FOR FURTHER STUDY and additional readings to guide students to deeper understanding and research
LINKS TO CITABLE LITERATURE help students expand their knowledge using primary sources of information