Articles

Found 11 Documents
Search

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 | Original Source | Check in Google Scholar | Full PDF (273.576 KB)

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.
RANCANGAN DATABASE SUBSISTEM PRODUKSI DENGAN PENDEKATAN SEMANTIC OBJECT MODEL Yuliana, Oviliani Yenty
Jurnal Teknik Industri Vol 4, No 1 (2002): JUNE 2002
Publisher : Institute of Research and Community Outreach - Petra Christian University

Show Abstract | Original Source | Check in Google Scholar | Full PDF (94.748 KB)

Abstract

To compete in the global market, business performer who active in industry fields should have and get information quickly and accurately, so they could make the precise decision. Traditional cost accounting system cannot give sufficient information, so many industries shift to Activity-Based Costing system (ABC). ABC system is more complex and need more data that should be save and process, so it should be applied information technology and database than traditional cost accounting system. The development of the software technology recently makes the construction of application program is not problem again. The primary problem is how to design database that presented information quickly and accurately. For that reason it necessary to make the model first. This paper discusses database modelling with semantic object model approach. This model is easier to use and is generate more normal database design than entity relationship model approach. Abstract in Bahasa Indonesia : Dalam persaingan di pasar bebas, para pelaku bisnis di bidang industri dalam membuat suatu keputusan yang tepat memerlukan informasi secara cepat dan akurat. Sistem akuntansi biaya tradisional tidak dapat menyediakan informasi yang memadai, sehingga banyak perusahaan industri yang beralih ke sistem Activity-Based Costing (ABC). Tetapi, sistem ABC merupakan sistem yang kompleks dan memerlukan banyak data yang harus disimpan dan diolah, sehingga harus menggunakan teknologi informasi dan database. Kemajuan di bidang perangkat lunak mengakibatkan pembuatan aplikasi program bukan masalah lagi. Permasalahan utama adalah bagaimana merancang database, agar dapat menyajikan informasi secara cepat dan akurat. Untuk itu, dalam makalah ini dibahas pemodelan database dengan pendekatan semantic object model. Model data ini lebih mudah digunakan dan menghasilkan transformasi yang lebih normal, jika dibandingkan dengan entity relationship model yang umum digunakan. Kata kunci: Sub Sistem Produksi, Semantic Object Model, Database Relational.
PENDEKATAN MODEL MATEMATIS UNTUK MENENTUKAN PERSENTASE MARKUP HARGA JUAL PRODUK Yuliana, Oviliani Yenty; Wahyudi, Yohan; Halim, Siana
Jurnal Teknik Industri Vol 4, No 2 (2002): DECEMBER 2002
Publisher : Institute of Research and Community Outreach - Petra Christian University

Show Abstract | Original Source | Check in Google Scholar | Full PDF (1074.253 KB)

Abstract

The purpose of this research is to design Mathematical models that can determine the selling volume as an alternative to improve the markup percentage. Mathematical models was designed with double regression statistic. Selling volume is a function of markup, market condition, and substitute condition variables. The designed Mathematical model has fulfilled by the test of: error upon assumption, accurate model, validation model, and multi collinear problem. The Mathematical model has applied in application program with expectation that the application program can give: (1) alternative to decide percentage markup for user, (2) Illustration of gross profit estimation that will be achieve for selected percentage markup, (3) Illustration of estimation percentage of the units sold that will be achieve for selected percentage markup, and (4) Illustration of total net income before tax will get for specific period. Abstract in Bahasa Indonesia : Penelitian ini bertujuan untuk merancang model Matematis guna menetapkan volume penjualan, sebagai alternatif untuk menentukan persentase markup harga jual produk. Model Matematis dirancang menggunakan Statistik Regresi Berganda. Volume penjualan merupakan fungsi dari variabel markup, kondisi pasar, dan kondisi pengganti. Model Matematis yang dirancang sudah memenuhi uji: asumsi atas error, akurasi model, validasi model, dan masalah multikolinearitas. Rancangan model Matematis tersebut diterapkan dalam program aplikasi dengan harapan dapat memberi: (1) alternatif bagi pengguna mengenai berapa besar markup yang sebaiknya ditetapkan, (2) gambaran perkiraan laba kotor yang akan diperoleh setiap pemilihan markup, (3) gambaran perkiraan persentase unit yang terjual setiap pemilihan markup, dan (4) gambaran total laba kotor sebelum pajak yang dapat diperoleh pada periode yang bersangkutan. Kata kunci: model Matematis, aplikasi program, volume penjualan, markup, laba kotor.
Pemetaan Penderita Pneumonia di Surabaya dengan Menggunakan Geostatistik Hartanto, Stefanie; Halim, Siana; Yuliana, Oviliani Yenty
Jurnal Teknik Industri Vol 12, No 1 (2010): JUNE 2010
Publisher : Institute of Research and Community Outreach - Petra Christian University

