Claim Missing Document
Check
Articles

Found 3 Documents
Search
Journal : International Journal of Engineering and Emerging Technology

Middleware ETL with CDC based on Event Driven Programming I Gede Adnyana; Made Sudarma; Wayan Gede Ariastina
International Journal of Engineering and Emerging Technology Vol 3 No 2 (2018): July - December
Publisher : Doctorate Program of Engineering Science, Faculty of Engineering, Udayana University

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

To achieve the real time data warehouse is strongly influenced by the process in the data warehouse known as Extract, Tranform, Loading (ETL). One way to optimize the ETL process is processing only data that undergoes changes on the On Line Transaction Processing (OLTP) system. This technique is known as Change Data Capture (CDC) which is designed to maximize the efficiency of the ETL process. In this research middleware was built as a place where the ETL process will be carried out, transaction data from the OLTP system will be captured and sent directly to the middleware for further processing. The method used to capture changes in OLTP systems is Change Data Capture (CDC) based on Event Driven Programming, where this technique relies on events that occur in OLTP in capturing data changes. Functional testing is done by making a simulation of the insert and update processes in test applications namely OLTP CRM system.The results of the research obtained are (1) Change Data Capture (CDC) based on Event Driven Programming can capture changes in data that occur in OLTP CRM database;(2) ETL process to load data from Normalized Data Store (NDS ) to data warehouse with Timestamp technique can load data that only undergoes changes that are processed to be loaded in Data Warehouse;(3) An increase in the amount of data that is processed has an effect on increasing processing time. Other factors that affect the value of process time are execution plan and cache memory
Effect of Solvents on Natural Dyes Extraction from Mangosteen Waste for Dye Sensitized Solar Cell Application I Nyoman Setiawan; Ida Ayu Dwi Giriantari; Wayan Gede Ariastina; Ida Bagus Alit Swamardika
International Journal of Engineering and Emerging Technology Vol 3 No 2 (2018): July - December
Publisher : Doctorate Program of Engineering Science, Faculty of Engineering, Udayana University

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

Natural dyes are economically and environmentally superior to ruthenium-based dyes because they are cheap and non-toxic. In this study, natural dyes were extracted from mangosteen peel waste. Color extraction was carried out with three types of solvents (distilled water, methanol and ethanol) which had been acidified with 10% citric acid and with a ratio of material: solvent (1: 4, 1: 6, 1: 8 w / v). The photochemical properties are studied by UV-Vis spectrophotometer and FTIR spectroscopy. The absorption peak of the three types of solvent occurs at different wavelengths. The presence of carbonyl (C = O) and hydroxyl (OH) groups contained in anthocyanins can attach coloring to the surface of TiO2. Ethanol solvents with a ratio of 1: 8 produce the lowest photon energy at wavelength and absorption coefficient of 539.00 nm and 2,008 km-1 respectively. The lowest band gap of the dye helps electrons move rapidly from the valence band to the conduction band and only requires less energy for electron recombination which will increase the performance of the DSSC.
A Placement and Sizing of Distributed Generation Based on Combines Sensitivity Factor and Particle Swarm Optimization: A Case Study in Bali’s Power Transmission Networks Ngakan Putu Satrya Utama; Rukmi Sari Hartati; Wayan Gede Ariastina; Ida Bagus Alit Swamardika
International Journal of Engineering and Emerging Technology Vol 2 No 2 (2017): July - December
Publisher : Doctorate Program of Engineering Science, Faculty of Engineering, Udayana University

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

Although many methods for optimizing DGplacement and its size in a network with the target of reducingsystem power losses and voltage profile have already beencommended, they still lack from several weaknesses. As a resultmuch can be done about to happen with new algorithms. Theproposed algorithms commonly have stressed their formulationson real power losses only and ignored the reactive power losses.Power systems reactive power injection plays an important rolein voltage stability control, thus the reactive power losses need tobe incorporated in optimizing DG allocation considering theirvoltage profile improvement. Whereas Particle SwarmOptimization (PSO) approach was proposed for finding theoptimal size of DG. This study work intended to apply both realand reactive power flow, power loss sensitivity factors and PSOmethod in finding the candidate buses for DG placement and itssize on Bali’s 150 kV transmission networks. The experimentalresults show that the proposed algorithm is indeed capable ofobtaining a good quality solution efficiently
Co-Authors A I Weking A. A. Ngurah Bagus Budi Nathawibawa A. A. T. B. Artawan A. Ibi Weking A.A Ngurah Amrita A.A. Gede Ari Pawitra Putra A.I. Weking AA. M Pemayun Abdul Latif Abid Surya Bimantara Agus Selamet Duniaji Awgustus Patandean Bawa Adiputra C. G. I. Partha, C. G. I. C. G. Indra Partha D.Y. Manurung Derren, M. Dewa ayu Nancy Cahyani Dharmawan, N. B. Dony Septa Primadita DPD Suparyawan Gede Endrawadi Gede Ogiana Gede Sukadarmika Govinda Riawan Haekal, Muhammad Hasan Dedy Sudono I Dewa Gede Wisnu Agung Bayuna I G.N. Evan Aditya Pramana I Gede Adnyana I Gede Budhi Arsana I GN Dion Adiputra I Gusti Ngurah Priambadi I Kadek Hendy Wijaya I Kadek Krisna Yoga I Ketut Citra Adi Putra I M Suartika I M.T. Sismantara I N Satya Kumara I Nyoman Budiastra I Nyoman Oksa Winanta I Nyoman Setiawan I Nyoman Suprapta Winaya I P. A. Edi Pramana I Putu Arsikaputra I Putu Eka April Yanto I W A Wijaya I W A WINARTA I W Rinas I W.Y.M. Wiguna I Wayan Arta Saputra I Wayan Arta Wijaya I Wayan Sukerayasa I. N. S. Kumara I. W. Sukerayasa, I. W. I.B.G. Manuaba I.G.W. Artana I.N.S. Kumara I.P.H. Wahyudi I.W. Yudi Martha Wiguna Ida Ayu Dwi Giriantari Ida Bagus A. Swamardika Ida Bagus Bawa Adiputra Indra Baskara INS Kumara INS Kumara Intan Aprilia Medina IW Gunarta J. Pangaribuan Julius Mahendra Sihombing Juniastra Gina K A Kartika Sari Kadek Ary Budi Permana Kadek Hari Merta Kadek Sumariana Kenny Angel Manik Ketut Vidhia Kumara Komang Oka Saputra Kumara, I. N. S. l Gusti Ngurah Janardana Leba, G. I. M. M.K. Huda M.T. S.T. I Wayan Sutaya . Made Sudarma mahadi putra Michael Candra Santoso Muhammad Fauzi Muhammad Hari Wijaya Muhammad Malik Al Falah N. A. Kartono N. B. Dharmawan N. Nuswantara N.W. Budiantari Ngakan Putu Satriya Utama Ngakan Putu Satrya Utama Ni Made Ary Esta Dewi Wirastuti Ni Made Ary Esta Dewi Wirastuti NM Karmiathi Norberto Soares Nyoman Gede Yudiarta Ontoseno Penangsang Pande K. B. Sutawan Putu Martha Risnadinata R.S. Hartati Rukmi Sari Hartati Sari, N. P. A. R. Sembiring, Rinawati Setiawan, I N. Setiawan, I. N. Sinaga, P. M. Solly Aryza Suriana, I Wayan Surung Rafael Sihaloho Virgunia, D. A. Yohana Fransisca Sarumpaet