Article Per Year (5 Year)
p-Index From 2021 - 2026
6.306
P-Index
This Author published in this journals
All Journal Jurnal Ilmu Komputer Jurnal Pendidikan Teknologi dan Kejuruan Semantik Syntax Jurnal Informatika Scan : Jurnal Teknologi Informasi dan Komunikasi Telematika : Jurnal Informatika dan Teknologi Informasi Jurnal Teknologi Informasi dan Ilmu Komputer Transformasi: Jurnal Pengabdian Masyarakat Jurnal Informatika dan Teknik Elektro Terapan CESS (Journal of Computer Engineering, System and Science) JOIV : International Journal on Informatics Visualization JIKO (Jurnal Informatika dan Komputer) JUTIK : Jurnal Teknologi Informasi dan Komputer Jurnal Sains dan Informatika SINTECH (Science and Information Technology) Journal Jurnal RESISTOR (Rekayasa Sistem Komputer) WIDYA LAKSANA Jurnal Nasional Pendidikan Teknik Informatika (JANAPATI) JIPI (Jurnal Ilmiah Penelitian dan Pembelajaran Informatika) Jurnal Teknologi Terpadu Antivirus : Jurnal Ilmiah Teknik Informatika Jurnal Mantik Jusikom: Jurnal Sistem Informasi Ilmu Komputer JATI (Jurnal Mahasiswa Teknik Informatika) CICES (Cyberpreneurship Innovative and Creative Exact and Social Science) Gestalt : Jurnal Desain Komunikasi Visual Jifosi International Journal Of Computer, Network Security and Information System (IJCONSIST) Abdimas Altruis: Jurnal Pengabdian Kepada Masyarakat Jurnal WIDYA LAKSMI (Jurnal Pengabdian Kepada Masyarakat) Jurnal Informatika Teknologi dan Sains (Jinteks) Jurnal Ilmiah Edutic : Pendidikan dan Informatika Jurnal Krisnadana Jurnal Ilmiah Teknik Informatika dan Komunikasi Harmoni: Jurnal Ilmu Komunikasi Dan Sosial Jurnal Krisnadana Jurnal Indonesia : Manajemen Informatika dan Komunikasi Kesatria : Jurnal Penerapan Sistem Informasi (Komputer dan Manajemen) Jupiter: Publikasi Ilmu Keteknikan Industri, Teknik Elektro dan Informatika Modem : Jurnal Informatika dan Sains Teknologi KOMET
Made Hanindia Prami Swari
Informatika, Universitas Pembangunan Nasional Veteran Jawa Timur
Religion Aerospace Engineering Agriculture, Biological Sciences & Forestry Humanities Automotive Engineering Chemical Engineering, Chemistry & Bioengineering Civil Engineering, Building, Construction & Architecture Computer Science & IT Control & Systems Engineering Decision Sciences, Operations Research & Management Economics, Econometrics & Finance Education Electrical & Electronics Engineering Energy Engineering Environmental Science Languange, Linguistic, Communication & Media Law, Crime, Criminology & Criminal Justice Library & Information Science Mathematics Public Health Social Sciences Other

Published : 64 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search
Journal : Jurnal Ilmu Komputer

 1 
ANALISIS FRAGMENTASI TABEL SECARA VERTIKAL MENGGUNAKAN ALGORITMA BOND ENERGY DALAM HUBUNGANNYA DENGAN KECEPATAN EKSEKUSI QUERY Made Hanindia Prami Swari; Ngurah Agus Sanjaya ER
Jurnal Ilmu Komputer Vol. 5, No. 1 April 2012
Publisher : Informatics Department, Faculty of Mathematics and Natural Sciences, Udayana University

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

Abstract

The required time to run a query on a database which possesses a large number of attributes and rows highly depends on the number of attributes accessed. An optimal query will only access necessary attributes. A vertical fragmentation of a table helps in isolating the frequently accessed attributes with those which are less frequently used.In this research, we develop an application to help the comparison of query execution time on a normal and vertically fragmented table. We use a Bond Energy algorithm to form the table’s vertical fragmentation. In this algorithm, the fragmentation process has to fulfill the completeness and disjointness conditions.We perform and test this application by using 40 queries from “Sistem Informasi Perencanaan Universitas Udayana”. Our test results show that a vertical fragmentation using Bond Energy algorithm increases the speed of query execution on the following: queries which access only several attributes from a table and queries with arithmetic operations such as sum or average. For insert and update queries, vertical fragmentation has no significant impact.
Co-Authors Agung Mustika Rizki, Agung Mustika Aileena Solicitor Costa Rica El Chidtian Akbar, Fawwaz Ali Andreas Nugroho Sihananto Andreas Nugroho Sihanto Anggraini Puspita Sari Ani Dijah Rahajoe Arifan, Miftakhul Askara Raditya Aurora Prameswaty, Almira Azhari SN Basuki Rahmat Damayanti, Alfina Diyasa, I Gede Susrama Mas Dwi Wahyuningtyas Eva Yulia Puspaningrum Faisal Muttaqin Faisal Muttaqin Fetty Tri Anggraeny Firmansyah Firdaus Anhar Firza Prima Aditiawan Gilang Gema Ramadhan Handika, I Putu Susila Henni Endah Wahanani Hutagaol, LeonHoss I Gede Winaya I Gusti Ngurah Agung Mahendra I Kadek Susila Satwika I Kadek Susila Satwika I Nyoman Sujana I Putu Susila Handika I Putu Susila Handika I WAYAN SUDIARSA Ika Nur Habibah Jannatul Firdaus Joni Bastian Joni Bastian Julastri, Bregsi Atingsari Kartika Maulida Hindrayani Kevin Santosa, Mochammad Lintang Perdana Rochmat Sugiharto Mandyartha, Eka Prakarsa Martoni Martoni Maulana, Hendra Muhammad Farhan Maulana Muhammad Hakam Fardana Muhammad Rifki Bahrul Ulum Muhammad Syafril Hidayat Muttaqin, Faisal Muttaqin, Faisal Nabila Rizky Amali Putri Ngurah Agus Sanjaya ER Nine Alvariqati Varqa Ansori Nugroho Sihananto, Anderas Permana, Eriko Indra Phitria, Shaum Pratama Wirya Atmaja Pratiwi, Nisa Prismahardi Aji Riyantoko Putra, Chrystia Aji Rabbani, Rafi Rahel Widya Arianti Rahel Widya Arianti Rahmadsyach, Mochammad Taufiq Retno Mumpuni Risnaldy Novendra Irawan Rizki, Agung Mustika Satria, Vinza Hedi Satwika, I Kadek Susila Sugiarto Sukandar, Ivan Christopher Syaifullah Jauharis Saputra, Wahyu Tasya Ardhian Nisaa' Tentra Olivia Tresna Maulana Fahrudin Tresna Maulana Fahrudin Ulummuddin, Ikhya Wahyu Syaifullah Jauharis Saputra Wariyanti Nugroho Putri Wayan Gede Suka Parwita Welda Wirya Atmaja, Pratama Yuniar Purbasari, Intan