Data Warehouse Architecture Essay

Data Warehouse Architecture Essay

Length: 569 words (1.6 double-spaced pages)

Rating: Good Essays

Open Document

Essay Preview

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 ...

Need Writing Help?

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

Check your paper »

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]

Good Essays
1030 words (2.9 pages)

Based On Mapreduce Parallel Data Processing System Classes ( Hadoop And Hive )

- In this report, the report will introduce based on MapReduce parallel data processing system classes ( Hadoop and Hive ), to optimize connection optimize storage layer and the query optimizer aspects OLAP two working efficiency of the implementation of tasks and explore big data system Environmental analysis of complex technical challenges and common optimization strategies to optimize face. Consider the main reasons that force companies to implement data warehousing. The help in making decisions based on facts rather than intuition," "provide an opportunity to get to know the customer" and, of course, everywhere inserted - is only the first step in the implementation of these ambitious goal...   [tags: Data management, Data warehouse]

Good Essays
994 words (2.8 pages)

Job Roles And Responsibilities At Ibm Cloud And Cloudera Big Data Architect : Business Analytics & Strategy

- Executive Summary The aim of this report is identifying job roles and responsibilities, and answering the questions to demonstrate the finding in data curation and management. An employment services website and other article are used in this research. The results indicate that the role, tasks and responsibilities of the Data curation and management related job roles are depended on the nature of the position within the organisational structure and supporting infrastructure. Content Executive Summary 1 Introduction 1 Job role analysis 1 Research question answer 3 Q1 Nature of the roles 3 Q2 Positions fit within the organisational structure 3 Q3 Position descriptions level...   [tags: Data management, Data warehouse, Data mining]

Good Essays
1927 words (5.5 pages)

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]

Good Essays
1268 words (3.6 pages)

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]

Free Essays
1282 words (3.7 pages)

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]

Good Essays
1169 words (3.3 pages)

A Brief Note On Analytics And Business Intelligence Essay

- Abstract— Analytics and Business Intelligence is a rapidly increasing area in terms of Information technology since the amount of data and information to be gathered has increased substantially in the past few years. Recording information and gathering patterns and trends out of them is a difficult task and this is where business intelligence comes into picture. Not only the past, but also predicting the future trends becomes easy with the help of these tools. A lot of companies, like Pentaho, JasperSoft, KNIME, Vanilla etc....   [tags: Business intelligence, Data warehouse]

Good Essays
1113 words (3.2 pages)

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]

Free Essays
1829 words (5.2 pages)

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 ]

Good Essays
910 words (2.6 pages)

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]

Good Essays
2853 words (8.2 pages)