scholarly journals Comparison of MySQL, MSSQL, PostgreSQL, Oracle databases performance, including virtualization

2020 ◽  
Vol 16 ◽  
pp. 279-284
Author(s):  
Wojciech Truskowski ◽  
Rafał Klewek ◽  
Maria Skublewska-Paszkowska

Oracle, MSSQL, MySQL and PostgreSQL are four of the most popular relational databases. They are often used in internet applications. This paper aims to compare the efficiency of these technologies in terms of speed using virtualization with Docker. No publications that include virtualization were found among previous papers. After review of the literature, it was hypothesized that the Oracle engine would be the fastest. During the research, a series of experiments was carried out using the application, in which tests for measuring the time of instruction execution were implemented. Each query was measured 100 times and the first measurement was rejected. The obtained results confirmed the hypothesis about the superiority of the Oracle database. As in previous studies, it proved to be the fastest, also using virtualization.

2018 ◽  
Vol 8 ◽  
pp. 263-269
Author(s):  
Grzegorz Dziewit ◽  
Jakub Korczyński ◽  
Maria Skublewska-Paszkowska

Comparison of efficiency is not a trivial phenomenon because of disparities between different database systems. This paper presents a methodology of comparing relational database systems in respect of mean time of execution individual DML queries containing subqueries and conjunction of tables. The presented methodology can be additionally accommodated to studies of efficiency in a range of database system itself (study of queries executed directly in database engine). The described methodology allows to receive statement telling which database system is better in comparison to another in dependency of functionalities fulfilled by external application. In the article the analysis of mean time of execution individual DML queries was performed.Two research hypotheses have been put forward: "Microsoft SQL Server database system needs less time to execute INSERT and UPDATE queries than Oracle database" and "Oracle database system needs less time to execute DML queries with binary data than SQL Server"


PLoS ONE ◽  
2021 ◽  
Vol 16 (2) ◽  
pp. e0245122
Author(s):  
Iztok Savnik ◽  
Mikita Akulich ◽  
Matjaž Krnc ◽  
Riste Škrekovski

Set containment operations form an important tool in various fields such as information retrieval, AI systems, object-relational databases, and Internet applications. In the paper, a set-trie data structure for storing sets is considered, along with the efficient algorithms for the corresponding set containment operations. We present the mathematical and empirical study of the set-trie. In the mathematical study, the relevant upper-bounds on the efficiency of its expected performance are established by utilizing a natural probabilistic model. In the empirical study, we give insight into how different distributions of input data impact the efficiency of set-trie. Using the correct parameters for those randomly generated datasets, we expose the key sources of the input sensitivity of set-trie. Finally, the empirical comparison of set-trie with the inverted index is based on the real-world datasets containing sets of low cardinality. The comparison shows that the running time of set-trie consistently outperforms the inverted index by orders of magnitude.


1989 ◽  
Vol 33 (19) ◽  
pp. 1305-1309 ◽  
Author(s):  
Robert E. Llaneras ◽  
Robert W. Swezey ◽  
John A. Allen

This paper draws upon both an extensive review of the literature, and a series of experiments manipulating motion-based (videotaped) versus static (35-mm slide) presentations of instructional material across a variety of instructional conditions. Performance measures in the experiments included both hands-on tasks and conceptual knowledge tests. Results indicated that electromechanical maintenance performance did not differ significantly between statically and dynamically trained groups across a variety of types and complexities of electromechanical maintenance tasks and instructional strategy conditions.


Author(s):  
G. Cliff ◽  
M.J. Nasir ◽  
G.W. Lorimer ◽  
N. Ridley

In a specimen which is transmission thin to 100 kV electrons - a sample in which X-ray absorption is so insignificant that it can be neglected and where fluorescence effects can generally be ignored (1,2) - a ratio of characteristic X-ray intensities, I1/I2 can be converted into a weight fraction ratio, C1/C2, using the equationwhere k12 is, at a given voltage, a constant independent of composition or thickness, k12 values can be determined experimentally from thin standards (3) or calculated (4,6). Both experimental and calculated k12 values have been obtained for K(11<Z>19),kα(Z>19) and some Lα radiation (3,6) at 100 kV. The object of the present series of experiments was to experimentally determine k12 values at voltages between 200 and 1000 kV and to compare these with calculated values.The experiments were carried out on an AEI-EM7 HVEM fitted with an energy dispersive X-ray detector.


Author(s):  
H. Lin ◽  
D. P. Pope

