Self-Optimizing Database Architecture

Over the most recent decades, analysts and database service providers have fabricated devices to help DBAs (Database Administrators) in various parts of framework tuning and the actual design of the database. Most of this past work, regardless, is fragmented on the grounds that it expects people to come up with an official agreement or judgement about any modifications to the data in the database and fix issues after they happen rather than preventing such cases from taking place or adjusting to these changes automatically. What is required for a really "self-driving" database management system (DBMS) is another way of approaching this that is intended for independent activity and automatic decision making. This is different from prior endeavors since all angles of this framework are constrained by a coordinated arranging part that not just enhance the framework for the current responsibility, but in addition to this, it also predicts future responsibility that might take place and prepares itself for such not-so-common occurrences and adjusts to them as required while keeping the efficiency of the operations as close to normal as possible. With this, the DBMS can uphold all the past tuning procedures without requiring a human to decide the right way and proper opportunity to use them. It likewise empowers new advancements that are significant for current DBMSs (Database Management System), which are impractical today because of the fact that the intricacy of overseeing these frameworks has outperformed the abilities of human specialists who are supposed to tune them and make changes when required. Keywords: Database Management System, Database Administrator, Forecasting, Long Short-Term Memory, Recurrent Neural Networks

Interdependence of constructive and settlement schemes of the building

At the design stage is very important for the formation of the reliability of any building is the stage of formation of the design model of the building, which is the basis for the construction of its load-bearing elements. The main at this stage is the adequacy of the adopted calculation model to the actual design scheme. A very important condition for assessing the actual operation of the building is to take into account the joint work of the upper part of the building (frame) with the foundations and soil base. The article examines some problems in the operation of structures, which are related to the choice of design models used in their design, on the example of a 9-storey parking lot built in the early 2000s on Pobeda Square in Kyiv. Chi-rural studies using PC LIRA-CAD analyzed the impact of joint work of the framework and foundations on the efforts at their contact. It was found that: - the impact of joint work of the frame and foundations is significant and is manifested only within a few lower floors of the frame; - taking into account the nonlinear operation of reinforced concrete structures in most cases significantly reduces the calculated forces at peak points - concentrators; - in the design process it is necessary to consider and analyze the variant design solutions of the system.

Análisis térmico de los elementos de sujeción del núcleo de un reactor trifásico

In this thesis work the temperature distribution in the frame bolts of a 5 MVA, 115 kV, 60 Hz, three-phase five-limbs shunt reactor is obtained utilizing the finite element method (FEM) and the commercial ANSYS Maxwell software. This because the reactor actually failed while it was running, the failure occurred progressively as the screw insulation was damaged and caused an unwanted temperature rise. A time-harmonic analysis is performed to compute the magnetic field distribution in the reactor and the power losses in the frame bolts. A three-dimensional (3-D) shunt reactor model is utilized, and Maxwell’s equations are solved utilizing scalar and vectorial magnetic potentials. The 3-D electromagnetic shunt reactor model is validated by comparing the value of inductance measured in the laboratory with the value of inductance computed in the 3-D FE simulation. In addition, the core losses computed in the FE simulation are compared with the core losses measured in the laboratory. This thesis work is important for transformer manufacturers which requires an adequate shunt reactor model to analyze it under different operation conditions and to optimize the actual design.

Experimental analysis of zero-natural-frequency damper for transmission line large cross project based on NES

The operation experience of transmission line large cross project shows that the traditional anti-aeolian-vibration devices had poor adaptability to complex terrain and micro meteorological conditions, and they were difficult to meet the application requirements of super large cross project at this stage. A zero-natural-frequency damper was designed by introducing nonlinear energy sink in this paper, and the solid prototypes were processed. According to the actual design parameters of conductor using in a large cross project, the anti-vibration effect was tested by using the indoor simulation test span. The test results showed that the anti-vibration effect of the scheme based on the zero-natural-frequency damper could meet the needs of practical engineering. The installation of this damper could improve conductors’ and fittings’ adaptability to complex terrain and enhance the wind and anti-vibration ability of transmission line.

Design of Extended Hamming Code Technique Encryption for Audio Signals by Double Code Error Prediction

Noise can scramble a message that is sent. This is true for both voicemails and digital communications transmitted to and from computer systems. During transmission, mistakes tend to happen. Computer memory is the most commonplace to use Hamming code error correction. With extra parity/redundancy bits added to Hamming code, single-bit errors may be detected and corrected. Short-distance data transmissions often make use of Hamming coding. The redundancy bits are interspersed and evacuated subsequently when scaling it for longer data lengths. The new hamming code approach may be quickly and easily adapted to any situation. As a result, it's ideal for sending large data bitstreams since the overhead bits per data bit ratio is much lower. The investigation in this article is extended Hamming codes for product codes. The proposal particularly emphasises on how well it functions with low error rate, which is critical for multimedia wireless applications. It provides a foundation and a comprehensive set of methods for quantitatively evaluating this performance without the need of time-consuming simulations. It provides fresh theoretical findings on the well-known approximation, where the bit error rate roughly equal to the frame error rate times the minimal distance to the codeword length ratio. Moreover, the analytical method is applied to actual design considerations such as shorter and punctured codes along with the payload and redundancy bits calculation. Using the extended identity equation on the dual codes, decoding can be done at the first instance. The achievement of 43.48% redundancy bits is obtained during the testing process which is a huge proportion reduced in this research work.

