Creating a Data Warehouse

Powerful Essays
Topics: Data warehouse
Research Paper

Creating a Data Warehouse

Introduction
Data warehouses are the latest buzz in the business world. Not only are they used to store data for reporting and forecasting, but they are part of a decision support system. There are many reasons for creating and using a data warehouse. The data warehouse will support the decisions a business needs to make, usually on a daily basis. The data warehouse collects data, consolidates the data for reporting purposes. Data warehouses are accompanied by analytical tools that accommodate forecasting as part of the decision support system. The purpose of this paper is to explore the creation of a data warehouse. Since the specifics of creating the data warehouse are determined by the database system, this paper will devote its discussion to the design or layout of the data warehouse. Before discussion of the layout of the data ware house proceeds, the basics about a data warehouse need to be discussed. Then the elements of the data ware house will be covered.

What is a Data Warehouse?
A data warehouse is a warehouse full of data, an electronic warehouse. In a manner of speaking this is true. Don Awalt describes it as follows, “A data warehouse is the cohesive data model that defines the central data repository for an organization. “ He also further stated that “we consider it a complete, integrated data model of the enterprise, regardless of how of where the data is stored.” Thus we can see that the data warehouse collects and stores the data for an organization in an organized manner that allows for analytical purposes. These purposes can be for forecasting, predictive analysis or for historical reporting. Many organizations utilize an online transaction processing system (OLTP), while the data warehouse can be used with a tool such as online analytical processing (OLAP) and data mining. Since the purpose of the OLAP differs from the OLTP, the design characteristics of a relational database that



References: Awalt, Don, and Brian Lawton. "Data Warehousing: Back to Basics." SQL Server Magazine Feb. 2000. 1 Feb. 2008 http://www.sqlmag.com/Article/ArticleID/7833/sql_server_7833.html. "Creating an Oracle Data Warehouse." Oracle. 1 Feb. 2008 . "Data Warehouse Design Considerations for SQL Server 2000." Microsoft. 1 Feb. 2008 . "DB2 Database for Linux, UNIX and Windows." IBM. 1 Feb. 2008 . "How to Create a Data Warehouse Structure." Exforsys, Inc. 1 Feb. 2008 . Marakas, George M. Decision Support Systems in the 21st Century. 2nd ed. Upper Saddle River, New Jersey: Prentice Hall, 2003. Turban, Efraim, Jay E. Aronson, Ting-Peng Liang, and Ramesh Sharda. Decision Support and Business Intelligence Systems. 8th ed. Upper Saddle River, New Jersey: Prentice Hall, 2007.

