Free

DW - Components of Data Warehouses - Assignment Example

Summary

According to Kimball and Ross (2002), data sources refer to electronic repository that generates data that are directed towards the data warehouse either on a regular interval or on a real-time basis for transaction by transaction. Examples of sources systems include Excel files…

Download full paper File format: .doc, available for editing

GRAB THE BEST PAPER92.9% of users find it useful

Read Text Preview

Subject: Information Technology
Type: Assignment
Level: High School
Pages: 1 (250 words)
Downloads: 2
Author: diegomohr

Extract of sample "DW - Components of Data Warehouses"

Components of a Data Warehouse s Components of a Data Warehouse Data sources According to Kimball and Ross (2002), data sources refer to electronic repository that generates data that are directed towards the data warehouse either on a regular interval or on a real-time basis for transaction by transaction. Examples of sources systems include Excel files / MS Access, customer service system, cash management systems, flat files, and C-L system.Data transformation The second key component is data transformation or staging, where data is received from the sources.

This component cleans, consolidate, standardize, reconcile, augment, and enrich data before it is transfers it to the data warehouse (Kimball and Ross, 2002). Data warehouseAccording to Kimball and Ross (2002), this is the third key component and it is designed to store information in a format compatible with other systems where data passes and makes it easily accessible for different users. Kimball and Ross (2002) further added that data warehouse provides security to data, monitor updates from different sources, and even checks the quality of data.

ReportingThis component mainly ensures that data is available for all the users from the central data warehouse.Metadata According to Kimball and Ross (2002), metadata or data about data is mainly designed to inform users about the status of the data warehouse and the information that are stored in the data warehouse.OperationsThis component consists of the process of loading, manipulating, and retrieving data from the data warehouse. Operations also include data management and capacity management.

Complementary componentsThese complementary or optional components only exist in some data warehouses and they include dependent data marts and logical data marts. Kimball and Ross (2002) stated that the dependent data mart is a physical database, which gets its information from the data warehouse. The dependent data mart could exist as part of the central database or on a separate hardware platform.In regards to logical data mart, Kimball and Ross (2002) stated that it is a filtered view of the central data warehouse but it does not physically exist as separate data copy.

ReferencesKimball, R. and Ross, M. (2002). The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling. (2nd edition). U.S: Wiley Publishers

Cite this document

APA
MLA
CHICAGO

(“DW - Components of Data Warehouses Assignment Example | Topics and Well Written Essays - 250 words”, n.d.)
DW - Components of Data Warehouses Assignment Example | Topics and Well Written Essays - 250 words. Retrieved from https://studentshare.org/information-technology/1620947-dw-components-of-data-warehouses

(DW - Components of Data Warehouses Assignment Example | Topics and Well Written Essays - 250 Words)
DW - Components of Data Warehouses Assignment Example | Topics and Well Written Essays - 250 Words. https://studentshare.org/information-technology/1620947-dw-components-of-data-warehouses.

“DW - Components of Data Warehouses Assignment Example | Topics and Well Written Essays - 250 Words”, n.d. https://studentshare.org/information-technology/1620947-dw-components-of-data-warehouses.

Cited: 0 times

CHECK THESE SAMPLES OF DW - Components of Data Warehouses

The Nature and Importance of Warehousing

warehouses are used by people like manufacturers, importers, exporters, people in the logistics industry etc.... With the advent of globalization and information technology, nowadays, warehouses are being fully automated.... In such automated warehouses, there are hardly any workers found working inside....

10 Pages (2500 words) Research Paper

Managing Information Systems

Expand usage of the system within company by identifying non-users of data warehouse and schedule them for appropriate training.... data warehousing rose out of a need top compile a company's interesting data that was stored in disparate database.... data is therefore copied from operational databases, transformed and exported into a warehouse in a predetermined format that will allow it to be queried. … "A data warehouse is a logical collection of information gathered from many different operational databases used to create business intelligence that supports business analysis activities and decision-making tasks, primarily, a record of an enterprise's past transactional and operational information, stored in a database designed to favor efficient data analysis and reporting....

15 Pages (3750 words) Essay

What Is a Data Warehouse and Its Importance

data warehouses are traditionally set up to update the operational data on a daily basis.... hellip; Generally speaking, it is essential to state that business decisions are taken with the help of data and information available in the context and companies are rapidly adopting innovative tools and techniques to facilitate the process of data collection and conversion into relevant meaningful information.... The data warehouse is a silo of data gathered from multiple data sources that are coming from wide-ranging sources and forming an all-inclusive database by filtering the old and new data based on business logic and the need of the organization....

9 Pages (2250 words) Coursework

The Impact of Semi-Passive RFID Tags on the UK Warehouse Operations Performance

Refined in 1948 for ‘civilian' use (Roberts, 2006) the system consists of “two basic components – a transponder [the tag itself] and a transceiver [the reader].... Warehousing in its most simplistic form consists of receiving and identifying incoming objects, storing them temporarily in appropriate locations within the warehouse and, when required retrieving them for onward transmission to the intended recipient or next destination. The… This will be done by means of a literature survey covering the characteristics of the available systems, a consideration of how they ight be used in warehousing and, when they are used, what benefits have resulted from their use in both the warehouse situation and allied industries....

4 Pages (1000 words) Essay

Extraction, Transformation and Load: Data Warehouse

As we know that data warehouses are built to provide managers vital information for strategic decision-making purposes.... This issue makes it necessary for data warehouses to store the current state of data as well.... The quality of data in these sources is many of the times inadequate and inconsistent.... The sources of data can be on ASCII files, VSAM files, legacy databases and systems, mainframe computers and other proprietary systems....

8 Pages (2000 words) Term Paper

Network Design of the Storage and Logistics Company

Competitiveness from this aspect will be unmatched due to efficient and reliable transportation of data.... These implementations should be established in order to centralize all company data and extend the reach of all company departments.... The paper "Network Design of the Storage and Logistics Company" highlights that Storage and Logistics Company is a warehousing and delivery corporation located in London....

6 Pages (1500 words) Coursework

The Ideal Size of Warehousing

A warehouse can serve differently but it shares the same pattern of material flow and these warehouses involve receiving bulk shipments, stacks for quick retrieval, responding to customer's requests, retrieving and sorting SKUs, and shipping to the customers.... The paper 'The Ideal Size of Warehousing' presents the operating costs and capital expenses which increase because it offers a number of storage racks, lift trucks, which increases operating costs because there are more workers who have to travel many distances to store items....

8 Pages (2000 words) Term Paper

Different IT Solutions Adopted by Linfox

Easy and faster customization and accurate current data are among other benefits of this system that propelled Linfox to great levels by giving it a highly competitive edge in the management of its customers.... … The paper "Different IT Solutions Adopted by Linfox" is a wonderful example of a case study on information technology....

9 Pages (2250 words) Case Study