Similarities And Differences Of The Data Warehouse And Data Management Strategy

Improved Essays
A Data Warehouse is a centrally placed storage for data collected from within and outside the organisation. The collected information is organised around key business objectives, and it is utilised during analysis and reporting. It is simply a central database with the sole purpose of analysis and reporting. On the other hand, a Data Mart is much smaller than a Data Warehouse and is applied in a functional area like say finance, where the enterprise adjudges that it would profit from business intelligence. Simply put, a Data Mart can be a single piece or a subset of a Data Warehouse that focuses on a particular enterprise segment. Many Data Marts put together, create a Data Warehouse.
The similarity and differences of the Data Warehouse and
…show more content…
It emphasises on the kind of data and software combined to deliver information necessary for the implementation of the business strategy. Rouse (2010) identified various data management policies like Data life cycle Management, Master Data Management policy and Big Data Management policy. The Data Life Cycle Management policy focuses on managing how information flows throughout the data’s life cycle. The policy controls data movement from the creation stage until the time the data is deemed obsolete. The other that is Master Data Management strategy enables an enterprise to link all its crucial data together through a master file. The master file would act as the common point of …show more content…
This type of management approach organises the various assets that are data warehousing, business intelligence and database management systems to its corresponding disciplines. Such coordination of the information assets and the data management disciplines ensures that information strategy is appropriately and efficiently aligned to the enterprise’s goals. Such an approach provides strategic business intelligence, business transformation and integration, which enables organisations develop best practices. It brings together previously siloed information technology teams into one coherent camp that can reuse and share information technology systems and in the long-run improve operational excellence. Therefore, the Unified Data Management Strategy brings together segmented divisional use of data into one pool that utilizes similar data analysis tools and

