Adi Handika
Universitas Islam Negeri K.H. Abdurrahman Wahid Pekalongan

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

Found 2 Documents
Search

QUERY OPTIMIZATION ON SEMI STRUCTURED MYSQL RETAIL DATA USING GENERATED COLUMNS Adi Handika; Muqtafiy Muhammad; Muhammad Azka Bani Shalih; Nabil Yudha Syahputra; Imam Prayogo Pujiono
Jurnal Manajemen Informatika dan Sistem Informasi Vol. 9 No. 2 (2026): MISI Juni 2026
Publisher : LPPM STMIK Lombok

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.36595/misi.v9i2.2058

Abstract

This study compares query performance among three data storage models in MySQL: the relational model (retail_relational), the unoptimized JSON model (retail_json_raw), and the JSON model with generated columns and indexes (retail_json_gc). The dataset used is a public retail transaction dataset containing more than one million records with eight attributes including Invoice, StockCode, Description, Quantity, InvoiceDate, Price, Customer ID, and Country. Four query scenarios were tested: filtering by country, searching by stock code, filtering by price range, and grouping by country for revenue aggregation. Each query was executed ten times and analyzed using EXPLAIN to observe the execution plan. Results show that the JSON_GC model consistently achieves the fastest execution time across all scenarios. For the stock code filter query, JSON_GC achieves an average of 0.006 seconds compared to 1.577 seconds for the relational model and 1.950 seconds for JSON_Raw. For the GROUP BY aggregation query, JSON_GC requires only 0.002 seconds compared to more than 1.6 seconds for both other models. This performance difference is due to generated columns supporting index scans and covering indexes, preventing MySQL from performing full table scans. The JSON_Raw model is consistently the slowest due to the overhead of JSON_EXTRACT functions and the inability to be directly indexed. This study concludes that generated columns are a highly effective optimization strategy for managing semi structured JSON based data in MySQL.
When ESG Meets Foreign Capital: Market Valuation Evidence from Indonesia’s LQ45 Adi Handika
Jurnal Ilmiah Wahana Akuntansi Vol. 21 No. 1 (2026): Jurnal Ilmiah Wahana Akuntansi
Publisher : Fakultas Ekonomi dan Bisnis dan LPPM Universitas Negeri Jakarta

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.21009/wahana.21.014

Abstract

The relationship between Environmental, Social, and Governance performance and firm value remained theoretically contested in emerging capital markets, where investor heterogeneity and limited sustainability awareness complicated the valuation mechanism. This study examined whether Environmental, Social, and Governance risk exposure, as measured by the Sustainalytics Environmental, Social, and Governance Risk Score, where lower scores indicated better Environmental, Social, and Governance management, was significantly associated with firm valuation and whether foreign investor participation conditionally moderated this relationship among firms in the LQ45 index on the Indonesia Stock Exchange. Using an unbalanced panel of 73 LQ45 firms over 2020 to 2026 with 527 to 540 firm year observations, this study employed fixed effect panel regression with heteroskedasticity robust standard errors. An interaction model incorporating mean centred Environmental, Social, and Governance scores and net foreign investor flows was estimated, while logarithmic transformation was applied to address distributional skewness. The results showed that the Environmental, Social, and Governance Risk Score exhibited a positive and statistically significant effect on firm valuation at the 5 percent significance level. Higher scores, which denoted greater unmanaged Environmental, Social, and Governance risk, reflected the complex valuation dynamics of Indonesia’s resource intensive LQ45 composition. The interaction between Environmental, Social, and Governance Risk Score and foreign investor participation was also positive and highly significant, confirming that foreign investors amplified market sensitivity toward Environmental, Social, and Governance related information. These findings indicated that Environmental, Social, and Governance based market valuation in Indonesia was conditional rather than universal. Relevansi informasi Environmental, Social, and Governance terhadap valuasi perusahaan masih diperdebatkan di pasar modal negara berkembang. Penelitian ini menguji hubungan antara ESG Risk Score dan nilai perusahaan serta menilai apakah transaksi Net Foreign memoderasi hubungan tersebut pada perusahaan LQ45 di Bursa Efek Indonesia. Panel tidak seimbang mencakup 540 observasi perusahaan periode dari 73 konstituen dalam dua belas jendela observasi LQ45, mulai Februari sampai Juli 2020 hingga Agustus 2025 sampai Januari 2026, sedangkan regresi utama menggunakan 527 observasi dari 71 perusahaan. Model firm fixed effects utama menunjukkan koefisien ESG Risk Score dan interaksi ESG Risk Score × Net Foreign yang positif, tetapi koefisien langsung ESG menjadi tidak signifikan setelah efek waktu dimasukkan dan interaksi tertinggal tidak signifikan. Temuan menunjukkan bahwa penilaian risiko ESG bersifat kontemporer dan bergantung pada partisipasi perdagangan asing, periode pasar, dan lingkungan sektoral, bukan merupakan premi valuasi yang bersifat universal.