scholarly journals Design of the database structure for software optimization of operation of the stochastic multiphase systems

2020 ◽  
pp. 42-55
Author(s):  
Ivan Alekseevich Selishchev ◽  
Svetlana Aleksandrovna Oleinikova
Keyword(s):  
Relational Databases ◽  
Random Variable ◽  
Logical Structure ◽  
Service Systems ◽  
Construction Sector ◽  
It Projects ◽  
Software Optimization ◽  
Database Structure ◽  
Multiphase Systems ◽  
Universal Structure

The object of this research is the service systems that receive a stream of requests on their input, which represents a range of mutually dependent operations of the “finish” – “start” type. The time of conducting separate operations is a random variable, and the delivery itself requires the use of one or several types of resources. It is suggested that there are timeframes for processing the request. The goal of this research is to develop the database structure that would allow storing information on the incoming projects, operations, mutual dependence, used resources and specialists. The design of logical structure of the database was carried out using the methodology “essence – link”, which determines the data values in the context of their correlation with other data. The analysis of specificity of the object of research revealed a range of requirements submitted in the database. Leaning on these requirements along with considering normalization of relations used in the theory of relational databases, the author designed the universal structure from the perspective of its application, support of the analysis of the scheduling process, and the entirety of peculiarities of the object of research. Such database structure can be used in different fields that allow decomposition of the project into multiple separate interdependent tasks, not requiring major modifications. The article provides the examples of using the database for information systems in construction sector, as well as for the development of IT projects.

scholarly journals Performance Impact of Optimization Methods on MySQL Document-Based and Relational Databases

2021 ◽  
Vol 11 (15) ◽  
pp. 6794
Author(s):  
Cornelia A. Győrödi ◽  
Diana V. Dumşe-Burescu ◽  
Robert Ş. Győrödi ◽  
Doina R. Zmaranda ◽  
Livia Bandici ◽  
...  
Keyword(s):  
Performance Improvement ◽  
Relational Databases ◽  
Optimization Methods ◽  
Management Systems ◽  
Performance Impact ◽  
Database Structure ◽  
Database Technology ◽  
And Performance ◽  
The Impact

Databases are an important part of today’s applications where large amounts of data need to be stored, processed, and accessed quickly. One of the important criteria when choosing to use a database technology is its data processing performance. In this paper, some methods for optimizing the database structure and queries were applied on two popular open-source database management systems: MySQL as a relational DBMS, and document-based MySQL as a non-relational DBMS. The main objective of this paper was to conduct a comparative analysis of the impact that the proposed optimization methods have on each specific DBMS when carrying out CRUD (CREATE, READ, UPDATE, DELETE) requests. To perform the analysis and performance evaluation of CRUD operations for different amounts of data, a case study testing architecture based on Java was developed and used to show how the databases’ proposed optimization methods can influence the performance of the application, and to highlight the differences in response time and complexity. The results obtained show the degree to which the proposed optimization methods contributed to the application’s performance improvement in the case of both databases; based on these, a detailed analysis and several conclusions are presented to support a decision for choosing a specific approach.

scholarly journals Relational database problems

2020 ◽  
pp. 7-18
Author(s):  
Konstantin Alekseev
Keyword(s):  
Information Systems ◽  
Relational Database ◽  
Relational Databases ◽  
Query Language ◽  
Heuristic Methods ◽  
Storage Medium ◽  
Database Structure ◽  
Slow Decline ◽  
The Subject ◽  
Over Time

The relevance of this article lies in the fact that today's databases are the basis of numerous information systems. The information accumulated in them is extremely valuable material, and today database processing methods are widely spread in terms of extracting additional methods, knowledge from them, which are interconnected with generalization and various additional methods of information processing.The object of research in this work is relational databases and DBMS, the subject of research is the features of their use in applied programming.In accordance with the set goal, it is necessary to solve the following tasks:1) to consider the concept and essence of a relational database;2) to analyze the problematic aspects of relational databases in modern conditions. Relational databases are among the most widespread due to their simplicity and clarity at the creation stage and at the user level. It should also be noted that the main advantage of RDB is its compatibility with the main query language SQL, which is intuitive for users.Nevertheless, with all the variety of approaches, there are still some canons, violation of which greatly affects both the design of the database and its operation. For example, the problem of database normalization is very relevant. Neglecting normalization makes the database structure confusing and the database itself unreliable.Promising directions include the development of queries to a relational database using heuristic methods, as well as the method of accumulating previously optimized queries with subsequent verification of the derivability of the current query from the accumulated ones.Finally, a very slow decline in relational databases is probably happening. While they are still the primary storage medium, especially in large enterprise projects, they are gradually being replaced by non-relational solutions that will become the majority over time.

Generation of Correlated Logistic-Normal Random Variates for Medical Decision Trees

1998 ◽  
Vol 37 (03) ◽  
pp. 235-238 ◽  
Author(s):  
M. El-Taha ◽  
D. E. Clark
Keyword(s):  
Monte Carlo ◽  
Decision Trees ◽  
Computer Algebra ◽  
Taylor Series ◽  
Computer Algebra System ◽  
Random Variable ◽  
Monte Carlo Analysis ◽  
Normal Random Variable ◽  
Medical Decision ◽  
Theoretical Results

AbstractA Logistic-Normal random variable (Y) is obtained from a Normal random variable (X) by the relation Y = (ex)/(1 + ex). In Monte-Carlo analysis of decision trees, Logistic-Normal random variates may be used to model the branching probabilities. In some cases, the probabilities to be modeled may not be independent, and a method for generating correlated Logistic-Normal random variates would be useful. A technique for generating correlated Normal random variates has been previously described. Using Taylor Series approximations and the algebraic definitions of variance and covariance, we describe methods for estimating the means, variances, and covariances of Normal random variates which, after translation using the above formula, will result in Logistic-Normal random variates having approximately the desired means, variances, and covariances. Multiple simulations of the method using the Mathematica computer algebra system show satisfactory agreement with the theoretical results.

Formation Of An Estimate For A State Contract With A Firm Price In The Construction Sector

2020 ◽  
pp. 47-57
Keyword(s):  
Construction Projects ◽  
Cost Of Capital ◽  
Federal Budget ◽  
The State ◽  
Structural Elements ◽  
Construction Sector ◽  
Construction Process ◽  
Practical Application ◽  
Stage Of Development ◽  
Capital Construction

The issues of determining the estimated cost of capital construction projects with the involvement of Federal budget funds at the stage of development of project documentation, during verification of the accuracy of determining the estimated cost and the initial (maximum) contract price are considered. On the basis of the assessment of amendments to urban planning legislation for the purpose of implementing a state contract by the contractor ( based on the results of competitive procedures or without competitive procedures by decision of state authorities), the procedure for forming the estimate as part of a state (municipal) contract, the price of which is firm, is presented. For the purpose of mutual settlements between the customer and the contractor for the work performed, the formation of primary accounting documentation, as well as for checking the work performed by regulatory authorities, an example of drawing up an estimate of the state (municipal) contract on the basis of grouping costs according to structural elements and complexes of work is given. The result of the research conducted was the development of regulations and the formation of criteria for their practical application by state bodies, institutions, organizations and other participants in the investment-construction process, as well as recipients of budget funds, who perform the functions of the state (municipal) customer, developer and technical customer.

Sign in / Sign up

Export Citation Format

Share Document