![](/images/graphics-bg.png)
منهجية معتمدة على البرمجة المشتقة من النماذج لتنظيف و استيراد المعطيات أثناء التشغيل
Other Title(s)
MDP based approach for data cleansing and importing at runtime
Author
Source
مجلة جامعة دمشق للعلوم الهندسية
Issue
Vol. 37, Issue 4 (31 Dec. 2021), pp.219-233, 15 p.
Publisher
Publication Date
2021-12-31
Country of Publication
Syria
No. of Pages
15
Main Subjects
Engineering & Technology Sciences (Multidisciplinary)
Abstract EN
This article presents a new methodology that uses a new models based on MDP (Model Driven Programming), which allows us to build user friendly and efficient ETL/data cleansing framework that functions in live environment.
It enables business experts to import and clean data themselves, as it does not require any background in programming or database management.
Data Importing and Cleansing is the most sensitive and expensive step in enterprise application development (such as e-government systems, ERPs, forex, banking, HMIS ...) and when it fails the entire project fails.
Our methodology is capable of detecting errors early, even before the actual importing of data.
It can check not only integrity errors but semantic errors also (as if we have already imported our data to the live system).
Moreover, our methodology allows us to roll back the imported data, any time, without restoring the whole database (ie., users can keep any record created after the importing process and remove only data related to the imported data).
This makes our model appropriate to import data to live systems.
We have implemented our approach using a MDP framework (Elixir) which is based on free/open source infrastructure including J2EE, JBoss, MySQ.
The final system is tested and validated within a real “cost control” project, which was applied for the medical services in the Ministry of Health (MoH) in Syria.
The first test is achieved in the biggest hospital belonging to MoH (Mujtahed Hospital), then in Eye hospital and the team of MoH continue the work by himself in all other hospitals.
American Psychological Association (APA)
جوخدار، عمار. 2021. منهجية معتمدة على البرمجة المشتقة من النماذج لتنظيف و استيراد المعطيات أثناء التشغيل. مجلة جامعة دمشق للعلوم الهندسية،مج. 37، ع. 4، ص ص. 219-233.
https://search.emarefa.net/detail/BIM-1417683
Modern Language Association (MLA)
جوخدار، عمار. منهجية معتمدة على البرمجة المشتقة من النماذج لتنظيف و استيراد المعطيات أثناء التشغيل. مجلة جامعة دمشق للعلوم الهندسية مج. 37، ع. 4 (2021)، ص ص. 219-233.
https://search.emarefa.net/detail/BIM-1417683
American Medical Association (AMA)
جوخدار، عمار. منهجية معتمدة على البرمجة المشتقة من النماذج لتنظيف و استيراد المعطيات أثناء التشغيل. مجلة جامعة دمشق للعلوم الهندسية. 2021. مج. 37، ع. 4، ص ص. 219-233.
https://search.emarefa.net/detail/BIM-1417683
Data Type
Journal Articles
Language
Arabic
Notes
يتضمن مراجع ببليوجرافية : ص. 232-233
Record ID
BIM-1417683