E-Certificate Information System Data Warehouse Topology: Architecture, Mathematical Models, and Optimization Strategies

Xudoyberdiyev, Rahmatillo, Egamberdiyev, Nodir, Yadgorov, Feruz

Al-Farg'oniy avlodlari · 2026-yil

Annotatsiya

This article is devoted to a comprehensive analysis of the database architecture of the state information system “E-Shahodatnoma”. The study studied the performance characteristics of the Microsoft SQL Server 2022 platform in a high-load environment, the relational topology and mathematical models of the data warehouse. The system contains a total database of 1.74 TB and more than 71 million records. During the study, the Hub-and-Spoke topology model, normalization levels (1NF, 2NF, 3NF), Foreign Key relationships and indexing strategies were practically analyzed.

Maqola ma’lumotlari
MualliflarXudoyberdiyev, Rahmatillo, Egamberdiyev, Nodir, Yadgorov, Feruz
JurnalAl-Farg'oniy avlodlari
Nashr sanasi2026-04-30
Son2
Betlar78-85
TilRus

Kalit so‘zlar

топология хранилища данных, реляционная модель, архитектура Hub-and-Spoke, высоконагруженные системы, нормализация, денормализация, показатели производительности, распределение Парето, коэффициент Джини, транзакционные системы., ma’lumotlar ombori topologiyasi, relatsion model, Hub-and-Spoke arxitekturasi, yuqori yuklamali tizimlar, normalizatsiya, denormalizatsiya, performance metrikalari, Pareto taqsimoti, Gini koeffitsiyenti, tranzaksion tizimlar., data warehouse topology, relational model, Hub-and-Spoke architecture, high-performance systems, normalization, denormalization, performance metrics, Pareto distribution, Gini coefficient, transactional systems.

Ilmiy soha

Al-Farg'oniy avlodlari jurnalidan boshqa maqolalar

Al-Farg'oniy avlodlari — barcha maqolalar