Show Abstract | Original Source | Check in Google Scholar | Full PDF (294.777 KB)

Abstract

In this paper we mapped the location of Pneumonia disease in Surabaya. We also analyse the survival of the afflicted and predict the spread of the disease using Kriging. The study reveals that after 45 days in the hospital, the survival of the Pneumonia’s patients decrease to 46.8%. Moreover, the centers of this disease are in Tubanan and Sukomanunggal Both of these regions are in West Surabaya which also is an industrial part of the city.
Bayesian Belief Network untuk Menghasilkan Fuzzy Association Rules Intan, Rolly; Yuliana, Oviliani Yenty; Kristanto, Dwi
Jurnal Teknik Industri Vol 12, No 1 (2010): JUNE 2010
Publisher : Institute of Research and Community Outreach - Petra Christian University

Show Abstract | Original Source | Check in Google Scholar | Full PDF (201.875 KB)

Abstract

Bayesian Belief Network (BBN), one of the data mining classification methods, is used in this research for mining and analyzing medical track record from a relational data table. In this paper, a mutual information concept is extended using fuzzy labels for determining the relation between two fuzzy nodes. The highest fuzzy information gain is used for mining fuzzy association rules in order to extend a BBN. Meaningful fuzzy labels can be defined for each domain data. For example, fuzzy labels of secondary disease and complication disease are defined for a disease classification. The implemented of the extended BBN in a application program gives a contribution for analyzing medical track record based on BBN graph and conditional probability tables.
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 | Original Source | Check in Google Scholar

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.
PENDEKATAN MODEL REA DALAM PERANCANGAN DATABASE SISTEM INFORMASI AKUNTANSI SIKLUS PENDAPATAN Yuliana, Oviliani Yenty
Jurnal Akuntansi dan Keuangan Vol 3, No 1 (2001): MAY 2001
Publisher : Institute of Research and Community Outreach - Petra Christian University

Show Abstract | Original Source | Check in Google Scholar | Full PDF (599.761 KB)

Abstract

Normalization concept in database is necessary in support in the computerized Accounting Information Systems (AIS). Entity Relationship Model (E-R Model) is usually used to design database as a common tool. However the rule of drawing E-R Model diagram is not so clear, therefore it make difficulty for data designer to construct normalization database. REA Model is a further development of E-R Model. REA Model using give-to-get principle that makes more easily to construct data model. This paper discuss the logical and physical view data, schema, REA Model, how to construct REA diagram, database design stages and how accountant participate in database design, as well as how to implement REA model into relational database specifically for revenue cycle Abstract in Bahasa Indonesia : Database yang memenuhi aturan normalisasi diperlukan untuk menunjang Sistem Informasi Akuntansi (SIA) terkomputerisasi. Alat yang biasa digunakan untuk merancang database adalah Entity Relationship Model (Model E-R). Namun aturan penggambaran diagram tidak begitu jelas, sehingga mempersulit perancang data untuk membentuk database yang memenuhi aturan normalisasi. Model REA merupakan pengembangan dari Model E-R. Model REA menerapkan prinsip give-to-get, sehingga mempermudah pembentukan model data. Dalam tulisan ini dibahas Logical dan Physical View data, schema, Model REA, menyusun diagram REA, tahap-tahap perancangan database dan peran serta akuntan, serta cara mengimplementasikan Model REA ke database relasional, khususnya pada siklus pendapatan. Kata kunci: Database, Model E-R, Model REA, SIA, Siklus Pendapatan
RANCANG SISTEM INFORMASI PERSEDIAAN BAHAN BAKU TERKOMPUTERISASI PT. KPL Yuliana, Oviliani Yenty; Octavia, Tanti
Jurnal Manajemen dan Kewirausahaan Vol 3, No 1 (2001): MARCH 2001
Publisher : Institute of Research and Community Outreach - Petra Christian University

Show Abstract | Original Source | Check in Google Scholar | Full PDF (375.14 KB)

Abstract

