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.
| Mualliflar | Xudoyberdiyev, Rahmatillo, Egamberdiyev, Nodir, Yadgorov, Feruz |
|---|---|
| Jurnal | Al-Farg'oniy avlodlari |
| Nashriyot | ТАТУ Фарғона филиали |
| ISSN | 2181-4252 |
| Nashr sanasi | 2026-04-30 |
| Son | 2 |
| Betlar | 78-85 |
| Til | Ingliz |
| Ilmiy soha | Texnika |
| Indeksga qo‘shilgan | 2026-08-26 |
топология хранилища данных, реляционная модель, архитектура 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.
| APA | Xudoyberdiyev, Rahmatillo, Egamberdiyev, Nodir, & Yadgorov, Feruz (2026). E-Certificate Information System Data Warehouse Topology: Architecture, Mathematical Models, and Optimization Strategies. Al-Farg'oniy avlodlari, (2), 78-85. https://al-fargoniy.uz/index.php/journal/article/view/1134 |
|---|---|
| GOST (OAK) | Xudoyberdiyev, Rahmatillo, Egamberdiyev, Nodir, Yadgorov, Feruz E-Certificate Information System Data Warehouse Topology: Architecture, Mathematical Models, and Optimization Strategies // Al-Farg'oniy avlodlari. – 2026. – № 2. – P. 78-85. |
| MLA | Xudoyberdiyev, Rahmatillo, Egamberdiyev, Nodir, and Yadgorov, Feruz. “E-Certificate Information System Data Warehouse Topology: Architecture, Mathematical Models, and Optimization Strategies.” Al-Farg'oniy avlodlari, (2), 78-85, 2026. https://al-fargoniy.uz/index.php/journal/article/view/1134 |
| Chicago | Xudoyberdiyev, Rahmatillo, Egamberdiyev, Nodir, and Yadgorov, Feruz. “E-Certificate Information System Data Warehouse Topology: Architecture, Mathematical Models, and Optimization Strategies.” Al-Farg'oniy avlodlari, (2), 78-85 (2026). https://al-fargoniy.uz/index.php/journal/article/view/1134 |
| Harvard | Xudoyberdiyev, Rahmatillo, Egamberdiyev, Nodir, and Yadgorov, Feruz (2026) ‘E-Certificate Information System Data Warehouse Topology: Architecture, Mathematical Models, and Optimization Strategies’, Al-Farg'oniy avlodlari, (2), 78-85. https://al-fargoniy.uz/index.php/journal/article/view/1134 |
| BibTeX | @article{xudoyberdiyevrahmatillo2026,
title = {E-Certificate Information System Data Warehouse Topology: Architecture, Mathematical Models, and Optimization Strategies},
author = {Xudoyberdiyev, Rahmatillo and Egamberdiyev, Nodir and Yadgorov, Feruz},
journal = {Al-Farg'oniy avlodlari},
year = {2026},
number = {2},
pages = {78-85},
url = {https://al-fargoniy.uz/index.php/journal/article/view/1134}
} |
Boshqa maqola uchun iqtibos tayyorlash
LLMs accelerate software development but often generate insecure code. This study proposes the Security Information Budget (SIB), a real-time metric measuring mutual information between model hidden representations and…
The article proposes a theoretical and methodological framework for the parameter-efficient adaptation of pre-trained large language models (specifically the LLaMA-3 and Mistral-7B classes) to the Uzbek language under…
Stealthy SQL injections using obfuscation, alternative encodings, and semantically veiled constructs remain a hard-to-detect threat to web applications. The paper proposes the INSECT framework, which combines formal…
This article presents a methodology for integrating multi-source geospatial data for soil salinity modeling. Field and laboratory observations, Sentinel-2 MSI imagery, spectral indices, and hydrogeological factors such…
The mathematical model allows for the evaluation of the performance efficiency of the water filter, taking into account changes in concentration, porosity, pressure values and the fouling process. To select the…
Ushbu tadqiqot mahalliy mahsulot savdosi uchun virtual platformada axborot almashinuvi jarayonlarini modellashtirish va optimallashtirishga bag'ishlangan. Tadqiqot obyekti raqamli platforma ichidagi axborot oqimi, mavzu…
This article proposes a conceptual model of enterprise energy monitoring based on IoT and edge computing. The model is designed for real-time monitoring, analysis, and management of energy consumption in industrial…
This article considers the issues of analyzing ECG signals based on statistical methods. In the study, the main parameters obtained from electrocardiogram signals were evaluated using mathematical and statistical…
This article discusses the fundamental role of the Euler function and Euler's theorem in public-key cryptosystems, in particular the RSA algorithm. The article analyzes the mathematical foundations of the Euler…
This paper proposes a simple and visually intuitive method for constructing Islamic ornamental patterns based on the “contacting polygons” technique introduced by Hankin. The proposed approach enables the formation of…
Al-Farg'oniy avlodlari — barcha maqolalar · 2026-yil arxivi
This article highlights the role and importance of modern information and communication technologies in the training of qualified specialists in sports activities. In addition, the importance of using digital devices in…
This article discusses methods for modeling and analyzing satellite communication channel characteristics. Simulations were conducted using MATLAB/Simulink, NS-3, and STK tools based on AWGN, Rayleigh, Rician, and…
This article examines compression as a meaning-oriented strategy in sign language translation and interpreting. Compression is understood not as arbitrary shortening, but as the selective reformulation of a source…
This study investigates the impact of Edge Computing on bandwidth utilization in Internet of Things (IoT)–driven Nigerian telecom networks. The rapid growth of IoT devices has significantly increased data traffic…
This article analyzes the scientific, pedagogical, and methodological foundations for the effective integration of national upbringing factors with modern global competencies in the context of continuous education…
This article addresses the problem of improving an adaptive traffic signal control algorithm at urban intersections by taking into account the dynamic characteristics of traffic flow. Fixed-time control under conditions…
Maqolada paxta xomashyosini yirik iflosliklardan tozalash jarayonida arrali baraban va kolosnikli panjara o‘rtasidagi o‘zaro ta’sirni takomillashtirish masalasi ko‘rib chiqilgan. Mavjud tozalagichlarda qo‘llaniladigan…
Maqolada paxta xomashyosini yirik va mayda iflosliklardan tozalash samaradorligini oshirishga qaratilgan ilmiy tadqiqotlar tizimlashtirilib, konstruktiv va texnologik omillarning o‘zaro ta’siri qiyosiy tahlil qilindi…