| 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 Department of Computing |
| Pages: | 90 leaves : ill. ; 30 cm |
| Language: | English |
| 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. |
| Rights: | All rights reserved |
| Access: | restricted access |
Files in This Item:
| File | Description | Size | Format | |
|---|---|---|---|---|
| b14895201.pdf | For All Users (off-campus access for PolyU Staff & Students only) | 3.32 MB | Adobe PDF | View/Open |
Copyright Undertaking
As a bona fide Library user, I declare that:
- I will abide by the rules and legal ordinances governing copyright regarding the use of the Database.
- 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.
- 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.
Please use this identifier to cite or link to this item:
https://theses.lib.polyu.edu.hk/handle/200/1200