Resources
Location:
A Warehouse Design; Keeping it Simple

A Warehouse Design; Keeping it Simple

Title:A Warehouse Design; Keeping it Simple (ID: EDU9934)
Author(s):Scott Thorne (MIT)
Topics:Data Warehouse
Origin:EDUCAUSE Annual Conferences (1999)
Type:Articles, Papers, and Reports
Abstract:MIT has implemented a warehouse, which brings several elements of function and design together. MIT's warehouse supports reporting, and acts as a hub for data distribution between systems. We've tried to satisfy both needs with an open flexible design. We've restructured our information, which comes nightly from source systems such as SAP, for easier reporting. The warehouse has row level access control which is driven from an enterprise authorization system (Roles). Other design features are a metadata driven data conversion and load process, distributed report creation, encrypted transport, and a system of automated integrity checks and controls. This paper covers the major design points and some of our experiences implementing and maintaining a warehouse.
View this resource:
Bookmark/Search this page with:
   del.icio.us   Digg   Google   Yahoo   Technorati Stumbleupon Facebook Twitter

 
© Copyright 1999-2009 EDUCAUSE
  Unless otherwise noted, EDUCAUSE holds the copyright on all materials published by the association, whether in print or electronic form. In certain cases the work remains the intellectual property of the individual author(s) (see Special Circumstances). Content from conference speeches, presentations, blogs, wikis and feeds reflect the opinions of the author, and not necessarily those of EDUCAUSE or its members.