Abstract. Objective. The purpose of this article is to conduct an overview and comparative analysis of the most up-to-date server database management systems, including Informix Dynamic Server, Microsoft SQL Server, Db2 Universal Database and Oracle 9i. we strive to identify the main characteristics and distinctive features of each of these DBMS, as well as to evaluate their advantages and limitations. Methods. For the analysis, we relied on available sources of information, including official documents, technical documentation, scientific articles and publications, as well as experienced users and database experts. Results. the analysis showed that each of the considered DBMS has its own advantages and disadvantages. Informix Dynamic Server stands out for a wide range of architectural features that provide high performance and scalability, but require a higher level of professionalism in administration. Microsoft SQL Server is attractive for the Windows operating system, has a developed dialect of the SQL language and a rich set of development tools, but is mainly focused on integration with other Microsoft products. Db2 Universal Database provides high performance, scalability and multiplatform, but has a complex interface and functionality. Oracle 9i is focused on use in the Internet environment, supports various hardware and software platforms, but requires highly qualified developers and administrators. Conclusion. In this paper, we considered the signs by which it is possible to analyze the advantages and disadvantages of database management systems (DBMS). During the performance analysis, the indicators of query execution speed, transaction processing and scalability of the system with an increase in data volume were considered. Data availability has also been studied, including the possibility of replication and fault tolerance of the system, special attention is paid to the functionality of the DBMS server. Keywords: database management systems, performance, scalability, data availability, server functionality, DBMS openness, development tools, administration tools, DB2, Oracle, Microsoft SQL Server, Informix, advantages, disadvantages.
| Mualliflar | Худайбердиев, Сахобиддин |
|---|---|
| Jurnal | Наманган муҳандисликтехнология институти илмийтехника журнали |
| Nashr sanasi | 2023-09-30 |
| Jild | 8 |
| Son | 3 |
| Betlar | 164-169 |
| Til | Ingliz |
Abstract. Objective. This article is based on the need to study the foreign experience of developing service sectors in small business and private business entities. The article analyzes the experiences of…
Assessing the quality of automated systems is a very difficult task. This article uses a factor graph and a message passing algorithm to evaluate the quality of the output of the automated local work management system…
In this work, PMMA-EC-LiTf, PMMA-EC-MgTf2 samples were prepared at a concentration of 20%. Using Nyquist coordinates, results were obtained for active and reactive impedances at temperatures from 243K to 283 K and…
Abstract. Objective. As the object of this research work, samples of almonds soaked at different times were selected, and the influence of the time of thawing of kernels on the nutritional value, quality, product…
Abstract: Objective. In this article, taking into account the natural and climatic conditions of Uzbekistan, the formation and study of a package of materials for men's outerwear that meets functional and operational…
Abstract. Objective. The purpose of the project was to increase the capacity of our country on fruit and vegetable expositions, to research drying devices in order to increase their economic efficiency by reducing the…
This article provides information on measures to prevent micronutrient deficiency, which is one of the most important problems of the population.The creation of products containing a wide range of biologically active…
Abstract. Objective. In this article, the movement of fibers in the air channel and the rotor in the pneumomechanical spinning machine was studied. In the experimental work, the uniformity and stability of the velocity…
Abstract. The article covers the issues of developing the informational and methodological support of the decision-making process on the formation of the assortment of special clothes. At the initial stage of design…
Abstract. Objective. In this paper, we conducted research based on a new experimental approach to describe the airflow in a rotor-spinning machine experimentally. This article studied the movement of fibers in the air…
Наманган муҳандисликтехнология институти илмийтехника журнали — barcha maqolalar