Related Documents

  • Improved Essays

    Nt1310 Unit 3 Study Guide

    • 703 Words
    • 3 Pages

    1) What is BI? Business intelligence, or BI, is an umbrella term that refers to a variety of software applications used to analyze an organization’s raw data. Companies use BI and several related activities, including data mining, online analytical processing, querying and reporting to improve decision making, cut costs, identify new business opportunities and identify inefficient business processes that are ripe for re-engineering. 2) What is Visual Analytics, dashboards, data warehouse, data dictionary, meta data, ETL, schema, attributes, hierarchy, cube, OLAP, “drill down”, data mining, data mapping.…

    • 703 Words
    • 3 Pages
    Improved Essays
  • Improved Essays

    Ba501 Week 1 Assignment

    • 740 Words
    • 3 Pages

    BA501 Overview of Business Intelligence Week 1 Assignment David Nagus Grantham University Professor Jackson May 6, 2015 I Introduction With any business with a database system there are bound to be changes and different metrics used in the decisions of running a business. These days almost all businesses have a computer system or network of computers that are interlinked. One aspect of a business is how they secure their network and who has access to data and who does not. On a almost daily basis businesses are being targeted with threats from outside sources to steal data, cause harm or disrupt the daily workings of a business and affecting people's lives.…

    • 740 Words
    • 3 Pages
    Improved Essays
  • Improved Essays

    College to Career: A recent survey commissioned by Bentley University in 2014 found that “compared with business decision-makers and corporate recruiters, high school and college students were far less likely to define preparedness in terms of personal traits or work ethic” (Chase, 2015). This means skills and experience rank high for college students when they evaluate preparedness. Unfortunately, the same survey found “thirty-seven percent of recent college graduates give themselves a grade of “C” or lower on their individual level of preparedness” (Chase, 2015).…

    • 899 Words
    • 4 Pages
    Improved Essays
  • Decent Essays

    Ist 305 Assignment 6-3

    • 538 Words
    • 3 Pages

    ID: 2597622 IST 305 – Assignment 6 6-1: The Toronto Globe and Mail had an information systems issue with how their business databases and files were stored. Throughout the firm, multiple databases were isolated and duplicated among departments. This had caused issues, such as their subscribers receiving unnecessary marketing material, and not being able to keep the databases secure. In order for them to solve this issue was to implement and store all company data into a data warehouse using SAP NetWeaver, as well as educate their own employees on the new system to prevent further inconsistent databases. By implementing the data warehouse and training their employees, it produced the results that management envisioned.…

    • 538 Words
    • 3 Pages
    Decent Essays
  • Decent Essays

    Macy’s Inc. relies extensively on technology and on its information systems to process transactions, compile results and operate its business. As an advantage, Macy’s Systems and Technology, Inc. engages in creating, collecting, and directing pieces of data to form management tools. The company implements integrated retail, e-commerce, and data warehouse systems. As a disadvantage, the information systems can be subject to interruption from power outages, damage from viruses, cyber-attack or other security breaches. In these cases, companies like Macy’s may experience the loss of critical data and delays in its processes.…

    • 111 Words
    • 1 Pages
    Decent Essays
  • Improved Essays

    IT security threats and cryptography 7/A. P1: Explain the different security threats that can affect the IT systems of originations. 7/A.M1: Assess the impact that IT security threats can have on organization's IT systems and business whilst taking account of the principles of information security and legal requirements In today's society data is a very valuable thing companies have to take in to account how to protect that data from the threats, Threats is a way in which the data is vulnerable and therefore rules and regulations have been put in place to stop these potential threats for example all will have adhere to the principles of information security this is a way in which data is protected, I have been working for a start-up company…

    • 1332 Words
    • 6 Pages
    Improved Essays
  • Improved Essays

    Cookie-Cutter Strategies

    • 384 Words
    • 2 Pages

    There is no silver bullet that will transform student retention rates in a few days. Student success will happen over time, not overnight. We cannot dismiss the urgency of the moment. We must be fully committed to perform every function, take advantage of every opportunity, and be accountable for every responsibility so that student success becomes a reality. Academic institutions have developed best practices that we can follow.…

    • 384 Words
    • 2 Pages
    Improved Essays
  • Superior Essays

    Zillow Case Study Essay

    • 1460 Words
    • 6 Pages

    Introduction In this case study, the business of Zillow.com in providing real estate information to all users to its website is explored, and the use of business intelligence by Zillow.com in its offering to customer, and the way it uses a data mart to market its new product, are discussed. In addition, this case study includes a discussion of various characteristics of information quality as seen from Zillow’s perspective, and how Zillow is using a data-driven website. Analysis Background of Zillow.com Zillow.com is an online web-based real estate site helping homeonwers, buyers to find and share information about real estate and mortgages. It allows users to access information anonoyoumously and free of charge, using the kinds of tools…

    • 1460 Words
    • 6 Pages
    Superior Essays
  • Great Essays

    Case Study Assignment – I Campbellsville University MASSIVE DATABASE MASTERING - MASTERCARD INTERNATIONAL Various affiliations are endeavoring to address the open entryways and limit challenges related with "huge data." Industry masters gage that the total volume of data is increasing at general interims and most by a wide margin of new data being delivered is prepared to go spaces. MasterCard Universal (www.mastercard.com) is not any more impossible to miss to think about the issues identified with monstrous databases. MasterCard has amassed a data circulation focus that is more than 100-terabytes in size. Insiders expect that it will create to more than 1.8 petabytes.…

    • 933 Words
    • 4 Pages
    Great Essays
  • Great Essays

    Data Retention Policy

    • 1877 Words
    • 8 Pages

    1 Data archiving is the process of moving data that is no longer actively used to a separate storage device for long-term retention. Archive data consists of older data that is still important to the organization and may be needed for future reference, as well as data that must be retained for regulatory compliance. Data archives are indexed and have search capabilities so files and parts of files can be easily located and retrieved. Archiving information involves removing old inactive files from the main filing system, thereby freeing space for current 'active' files that need to be accessed regularly but with the advantage that they can be retrieved at a later date if required. Usually it is easy to predict when something needs to be archived…

    • 1877 Words
    • 8 Pages
    Great Essays
  • Brilliant Essays

    The next best practice is information management. The author believes that technology is not the answer but an enabler for companies to manage their information as an asset. The main purpose of managing information as an asset is to benefit the customer. "There has to be a sustained commitment to change attitudes and behavior if technology is going to help in leveraging information assets for the benefit of the customer." (Unruh, 1997)…

    • 3010 Words
    • 13 Pages
    Brilliant Essays
  • Decent Essays

    Reginald, Eveyone uses statistic on a daily basis, however some individuals do not realize they are using statistic practices in solving there problems. I enjoyed reading your post. Moreover, how you where able to apply the knowledge of larger samples produce significat outcomes in your IT department. The data has proven to be critical in assisting you in making sound business decisions.…

    • 104 Words
    • 1 Pages
    Decent Essays
  • Improved Essays

    Nt1330 Chapter 9

    • 1156 Words
    • 5 Pages

    Submit the questions as a Word document attachment. Chapter 9 Project Questions: 56, 59, & 60. Ensure you include a link to the websites and APA information. Chapter 9 Review Questions: 1, 2, 4, 7 - 9, 11 - 19, 30, 31, 36, 38 - 45, 51, & 54. Chapter 10B Review Questions: 8 - 11.…

    • 1156 Words
    • 5 Pages
    Improved Essays
  • Superior Essays

    Amazon Research Paper

    • 1604 Words
    • 7 Pages

    This assignment has presented three main points why big data is so crucial. Firstly, Amazon is widely praised for having pioneered web-based customer relations, setting an industry benchmark in market-leading technological infrastructure. Secondly Amaxon offer anonline personal service References Kotler, P., Armstrong, G., Wong, V., and Saunders, J., 2008. Principles of Marketing.…

    • 1604 Words
    • 7 Pages
    Superior Essays
  • Superior Essays

    Command Prompt

    • 1077 Words
    • 5 Pages

    Files are produced for a reason, and the files must be managed and secured effectively. In addition to the appropriate security, the information must be backed up and recoverable if needed. An organization will produce data, and the need to manage the data is often overlooked; however, it is not any less important than the business itself. Effective file management and the business go…

    • 1077 Words
    • 5 Pages
    Superior Essays