Design of Data warehouse to Analyze CMMS Data
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
How to Cite
Issue
Section
License
Copyright (c) 2022 ttps://creativecommons.org/licenses/by-nc-sa/4.0/
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:
- Share — copy and redistribute the material in any medium or format
- 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.
