JSON Implementation to Minimize the Use of the Number of Columns of a Table in a PostgreSQL Database:

Mochamad Alfan Rosid

doi:10.21070/10.21070/joincs.v1i1.802

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

DOI: https://doi.org/10.21070/10.21070/joincs.v1i1.802

Abstract

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 useless. On 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.

References

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

Fathansyah, Basis Data, Informatika, Bandung, 2007.

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 DOI: https://doi.org/10.1109/CMC.2011.25

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.

Jackson W, JSON Quick Sintax Reference, The Expert’s Voice in Web Develoment. Lompoc, California, USA:Apress. 2016. DOI: https://doi.org/10.1007/978-1-4842-1863-1

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. DOI: https://doi.org/10.1109/POLICY.2012.15

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

Smith Ben. Beginning JSON, The Expert’s Voice in Web Develoment. New York: Apress. 2015 DOI: https://doi.org/10.1007/978-1-4842-0202-9

JSON Implementation to Minimize the Use of the Number of Columns of a Table in a PostgreSQL Database

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

Abstract

References