APLIKASI MOBILE SQL UNTUK ADMINISTRASI BASISDATA POSTGRESQL MEMANFAATKAN JAVA SERVLET

Authors

  • Erick Costanio Fakultas Teknologi Informasi, Universitas Kristen Maranatha
  • Hapnes Toba Fakultas Teknologi Informasi, Universitas Kristen Maranatha

:

https://doi.org/10.9744/informatika.9.2.122-129

Keywords:

Mobile SQL, Java ME, Postgre, database administration, servlet

Abstract

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

Downloads

Published

2010-02-10

How to Cite

Costanio, E., & Toba, H. (2010). APLIKASI MOBILE SQL UNTUK ADMINISTRASI BASISDATA POSTGRESQL MEMANFAATKAN JAVA SERVLET. Jurnal Informatika, 9(2), 122-129. https://doi.org/10.9744/informatika.9.2.122-129

Issue

Vol. 9 No. 2 (2008): NOVEMBER 2008

Section

Articles

License

Authors who publish with this journal agree to the following terms:


  1. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.

  2. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.

  3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).