Modeling Web-Based Data in a Data Warehouse

Author(s):  
Hadrian Peter ◽  
Charles Greenidge

Good database design generates effective operational databases through which we can track customers, sales, inventories, and other variables of interest. The main reason for generating, storing, and managing good data is to enhance the decision-making process. The tool used during this process is the decision support system (DSS). The information requirements of the DSS have become so complex, that it is difficult for it to extract all the necessary information from the data structures typically found in operational databases. For this reason, a new storage facility called a data warehouse has been developed. Data in the data warehouse have characteristics that are quite distinct from those in the operational database (Rob & Coronel, 2002).

2011 ◽  
Vol 383-390 ◽  
pp. 4653-4659
Author(s):  
Amro F. Alasta ◽  
Muftah A. Enaba

Since the use of computers in business world, data collection has become one of the most important issues due to the available knowledge in the data; such data has been stored in database. Database system was developed which led to the evolvement of hierarchical and relational database followed by Standard Query Language (SQL). As data size increases, the need for more control and information retrieval increase. These increases lead to the development of data mining systems and data warehouses. This paper focuses on the use of data warehouse as a supporting tool in decision making. We to study the effectiveness of data warehouse techniques in the sense of time and flexibility in our case study (Manpower Employment). The study will conclude with a comparison of traditional relational database and the use of data warehouse. The fundamental role of data warehouse is to provide data for supporting decision-making process. Data in data warehouse environment is multidimensional data store. We can simply say that data warehouse is a process not a product, for assembling and managing data from various sources for the purpose of gaining a single detailed view of part or all an establishment. The data warehouse concept has changed the nature of decision support system, by adding new benefits for improving and expanding the scope, accuracy, and accessibility of data. The warehouse is the link between the application and raw data, which is scattered in separate database but now is unified. The objectives of this work are to study the impact of using data warehouse on Manpower Employment Decision Support System, in the sense as far as the data quality concern. We will focus on the benefits gained from using data warehouse, and why it is more powerful than the use of traditional databases in decision making. The case study will be the Libyan national manpower employment agency. The data warehouse will collect database scattered from different sources in Libya in order to compare the performance and time.


2009 ◽  
Vol 25 (03) ◽  
pp. 161-167
Author(s):  
Charalambia Pylarinou ◽  
Nikos Karacapilidis ◽  
Emmanuel D. Adamides

Aiming to augment the quality of decision making in vessel dismantling, this paper presents an innovative decision support system that takes into account the diversity of the associated constraints to aid stakeholders handle issues such as the appropriateness of a disposal methodology or the level of safety in a dismantling yard. Being seamlessly integrated with an advanced simulation environment, the system also facilitates the collaborative design of dismantling processes.


2013 ◽  
Vol 850-851 ◽  
pp. 1048-1051
Author(s):  
Guang Yu Peng

This paper analyzes the DSS characteristics about the marketing under the internet as well as the influencing factors of the market decisions, Studying the decision-making functions of marketing decision support system DSS. It proposed the marketing DSS design, logical structure and its implementation based on a data warehouse as the center, online analysis processing and data mining as a means.


2016 ◽  
Vol 3 (4) ◽  
pp. 344
Author(s):  
Tri Widayanti ◽  
Tony Wijaya

Penggunaan sistem pendukung keputusan dapat meningkatkan proses penilaian dalam seleksi Beasiswa bidikmisi sehingga dapat mengurangi subjektivitas pengambilan keputusan. Keputusan ini di dukung oleh beberapa kriteria sehingga dapat terpilih penerima beasiswa bidikmisi sesuai dengan kuota yang telah diberikan Kemenristek Dikti.Penelitian ini berbentuk studi kasus dengan metode research and development yang subjek penelitiannya adalah Politeknik Negeri Pontianak. Sistem pendukung keputusan untuk seleksi penerima beasiswa bidikmisi menggunakan metode TOPSIS berbasis web dengan menggunakan basis data MySQL dan bahasa pemrograman PHP. Metode perancangan aplikasi sistem pengambilan keputusan seleksi penerima beasiswa bidikmisi menggunakan metode Agile dengan pendekatan Extreme Programming yang memiliki tahapan antara lain Planning, Design, Coding, dan Testing yang menggunakan pendekatan Object-Oriented dengan sistem pemodelannya menggunakan UML. Hasil implementasi Metode TOPSIS dalam sistem pendukung keputusan seleksi penerima beasiswa bidikmisi berbasis web menampilkan fitur menu pendaftaran calon peserta bidikmisi, menu pengisian kriteria, menu penilaian calon peserta, menu hasil penilaian, menu kelola kriteria, menu kelola alternatif kriteria dan menu kelola pemakai. Selain itu, hasil implementasi memberikan objektivitas dan kemudahan bagi panitia dalam penilaian dan perankingan. Hasil pengujian juga menunjukkan bahwa penggunaan metode TOPSIS sebagai alternatif pengambilan keputusan dalam seleksi penerima beasiswa bidikmisi dapat menyaring 20% penerima beasiswa bidikmisi yang seharusnya tidak layak mendapatkan beasiswa tersebut.The use of decision support system can enhance the assessment process of bidikmisi scholarship selection, so that it may reduce the subjectivity in decision making. This decision system is supported by some criteria, so that the reciplent of bidikmisi scholarship can be selected accordance to the provided quota by Kemenristek Dikti. This is a case study research with research and development method where research participant is State Polytechnic School of Pontianak. TOPSIS method is used in decision support system for bidikmisi scholarship acceptance selection web-based using MySQL based data and PHP language program. The application design method of decision support system of bidikmisi scholarship selection recipients use agile method of Extreme Programming approach which steps of Planning, Design, Coding and Testing of object-Oriented approach with UML. The result of TOPSIS method application in decision support system of bidikmisi scholarship selection recipients web-based display fitur menu of bidikmisi candidate registration, prospective participants charging criteria, candidate assessment menu, the assessment result menu, management criteria menu, alternative governance criteria and the user governance menu. Basides, the result of the implememtation gives objectivities and ease for the committee in the assessment and ranking. The test results also show that the use TOPSIS method as an alternative decision-making in the selection of awardees bidikmisi can filter 20 % scholarship bidikmisi that should not be eligible for the scholarship.


