DESAIN DATABASE UNTUK OPTIMALISASI SISTEM PREDIKSI TRANSAKSI PENJUALAN

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


DOI: https://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

Article Metrics :

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.