Understanding the database manipulation behavior of programs

Penelitian ini memiliki tujuan untuk menyediakan layanan dalam bentuk aplikasi untuk melakukan kegiatan Database Manipulation Language (DML) yang diterapkan dalam bentuk cloud computing . Sebanyak tiga buah computer dimanfaatkan untuk memberikan layanan pemrosesan dan penyimpanan database tanpa menggunakan perintah yang ada pada Structure Query Language (SQL) dan satu buah computer digunakan sebagai server yang melayani pengguna untuk melakukan kegiatan DML tanpa menggunakan perintah SQL . Dengan menggunakan teknologi cloud pengelolaan database berbasis SQL yang biasanya menggunakan perintah berbasis command line dapat dilakukan dengan cara yang lebih mudah. Layanan yang diberikan oleh cloud untuk mengelola database berbasis SQL khususnya fungsi DML. Hasil dari implementasi layanan pada jaringan internet, Wireless lan, dan LAN dapat berjalan dengan baik dengan kasus pengujian fungsi pada ketiga media jaringan tersebut. Dengan demikian para pengguna yang sama sekali tidak mengerti bahasa SQL dapat menggunakan layanan ini dengan mudah untuk mengolah database SQL secara mandiri.

Download Full-text

Ethereum Blockchain based Secure E-voting System

International Journal of Innovative Technology and Exploring Engineering - Special Issue ◽

10.35940/ijitee.e2542.039520 ◽

2020 ◽

Vol 9 (5) ◽

pp. 1677-1681

Keyword(s):

Electronic Voting ◽

Data Networks ◽

Blockchain Technology ◽

Full Control ◽

Traditional Structure ◽

System Use ◽

Voting System ◽

Database Manipulation ◽

Electronic Voting System ◽

Centralized System

The security and accountability issues are a challenge to the traditional structure from still widespread elections. General e-voting system use a centralized system, where one organization manages overall system. These organisations have full control over the database and system, allowing manipulation of the database. There should be no e-voting system to secure data and potential attacks should be able to withstand. Blockchain technology should solve certain voting problems. In this paper we are implementing an ethereum blockchain based electronic voting system. Ethereum blockchain networks are used to transfer money and store data. Networks are organized by one or more machines. Every node is a machine that running an ethereum client. The eligible one can run the node. By adopting blockchain in e-voting system database distribution, one of the cheating sources of database manipulation and data loss can be reduced. This can be a better solution for the currently existing issues over rigging the electronic voting machines to win elections by the political parties in our government

Download Full-text

Aplikasi Sistem Akuntansi Rekapitulasi Pendapatan pada Perusahaan Daerah Air Minum (PDAM) Tirtauli Pematangsiantar

JURNAL PETIK ◽

10.31980/jpetik.v6i1.739 ◽

2020 ◽

Vol 6 (1) ◽

pp. 7-17

Author(s):

Sindi Raharjo Tanjung ◽

Dedi Suhendro

Keyword(s):

Visual Basic ◽

Accounting System ◽

Microsoft Excel ◽

Application System ◽

Water Company ◽

Database Manipulation ◽

Owned Company ◽

Income Accounting ◽

Regional Water ◽

Better Than

Abstact — The Tirtauli Pematangsiantar Regional Water Company (PDAM) is classified as a state-owned company that has operational objectives to meet the needs of the community. Revenues at the Tirtauli Regional Water Company (PDAM) are divided into two, namely water revenues and non-water revenues. Regional income recapitulation Tirtauli Pematangsaiantar still uses Microsoft Excel application where the application is still often an error in revenue recapitulation. Based on this, the authors designed a recapitulation income accounting system application program using Microsoft Basic Net and MySQL database to produce applications better than those running. Application of income recapitulation accounting system using Microsoft Visual Basic Net is designed to produce a better application using a MySQL database designed to perform database manipulation processes with various facilities. The purpose of the authors designed the application to facilitate the User in recapitulation of income with the Visual Basic Net application system so that it can help or simplify the process of inputing income recapitulation.Keywords : Application, Revenue Recapitulation, Microsoft Visual Basic Net, MySQL Database.Abstrak — Perusahaan Daerah Air Minum (PDAM) Tirtauli Pematangsiantar digolongkan sebagai perusahaan negara yang memiliki tujuan operasional untuk memenuhi kebutuhan masyarakat. Pendapatan pada Perusahaan Daerah Air Minum (PDAM) Tirtauli terbagi menjadi dua, yaitu penerimaan air dan pendapatan non-air. Rekapitulasi pendapatan perusahaan Daerah Air Minum (PDAM) Tirtauli Pematangsaiantar masih menggunakan aplikasi Microsoft Excel di mana aplikasi masih sering kesalahan dalam rekapitulasi pendapatan. Berdasarkan hal ini, penulis merancang program aplikasi sistem akuntansi pendapatan rekapitulasi dengan menggunakan Microsoft Basic Net dan database MySQL untuk menghasilkan aplikasi lebih baik yang sedang berjalan. Aplikasi sistem akuntansi rekapitulasi pendapatan menggunakan Microsoft Visual Basic Net dirancang untuk menghasilkan suatu aplikasi yang lebih baik dengan menggunakan database MySQL yang didesain untuk melakukan proses manipulasi database dengan berbagai fasilitas. Tujuan penulis merancang aplikasi untuk mempermudah User dalam melakukan rekapitulasi pendapatan dengan sistem aplikasi Visual Basic Net sehingga dapat membantu atau mempermudah proses penginputan rekapitulasi pendapatan.Kata Kunci : Aplikasi, Rekapitulasi Pendapatan, Microsoft Visual Basic Net, Database MySQL.

Download Full-text

Database Secure Manipulation based on Paillier’s Homomorphic Encryption (DSM-PHE)

International Journal of Interactive Mobile Technologies (iJIM) ◽

10.3991/ijim.v13i12.11396 ◽

2019 ◽

Vol 13 (12) ◽

pp. 136

Author(s):

Somchai Prakancharoen

Keyword(s):

Data Base ◽

Simple Technique ◽

Homomorphic Encryption ◽

Simple Solution ◽

Encryption Algorithm ◽

Sensitive Data ◽

Database Manipulation ◽

Division Operation

The objective of this research was to suggest some simple solution to increase database manipulation security. Based on advantage of Homomorphic encryption, user’s data in database is always encrypted by Homomorphic encryption algorithm such as Paillier. User’s data is manipulated or processed on many times such as addition, subtraction, multiplication and division. By the advantage of Homomorphic encryption algorithm, user’s data were no need to decrypt while it was manipulated therefore secrecy of data was still reserved. Unfortunately, Paillier’s Homomorphic encryption is normally coverage only addition and multiplication mathematical data operation. This paper suggests simple technique to enhance Pailler’s encryption algorithm to perform data operation as well in subtraction and division operation. Evaluation in suggested data base manipulation, DSM-PHE, indicates that its operation tasks was five operation times more than ordinary data base manipulation operation tasks, without any encryption. Therefore DSM-PHE should be especially used in more sensitive data.

Download Full-text