You May Also Find These Documents Helpful

  • Powerful Essays

    Data Warehouse

    • 4241 Words
    • 38 Pages

    Data Warehouse Concepts and Design Contents Data Warehouse Concepts and Design 1 Abstract 2 Abbreviations 2 Keywords 3 Introduction 3 Jarir Bookstore – Applying the Kimball Method 3 Summary from the available literature and Follow a Proven Methodology: Lifecycle Steps and Tracks 4 Issues and Process involved in Implementation of DW/BI system 5 Data Model Design 6 Star Schema Model 7 Fact Table 10 Dimension Table: 11 Design Feature: 12 Identifying the fields from facts/dimensions: MS: 12 Advanced…

    • 4241 Words
    • 38 Pages
    Powerful Essays
  • Powerful Essays

    DATA WAREHOUSES & DATA MINING Term-Paper In Management Support System [pic] Submitted By: Submitted To: Chitransh Naman Anita Ma’am A22-JK903 Lecturer 10900100 MSS ABSTRACT :- Collection of integrated, subject-oriented, time-variant and non-volatile data in support of managements decision making process. Described as the "single point of truth", the "corporate memory", the sole historical register of virtually all transactions…

    • 2771 Words
    • 12 Pages
    Powerful Essays
  • Powerful Essays

    Information Systems Management Research Project ON Data Warehousing and Data Mining Submitted in Partial fulfilment of requirement of award of MBA degree of GGSIPU, New Delhi Submitted By: Swati Singhal (12015603911) Saba Afghan (11415603911) 2011-2013…

    • 2521 Words
    • 11 Pages
    Powerful Essays
  • Good Essays

    Fig: Architecture of data warehouse Operations Conceiving data as a cube with hierarchical dimensions leads to conceptually straightforward operations to facilitate analysis. Aligning the data content with a familiar visualization enhances analyst learning and productivity.[5] The user-initiated process of navigating by calling for page displays interactively, through the specification of slices via rotations and drill down/up is sometimes called "slice and dice". Common operations…

    • 337 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Erp Data Warehouse

    • 447 Words
    • 2 Pages

    IST/ERP 444 Data Warehouse Homework 1: Definition of Data Warehousing Name: Rallapalli Venkata Pavani Search any resource (Books, Web Sites, Papers, etc.) to find three definitions for Data Warehousing. Include the detailed information (Title, authors and the source of the definitions. For example: “Data warehousing is a collection of decision support technologies, aimed at enabling the knowledge worker (executive, manager, analyst) to make better and faster decisions.”…

    • 447 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    What Is a Data Warehouse ?

    • 2434 Words
    • 10 Pages

    Question 1 What is a data warehouse? What problems does it solve for a business? A data warehouse is a place where data is stored for archival purpose, analysis purpose. Usually a data warehouse is either a single computer or many computers servers tied together to create one giant computer systems. Data warehouse solve a lot of problems to companies as it helps to structure files and avoid unnecessary duplication of data. Data warehouse also allows to easily updating data and encourages management…

    • 2434 Words
    • 10 Pages
    Powerful Essays
  • Good Essays

    Data Warehouse Testing

    • 1191 Words
    • 5 Pages

    Data Warehouse Testing By : Kartikey Brahmkshatriya (M.C.A) Index 1. Introduction 3 2. About Data Warehouse 3 2.1 Data Warehouse definition 3 3. Testing Process for Data warehouse: 3 3.1 Requirements Testing : 3 3.2 Unit Testing : 4 3.3 Integration Testing : 4 3.3.1 Scenarios to be covered in Integration Testing 5 3.3.2 Validating the Report data 5 3.4 User Acceptance Testing 5 4. Conclusion 5 Introduction This document details the testing…

    • 1191 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    CHAPTER 3 DATABASES AND DATA WAREHOUSES Building Business Intelligence CONTACT INFORMATION: Stephen Haag is the primary author of this chapter. If you have any questions or comments, please direct them to him at shaag@du.edu. THIS CHAPTER/MODULE IN SHORT FORM… This chapter introduces your students to the vitally important role of information in an organization and the various technology tools (databases, DBMSs, data warehouses, and data-mining tools) that facilitate the management…

    • 8422 Words
    • 34 Pages
    Powerful Essays
  • Best Essays

    Data Warehouse and Crm

    • 3661 Words
    • 15 Pages

    More than Data Warehouse- An insight to Customer Information Ritu Aggrawal – agg_ritu@rediffmail.com Deepshikha Kalra -deepshikha_ishan@yahoo.co.in working with MERI affiliated to GGSIPU, Delhi ABSTRACT The business requirements of an enterprise are constantly changing and the changes are coming at an exponential rate. Like advances in Information Technology have helped companies to quickly match competition. As a result, product quality and cost are no longer significant competitive…

    • 3661 Words
    • 15 Pages
    Best Essays
  • Satisfactory Essays

    John Smith Dr. Daniels 2/14/13 Chapter 5 Video Case 1. Data warehouses store current as well as historical data and are used for creating trending reports for senior management reporting such as annual and quarterly comparisons. REI is building a data warehouse because they want to better serve their customers with their products. The data ware house allows REI to make the customers experience with their company a much more fulfilling one ensuring their return. 2. Consumer cooperatives…

    • 310 Words
    • 2 Pages
    Satisfactory Essays