Design of Data warehouse to Analyze CMMS Data

Authors

  • Ali Suleiman Tishreen University

Keywords:

مستودعات البيانات

Abstract

In this paper, a system based on data warehouse technology and remote database modeling is designed to receive data related to the maintenance and analysis of the machines in order to reach results that contribute to the decision making that may relate to the state of machines or types of faults or the time of occurrence. Lattakia International.
The system relies on a Compaq server, an Oracle 11 database engine, and Oracle Developer to create reports and searches.

The results showed that the use of data warehouse technologies in the analysis of computer maintenance systems data reduces the time required for the completion of queries on the data and allows generation of many reports that need to be generated using the traditional database to write a large number of queries manually.

Downloads

Published

2022-11-13

How to Cite

1.
علي سليمان. Design of Data warehouse to Analyze CMMS Data. Tuj-eng [Internet]. 2022Nov.13 [cited 2024Nov.26];40(6). Available from: https://journal.tishreen.edu.sy/index.php/engscnc/article/view/14088

Issue

Vol. 40 No. 6 (2018): العلوم الهندسية

Section

Articles

License

Copyright (c) 2022 ttps://creativecommons.org/licenses/by-nc-sa/4.0/

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

The authors retain the copyright and grant the right to publish in the magazine for the first time with the transfer of the commercial right to Tishreen University Journal for Research and Scientific Studies - Engineering Sciences Series

 Under a CC BY- NC-SA 04 license that allows others to share the work with of the work's authorship and initial publication in this journal. Authors can use a copy of their articles in their scientific activity, and on their scientific websites, provided that the place of publication is indicted in  Tishreen University Journal for Research and Scientific Studies - Engineering Sciences Series   .  The Readers have the right to send, print and subscribe to the initial version of the article, and the title of  Tishreen University Journal for Research and Scientific Studies - Engineering Sciences Series     Publisher

journal uses a CC BY-NC-SA license which mean

You are free to:

  • Adapt — remix, transform, and build upon the material
  •  
  • The licensor cannot revoke these freedoms as long as you follow the license terms.

 

  • Attribution — You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
  • NonCommercial — You may not use the material for commercial purposes.
  • ShareAlike — If you remix, transform, or build upon the material, you must distribute your contributions under the same license as the original.
  • No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.