Online Submission!

Open Journal Systems

A methodical and adaptive framework for Data Warehouse of Salary Management System

Manzoor Ahmad

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.


Full Text:

PDF

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 inData Warehousing to Support Business Initiatives and Needs”, Proceedings of the 37th Hawaii International Conference on System Sciences 2004

Jorge Bernardino, Pedro Furtado, Henrique Madeira,” ACost 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 AssociationRule 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 Development 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.




DOI: http://dx.doi.org/10.6084/ijact.v3i6.310

Refbacks

  • There are currently no refbacks.