Characteristics Of A Data Warehouse

Improved Essays
A data warehouse is a big store of data which basically serves as an entity for collecting and storing integrated sets of data from different sources and eras of time period. As per Bill Inmon, father of data warehousing, a data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management 's decision making process. Basically, data warehousing is focused in query and analysis of data. It acts as storage of different kinds of historical data from various sources and helps in distinguishing the major two workloads: transactional and analytical workload. Further, Data warehousing assimilates data stores with different models like conceptual, logical, and physical models so as to provide …show more content…
Subject Oriented:
Relevant and required data are presented as per the subject matter or area of concern, no matter the sources of data collection. Different subject matter can be treated and analyzed separately by retrieving necessary data from the collection of abundant quantity of data from the data warehouse. As an illustration, let us suppose there are departments like finance, human resource, accounting, sales and marketing departments in a company, and then each department can retrieve required data for their specific subject matter from a same storage of data
…show more content…
But the basic architectural components of data warehouse are discussed below:
a. Data source layer
It is one of the components in data warehouse that serves as a supplier of data or information to be stored in a data warehouse. Data source may be any operational systems, flat files, web server logs or third party data source. Further, a data warehouse should treat any incoming information as data irrespective of data format they belong to. b. Data Extraction Layer
This layer comes after the data source layer where data gets extracted from data source into the data warehouse system. While extracting data, if there is a provision of update notification from source system then the updated data can be collected whenever notified, and this is a best approach to carry out in data extraction process. But some source systems may not have this notifying facility but can cite which data has been updated, and in this case a data warehouse can extract required data only. Some sources of data neither provides any notification nor points out the modified data, and this is the condition where full data is to be retrieved from data source. Sometimes data cleansing also occurs here but no major data transformation or modification is

Related Documents

  • Improved Essays

    Nt1310 Unit 4 Assignment

    • 293 Words
    • 2 Pages

    1. Collect data – internal and external: are made up of secondary sources of data. Internal data: is a data which is already in operation and it is stored within the organisation. For example: profit and loss statement, balance sheet, sales figures and inventory records. While External of data: is the data which does not exist inside the company, but was brought by individuals from outside the organisation, for example: government sources, corporate filings and media, including broadcast, print and internet (Grimsley, Sources of Secondary Data, 2003-2015).…

    • 293 Words
    • 2 Pages
    Improved Essays
  • Improved Essays

    1-1. What is the “Post-PC era”? The post PC era is where wireless, mobile devices such as iPads and notebook out sell PC’s and become the mainstream popular demand. 1-2.…

    • 571 Words
    • 3 Pages
    Improved 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
  • Improved Essays

    Nt1310 Unit 3 Study Guide

    • 703 Words
    • 3 Pages

    11. OLAP: an online analytical processing (OLAP) engine, responsible for data discovery, including capabilities for limitless report viewing, complex analytical calculations, and predictive “what if” scenario (budget, forecast) planning. It performs multidimensional analysis of business data and provides the capability for complex calculations, trend analysis, and sophisticated data modeling. 12. “Drill down”: To drill down means to go through the hierarchy of folders to find a specific file or to click through drop-down menus in a GUI or access database.…

    • 703 Words
    • 3 Pages
    Improved 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
  • Decent Essays

    Operational Support: An operational support system (OSS) is a group of computer programs or an IT system used by communications service providers for monitoring, controlling, analyzing and managing a computer. John Lewis do this so they can see the products they are selling well they day by their till. The till sends information to a data base that records what they are selling and what is getting returned. Data Analysis: Data analysis, is a process of inspecting, cleansing, transforming, and modeling date with the goal to discovering key information, suggesting, conclusions, and supporting decision making towards a subject.…

    • 458 Words
    • 2 Pages
    Decent 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
  • Great Essays

    Nt1330 Unit 2 Case Analysis

    • 2280 Words
    • 10 Pages

    Question 1 a. The approach I would take to determine if it is more cost effective to produce firmware (HW/SW) units to determine economic feasibility for producing the units in-house sourcing or outsourcing by using cost-benefit analysis checklist that includes: • Consider all strategies for development. • Each alternative should have costs and benefits and identify when realization of cost and benefits will be ensued. • The analysis will include future growth to allow for scalability.…

    • 2280 Words
    • 10 Pages
    Great Essays
  • Decent Essays

    End-Of-Chapter Quiz

    • 680 Words
    • 3 Pages

    Correct answer Screenshot 2) Bringing data in from an external data source is known as: (1 point) Correct answer Importing 3) This is stored in columns and contains a specific type of data such as name, employee number, or social security number.…

    • 680 Words
    • 3 Pages
    Decent Essays
  • Improved Essays

    Target Corporation enhances its information warehouses with latest big data that is technologically sophisticated to crunch large data using complex algorithms and provide vital output data for a daily operation as well as strengthen its capabilities over its rival which is a competitive advantage and speed up worker productivity. A quality tracking tool provided by an information system tracks each package, parts ensuring the goods meet the quality standard. Target Corporation allocated large budget to upgrade the information system as part of a roadmap to transform business (Target Roadmap, 2015). The internal information system supports demand forecasting for accurate inventory, provides relevant analytics capabilities to varies internal…

    • 1009 Words
    • 5 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
  • Improved Essays

    Logos In the journal, Dr. Gamage uses the rhetorical appeals technique by the logos method in frequent. Logos is a literary device such as a statement or an argument used to persuade the target audience with a logic. Hence, the author uses logos to make his statement concrete with the supportive facts and documents. Dr. Gamage raises the curiosities of the Big Data, and he predicts it will be the major trend in the future. The author points out Big Data consistently benefits the enterprises, “research indicates that 77% of companies that are good with data achieve better financial performance” and “those who were early adopters of Big Data analytics not only gained a substantial lead in the corporate world but those with advanced analytics…

    • 298 Words
    • 2 Pages
    Improved Essays
  • Great Essays

    Choosing A Family Dog

    • 520 Words
    • 3 Pages

    What is your main criterion for choosing a family dog? We live in an apartment, so my most important criteria is size. Do you have any other important criteria for choosing a family dog? I guess breed would be another important criteria. .…

    • 520 Words
    • 3 Pages
    Great Essays
  • Improved Essays

    In 2012 retail chain, Target could successfully identify pregnant women based on purchasing demographic data parsed through their predictive models, moreover they could presume the gender of the child and the progress of the pregnancy. The recent use of big data and data mining for business, personal and security related advantages have had questionable ethics between consumers and enterprises alike. However, the definitive benefits produced by big data undoubtedly exceed the potential risks that may present themselves over time. The collection and processing of substantial volumes of data by businesses to enhance their operations is not a new idea and has been around years before the popularization of the term Big Data.…

    • 337 Words
    • 2 Pages
    Improved Essays
  • Great Essays

    The current DataClear website describes the company as “a team of industry experts, business consultants, college professors, data scientists and technical architects” (DataClear, 2016). DataClear provides business advisory services, technical…

    • 1259 Words
    • 6 Pages
    Great Essays