Veritabanı Tasarımının Yazılım Performansına Etkisi: Normalizasyona karşı Denormalizasyon. Uzun, E., Buluş, H., N., & Erdoğan, C. Süleyman Demirel Üniversitesi Fen Bilimleri Enstitüsü Dergisi, 22(2):887, 2, 2018.
Veritabanı Tasarımının Yazılım Performansına Etkisi: Normalizasyona karşı Denormalizasyon [link]Website  doi  abstract   bibtex   9 downloads  
One of the most important factors affecting software performance is the improvements that can be made in database design. The normalization process, which is based on the relational database theory, is often used in database design. However, as the amount of data increases, performance problems arise due to the normalization process. In order to overcome the performance problems, denormalization without theoretical process is utilized. In this study, a performance enhancement database design is introduced in a survey application and the performance improvements of three different relational database management systems including MySQL, PostgreSQL and Oracle are examined. In addition, it is explained through CAP theory when to pass to NSQL, one of today's popular database systems, and the place of normalization and denormalization processes in this theory.
@article{
 title = {Veritabanı Tasarımının Yazılım Performansına Etkisi: Normalizasyona karşı Denormalizasyon},
 type = {article},
 year = {2018},
 keywords = {CAP theorem,Database design,Denormalization,Indexing,Normalization,Software performance},
 pages = {887},
 volume = {22},
 websites = {https://dergipark.org.tr/tr/download/article-file/529039},
 month = {2},
 day = {16},
 id = {2d4981c0-2c0a-31a6-a8b9-13cd90cfd0a9},
 created = {2018-06-05T12:53:51.315Z},
 file_attached = {false},
 profile_id = {37fa15c3-e5d0-3212-8e18-e4c72814fd47},
 last_modified = {2023-08-22T20:52:46.233Z},
 read = {false},
 starred = {false},
 authored = {true},
 confirmed = {true},
 hidden = {false},
 citation_key = {Uzun2018_SDFBD},
 folder_uuids = {bc101896-c263-4799-878a-a9fddc1af501},
 private_publication = {false},
 abstract = {One of the most important factors affecting software performance is the improvements that can be made in database design. The normalization process, which is based on the relational database theory, is often used in database design. However, as the amount of data increases, performance problems arise due to the normalization process. In order to overcome the performance problems, denormalization without theoretical process is utilized. In this study, a performance enhancement database design is introduced in a survey application and the performance improvements of three different relational database management systems including MySQL, PostgreSQL and Oracle are examined. In addition, it is explained through CAP theory when to pass to NSQL, one of today's popular database systems, and the place of normalization and denormalization processes in this theory.},
 bibtype = {article},
 author = {Uzun, Erdinç and Buluş, Halil Nusret and Erdoğan, Cihat},
 doi = {10.19113/sdufbed.02548},
 journal = {Süleyman Demirel Üniversitesi Fen Bilimleri Enstitüsü Dergisi},
 number = {2}
}

Downloads: 9