During a study of mechanical properties of recrystallized B-free Ni3Al single crystals, regularly spaced parallel traces within individual grains were discovered on the surfaces of thin recrystallized sheets, see Fig. 1. They appeared to be slip traces, but since we could not find similar observations in the literature, a series of experiments was performed to identify them. We will refer to them “traces”, because they contain some, if not all, of the properties of slip traces. A variety of techniques, including the Electron Backscattering Pattern (EBSP) method, was used to ascertain the composition, geometry, and crystallography of these traces. The effect of sample thickness on their formation was also investigated.In summary, these traces on the surface of recrystallized Ni3Al have the following properties:1.The chemistry and crystallographic orientation of the traces are the same as the bulk. No oxides or other second phases were observed.2.The traces are not grooves caused by thermal etching at previous locations of grain boundaries.3.The traces form after recrystallization (because the starting Ni3Al is a single crystal).4.For thicknesses between 50 μm and 720 μm, the density of the traces increases as the sample thickness decreases. Only one set of “protrusion-like” traces is visible in a given grain on the thicker samples, but multiple sets of “cliff-like” traces are visible on the thinner ones (See Fig. 1 and Fig. 2).5.They are linear and parallel to the traces of {111} planes on the surface, see Fig. 3.6.Some of the traces terminate within the interior of the grains, and the rest of them either terminate at or are continuous across grain boundaries. The portion of latter increases with decreasing thickness.7.The grain size decreases with decreasing thickness, the decrease is more pronounced when the grain size is comparable with the thickness, Fig. 4.8.Traces also formed during the recrystallization of cold-rolled polycrystalline Cu thin sheets, Fig. 5.


Author(s):  
G-A. Keller ◽  
S. J. Gould ◽  
S. Subramani ◽  
S. Krisans

Subcellular compartments within eukaryotic cells must each be supplied with unique sets of proteins that must be directed to, and translocated across one or more membranes of the target organelles. This transport is mediated by cis- acting targeting signals present within the imported proteins. The following is a chronological account of a series of experiments designed and carried out in an effort to understand how proteins are targeted to the peroxisomal compartment.-We demonstrated by immunocryoelectron microscopy that the enzyme luciferase is a peroxisomal enzyme in the firefly lantern. -We expressed the cDNA encoding firefly luciferase in mammalian cells and demonstrated by immunofluorescence that the enzyme was transported into the peroxisomes of the transfected cells. -Using deletions, linker insertions, and gene fusion to identify regions of luciferase involved in its transport to the peroxisomes, we demonstrated that luciferase contains a peroxisomal targeting signal (PTS) within its COOH-terminal twelve amino acid.


Author(s):  
J. Drennan ◽  
R.H.J. Hannink ◽  
D.R. Clarke ◽  
T.M. Shaw

Magnesia partially stabilised zirconia (Mg-PSZ) ceramics are renowned for their excellent nechanical properties. These are effected by processing conditions and purity of starting materials. It has been previously shown that small additions of strontia (SrO) have the effect of removing the major contaminant, silica (SiO2).The mechanism by which this occurs is not fully understood but the strontia appears to form a very mobile liquid phase at the grain boundaries. As the sintering reaches the final stages the liquid phase is expelled to the surface of the ceramic. A series of experiments, to examine the behaviour of the liquid grain boundary phase, were designed to produce compositional gradients across the ceramic bodies. To achieve this, changes in both silica content and furnace atmosphere were implemented. Analytical electron microscope techniques were used to monitor the form and composition of the phases developed. This paper describes the results of our investigation and the presentation will discuss the work with reference to liquid phase sintering of ceramics in general.


2020 ◽  
Vol 5 (1) ◽  
pp. 326-338 ◽  
Author(s):  
Kristen Weidner ◽  
Joneen Lowman

Purpose We conducted a systematic review of the literature regarding adult telepractice services (screening, assessment, and treatment) from approximately 2014 to 2019. Method Thirty-one relevant studies were identified from a literature search, assessed for quality, and reported. Results Included studies illustrated feasibility, efficacy, diagnostic accuracy, and noninferiority of various speech-language pathology services across adult populations, including chronic aphasia, Parkinson's disease, dysphagia, and primary progressive aphasia. Technical aspects of the equipment and software used to deliver services were discussed. Some general themes were noted as areas for future research. Conclusion Overall, results of the review continue to support the use of telepractice as an appropriate service delivery model in speech-language pathology for adults. Strong research designs, including experimental control, across multiple well-described settings are still needed to definitively determine effectiveness of telepractice services.


Sign in / Sign up

Export Citation Format

Share Document