Title :
Decision support system for personnel information using data warehouse
Author_Institution :
Univ. of Comput. Studies, (Mandalay), Mandalay, Myanmar
Abstract :
In the area of information and communication technology, a wide variety of methods and tools are used for storing, processing and analyzing data. This paper is one in a series describing reference configuration and sizing information for Access data warehouses for small, medium, large solutions to meet business data warehouse needs. The system can be used by managers and end-users to understand the business and make decisions. This system attempts to study OLAP queries which are in terms of a multidimensional data mode. According to the respective roles and privileges, OLAP queries can be retrieved from the data warehouse. The system analyses personnel data for technological universities in Myanmar. This system is implemented by using J Builder 9 language and Microsoft Access.
Keywords :
business data processing; data warehouses; decision making; decision support systems; query processing; relational databases; Access data warehouses; J Builder 9 language; Microsoft Access; Myanmar; OLAP queries retrieval; business data warehouse; decision making; decision support system; information and communication technology; multidimensional data mode; personnel information; reference configuration; technological universities; Data analysis; Data mining; Data warehouses; Databases; Decision making; Decision support systems; Information analysis; Information retrieval; Multidimensional systems; Personnel; Data warehouse; Star schema; and OLAP;
Conference_Titel :
Computer and Automation Engineering (ICCAE), 2010 The 2nd International Conference on
Conference_Location :
Singapore
Print_ISBN :
978-1-4244-5585-0
Electronic_ISBN :
978-1-4244-5586-7
DOI :
10.1109/ICCAE.2010.5451300