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

  • 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
  • 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

    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
  • Better Essays

    Data Warehousing

    • 1687 Words
    • 7 Pages

    Data warehousing is the process of collecting data in raw form for analyzing trends. The benefits to data warehousing are improved end-user access, increased data consistency, various kinds of reports can be made from the data collected, gather the data in a common place from separate sources and additional documentation of data. Potential lower computing costs, increased productivity, end-users can query the database without using overhead of the operational systems and creates an infrastructure that can be used when changing systems, these are some more advantages to data warehousing…

    • 1687 Words
    • 7 Pages
    Better Essays
  • Good Essays

    Helping end users to make better business decisions by analyzing, consolidating and providing access to vast amounts of data through a series of tools is referred to Business Intelligence.[2] BI process usually provides users the internal relationship of data so that enable users to see the patterns, relationships and insights of the data and make better decisions. In the Terrorist Watch List Database case, according to the standard provided in the data mining of the database, information can be correctly classified multi-dimensional. For instance, the information on the watch list can be distributed to different government agency systems (e.g. FBI, CIA, NSA,TSA) to detect and trace the movement of suspects. What is more, the information received by different agencies is pre-classified so as to fit the specific agency’s mission. The distribution and integration process involves classification of the information as well as multi-dimensional analysis processes. These processes are all referred to Business Intelligence through which end users get consolidated analysis and get access to vast data.…

    • 860 Words
    • 4 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

    The data warehouse initial focus was to provide accurate integrated data revenue management. At Continental they moves real-time data, ranging from to-the-minute to hourly about customers, reservations, check-ins, operations and flits from its main operation system to the enterprise data ware house.…

    • 1679 Words
    • 7 Pages
    Good Essays
  • Good Essays

    If I were to design Ben & Jerry's data warehouse I would use several dimensions of information. The first dimension would consist of the company's products; ice cream, frozen yogurt or merchandise. The marketing department has to know which products are selling, if Ben & Jerry's didn't know that their T-shirts are selling out as soon as they hit the stores, then they wouldn't be able to take advantage of the opportunity to sell the shirts. The second dimension would consist of the different areas of sales; US, Canada, Mexico, or Europe. I am not sure if they sell their ice cream in Mexico, but with data collection they can find out if their ice cream would be a better seller in the hot climate, rather than pushing for greater distribution in Canada. The third dimension would consist of the "specifics"; where the sale was made, when the sale was made, and who purchased the product. This information can help in the design of the product to focus on the buyer; it can tailor flavors to seasons, and packaging to buyer who looks for the better-looking product. If Ben & Jerry's could know when a season was coming to an end in a specific area, then they could forecast the need or the decline in need and speed up, or slow down distribution to those areas. The focus of the information is that it needs to be useful, and almost any information is useful.…

    • 605 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    A data warehouse is a database that stores current and historical data of potential interest to decision makers throughout the company. [1] After the events of September 11, 2001, the US Government determined the need for a comprehensive single source to identify and deter all persons either suspected to engage in terrorist activities against the US. Thus, the Terrorist Watch List and Database were created, bringing together all the information from various government agencies who had previously been maintaining separate lists of persons, into the Watch List in a standard format and available to all. This database is an example of data warehousing.…

    • 1645 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    dfdfdfdfdfdfdfdfdf

    • 352 Words
    • 2 Pages

    13) A data warehouse also contains a special database that stores the ________, which records the data’s source, history, format and constraints. Page 283…

    • 352 Words
    • 2 Pages
    Satisfactory Essays
  • Best Essays

    Data Warehousing and Olap

    • 2507 Words
    • 11 Pages

    A data warehouse is a “subject-oriented, integrated, time varying, non-volatile collection of data that is used primarily in organizational…

    • 2507 Words
    • 11 Pages
    Best Essays
  • Powerful Essays

    Until recently, data warehousing has been an option mostly for big companies, but the reduced costs of warehousing technology make it practical -- often even a competitive requirement for -- smaller companies as well. Turnkey integrated analytical solutions are reducing the cost, time, and risk involved in data warehouse implementations. While access to the warehouse was previously limited to highly trained analytical specialists, corporate portals now make it possible to grant data access to hundreds or thousands of employees.…

    • 1938 Words
    • 8 Pages
    Powerful Essays
  • Good Essays

    * Recipient of a Leadership in Data Warehousing Award from the Data Warehousing Institute (TDWI), the premier association for data warehousing.…

    • 1302 Words
    • 6 Pages
    Good Essays
  • Powerful Essays

    What Is a Data Warehouse ?

    • 2434 Words
    • 10 Pages

    A data warehouse is a place where data is stored for archival purpose, analysis purpose.…

    • 2434 Words
    • 10 Pages
    Powerful Essays