Native JSON model for data integration in business intelligent applications

MOHD KAMIR YUSOF; MUSTAFA MAN; WAN AMIR FAZAMIN WAN HAMZAH; SUHAILAN SAFEI; ISMAHAFEZI ISMAIL

Author(s)

MOHD KAMIR YUSOF Faculty of Informatics & Computing, Universiti Sultan Zainal Abidin, 22200 Besut, Terengganu, Malaysia

MUSTAFA MAN Faculty of Ocean Engineerinf Technology & Informatics, 21300 K.Terengganu,Terengganu, Malaysia

WAN AMIR FAZAMIN WAN HAMZAH Faculty of Informatics & Computing, Universiti Sultan Zainal Abidin, 22200 Besut, Terengganu, Malaysia

SUHAILAN SAFEI Faculty of Informatics & Computing, Universiti Sultan Zainal Abidin, 22200 Besut, Terengganu, Malaysia

ISMAHAFEZI ISMAIL Faculty of Informatics & Computing, Universiti Sultan Zainal Abidin, 22200 Besut, Terengganu, Malaysia

Abstract

Collection of data is important component for most business intelligent (BI) application to make a best decision regarding to company. Successful of BI application is consist how much this application can provide useful data for decision maker to achieve the company critical goals such as achieving or exceeding revenue, opportunity to reduce cost, etc. However, 80 percent of BI application has a problem to produce useful data because of data integration issue. This issue is occurred because of increasing amount of data., integration difficulties, and high complexity. Universal data integration model is required to provide useful data for BI application. Native XML (NXD) and JSON are two approaches have been implemented in data integration. These approaches are proven efficient for data integration in term of data insertion response time and query processing response time. Based on NXD and JSON, this paper proposed Native JSON (N-JSON) as a new alternative data integration for BI application. Three experiments such as data insertion response time, query processing response time and CPU usage has been done by using two different datasets; SigmodRecord and DBLP. The results indicate N-JSON produces a better performance compared NXD. As a result, N-JSON can be used as an alternative data integration for BI application in order to provide useful data to decision maker.

Publication Details

Page(s) 5384-5395

DOI DOI not available

Published Journal: Journal of Theoretical and Applied Information Technology, Volume: 100, Issue: 18, Year: 2022

Request the full text from PASTIC

Keywords

Data Integration, Native XML, Native JSON, JSON, Business Intelligent