Advanced Query Optimization Interface (AQOI) for Oracle DBMS
Year: 2024
Type: article
Abstract: This publication presents the design and implementation of the Advanced Query Optimization Interface (AQOI), a software tool developed to assist database administrators in writing and optimizing complex SQL queries for Oracle DBMS. The system provides a user-friendly interface that analyzes query performance, identifies inefficiencies, and suggests optimization improvements. Built with React, HTML5, CSS3, and MySQL integration, AQOI enhances query efficiency by displaying execution times and pinpointing poorly optimized statements. The project aims to improve database performance, reduce resource consumption, and support decision-making in modern, data-intensive environments.
Author: Noupouwo Dongmo, Stephane Merci
Language: English
Subfield: Computer Networks and Communications
Field: Computer Science
Domain: Physical Sciences
Open Access status: green
OpenAlex ID: W7092513450
FWCI:
Cites:
Cited by:
Related to: