Data Warehouse is a system designed to meet information needs, generating and maintaining data extracted from transactional systems, operational data stores and external sources. The data is organized in a warehouse that combines them through summaries and aggregations, making them suitable information for decision making.
It is a database for decision support of end users, derived from several other operational databases. (SERRA, 2002, p.140).
Crudely speaking, the operational systems of record are where the data is put in, and the data warehouse is where we get the data out. (Kimball, 1998, p.9).
According to Kimball (1998), a data warehouse system consists of basic elements that are source systems, data preparation area, data warehouse presentation servers, dimensional model, business processes, data marts, data warehouse, operational data storage (ODS), OLAP, ROLAP, MOLAP, end-user application, end-user data access tool, ad hoc search tool, modeling applications, and metadata.
Creating a data warehouse requires time, money, and considerable managerial effort. Many companies begin a data warehouse project focusing on the special needs of small groups within the organization. These small data stores are called data marts. A data mart is a small data warehouse that supports the decision of a small group of people. (SERRA, 2002, p.136).
Also, Kimball (1998) informs that the Data Warehouse makes information accessible to an organization and makes it consistent. It is a source of information designed for continuous change, protects informational heritage, and is the basis for fact-based decision making.
Text: Pedro Carneiro Jr.
Revision: Luis Cláudio R. da Silveira
These are the posts on the same “Enum and Quality in BI” monograph:
- When to use Enums?
- About The Software Design Science – Part 1 of 2
- About The Software Design Science – Part 2 of 2
- About Business Intelligence (BI)
- About Business Intelligence: The Relationship Between Data, Information and Knowledge
- About Business Intelligence: The Quality of Data
- About Business Intelligence: The Quality of Information
- About Business Intelligence: The Relationship Between Operational Information and Managerial Information
- About Business Intelligence: The Adequacy of the Information to the Business Needs
- About Business Intelligence: Data Warehouse
This short text is a mere Portuguese to English translation from part of my monograph “THE PERSISTENCE OF ENUMERATIONS IN POSTGRESQL DATABASES AND QUALITY IN BUSINESS INTELLIGENCE” (free translation of the title), also aliased as “Enum and Quality in BI”, which corresponds to a minor part of the document structure.
- SERRA, Laércio. A Essência do Business Intelligence. 1ª ed. São Paulo:
Berkeley, 2002 – https://www.skoob.com.br/a-essencia-do-business-intelligence-154218ed172085.html, ISBN-10: 8572516301;
- KIMBALL, Ralph et al. The Data Warehouse Lifecycle Toolkit. New York, USA: Wiley, 1998 – http://www.wiley.com/WileyCDA/WileyTitle/productCd-0471255475.html, ISBN: 978-0-471-25547-5.
- “The Commons”, Flickr.com / Internet Archive Book Images – https://www.flickr.com/photos/internetarchivebookimages/14737878176/sizes/l