Журнал «Современная Наука»

Russian (CIS)English (United Kingdom)
 MOSCOW +7(495)-142-86-81

QUERY OPTIMIZATION IN RELATIONAL DATABASES

Conde Abdul Karim  (PhD student, Department of Management and Informatics in Technical Systems, Moscow State Technological University "STANKIN", Russian Federation, Moscow )

This article discusses query optimization technologies in relational databases. The purpose of this article is to optimize the query structure in relational databases when processing large amounts of information. As a result of the work, the main provisions were developed in the form of the results of the analysis of technologies for improving database performance using indexing technologies, methods for optimizing the database structure to improve performance, using the identification of bottlenecks and problematic queries, as well as monitoring and testing database performance.

Keywords:query optimization, relational database, indexing, stored procedures, database performance monitoring
 

Read the full article …

Citation link:
Conde A. K. QUERY OPTIMIZATION IN RELATIONAL DATABASES // Современная наука: актуальные проблемы теории и практики. Серия: Естественные и Технические Науки. -2024. -№07. -С. 103-107 DOI 10.37882/2223-2966.2024.7.22
LEGAL INFORMATION:
Reproduction of materials is permitted only for non-commercial purposes with reference to the original publication. Protected by the laws of the Russian Federation. Any violations of the law are prosecuted.
© ООО "Научные технологии"

Terms Publications

Issues of the journals (Archive)

ECONOMICS AND LAW
HUMANITIES
NATURAL AND TECHNICAL SCIENCES
COGNITION

Серия - Natural and Technical Sciences