Proceedings Article10.1109/JCSSE.2011.5930134
Defining global schema for ETL of human resource performance appraisal system using REA ontology
Udomchai Sutheparaks,Wiwat Vatanawood,Chate Patanothai +2 more
- 11 May 2011
- pp 275-280
8
TL;DR: This study presents the generic model for not only human resource performance appraisal system, but also other business domains that can be extended and adapted to constant changes of appraisal policies and implemented with RDF.
read more
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.
read more
Chat with Paper
AI Agents for this Paper
Find similar papers on Google Scholar, PubMed and Arxiv
Write a critical review of this paper
Analyze citations of this paper to find unaddressed research gaps
Citations
Extended Formalized Model for Financial Module of Open Source ERP System using REA Ontology Jedpreeya Bekthaisong
Wiwat Vatanawood
- 01 Jan 2013
TL;DR: The reverse engineering of the Open Source ERP’s source code is reversed into UML class diagram and the steps to classify the REA role of each particular classes of the ERP design model are performed.
The multi-criteria evaluation of research efforts based on ETL software: from business intelligence approach to big data and semantic approaches
Chaimae Boulahia,Hicham Behja,Mohammed Reda Chbihi Louhdi,Zoubair Boulahia +3 more
Resources-Events-Agents Design Theory: A Revolutionary Approach to Enterprise System Design
TL;DR: REA’s genesis and primary constructs are discussed, a history of REA research is provided, the impact on practice is discussed, and speculation as to what the future may hold for REA-based enterprise systems is speculated.
References
•Book
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data
Ralph Kimball,Joe Caserta +1 more
- 01 Jan 2004
TL;DR: This book delivers realworld solutions for the most timeand labor-intensive portion of data warehousing-data staging, or the extract, transform, load (ETL) process andelineates best practices for extracting data from scattered sources.
674
•Book
Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-Support Applications
Larissa Terpeluk Moss,Shaku Atre +1 more
- 01 Feb 2003
TL;DR: The authors walk readers through every step of the process--from strategic planning to the selection of new technologies and the evaluation of application releases and conclude by crystallizing their many years of experience in a list of dos, don'ts, tips, and rules of thumb.
540
D2R Server - Publishing Relational Databases on the Semantic Web
Christian Bizer,Richard Cyganiak,Freie Universit +2 more
- 01 Jan 2004
TL;DR: D2R Server is a tool for publishing the content of relational databases on the Semantic Web that allows Web agents to retrieve RDF and XHTML representations of resources and to query non-RDF databases using the SParQL query language over the SPARQL protocol.
453
An ontological analysis of the economic primitives of the extended-REA enterprise information architecture
TL;DR: The economic primitives of the original REA model plus some newer components (commitments, types, custody, reciprocal, etc.) will be analyzed individually and collectively as a specific domain ontology to guide further conceptual development of REA extensions.
306
•Book
Model-Driven Design Using Business Patterns
Pavel Hruby
- 22 Jun 2006
TL;DR: This book presents more than 20 structural and behavioral business patterns that use the REA (resources, events, agents) pattern as a common backbone that can be used to design and ensure that the meta-rules are followed by the developers of the actual applications.
209