Defining global schema for ETL of human resource performance appraisal system using REA ontology

Abstract

Integrating data sources with different local schemas by ETL requires a global schema definition for improving consistency. However, the definition is usually performed without standard guideline. We propose an improved methodology for defining a conceptual model for the global schema by applying REA ontology which represents semantics for general organizational activities with their underlying policies. This study presents the generic model for not only human resource performance appraisal system, but also other business domains. The model can be extended and adapted to constant changes of appraisal policies. To be conformed to the ontology foundation, it can be implemented with RDF.