Indonesian Journal of Electrical Engineering and Computer Science
Vol 4, No 1: October 2016

Efficiency of JSON approach for Data Extraction and Query Retrieval

Mohd Kamir Yusof (Universiti Sultan Zainal Abidin)
Mustafa Man (Universiti Sultan Zainal Abidin)



Article Info

Publish Date
01 Oct 2016

Abstract

Students’ Information System (SIS) in Universiti Sultan Zainal Abidin (UniSZA) handles thousands of records on the information of students, subject registration, etc. Efficiency of storage and query retrieval of these records is the matter of database management especially involving with huge data. However, the execution time for storing and retrieving these data are still considerably inefficient due to several factors. In this contribution, two database approaches namely Extensible Markup Language (XML) and JavaScript Object Notation (JSON) were investigated to evaluate their suitability for handling thousands records in SIS. The results showed JSON is the best choice for storage and query speed. These are essential to cope with the characteristics of students’ data. Whilst, XML and JSON technologies are relatively new to date in comparison to the relational database. Indeed, JSON technology demonstrates greater potential to become a key database technology for handling huge data due to an increase of data annually.

Copyrights © 2016