Comparatıve Performance Analysıs of Data Storage Systems (Json, Sqlıte, Postgresql) in a Log Analysıs Applıcatıon
Session
Computer Science and Communication Engineering
Description
In this thesis, a comparative performance analysis of different data storage systems, namely: JSON, SQLite, and PostgreSQL, has been conducted within the framework of a log analysis application. For each technology—JSON, SQLite, and PostgreSQL—the analysis will follow an identical structure. Initially, the history and the philosophy behind their creation will be examined. Subsequently, the architecture and key technical characteristics that influence performance will be detailed. The main objective of this study is to evaluate the efficiency, response time, resource utilization, and the degree of scalability of each system in various processes of log data management and analysis. The use of different performance testing and analysis methodologies was essential to obtain accurate insights into the advantages and disadvantages of each system in the context of real-world applications. This approach will build the theoretical foundation for the empirical comparison that will follow in the subsequent chapters. The results of the study have shown significant differences in performance and efficiency, aiding in the determination of the most suitable data storage system choice depending on the specific requirements of the log analysis application. This study contributes to the further understanding of the decision-making parameters related to the selection of the appropriate database architecture for similar projects.
Keywords:
Performance Analysis, Data Storage System, Log Analysis
Proceedings Editor
Edmond Hajrizi
ISBN
978-9951-982-41-2
Location
UBT Kampus, Lipjan
Start Date
25-10-2025 9:00 AM
End Date
26-10-2025 6:00 PM
DOI
10.33107/ubt-ic.2025.75
Recommended Citation
Alushaj, Edison and Novoberdaliu, Alma, "Comparatıve Performance Analysıs of Data Storage Systems (Json, Sqlıte, Postgresql) in a Log Analysıs Applıcatıon" (2025). UBT International Conference. 7.
https://knowledgecenter.ubt-uni.net/conference/2025UBTIC/CS/7
Comparatıve Performance Analysıs of Data Storage Systems (Json, Sqlıte, Postgresql) in a Log Analysıs Applıcatıon
UBT Kampus, Lipjan
In this thesis, a comparative performance analysis of different data storage systems, namely: JSON, SQLite, and PostgreSQL, has been conducted within the framework of a log analysis application. For each technology—JSON, SQLite, and PostgreSQL—the analysis will follow an identical structure. Initially, the history and the philosophy behind their creation will be examined. Subsequently, the architecture and key technical characteristics that influence performance will be detailed. The main objective of this study is to evaluate the efficiency, response time, resource utilization, and the degree of scalability of each system in various processes of log data management and analysis. The use of different performance testing and analysis methodologies was essential to obtain accurate insights into the advantages and disadvantages of each system in the context of real-world applications. This approach will build the theoretical foundation for the empirical comparison that will follow in the subsequent chapters. The results of the study have shown significant differences in performance and efficiency, aiding in the determination of the most suitable data storage system choice depending on the specific requirements of the log analysis application. This study contributes to the further understanding of the decision-making parameters related to the selection of the appropriate database architecture for similar projects.