Data Warehouse Architecture Essay

545 words - 2 pages

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 is the most significant and most effective. Therefore, a research has been conducted to know which is the best data warehouse architecture and formed a group of 20 experts to help identify the architectures to be studied and what metrics to use (Ariyachandra & Watson, 2008). The five architectures that were investigated were: (1) Independent Data Marts, (2) Bus Architecture, (3) Hub and Spoke Architecture, (4) Centralized Architecture and (5) Federated Architecture.
Independent data marts are the initial efforts to provide a repository of decision support data (Ariyachandra & Watson, 2008). This...

Find Another Essay On Data Warehouse Architecture

Enterprise Data Management Essay

1162 words - 5 pages 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

Singapore's No Child Left Behind Quality Assurance Program

1119 words - 4 pages packed into the data objects. The metadata can be transformed before loading into the MoE data warehouse in accordance with pre-configured mapping schemas. Effectively, the transformation of metadata functions as a set of business rules which are applied to the attributes of the data before loading, thus improving the consistency and accuracy of the data reported. In addition, the architecture also provides flexibility to change the metadata in

Enterprise Data Management

1657 words - 7 pages data. Will a direct connection suffice as in one tier architecture or will more be needed. Will a data warehouse bog down data retrieval and contain more that is needed or will data marts be more efficient? Will the company have people that are trained and competent to run complex user DBMS interfaces? By providing enterprise management with decisional information, data warehouses have the potential of greatly affecting the operations of an

Hello World

1808 words - 7 pages addresses.The design focus covers many considerations, including maintaining session data, choosing an authentication model, implementing basic Web functionality, isolating presentation from business and data services, supporting UI for multiple devices, and using BizDesk Services.For more detailed information refer to the documentation included in the download file.Rationale The Microsoft Reference Architecture for Commerce: Business to Consumer

The XYZ Ltd Booking Information System Website

1547 words - 7 pages complicated formulas and queries to produce the relevant required data. (Data Warehouse, 2009) • Transform: After the data was extracted from the database to excel we transformed it and assigned a specific page for each route. For example the figure below shows the data of Sheffield – Manchester route, When all the data routes are transformed to an excel page, OLAP process is launched to be applied by manipulating the data using complicated

Business Intelligence

1492 words - 6 pages give the organization ability to grow and compete with the utilization of data pertaining to sales, production, employees, internal operations such identifying changes in trends, performance, company projects, market share, sales, customer behavior, as well as customer spending patterns, preferences, and market conditions.a)A data warehouse is the main location for an organization's complete available historical data, its foundation for

ETL and Data Management

2115 words - 8 pages the target end typically referred as the data warehouse. On the basis of the necessities of the businesses, the ETL overall process differs extensively. A number of data warehouse possibly will overwrite the present data by means of collective information; commonly, appraising the data which is extracted carried out based on the frequency of day-to-day, week on week, or month on month. ETL and ELT Conventionally ETL process was referred as

Major technological challenges for small to medium sized businesses

565 words - 2 pages technical costs could result in cost savings and benefit in experience of the resource provider (Turban et al, p. 629). The infrastructure includes content creation, delivery and management. The major categories are information about the company, products, services, customers, investor relations, press releases, enterprise resource planning (ERP) (including warehouse management systems [WMS]), customer relationship management (CRM), and web site

Relational Database Management System

1093 words - 4 pages . Other features include consistency and protection of data through locking mechanisms. Oracle applications may run on the same computer as the Oracle Server. Alternatively, you can run applications on a system local to the user and run the Oracle Server on another system (client-server architecture). In this client-server environment, a wide range of computing resources can be used. For example, a form-based airline reservation application can run

project plan

1475 words - 6 pages building a network infrastructure. Most architecture use routers with built-in firewalls, as well as software that allow finely-tuned user-access control, data packet monitoring, and strictly defined protocols” (What is Network Infrastructure?). Security can also be controlled by adjusting network sharing properties on individual systems, which limits the folders and files that can be seen by other users on the network. Works Cited How to Secure

Business Requirements

2142 words - 9 pages 1 Business Requirements 1.1 Project Overview SMB Computation, a data collection and analysis company has been operating for less than two years and has grown exponentially. SMB Computation is seeking to create a repository for collected data beyond that of standard relational databases and their ten-terabyte data warehouse has been forecasted to grow about twenty percent each year. A plan of action to compensate for the growth of the company

Similar Essays

Application Architecture & Process Design Essay

708 words - 3 pages A database is a collection of related information that is organized in a database management system where the data can be retrieved by organizations to aid them in making strategic business decisions. The information from these databases are organized and collected in ways to help an organization retrieve the needed data with ease. Data warehouse, data mart, three-tier architecture and active service pages (ASP) are data concepts that are used

Data Warehousing Development Methodologies: A Comparative Analysis

3704 words - 15 pages consulting, data warehouse information discovery, data warehouselogical data modelling, and data warehouse architecture design. During this planningphase the business problem that the warehouse is to address is defined along withthe criteria that will be used to measure the success of the warehouse project. Theusers and their data requirements are identified. Data sources are identified and thetools to be used to access and load data are defined

Implementing A Data Warehouse In A Kar Dealer Network

1378 words - 6 pages 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

Data Warehousing Essay

998 words - 4 pages staging it prior to loading into the Data Warehouse is fairly well accepted, two basic camps have formed over the basic architecture of the Data Warehouse. One camp, proposes an Independent Data Mart architecture, where the data is loaded directly from the staging areas into a collection of small data warehouses that are limited in scope, called Data Marts. These Data Marts then supply the data to the end user. This architecture is very popular