DESAIN DATABASE UNTUK OPTIMALISASI SISTEM PREDIKSI TRANSAKSI PENJUALAN

Sucipto Sucipto - [ http://orcid.org/0000-0003-3412-002X ]
Rini Indriati
Fitra Bagoes Hariawaan


DOI: http://dx.doi.org/10.29100/jipi.v2i2.367

Abstract


The advance of informational technology is expected to be a tool which helps data tabulating process.  Management and usage of the data systematically can produce detailed information. The important of data management is able to enhance the quality of information that is processed. Data management is started from the storage system of data namely database design. In the database design, the thing that should be heeded is the relation of each table inside of it. The relation among the table shows the linkages data that will be processed to be essential information. In this research, the focused discussion is optimalizing a table for further tabulating towards a marketing informational system database.  The database that will be optimalized will be used to marketing prediction tabulation. In tabulating stage, data prediction in database will be exported into two databases namely PostgreSQL and MariaDB. The data used for examining amount 476619 marketing data is taken from marketing transaction among 2015-2017. This research data is tabulated using join table that produce 374 data. The data is the information that will be used for marketing prediction. Based on rapidity examination of marketing data tabulation by using PostSQL indicates slight difference around 0.26 seconds faster than MariaDB. The research result of database optimalizing design which has been made shows that PostgreSQL is better in data tabulating rapidity than MariaDB

Full Text:

PDF

References


T. M. Connolly and C. E. Begg, Database systems: a practical approach to design implementation and management, 5th ed. America: Pearson Education, 2010.

C. J. Date, “An Introduction to Database Systems,” 8th ed., International: Pearson, 2004.

A. Silberschatz, H. F. Korth, and S. Sudarshan, “Database System Concepts,” 4th ed., New York: McGraw-Hill, 2002.

R. Kuswandi, H. Fahmi, H. Faidah, H. Setiadi, and Z. Hasibuan, “Konsolidasi database kependudukan nasional,” in Seminar Nasional Aplikasi Teknologi Informasi, 2007, vol. 3, no. 1, pp. 28–34.

S. Sucipto, A. Suhartanto, and R. Firliana, “Representasi Fuzzy Tsukamoto Menggunakan Fungsi PL/PgSQL Dan Check Constraint,” in Seminar Nasional Teknologi Informasi dan Multimedia 2015, 2015, p. 4.5-7-4.5-12.

M. Arief and F. Rachman, “Database Integration Based on Combination Schema Matching Approach ( case study : Multi-database of District Health Information System ),” in International Conferences on Information Technology, Information Systems and Electrical Engineering (ICITISEE), 2017, pp. 429–434.


Article Metrics

Abstract view : 14 times
PDF View : 6 times

Refbacks

  • There are currently no refbacks.


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

Jurnal Ilmiah Penelitian dan Pembelajaran Informatika (JIPI)
Program Studi Pendidikan Teknologi Informasi
STKIP PGRI Tulungagung Jalan Major Sujadi Timur 7, Plosokandang, Kedungwaru
Tulungagung, Kabupaten Tulungagung, Jawa Timur 66229
Telepon:(0355) 321426
E-mail:jipi@stkippgritulungagung.ac.id

DOI : http://dx.doi.org/10.29100/jipi.xxx

 

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License