Building a data warehouse for human resources management

Pao Yue-kong Library Electronic Theses Database

Building a data warehouse for human resources management


Author: Lam, Susanna
Title: Building a data warehouse for human resources management
Degree: M.Sc.
Year: 1999
Subject: Personnel management -- Data processing
Data warehousing
Hong Kong Polytechnic University -- Dissertations
Department: Multi-disciplinary Studies
Dept. of Computing
Pages: 90 leaves : ill. ; 30 cm
Language: English
InnoPac Record:
Abstract: This paper focuses on the development of a data warehouse to fulfill the information needs for the effective delivery of major human resources functions such as recruitment, staff cost management and benefits administration etc. The data warehouse will be built utilizing data generated from transaction processing systems that support the routine human resources operations including payroll generation, staff recording, and claims processing etc. The whole development process will put emphasis on two aspects of the data warehousing technology: the data model at the back end and the use of on-line analytical tool at the front end of the data warehouse. Other aspects of data warehousing, such as designing the extraction processes for populating the data warehouse and designing aggregations and precalculations, will only he briefly described. Apart from the above-mentioned, other data warehousing concepts including physical architecture of the data warehouse, the design of metadata and the daily administration of the warehouse are out of the scope of this paper. This paper will use the case of a bank to illustrate the development process. The background of the case will be introduced first and the information needs for human resources management in the bank will be discussed. Based on these information requirements and the data available in the operational human resources system, a data model will be developed using the Star Schema, which is a prevailing data modeling technique for data warehousing. To illustrate how the proposed data model and the online analytical processing tool interact to support human resources management decision making, a prototype of the recommended data warehouse will be developed. Finally, the effectiveness of the data warehouse and the operational system in supporting data analysis will be compared.

Files in this item

Files Size Format
b14895201.pdf 3.401Mb PDF
Copyright Undertaking
As a bona fide Library user, I declare that:
  1. I will abide by the rules and legal ordinances governing copyright regarding the use of the Database.
  2. I will use the Database for the purpose of my research or private study only and not for circulation or further reproduction or any other purpose.
  3. I agree to indemnify and hold the University harmless from and against any loss, damage, cost, liability or expenses arising from copyright infringement or unauthorized usage.
By downloading any item(s) listed above, you acknowledge that you have read and understood the copyright undertaking as stated above, and agree to be bound by all of its terms.


Quick Search


More Information