Journal of Intelligent Software Systems
Vol 1, No 2 (2022): Desember

Query Execution Performance Analysis of Column-Oriented Database in Dashboard

Bagas Triaji (UTDI)
Widyastuti Andriyani (UTDI)
Totok Suprawoto (UTDI)
Muhammad Agung Nugroho (UTDI)
Rikie Kartadie (UTDI)

Article Info

Publish Date
31 Dec 2022

Abstract

In making reports or dashboards from operational data, problems often occur in the query process with low speed in responding to an output, causing the server to experience overload. This condition often occurs in companies or higher education organizations in managing academic data. This condition can be improved by optimizing the database server by integrating relational databases with column-oriented databases to speed up query responses and save development costs. Based on the experiments that had been carried out, column-oriented has succeeded in optimizing with a significant difference in query execution time and the server does not crash.

Copyrights © 2022




Citation Download
RIS
EndNote, Reference Manager, ProCite
BibTex
Latex, Jabref
Full PDF
649.54 KB
Original Source
Download Original
Google Scholar
Check in Google Scholar
Journal Info
Journal of Intelligent Software Systems
Website

Abbrev

JISS

Publisher

Universitas Teknologi Digital Indonesia

Subject

Computer Science & IT

Description

Journal of Intelligent Software Systems (JISS) is open access, peer-reviewed international journal that will consider any original scientific article that expands the field of Intelligent Software Systems. The journal publishes articles in all Intelligent Software Systems specialities of interest to ...