Increasing performance in large capacity databases

By, Eliona SKENDERAJ

Abstract

The daily activity of companies is closely related to data. Databases are growing and demand for data per unit of time is increasing and high performance is required to meet this demand. Big data is a collection of large volumes of complex data that exceeds the processing capacity of traditional database architecture. They are also so difficult to administer and organize, and for this reason, the best aim is to find the best and most effective solution. The purpose of this work is to identify the main performance issues that appear while working with databases with large capacities and to propose solutions for such cases. DBMS systems have implemented techniques and tools that monitor data activity and help to improve performance. One of the main directions that focuses on the work of the topic is that of writing requests “query design” in such a way that regardless of the size of the data required, these requests are not delayed and fail. The goal is that, regardless of the proposed writing method, it provides recommendations that will be practically applied in a data warehouse system. In this way, the benefit in performance will be compared. In the end of this paper, it was possible to find very effective and clear solutions.
Key words: Database, SQL, query, performance, large capacities.