Penn Computing

Penn Computing

Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn

  
  UPDATES
Current Load Status
Regular Availability
  
  INFORMATION
FAQs & Tips
Password Changer
Support services
Security
About the Data Warehouse
Data Administration
  
  DATA COLLECTIONS
Advancement
Assets
BRIM
Express Mail
Facilities
Faculty
GAR
General Ledger
Infrastructure
ISSS-iOffice
Learning Management
Position Inventory
Research-PennERA Proposals
Salary Management
Student
Travel Expense Management
Tuition Distribution
Cross-Collection

About the Warehouse and the Data Collections

Implemented in 1995 after an indepth pilot study, the University's Data Warehouse makes Penn's institutional data available to decision makers for query, analysis, and reporting. The Warehouse stores selected data from Penn's business systems, such as SRS (Students Record System) and BEN Financials. The data is filtered, made consistent, and aggregated in various ways. Use of the Warehouse is restricted to authorized individuals of the Penn community. Access to the Warehouse does not require formal programming skills; desktop tools such as Business Objects support analysis and reporting.

The Warehouse contains student and course data, sponsored project data, salary management data, general ledger data, property management asset data, space data and insitutional advancement data. See the quick reference guides below for overviews of the various data collections.

  • Assets (PDF)
  • BRS (PDF)
  • Facilities (PDF)
  • Faculty (PDF)
  • General Ledger (PDF)
  • PennERA Proposals / Research (PDF)
  • Salary Management (PDF)
  • Student (PDF)
    • Graduate Admission (PDF)
    • Student Financial Aid (PDF)
  • Travel and Expense Management (PDF)
  • Tuition Distribution (PDF)

While the Warehouse is organized by subject areas, into "data collections", tables from various collections are often joined together to provide integrated information about the University.

Technical Information
The University's Data Warehouse is an Oracle 11.2.0.3 (11g) relational database management system (RDBMS). The database resides on a eight processor IBM P6 Series Symmetric Multiprocessor (SMP) server with 64 GB of memory and over 1.25 TB disk space, running under AIX 6.1

More information about the University's Data Warehouse is available in the following documents:
How the Warehouse Works
What the Warehouse Contains

top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


Penn Computing University of Pennsylvania
Information Systems and Computing, University of Pennsylvania