The Impact of Changes in Exhaust Temperature on the Power Output and Heat Rate of a Gas Turbine with a Capacity of 238 MW

The exhaust temperature parameter is one of the parameters that need to be considered in maintaining the performance of the gas turbine. The purpose of this study is to analyze the effect of changes in exhaust temperature on power output and heat rate. The data used is the actual design data of the M701 gas turbine. This data is used in building the model using the GateCycle software. The modeling simulation results are then validated using the actual design data. To see the impact of changes in exhaust temperature, data from the latest gas turbine performance results are used. This study concludes that changes in exhaust temperature parameters of 1OC have an impact on changes in power output of 0.273% and heat rate of 0.047%.

Integrity Design Strategy in Steel Structure Bridge Design

Nowadays, the scope of bridge construction projects in China is becoming wider, which promotes China’s economic development to a large extent and also improves China’s transportation system. Meanwhile, people also put forward new requirements for the quality of steel structure bridges. However, in actual design, due to the influence of many factors, some problems are inevitable, which will affect the integrity of the design. Therefore, the designer needs to fully grasp the possible design problems, and then take effective measures to improve the integrity of the design scheme, so as to ensure the quality of the steel structure bridge and improves the safety of the steel structure bridge from the fundamentals. This paper mainly focuses on steel structure bridges, analyzed the current status of steel structure bridge types and their selection, and proposes the integrity design strategy of steel structure bridges.

Sound predictions in an urban context

Recent studies show that environmental noise in urban environments continues to be a great health risk. This noise is especially further transmitted by the hard materials that are mostly used for façades. To predict these effects it is desirable to have a reliable prediction method. There are already several ways to predict sound levels in an urban context. This paper investigates two while focusing specifically on a practical approach to show that the methods are suitable to use during an actual design project. The impact of changing a façade at a specific location is investigated using both prediction methods. A façade which reflects sound to a location where it has a smaller impact, a sound absorbing façade, and a façade which combines both are taken into consideration. These façade adaptions have the potential to improve the sound levels in the investigated area from 1.7 up to 9.3 dB(A).

TWO-LEVEL OPTIMIZATION OF PRODUCT FAMILIES: APPLICATION TO A PRODUCT FAMILY OF WATER HOSE BOXES

Increasing product complexity and individual customer requirements make the design of optimal product families difficult. Numerical optimization supports optimal design but must deal with the following challenges: many design variables, non-linear or discrete dependencies, and many possibilities of assigning shared components to products. Existing approaches use simplifications to alleviate those challenges. However, for use in industrial practice, they often use irrelevant commonality metrics, do not rely on the actual design variables of the product, or are unable to treat discrete variables. We present a two-level approach: (1) a genetic algorithm (GA) to find the best commonality scheme (i.e., assignment scheme of shared components to products) and (2) a particle swarm optimization (PSO) to optimize the design variables for one specific commonality scheme. It measures total cost, comprising manufacturing costs, economies of scales and complexity costs. The approach was applied to a product family consisting of five water hose boxes, each of them being subject to individual technical requirements. The results are discussed in the context of the product family design process.

PIVOT FOR THE PANDEMIC: COMPARISON OF TOY AND SCIENCE DEMO DESIGN PROJECTS IN A FIRST YEAR MECHANICAL ENGINEERING COURSE

The first year course, “ME 100: Introduction to Mechanical Engineering Practice, 1”, was redesignedfor the Fall 2017-2019 offerings. The goals of the redesign were to include: a major design project, opportunities for individual communication assessments, and opportunities for development of professional skills. A toy design project was piloted in Fall 2017 as a unifying course theme. In thisproject, industrial partners come to discuss the engineering and design that happens in the toy industry. They also help critique student work as they design a toy of their choosing. With the impacts of COVID 19 the decision was made to pivot to a challenge to design new classroomphysics demonstrations. The course redesign has generally been successful. Both projects have been well received by students, faculty, and industry partners, with students reporting on an end-of-term survey that it was engaging and doable, and that it helped develop their confidence andunderstanding of design, and mechanical engineering. The demo project was generally slightly better received, with 2-8% more students agreeing to statements about the usefulness and appeal of the project. Both projects, the toy project especially, serve as a vehicle to discuss differentaspects of design and professionalism. Challenges exist with giving students guidance at the start and throughout the project to ensure that all student teams have suitably scoped projects. There is also the challenge of helping students develop a design mindset, as several groups struggle with performing the justified decision making necessary to actual design a toy.