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

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

    The data has proven to be critical in assisting you in making sound business decisions. I concer that a lot of what we do in our place of employment is based on reading and interpertating data. Not only do we have to make sense of the data but also know what the probabilities of the desired result.…

    • 104 Words
    • 1 Pages
    Decent Essays
  • Improved Essays

    Ba501 Week 1 Assignment

    • 740 Words
    • 3 Pages

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

    Cardinal Health's implementation of SAP R/3 and a data warehouse in their medical products and services business, in combination with the willing and successful adoption by their employees, provided the foundation to create a powerful and functional advanced BI that the company leveraged to create competitive advantage in their industry and set the precedent for others looking to institute similar BPR projects. There were many examples of what Cardinal Health did right in order to achieve such a successful implementation and adoption of a drastically different business culture. First and foremost, Cardinal Health recognized early on that the requirement for senior executives and line managers…

    • 532 Words
    • 3 Pages
    Decent Essays
  • Improved Essays

    •Data and data management – The amount of data available today and the increased customer demand for access to a lot of product information makes data management a priority (Gregoire, 2014).…

    • 899 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    Unit 7 D2

    • 693 Words
    • 3 Pages

    Data warehouses- collects data from multiple databases and data silos; then organizes them for complex analysis, to gain more knowledge, and to use in their decision process.…

    • 693 Words
    • 3 Pages
    Improved Essays
  • Decent Essays

    Ist 305 Assignment 6-3

    • 538 Words
    • 3 Pages

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

    Nt1330 Chapter 9

    • 1156 Words
    • 5 Pages

    54. Data repository is important due to giving important information about the database, including permissions, user data, and a general bird-eyes view of what state the database is in. Without one large organizations have trouble making decisions on their overall…

    • 1156 Words
    • 5 Pages
    Improved Essays
  • Great Essays

    Data Retention Policy

    • 1877 Words
    • 8 Pages

    1.4 A data retention policy is the first step in helping protect an organization's data and avoid financial, civil and criminal penalties that increasingly accompany poor data management practices. Local, state, federal and international laws and industry regulations not only specify the types of data organizations and businesses must retain, legislation and industry guidelines also dictate how long specific types of data must be maintained and even the manner in which the data is to be stored. But legal considerations aren't the only reason to develop and implement strong data retention practices.…

    • 1877 Words
    • 8 Pages
    Great Essays
  • Superior Essays

    Zillow Case Study Essay

    • 1460 Words
    • 6 Pages

    Fourth, with a relational database, integrity contraints (both relational and business-critical) helps a company enforce business rules that ensures high information quality which provide better business decision support. Fifth, databases offer security features such as passworeds authentication, access level authorization. With cloud computing, the risk of data breach increases, so sound data governance policies and procedures help companies defend against information security threats (Baltzan,…

    • 1460 Words
    • 6 Pages
    Superior Essays
  • Great Essays

    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. The advancement of MasterCard's data stock room is empowered by a client/server…

    • 933 Words
    • 4 Pages
    Great Essays
  • Great Essays

    The article “Defining the duality of data governance” by Zweli Sikhakhane explores the duality of data governance, discusses what data duality isn’t and why data duality is essential for data-centric and data-aware cultures in corporations. The article describes data governance…

    • 1677 Words
    • 7 Pages
    Great Essays
  • Great Essays

    As the U.S. market leader in data analytics and management, DataClear will establish global operations making our expertise and resources available to business around the world. We will offer our global partners and customers the most modern and reliable data management systems available. We will apply the same level of standards and process excellence that we established within our domestic market, ensuring that we capture lessons learned, embrace diversity and become relevant members of our global customer teams.…

    • 1259 Words
    • 6 Pages
    Great Essays
  • Superior Essays

    Data integrity ensures that data is ultimately accurate. This is important when trying to analyze data that is stored in the database or data warehouse. Inaccurate data will lead to false results in reporting and analytics that will affect any business decisions that need to be made. When dealing with data integrity, having the full or complete set of data is a necessity. If only half or some of the data is entered than it cannot be considered accurate. There are several ways to ensure that data integrity is being followed by using: constraints, primary and foreign keys, and removing duplicate data from the database. When merging two company’s data into one data warehouse, data integrity needs to be checked using a technique known as data scrubbing.…

    • 1257 Words
    • 5 Pages
    Superior Essays
  • Superior Essays

    To initiate about databases, they are valuable across the world by people as individuals or predominantly by businesses for various reasons in which I will evaluate below. The title derives from incorporating any amounts of data from small to large scaled into a base, a base is a foundation that brings this data into one area (usually software) for ease of access, management, processing and locating in an organised manner.…

    • 1005 Words
    • 5 Pages
    Superior Essays