Stručni rad
https://doi.org/10.31784/zvr.11.1.16
SQL query tuning and optimization: an example using AWS
Jasmina Diković
; Veleučilište u Rijeci, Rijeka, Hrvatska
Ida Panev
orcid.org/0000-0002-4815-9358
; Veleučilište u Rijeci, Rijeka, Hrvatska
Sažetak
Since the total amount of created data is increasing every day, requirements related to computing capacity needed to process data are also growing. Cloud computing is becoming a rapidly growing resource for data processing. Cloud usage is typically based on a pay-as-you-go model, which is the reason why different optimization possibilities represent a significant factor in performance and cost management. This paper describes and presents an example with various actions that can be performed for the purpose of optimizing data and SQL queries when using cloud services on big data.
Described possibilities include choosing the appropriate data format or compression algorithm, but also other characteristics important for cloud environment, such as data partitioning and planning SQL queries structure. Presented practical example includes several SQL queries performed on differently processed data to compare performance against applied procedures and query characteristics. Based on the described features and obtained results, we can conclude there are multiple possibilities to optimize the implementation of SQL queries in cloud services. The importance of these actions arises from their contribution to the efficient and cost-effective usage of cloud services for big data.
Ključne riječi
SQL; optimization; big data; cloud computing; Amazon Web Services
Hrčak ID:
302884
URI
Datum izdavanja:
31.5.2023.
Posjeta: 392 *