Preview

Erp Data Warehouse

Satisfactory Essays
Open Document
Open Document
447 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Erp Data Warehouse
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.” An overview of data warehousing and OLAP technology by S Chaudhuri, U Dayal, from ACM Sigmod record, Volume 26 , Issue 1 (March 1997) Pages: 65 – 74.

1. “A data warehouse is an integrated and time varying collection of data derived from operational data and primarily used in strategic decision making by means of online analytical processing (OLAP) techniques.” from “Conceptual data warehouse design” by B. Husemann, J. Lichtenberger, and G. Vossen. Page 1.

2. “A galactic data warehouse is a subject-oriented, integrated, time-variant, non-volatile collection of data in support of management's decision making process about any and all enterprise business processes and departments, and about the enterprise taken as a whole. A business process-oriented data warehouse is a subject-oriented, integrated, time-variant, non-volatile collection of data in support of management's decision making process about any and all business processes and their interactions with one another and the external world. A department-oriented data warehouse is a subject-oriented, integrated, time-variant, non-volatile collection of data in support of management's decision making process about any and all departments, and their interactions with one another and with the external world.” From DKMS Brief No. Six: Data Warehouses, Data Marts, and Data Warehousing: New Definitions and New Conceptions by Joseph M.Firestone.

3. “Physically, a data

