Record Details

PERANCANGAN DAN PEMBUATAN APLIKASI ERD GENERATOR NOTASI ORM DARI SKRIP BASIS DATA ORACLE BERBASIS J2EE

Jurnal Informatika

View Archive Info
 
 
Field Value
 
Title PERANCANGAN DAN PEMBUATAN APLIKASI ERD GENERATOR NOTASI ORM DARI SKRIP BASIS DATA ORACLE BERBASIS J2EE
 
Creator Santoso, Leo Willyanto; Faculty of Industrial Technology, Petra Christian University
 
Subject Database, Conceptual data model, ERD, Oracle, and Servlets.
 
Description The existing of database processing is needed by many institutions and companies. Database is not only to get information faster, it is also enlarging their service to customer. For companies, this advantage can increase competency. Because of this reason, many companies using manual processing turn to database.
As mentioned above, database reverse engineering process has became a necessity for database developers to understand the structure of any databases. Commonly, this structure is modeled in some notations of Entity Relationships Diagram (ERD). The graphical visualization of database structure in an ERD can use many notations, so it is easy to understand. One of the approaches, which are easy to understand, is Object Role Modeling (ORM) diagram.
By reverse engineering the mapping process to relation schema of a database, ERD generation from a data definition language script of Oracle can be done. For more flexibility, this application is constructed web based with Servlets technology that is propertied by JavaTM 2 SDK.


Abstract in Bahasa Indonesia :

Kehadiran pemrosesan basis data diperlukan oleh berbagai institusi dan perusahaan. Basis data tidak hanya mempercepat pemerolehan informasi, tetapi juga dapat meningkatkan pelayanan kepada pelanggan. Bagi perusahaan, keuntungan seperti ini dapat meningkatkan daya saingnya terhadap perusahaan lain. Hal ini pulalah yang mendorong banyak perusahaan yang menggunakan pemrosesan manual mulai beralih memanfaatkan basis data.
Sejalan dengan hal di atas, proses reverse engineering terhadap suatu basis data menjadi suatu kebutuhan bagi perancang basis data untuk mengetahui struktur dari sebuah basis data. Struktur tersebut biasanya dimodelkan dalam bentuk Entity Relationships Diagram (ERD). Penggambaran struktur basis data dalam sebuah ERD dapat menggunakan berbagai notasi agar menjadi lebih mudah dimengerti. Salah satu notasi yang pendekatannya mudah dipahami adalah notasi Object Role Modeling (ORM) diagram.
Dengan melakukan pembalikan terhadap proses pemetaan ke skema relasi dari suatu basis data maka pembangkitan ERD dari suatu skrip pembuatan basis data Oracle dapat dilakukan. Agar lebih fleksibel, maka aplikasi yang dibangun berupa aplikasi berbasis web dengan menggunakan teknologi Servlets yang dimiliki oleh JavaTM 2 SDK.

Kata kunci: Basis data, Model data konseptual, ERD, Oracle, dan Servlets.
 
Publisher Institute of Research and Community Outreach - Petra Christian University
 
Date 2004-05-31
 
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/15437
10.9744/informatika.5.1.pp.7-13
 
Source Jurnal Informatika; Vol 5, No 1 (2004): MAY 2004; pp.7-13
 
Language eng
 
Relation http://jurnalinformatika.petra.ac.id/index.php/inf/article/view/15437/15429
 
Rights Authors who publish with this journal agree to the following terms: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.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.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).