Preview
Preview

Data Warehouse Architecture Essay

No Works Cited
Length: 569 words (1.6 double-spaced pages)
Rating: Orange      
Open Document
Need writing help? Check your paper »



- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

In order to store something, data should be collected first. Conducting interviews and distributing questionnaires are the most common and simplest techniques in collecting data. These techniques are useful in investigating a specific subject especially if there are no original data available. This is generally known as the collection of primary data. Before data can be used, data needs to be transformed to fit the present needs (TimeWeb, 2010). Checking for errors, making critical summary and accurate analysis is necessary in gathering and reporting data because a simple mistake in the process could lead to the distortion of the meaning and value of its original form. It is imperative to process the data carefully since this data becomes information needed to be stored. The main purpose of information storage system is to preserve the information gathered used for making plans and decisions at present and in the future.
Arguments in which data warehouse architecture is best among consultants and vendors never cease since each one of them claims that the architecture they use ...


Click the button above to view the complete essay, speech, term paper, or research paper

Need Writing Help?

Get feedback on grammar, clarity, concision and logic instantly.

Check your paper »







This essay is 100% guaranteed.


Title Length Color Rating  
Essay on Implementing a Data Warehouse in a Kar Dealer Network - Data warehouse architecture Goldfarelli & Rizzi (2009) describe two classifications of a data warehouse architecture. The first classification describes the physical separation of the data warehouse's architectural layers. The second classification is based on the methods devised by Inmon and Kimball. Inmon advocates the use of hub-and-spoke architecture, while Kimball prefers an architecture based on the data mart bus (Ariyachandra & Watson, 2006). The advantage of the hub-and-spoke approach is data integration versus the ease of development and a lower cost of the federated approach (Hwang & Cappel, 2002)....   [tags: hub-and-spoke, top-down, warehouse]
:: 16 Works Cited
1030 words
(2.9 pages)
Strong Essays [preview]
Implementing a Data Warehouse in a Kar Dealer Network Essay - Kar Dealership Data Warehouse The purpose of the Kar data warehouse is to make data available to the business users for decision making purposes and to enable the dealership use predictive analytics and statistics to help the company sell more Kar products. The reason for creating a data warehouse is to do business intelligence (Hammergren & Simon, 2009). The Kar dealership has realized that in order to be successful they must use their data as a tool to be competitive. They must find out who their customers are and what their preferences are....   [tags: dealership, business intelligence, dashboard]
:: 16 Works Cited
1268 words
(3.6 pages)
Strong Essays [preview]
Essay about Data Warehousing - Introduction Data Warehouses (DW) integrate data from multiple heterogeneous information sources and transform them into a multidimensional representation for decision support applications. Apart from a complex architecture, involving data sources, the data staging area, operational data stores, the global data warehouse, the client data marts, etc., a data warehouse is also characterized by a complex lifecycle. In a permanent design phase, the designer has to produce and maintain a conceptual model and a usually voluminous logical schema, accompanied by a detailed physical design for efficiency reasons....   [tags: Technology Data] 1282 words
(3.7 pages)
Strong Essays [preview]
Essay on Enterprise Data Management - Enterprise Data Management There are various terms that are associated with Enterprise Data Management. Some of these terms are UML, OLAP, OLTP, Data Warehouse, Data Mart and Multi-Tier Architecture. Subsequently, these terms were covered during the five week course of DMB405 and will be explained in further detail throughout the course of the paper. Although the paper will not be all inclusive to the detail of each term, it will touch upon the definition, their use and their place in Enterprise Data Management....   [tags: Business Inventory Data Management] 1169 words
(3.3 pages)
Strong Essays [preview]
Data Warehousing Essay - Businesses around the world are faced with many challenges when attempting to compete and gain a competitive advantage over their competition. The members of the management team within these businesses need to make quick and accurate decisions which will often impact the company and all of its employees, possibly for years to come. One of the worst situations for one of these decision makers to find themselves in is when they know that all of the information they need is available; but they are unable to retrieve that information in an accurate and useful way....   [tags: Information Technology ]
:: 4 Works Cited
910 words
(2.6 pages)
Better Essays [preview]
Essay on OLAP, Data Marts and Warehouses, Three-Tier Architecture and ASP - WEEK 4 INDIVIDUAL PAPER OLAP, DATA MARTS AND WAREHOUSES, THREE-TIER ARCHITECTURE AND ASP DBM405 OLAP, Data Marts and Warehouses, Three-Tier Architecture and ASP OLAP The term OLAP stands for ‘On-Line Analytical Processing’. OLAP is a technology used to process data a high performance level for analysis and shared in a multidimensional cube of information. The key thing that all OLAP products have in common is multidimensionality, but that is not the only requirement for an OLAP product....   [tags: essays research papers] 1829 words
(5.2 pages)
Strong Essays [preview]
Essay about ETL and Data Management - ETL and Data Management ETL Detailed Discussion The system of ETL is in general utilized to join in the data from numerous applications in the systems, characteristically established as well as reinforced by a number of existing vendors or others held on distinct hardware of the computer. The distinct systems comprising the actual data is most repeatedly accomplished as well as run by a number of employees. Referring to example of system used for cost accounting, it is evident that this system would thereby collate the information flow from payroll, transactions as well as acquiring....   [tags: Information Technology]
:: 7 Works Cited
2013 words
(5.8 pages)
Better Essays [preview]
The Revolution in Database Architecture, by Jim Gray Essay - The Revolution in Database Architecture, by Jim Gray, describes the path that Gray thought that the evolution of the Database Architecture would take after 2004. He considers that databases had been stagnated for several years and that, beginning in 2004, the development of several technologies would pave the way into a revolution in the database world. The 14 technologies mentioned as the key for the revolution are: 1. The ability to execute Object Oriented code inside the RDBMS. 2. Databases becoming a web service....   [tags: Predictions, Technology Advances]
:: 1 Works Cited
1227 words
(3.5 pages)
Strong Essays [preview]
Data Warehousing Essay - Data Warehouses In the past decade, we have witnessed a computer revolution that was unimaginable. Ten to fifteen years ago, this world never would have imagined what computers would have done for business. Furthermore, the Internet and the ability to conduct electronic commerce have changed the way we are as consumers. One of the upcoming concepts of the computer revolution in the past ten years has been that of Data Warehousing. In the following pages, we will examine this concept in the broadest sense first looking at a brief history of how databases and data warehouses have unrolled....   [tags: essays research papers fc]
:: 1 Works Cited
2853 words
(8.2 pages)
Powerful Essays [preview]
An Analysis of Key Enterprise Data Concepts Essay - An Analysis of Key Enterprise Data Concepts Business intelligence has several different meanings depending upon the organization and its goal. I general, it involves the collection of data and using it to predict future trends. This information is used to make decisions regarding the direction of said organization. Many businesses offer solutions that propose to pull together data from a variety of sources into a single repository and then analyze the data to gleam whatever information is needed....   [tags: essays research papers] 860 words
(2.5 pages)
Better Essays [preview]