Premium Essay

Dataware House Architecture

In: Computers and Technology

Submitted By rubin263
Words 1936
Pages 8
DATA WAREHOUSE ARCHITECTURE

Albina Yusupova
Data Warehouse Architecture

The main difference between the database architecture in a standard, on-line transaction processing oriented system (usually ERP or CRM system) and a Data Warehouse is that the system’s relational model is usually de-normalized into dimension and fact tables which are typical to a data warehouse database design. The differences in the database architectures are caused by different purposes of their existence.
In a typical OLTP system the database performance is crucial, as end-user interface responsiveness is one of the most important factors determining usefulness of the application. That kind of a database needs to handle inserting thousands of new records every hour. To achieve this usually the database is optimized for speed of Inserts, Updates and Deletes and for holding as few records as possible. So from a technical point of view most of the SQL queries issued will be INSERT, UPDATE and DELETE. Opposite to OLTP systems, a Data Warehouse is a system that should give response to almost any question regarding company performance measure. Usually the information delivered from a data warehouse is used by people who are in charge of making decisions. So the information should be accessible quickly and easily but it doesn't need to be the most recent possible and in the lowest detail level. Usually the data warehouses are refreshed on a daily basis (very often the ETL processes run overnight) or once a month (data is available for the end users around 5th working day of a new month). Very often the two approaches are combined.

The main challenge of a Data Warehouse architecture is to enable business to access historical, summarized data with a read-only access of the end-users. Again, from a technical standpoint the most SQL queries

Similar Documents

Free Essay

Successful Product Line Development and Sustainment: a Dod Case Study

...Successful Product Line Development and Sustainment: A DoD Case Study Sholom Cohen, Software Engineering Institute Ed Dunn, Naval Undersea Warfare Center Albert Soule, Software Engineering Institute September 2002 Product Line Systems Unlimited distribution subject to the copyright. Technical Note. CMU/SEI-2002-TN-018. The Software Engineering Institute is a federally funded research and development center sponsored by the U.S. Department of Defense. Copyright 2002 by Carnegie Mellon University. NO WARRANTY THIS CARNEGIE MELLON UNIVERSITY AND SOFTWARE ENGINEERING INSTITUTE MATERIAL IS FURNISHED ON AN "AS-IS" BASIS. CARNEGIE MELLON UNIVERSITY MAKES NO WARRANTIES OF ANY KIND, EITHER EXPRESSED OR IMPLIED, AS TO ANY MATTER INCLUDING, BUT NOT LIMITED TO, WARRANTY OF FITNESS FOR PURPOSE OR MERCHANTABILITY, EXCLUSIVITY, OR RESULTS OBTAINED FROM USE OF THE MATERIAL. CARNEGIE MELLON UNIVERSITY DOES NOT MAKE ANY WARRANTY OF ANY KIND WITH RESPECT TO FREEDOM FROM PATENT, TRADEMARK, OR COPYRIGHT INFRINGEMENT. Use of any trademarks in this report is not intended in any way to infringe on the rights of the trademark holder. Internal use. Permission to reproduce this document and to prepare derivative works from this document for internal use is granted, provided the copyright and “No Warranty” statements are included with all reproductions and derivative works. External use. Requests for permission to reproduce this document or prepare derivative works of this document for external...

Words: 16988 - Pages: 68

Free Essay

Work

...CORPORATE E-LEARNING: EXPLORING A NEW FRONTIER Trace A. Urdan Cornelia C. Weggen turdan@wrhambrecht.com cweggen@wrhambrecht.com 415.551.8600 “In a time of drastic change, it is the learners who inherit the future. The learned find themselves equipped to live in a world that no longer exists.” Eric Hoffer, in Vanguard Management, 1989 2 March 2000 Equity Research TABLE OF CONTENTS Executive Summary .....................................................................................................................................1 Education in the 21 Century – Creating a Learning Economy.......................................................................2 Why e-Learning?...........................................................................................................................................3 The Solution – Bring Learning to People .......................................................................................................6 Definitions – e-Learning versus Online Learning ............................................................................................8 Key Trends – The End of Learning as We Know It ........................................................................................10 The Corporate e-Learning Market – The Pie is Big ......................................................................................13 Market Segmentation – Claiming a Stake on the New Frontier ................................

Words: 31743 - Pages: 127