An optimised method for fetching and transforming survey data based on SQL and R programming language
Other Title(s)
طريقة محسنة لجلب و تحويل بيانات المسح بناء على لغتي برمجة SQL و R
Joint Authors
Hasan, Furat Falih
Jamal al-Din, Zulaykhah
Source
Issue
Vol. 16, Issue 2 (s) (30 Jun. 2019), pp.436-444, 9 p.
Publisher
University of Baghdad College of Science for Women
Publication Date
2019-06-30
Country of Publication
Iraq
No. of Pages
9
Main Subjects
Information Technology and Computer Science
Topics
Abstract EN
The development of information systems in recent years has contributed to various methods of gathering information to evaluate IS performance.
The most common approach used to collect information is called the survey system.
This method, however, suffers one major drawback.
The decision makers consume considerable time to transform data from survey sheets to analytical programs.
As such, this paper proposes a method called ‘survey algorithm based on R programming language’ or SABR, for data transformation from the survey sheets inside R environments by treating the arrangement of data as a relational format.
R and Relational data format provide excellent opportunity to manage and analyse the accumulated data.
Moreover, a survey system based on structured query language and R programming language is designed to optimize methods to manage survey systems by applying large features offered via combining multi data science languages.
The experiments verified enhancements of flexibility, technical tools, and data visualization features employed to process the collected data from different aspects; therefore, the proposed approach demonstrates a simple case study to enhance the evaluation requirements of the proposed technique.
Finally, the estimated results of this research can be used to improve the methods of information management on different aspects such as survey systems and other data models that hold the relational and non-relational models using SABR.
This method demonstrated improved accuracy of data collected, reduced data processing time and arranged data to the willing model.
American Psychological Association (APA)
Hasan, Furat Falih& Jamal al-Din, Zulaykhah. 2019. An optimised method for fetching and transforming survey data based on SQL and R programming language. Baghdad Science Journal،Vol. 16, no. 2 (s), pp.436-444.
https://search.emarefa.net/detail/BIM-891214
Modern Language Association (MLA)
Hasan, Furat Falih& Jamal al-Din, Zulaykhah. An optimised method for fetching and transforming survey data based on SQL and R programming language. Baghdad Science Journal Vol. 16, no. 2 (عدد خاص) (2019), pp.436-444.
https://search.emarefa.net/detail/BIM-891214
American Medical Association (AMA)
Hasan, Furat Falih& Jamal al-Din, Zulaykhah. An optimised method for fetching and transforming survey data based on SQL and R programming language. Baghdad Science Journal. 2019. Vol. 16, no. 2 (s), pp.436-444.
https://search.emarefa.net/detail/BIM-891214
Data Type
Journal Articles
Language
English
Notes
Includes bibliographical references : p. 443-444
Record ID
BIM-891214