A methodical and adaptive framework for Data Warehouse of Salary Management System
Keywords:
Operational systems, STAR Schema, Data Marts, Data Granularity, Data Fusion, OLAP (Online Analytical Processing)Abstract
Years of experience as an employee of University of Kashmir has always desired us to have a typical solution where most of the activities related to salary are fully automated without checking across the files whenever there is a need e.g. individual month‟s salary report , web based information submission, filing of returns , increment information etc. After thorough analysis , taking employee satisfaction , sensitivity and security of data , a long term solution was to develop a centralized University salary management system and its data warehouse . In this paper the design and implementation of an adaptive data warehouse is presented which supports large volume of data and saves the cost effectively. It also enable decision makers pose queries and question to the system. However decision support systems only support a set of queries and operations that are to be performed.
References
Inmon, W. H., “Building the Data Warehouse”, Second Edition, John Wiley & Sons, Inc 1996
Larry, Greenfield, LGI Systems Inc., "The Data Warehousing Information Center," 1997 pp http://pwp.starnetinc.com/larryg/index.html.
Kimball, Ralph, “The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses”, John Wiley & Sons,
Inc, 1996
A. Gupta, V. Harinarayan, and D. Quass. Aggregate query processing in datawarehousing environments. In Proc. 21th Int. Conf. on Very Large Data Bases, Zurich, Switzerland, 1995.
ACM/ IEEE CS Joint Task Force for Computing urriculum 2005. “Computing Curriculum 2005”. The Over view report” 30 Sep, 2005
C. Fahrner, and G. Vossen. A survey of database transformations based on the Entity Relationship model. Data & Knowledge Engineering, vol. 15, n. 3, pp. 213-250. 1995.
CAI Yong, HE Guangsheng, “Designing Model of Data Warehouse with OO Method [J]”, Computer Engineering and Applications, 2003.6.[5]
Fon Silvers, “Building and Maintaining a Data Warehouse,” AN AUERBACH BOOK”, CRC Press is an imprint of the Taylor & Francis Group, an informa business
Jeff Lawyer, Shamsul Chowdhury, “ Best Practices in Data Warehousing to Support Business Initiatives and Needs”, Proceedings of the 37th Hawaii International Conference on System Sciences 2004
Jorge Bernardino, Pedro Furtado, Henrique Madeira,” A Cost Effective Approach for Very Large Data Warehouses”, Proceedings of the International Database Engineering and Applications Symposium, 2002
Krishna. “Principles of Curriculum Design and Revision: A Case Study in Implementing Computing Curricula CC2001”. ITiCSE ‟05, June 27–29, 2005
LIN Yu,etc, “The Principles and Applications of Data Warehouse [M]”, Posts & Telecommunications Press, 2003.1
R. Barquin, and S. Edelstein. “Planning and Designing the Data Warehouse”,. Prentice Hall, 1996.
REN Jinluan, GU Peiliang, ZENG Zhenxiang, “Research on the Methods of Designing Data Structure of Data Warehouse ”, Computer Engineering and Applications, 2001.22.
SvetlozarNestorov, NenadJukic, “AdHoc Association Rule Mining within the Data Warehouse”, Proceedings of the 36th Hawaii International Conference on System Sciences, 2002
Syed Najamul-Hassan, MaqboolUddinShaikh, Uzair Iqbal Janjua,” Data Warehousing an Academic Discipline “Curriculum evelopment Approach, Methodologies and Issues”, 2006
Wu Shuning, Cui Deguang, Cheng Peng ,”The Four-stage Standardized Modeling Method in Data Warehouse System Development” Proceedings of the IEEE International Conference on Mechatronics & Automation Niagara Falls, Canada • July 2005
YUAN Hong, HE Houcun, “Online Analysis and Data Warehouse Modeling Technologies [J]”, Computer Application Research, 1999.12.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2014 COMPUSOFT: An International Journal of Advanced Computer Technology
This work is licensed under a Creative Commons Attribution 4.0 International License.
©2023. COMPUSOFT: AN INTERNATIONAL OF ADVANCED COMPUTER TECHNOLOGY by COMPUSOFT PUBLICATION is licensed under a Creative Commons Attribution 4.0 International License. Based on a work at COMPUSOFT: AN INTERNATIONAL OF ADVANCED COMPUTER TECHNOLOGY. Permissions beyond the scope of this license may be available at Creative Commons Attribution 4.0 International Public License.
