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.
The University's Data Warehouse is an Oracle 18.104.22.168.5 (12c) relational database management system (RDBMS). The database is over 2 TB in size and resides on a Dell PowerEdge R530 server with 64 GB of memory and 32 CPUs, running under Red Hat Linux 6.7 (64-bit).
More information about the University's Data Warehouse is available in
the following documents:
How the Warehouse Works
What the Warehouse Contains