You May Also Find These Documents Helpful

  • Good Essays

    Cis 850 Study Guid

    • 499 Words
    • 2 Pages

    * Explain both data warehousing and data mining. How are they related? List at least three uses of data mining.…

    • 499 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    This document is a proposal for building a data warehouse architecture that will consolidate and transform data into useful information for the purpose of decision-making and for establishing a new function that offers a broad array of decision support services to all units at ABC Retail Chain Corporation. Executives and decision-makers often need information to analyze the past, describe current circumstances, and anticipate the future. Presently, decision-makers across the Institute rely on hard copy reports or Excel Sheets to provide information. Typically, any request for information is forwarded to the operational areas of the Organization, which provide hard copy reports reflecting the data gathered in their functional area. To analyze and transform data into useful information, decision-makers and their staff have to manually re-enter the non-integrated data into their own mini-systems. This type of operation hinders the ability of decision making and the executives are either drowning in too much data with no option to analyze it or too little data, which means they are back to square one and must request additional information. Often executives receive multiple, conflicting information or information that is based on incomplete assumptions about the types of analysis required.…

    • 641 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Assignment #1 Hrm 530

    • 634 Words
    • 3 Pages

    HR Data warehouse - Selected Candidate will be responsible for design, implementation and systems expertise of the data warehouse components focusing primarily on business objects Xi. The scope of technical expertise includes design and development of BO reports, security set-up of medium to high complexity levels as well as the ability to coordinate projects with business personnel and other members of the project teams within the organization to ensure that system requirements, deadlines…

    • 634 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Dbm 381 Week 1 Individual

    • 971 Words
    • 4 Pages

    Data warehousing is how a facility stores data for use at a later date. Pulling of patient records to analyze the history of treatments to the results of using certain drugs is available for years. Safeguarding the storage of this…

    • 971 Words
    • 4 Pages
    Better Essays
  • Satisfactory Essays

    Answer: A data warehouse contain pool of data both current and of the past/historical which in turn are used to support decision making by the managers., Without it, GeoStor would lack the variety of data it needs to be able to perform different tasks for different functions.…

    • 617 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    | * IT department is not just one important department for the success of business intelligence of the bank. * The data fed into the warehouse helps IT department to better service the needs of the bank’s internal customers such as sales and marking departments. * However data warehouse which is managed by IT department act as an important source of the bank’s business intelligence.…

    • 341 Words
    • 1 Page
    Good Essays
  • Good Essays

    An active data warehousing, or ADW, is a data warehouse implementation that supports near-time or near-real-time decision making. It is featured by event-driven actions that are triggered by a continuous stream of queries that are generated by people or applications regarding an organization or company against a broad, deep granular set of enterprise data. Continental uses active data warehousing to keep track of their company’s daily progress and performance. Continental’s management team holds an operations meeting every morning to discuss how their company is performing in regards to the data collected by their active data warehousing program. The management team believes, “you can’t manage what you can’t measure,” so they use active data warehousing to keep track of their customers experience while using Continental Airlines. The information that the management team uses to analyze their company in regards to customer relationship is on-time arrival, on-time departures, baggage handling, and other key performance indicators. Continental also uses active data warehousing for revenue management, revenue accounting, flight operations, fraud detection and airline security. Continental restructured their goals to try to become customers “favorite” airline to use. They use their active data warehousing to gain as much information about the company’s performance as well as the customers experience. They use this real-time warehousing program to interpret information that is provided and make changes that will better improve their customers experience and help Continental better suit their business in regards to their customers’ needs.…

    • 1485 Words
    • 6 Pages
    Good Essays
  • Powerful Essays

    Which of the following is true about the terms “data” and “information” within the context of Chapter 1?…

    • 3129 Words
    • 27 Pages
    Powerful Essays
  • Good Essays

    Bis Midterm Sheet

    • 1467 Words
    • 6 Pages

    A data warehouse is to extract and clean data from operational systems and other sources to store and catalog that data for processing by BI tools. Data warehouses can include external data purchased from outside sources. Meta data is kept in the data warehouse. Physically, a data warehouse consists of a few fast computers with very large storage devices.…

    • 1467 Words
    • 6 Pages
    Good Essays
  • Good Essays

    The most important aspect of having data warehousing is the fact that it allows for data storage and presentation of this data enabling executives to make sound decisions. Another important use of data warehousing is it takes the separate areas the company is divided up in and takes it all and lumps it in to one single entity. One great benefit of data warehousing is that Huffman will be able to handle server task connected to all queries which is not commonly found in all systems. “Another powerful benefit of data warehouses is that they allow companies to use data modeling for querying tasks that are quite difficult for transaction processing” (Exforsys, 2007). Huffman trucking is already successful but by implementing a success data warehousing system they would be able to understand and analyze all data coming in and leaving the system better and at a more efficient rate. Attached to this report is a…

    • 891 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    REI - CAHPTER 4, CASE 2

    • 2464 Words
    • 9 Pages

    A data warehouse is a database used for reporting and data analysis. REI is building a data warehouse so that they will precisely know what the customer uses indoors and outdoors.…

    • 2464 Words
    • 9 Pages
    Satisfactory Essays
  • Good Essays

    Operational data are kept in a relational database that structures tables that tend to be extremely normalized. Operational data luggage compartment is optimized to support transactions that symbolize daily operations. For example, Customer data, and inventory data are in a frequent update mode. To provide effective modernize performance, operational systems keep data in many tables with the smallest number of fields. Operational data focus on individual transactions rather the effects of the transactions over time. In difference, data analysts tend to comprise of many data dimensions and are concerned in how the data recount over those…

    • 628 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Digital Forensic Evidence

    • 592 Words
    • 3 Pages

    The future research in this work will involve the implementation of the model in a real world data organization to help to define the functionality of the…

    • 592 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Data Warehousing Failures

    • 5385 Words
    • 22 Pages

    Eight studies of data warehousing failures are presented. They were written based on interviews with people who were associated with the projects. The extent of the failure varies with the organization, but in all cases, the project was at least a disappointment.…

    • 5385 Words
    • 22 Pages
    Powerful Essays
  • Best Essays

    Data Warehousing and Olap

    • 2507 Words
    • 11 Pages

    Data warehousing and on-line analytical processing (OLAP) are essential elements of decision support, which has increasingly become a focus of the database industry. Many commercial products and services are now available, and all of the principal database management system vendors now have offerings in these areas. Decision support places some rather different requirements on database technology compared to traditional on-line transaction processing applications. This paper provides an overview of data warehousing and OLAP technologies, with an emphasis on their new requirements. We describe back end tools for extracting, cleaning and loading data into a data warehouse; multidimensional data models typical of OLAP; front end client tools for querying and data analysis; server extensions for efficient query processing; and tools for metadata management and for managing the warehouse.…

    • 2507 Words
    • 11 Pages
    Best Essays