This study was done at PT. KPL which produces plastic goods. In order to compete with other plastic goods manufacturers during the economic crisis, PT. KPL must be able to minimize production costs. One of the ways is to reduce raw materials cost. The results were obtained with production demand forecasting, using the Holt-Winter method; the Moving Average with Index Seasonal method; the Single Exponential Smoothing Method; the Double Exponential Smoothing method; and the Multiplicative Winter method. Based on economic order quantity, the minimum total inventory cost was obtained. Economic order quantity was entered into Material Requirement Planning (MRP). Relevant, accurate, and timely information is needed for planning and controlling raw material inventory. For that purpuse, a computerized conceptual information system for raw material inventory was designed. Abstract in Bahasa Indonesia : Studi Kasus dilakukan pada PT. KPL yang bergerak dibidang pembuatan barang-barang plastik. Agar PT. KPL dapat bersaing dengan perusahaan sejenis dimasa krisis ekonomi. PT. KPL harus mampu menekan biaya produksi seminimal mungkin. Salah satu cara dengan menekan biaya persediaan bahan baku. Dari hasil penelitian diperoleh ramalan kebutuhan produk, yang diolah menggunakan metode: Holt Winter, Moving Average With Index Seasonal, Single Exponential Smoothing, Double Exponential Smoothing, Multiplicative Winter. Berdasarkan Economic Order Quantity dihasilkan total biaya persediaan yang minimum. Jumlah pemesanan yang ekonomis dimasukkan kedalam Material Requirement Planning (MRP). Informasi yang cepat, tepat, dan akurat diperlukan dalam merencanakan dan mengendalikan persediaan bahan baku. Untuk itu dirancang sistem informasi tersediaan bahan baku terkomputerisasi secara konsep. Kata kunci: ramalan kebutuhan produk, EOQ, MRP, sistem informasi
QUERY BY EXAMPLE: ALTERNATIF AUDIT TOOLS UNTUK MENUNJANG PENUGASAN AUDITOR DALAM PENGUJIAN SUBSTANTIF Yuliana, Oviliani Yenty; Tarigan, Josua
Media Riset Akuntansi, Auditing & Informasi Vol 8, No 2 (2008): Agustus
Publisher : LEMBAGA PENERBIT FAKULTAS EKONOMI DAN BISNIS UNIVERSITAS TRISAKTI

Show Abstract | Original Source | Check in Google Scholar | Full PDF (1769.884 KB)

Abstract

Along with the growth of the information technology (IT), several audit tools are developed to help the auditorto do theirduties efficiently and effectively. ACL and IDEA are the popularexamples of the audit tools nowadays. However; for small and medium public accountants (KAP) and aUsaha Kecil Menengahn (UKM) business sectors, ACL and IDEA audit tools pricing are very expensive. Moreover, based on preliminary survey, many companies have already recorded theirtransactions into a database. It motivates a study to optimize the database features that has been owned by KAP and UKM as audit tools. Therefore the companies can reduce theirinvestment. In this paper, researchers propose the use of Query By Example" (QBE) in Microsoft Access database as the audit tools. QBE is expected as one of alternative of audit tools that can assist auditor task, especially in substantive test.Key words : Information Technology (IT), audit tools, Query By Example (QBE)
PENDEKATAN MODEL MATEMATIS UNTUK MENENTUKAN PERSENTASE MARKUP HARGA JUAL PRODUK Yuliana, Oviliani Yenty; Wahyudi, Yohan; Halim, Siana
Jurnal Teknik Industri Vol 4, No 2 (2002): DECEMBER 2002
Publisher : Institute of Research and Community Outreach - Petra Christian University

Show Abstract | Original Source | Check in Google Scholar | Full PDF (1074.253 KB)

Abstract

The purpose of this research is to design Mathematical models that can determine the selling volume as an alternative to improve the markup percentage. Mathematical models was designed with double regression statistic. Selling volume is a function of markup, market condition, and substitute condition variables. The designed Mathematical model has fulfilled by the test of: error upon assumption, accurate model, validation model, and multi collinear problem. The Mathematical model has applied in application program with expectation that the application program can give: (1) alternative to decide percentage markup for user, (2) Illustration of gross profit estimation that will be achieve for selected percentage markup, (3) Illustration of estimation percentage of the units sold that will be achieve for selected percentage markup, and (4) Illustration of total net income before tax will get for specific period. Abstract in Bahasa Indonesia : Penelitian ini bertujuan untuk merancang model Matematis guna menetapkan volume penjualan, sebagai alternatif untuk menentukan persentase markup harga jual produk. Model Matematis dirancang menggunakan Statistik Regresi Berganda. Volume penjualan merupakan fungsi dari variabel markup, kondisi pasar, dan kondisi pengganti. Model Matematis yang dirancang sudah memenuhi uji: asumsi atas error, akurasi model, validasi model, dan masalah multikolinearitas. Rancangan model Matematis tersebut diterapkan dalam program aplikasi dengan harapan dapat memberi: (1) alternatif bagi pengguna mengenai berapa besar markup yang sebaiknya ditetapkan, (2) gambaran perkiraan laba kotor yang akan diperoleh setiap pemilihan markup, (3) gambaran perkiraan persentase unit yang terjual setiap pemilihan markup, dan (4) gambaran total laba kotor sebelum pajak yang dapat diperoleh pada periode yang bersangkutan. Kata kunci: model Matematis, aplikasi program, volume penjualan, markup, laba kotor.