Record Details

APLIKASI MOBILE SQL UNTUK ADMINISTRASI BASISDATA POSTGRESQL MEMANFAATKAN JAVA SERVLET

Jurnal Informatika

View Archive Info
 
 
Field Value
 
Title APLIKASI MOBILE SQL UNTUK ADMINISTRASI BASISDATA POSTGRESQL MEMANFAATKAN JAVA SERVLET
 
Creator Costanio, Erick
Toba, Hapnes
 
Subject
Mobile SQL, Java ME, Postgre, database administration, servlet
 
Description Since a database administrator is not always be in a fix place, we need something that make it possible for the administrator to manage the database anywhere. A Mobile SQL technology is flexible enough for an administrator to do this maintenance job immediately, such as for query operation, and database recovery. Our goal is to develop such application using Java ME and Servlet technology, thus making it runs on every mobile device that has MIDP 2.0, CLDC 1.1, and GPRS enabled device. While on a server computer, it needs web server and a DBMS. For this purpose, an object-oriented DBMS Postgre has been choosen. The main features of this application are: executing SQL queries; creating tables and users; making database backup and recovery; creating and executing SQL procedural language – PL/pgSQL; and sending a log through email. This application will also notify another adminstrator through email for any changes that has been made in the database


Abstract in Bahasa Indonesia:

Mobile SQL adalah alat administrasi basisdata PostgreSQL berbasis mobile menggunakan koneksi HTTP. Teknologi mobile yang bersifat fleksibel membuat administrator dapat segera melakukan perawatan basisdata jika diperlukan tanpa harus berada di lokasi server. Pengembangan aplikasi menggunakan teknologi Java ME dan Servlet, serta dapat dijalankan menggunakan telepon seluler sebagai klien dengan spesifikasi MIDP 2.0, CLDC 1.1 dan GPRS yang telah diaktifkan, sedangkan untuk komputer server diperlukan web server dan DBMS. Fitur utama pada aplikasi ini antara lain: menjalankan perintah SQL, membuat tabel dan pengguna, melakukan backup dan recovery basisdata, menulis dan menjalankan bahasa prosedural SQL - PL/pgSQL, serta mengirim log melalui email. Aplikasi Mobile SQL dapat digunakan untuk melakukan administrasi basisdata menggunakan telepon seluler.

Kata kunci: Mobile SQL, Java ME, DBMS, administrasi basisdata
 
Publisher Institute of Research and Community Outreach - Petra Christian University
 
Contributor
 
Date 2010-02-10
 
Type info:eu-repo/semantics/article
info:eu-repo/semantics/publishedVersion

 
Format application/pdf
 
Identifier http://jurnalinformatika.petra.ac.id/index.php/inf/article/view/17871
10.9744/informatika.9.2.122-129
 
Source Jurnal Informatika; Vol 9, No 2 (2008): NOVEMBER 2008; 122-129
2528-5823
1411-0105
 
Language eng
 
Relation http://jurnalinformatika.petra.ac.id/index.php/inf/article/view/17871/17800
 
Coverage