NERCOMP

1
NERCOMP Getting Data Out - SIG Mary
Weisse Manager, MIT Data Warehouse mca_at_mit.edu 617
-253-5398
2
What is the MIT Data Warehouse?

• Central repository for administrative data and
  meta data that can be easily accessed by members
  of the MIT community.
• http//web.mit.edu/warehouse

3
Why is it important?

• A tool to help users make better
• business decisions.
• Provides integrated data from various
  administrative departments.
• Provides historical reporting based on
  current past situations.
• The data is in a place that is accessible.
• The data is in a form that is easily
• understood by the community.

4
Design Focus

• End User Reporting
• Facilitating System Feeds
• Central Reporting

5
What data are available?

• Admissions MIT Card - Pictures
• Alumni MIT Id
• Benefits OSP Award Proposal
• Course Catalog Payroll (July 1, 2006)
• Degree Pre-registration
• EHS Procurement
• Facilities/Plant Maintenance Orders Roles
  /Authorization
• Financial Space
• Financial Aid Student
• Graduate Awards Subject Enrollment
• Instructor Telephone
• HR (Employees, Positions, Appointments) TLO
• Kerberos Vacation/Absences (July 1, 2006)
• Keys VAPS
• Libraries (Circulations, Collection Web
  Statistical Data
• Management, Serials Control,
• Processing)

6
Design Process

• Analysis Design
• Data Administration Issues
• - Missing data - Data business
  issues/policies
• Naming conventions - Agreed upon definitions
• Data integrity rules - Data verification policies
• Ownership/custodial rules assumptions
• Extracts
• Data Translation, Load, Verification
• Minimal time spent here automated generic
  process
• Customer Support

7
Conceptual Data Model
8
Star Schema
9
High Level Design
10
Department Master Hierarchy
11
Authorizations
12
Access Methods

• Data access tools
• Extracts and Feeds
• User Interfaces.
• SQL

13
User Support

• Formal Training
• Tools
• Data
• User Groups
• One-on-one
• Local Experts