DESAIN DATABASE UNTUK OPTIMALISASI SISTEM PREDIKSI TRANSAKSI PENJUALAN
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 i...
Main Authors: | , , |
---|---|
Format: | Article |
Language: | Indonesian |
Published: |
STKIP PGRI Tulungagung
2017-12-01
|
Series: | JIPI (Jurnal Ilmiah Penelitian dan Pembelajaran Informatika) |
Online Access: | http://jurnal.stkippgritulungagung.ac.id/index.php/jipi/article/view/367 |
id |
doaj-fef07038d84e4cbea8b9637b643c2a11 |
---|---|
record_format |
Article |
spelling |
doaj-fef07038d84e4cbea8b9637b643c2a112020-11-25T02:42:11ZindSTKIP PGRI TulungagungJIPI (Jurnal Ilmiah Penelitian dan Pembelajaran Informatika)2540-89842017-12-012210.29100/jipi.v2i2.367258DESAIN DATABASE UNTUK OPTIMALISASI SISTEM PREDIKSI TRANSAKSI PENJUALANSucipto Sucipto0Rini Indriati1Fitra Bagoes Hariawaan2University of Nusantara PGRI KediriUniversity of Nusantara PGRI KediriUniversity of Nusantara PGRI KediriThe 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 MariaDBhttp://jurnal.stkippgritulungagung.ac.id/index.php/jipi/article/view/367 |
collection |
DOAJ |
language |
Indonesian |
format |
Article |
sources |
DOAJ |
author |
Sucipto Sucipto Rini Indriati Fitra Bagoes Hariawaan |
spellingShingle |
Sucipto Sucipto Rini Indriati Fitra Bagoes Hariawaan DESAIN DATABASE UNTUK OPTIMALISASI SISTEM PREDIKSI TRANSAKSI PENJUALAN JIPI (Jurnal Ilmiah Penelitian dan Pembelajaran Informatika) |
author_facet |
Sucipto Sucipto Rini Indriati Fitra Bagoes Hariawaan |
author_sort |
Sucipto Sucipto |
title |
DESAIN DATABASE UNTUK OPTIMALISASI SISTEM PREDIKSI TRANSAKSI PENJUALAN |
title_short |
DESAIN DATABASE UNTUK OPTIMALISASI SISTEM PREDIKSI TRANSAKSI PENJUALAN |
title_full |
DESAIN DATABASE UNTUK OPTIMALISASI SISTEM PREDIKSI TRANSAKSI PENJUALAN |
title_fullStr |
DESAIN DATABASE UNTUK OPTIMALISASI SISTEM PREDIKSI TRANSAKSI PENJUALAN |
title_full_unstemmed |
DESAIN DATABASE UNTUK OPTIMALISASI SISTEM PREDIKSI TRANSAKSI PENJUALAN |
title_sort |
desain database untuk optimalisasi sistem prediksi transaksi penjualan |
publisher |
STKIP PGRI Tulungagung |
series |
JIPI (Jurnal Ilmiah Penelitian dan Pembelajaran Informatika) |
issn |
2540-8984 |
publishDate |
2017-12-01 |
description |
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 |
url |
http://jurnal.stkippgritulungagung.ac.id/index.php/jipi/article/view/367 |
work_keys_str_mv |
AT suciptosucipto desaindatabaseuntukoptimalisasisistemprediksitransaksipenjualan AT riniindriati desaindatabaseuntukoptimalisasisistemprediksitransaksipenjualan AT fitrabagoeshariawaan desaindatabaseuntukoptimalisasisistemprediksitransaksipenjualan |
_version_ |
1724774714826555392 |