2006 ◽  
Vol 33 (12) ◽  
pp. 1480-1489 ◽  
Author(s):  
Hongqin Fan ◽  
Hyoungkwan Kim ◽  
Osmar R Zaïane

Equipment logistics, maintenance, and repair are important aspects of construction equipment management. A well-managed equipment fleet helps reduce downtime, as well as total maintenance and repair costs. With quickly growing fleets of equipment, large contractors tend to divert the maintenance and repair of equipment from equipment managers to project managers. As a result, the equipment managers shift their attention from operational-level decision-making to corporate-level strategic decision-making regarding equipment management, which is often a challenging job with the current equipment management system. This paper presents an equipment data warehouse and a prototype decision support system (DSS). The proposed equipment data warehouse enables equipment managers to visually analyze the equipment fleet data from different perspectives and at various level of details. The data-warehouse-based DSS facilitates high-level, fact-based decision-making regarding equipment logistics, supplies, maintenance, repair, and replacement and has higher levels of performance and flexibility than the current equipment management system.Key words: data warehouse, decision support system, equipment management, multidimensional modeling.


Respati ◽  
2017 ◽  
Vol 10 (30) ◽  
Author(s):  
Parjono Parjono ◽  
Wing Wahyu Winarno ◽  
Emha Taufiq Luthfi

ABSTRACTThis decision support system is a web-based system, which can help decision makers to use data from a variety of models to problems tersetruktur. In this thesis, has constructed a decision support system poorhouse reconstruction using AHP method (Analytical Heirarchy Process) which aims to help provide alternative solutions / proposals in decision-making, in this case that would be the Head of Social Service Klaten. Decision support systems are built based on 14 criteria poor from BPS (Central Bureau of Statistics) and giving preference value weighted interest where the total value of the weight should not be more or less than 100 (100%).Keywords: SPK, Reconstruction, AHP.


2021 ◽  
Vol 9 (1) ◽  
pp. 1-6
Author(s):  
Wahyuni Fithratul Zalmi

Decision support system is a system adopted from human knowledge, which can help people in the decision making process. In research conducted at PT Coal Bukit Asam (Persero) authors see most of the systems currently used in the search process of promotion of employees still in manual form, causing the length of the assessment process associated with a promotion for every employee of the company in accordance with any the criteria that have been specified company. Various weighting of criteria and sub criteria established companies are always considered manager to each process of inputting assessment. Therefore, the authors make a decision support system application manager that can facilitate the process of inputting weight rating decision promotion of employees in accordance with the criteria and sub-criteria that have been specified company. Application decision support system of promotion is designed using Analytical Hierarchy Process that the process to obtain the priority weighting is done by comparing each criteria and sub-criteria. Decision to be achieved can help managers to determine who the employees are entitled to a promotion in accordance with keptusan obtained from the application of this decision-making system.


2012 ◽  
Vol 546-547 ◽  
pp. 1387-1392
Author(s):  
Chun Hua Zhou ◽  
Chu Xiang Chen ◽  
Yun Cheng Wang ◽  
Shi Jun Yao

According to the characteristics of college training and requirements of the society for talents, the decision support system of college training is designed in this paper. Targeted at graduates’ employment, a data warehouse for college students is set up and online analytical processing and data mining are conducted so as to find out the key factors that affect graduates to find a job. The experimental results are in line with the reality, which shows that decision support system of college training is a powerful auxiliary decision-making tool.


Sign in / Sign up

Export Citation Format

Share Document