Implementasi JSON untuk Minimasi Penggunaan Jumlah Kolom Suatu Tabel Pada Database PostgreSQL


Author (s)

(1) * Mochamad Alfan Rosid   (Universitas Muhammadiyah Sidoarjo)
(*) Corresponding Author


On the development of the database currently has become a very important thing, each will plan something, consider any thing we will need and use existing data in a database, The development of the database currently has become a very important thing, when we want to plan something and consider everything,  we will need and use existing data in a database, PostgreSQL is one Object Relational Database Management Systems (DBMS) open source with a lot of features that are not less sophisticated to commercial databases. On daily use, it sometimes occurs  a case that requires a dynamic column, therefore we should make the new columns to meet those needs. However, if each row of the table column requires  different  column and potentially need another ones, then it is going to be uselessOn the research of utilizing the technology of JavaScript Object Notation (JSON),Json_encode PHP programming language can simplify the use of the column so that  a new column is  no longer needed when we want to create a new column on the table, we only need a new column that stores an array that has been converted into a JSON string forms the result of json_encode that represents the column name and the content of the columns of a table. 


Database; PostgreSQL; ORDBMS; JSON; PHP

Full Text: PDF


[1] E-Aziz A.Abd, Kannan A. JSON Encryption. In Proceedings of 2014 International Conference on Computer Communication and Informatics (ICCCI -2014), Jan. 03 – 05, 2014, Coimbatore, INDIA, 2014

[2] Fathansyah, Basis Data, Informatika, Bandung, 2007.

[3] G. Wang. Improving Data Transmission in Web Applications via the Translation between XML and JSON. In Proceedings of 2011 Third International Conference on Communications and Mobile Computing (CMC), pages 182 – 185, 18-20 April, 2011

[4] J. Salahadin, V. Achim, V. Andrey. Learning PostgreSQL, Create, Develop, and manage relational databases in real-world applications using PostgreSQL. Birmingham-Mumbai:PACKT Publishing. 2015.

[5] Jackson W, JSON Quick Sintax Reference, The Expert’s Voice in Web Develoment. Lompoc, California, USA:Apress. 2016.

[6] L. Griffin, B. Butler, E. de Leastar, B. Jennings, and D. Botvich. On the Performance of Access Control Policy Evaluation. In Proceedings of 2012 IEEE International Symposium on Policies for Distributed Systems and Networks (POLICY), pages 25 – 32, 16-18 July, 2012.

[7] Munawaroh Siti. 2005. Mengeksplorasi Database PostgreSQL dengan PgAdmin III. Jurnal Teknologi Informasi DINAMIK.

[8] Smith Ben. Beginning JSON, The Expert’s Voice in Web Develoment. New York: Apress. 2015

Article View

Abstract views : 1397 times | PDF files viewed : 1038 times

Dimensions, PlumX, and Google Scholar Metrics



  • There are currently no refbacks.

Copyright (c) 2017 Journal Of Informatics, Network and Computer Science

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.