Claim Missing Document
Check
Articles

Found 2 Documents
Search
Journal : Jurnal Informatika

IMPLEMENTASI REFERENTIAL INTEGRITY CONSTRAINT PADA MICROSOFT ACCESS DALAM UPAYA MEMELIHARA KONSISTENSI DATA Yuliana, Oviliani Yenty
Jurnal Informatika Vol 2, No 1 (2001): MAY 2001
Publisher : Institute of Research and Community Outreach - Petra Christian University

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (371.515 KB) | DOI: 10.9744/informatika.2.1.pp. 33-43

Abstract

Data is business asset that should be safeguarded and maintained. Business data is recorded in a table/relation. Because inconeet relation structure could produce any modification anomaly, this relation should be normalized. Data modification in normalized relation will face referential integrity constraint problem. This problem could make inconsistent data and wrong information. Referential integrity constraint depends on minimum relationship cardinality. The trial and implementation of referential integrity constraint is taken on Microsoft Access. Abstract in Bahasa Indonesia : Data adalah asset perusahaan yang harus dijaga dan dipelihara. Data perusahaan dicatat pada tabel/relation. Struktur relation yang kurang baik dapat mengakibatkan modification anomaly, sehingga relation tersebut harus di-normalisasi. Modifikasi data pada relation yang sudah di-normalisasi akan menghadapi masalah referential integrity constraint. Masalah tersebut menyebabkan data tidak konsisten dan menghasilkan informasi yang salah. Referential integrity constraint tergantung pada minimum relationship cardinality. Penulis mengimplementasikan dan menguji coba referential integrity constraint pada Microsoft Access. Kata kunci: modification anomaly, normalization, referential integrity constraint, relationship cardinality constraint.
MINING MULTIDIMENSIONAL FUZZY ASSOCIATION RULES FROM A DATABASE OF MEDICAL RECORD PATIENTS Intan, Rolly; Yuliana, Oviliani Yenty; Handojo, Andreas
Jurnal Informatika Vol 9, No 1 (2008): MAY 2008
Publisher : Institute of Research and Community Outreach - Petra Christian University

Show Abstract | Download Original | Original Source | Check in Google Scholar | Full PDF (273.576 KB) | DOI: 10.9744/informatika.9.1.15-22

Abstract

Mining association rules is one of the important tasks in the process of data mining application. In general, the input as used in the process of generating rules is taken from a certain data table by which all the corresponding values of every domain data have correlations one to each others as given in the table. A problem arises when we need to generate the rules expressing the relationship between two or more domains that belong to several different tables in a normalized database. To overcome the problem, before generating rules it is necessary to join the participant tables into a general table by a process called Denormalization Process. This paper shows a process of generating Multidimensional Fuzzy Association Rules mining from a normalized database of medical record patients. The process consists of two sub-processes, namely sub-process of join tables (Denormalization Process) and sub-process of generating fuzzy rules. In general, the process of generating the fuzzy rules has been discussed in our previous papers [1, 2, 3, 4]. In addition to the process of generating fuzzy rules, this paper proposes a correlation measure of the rules as an additional consideration for evaluating interestingness of provided rules.