An Efficient Schema Transformation Technique for Data Migration from Relational to Column-Oriented Databases

Data transformation is the core process in migrating database from relational database to NoSQL database such as column-oriented database. However, there is no standard guideline for data transformation from relational database to NoSQL database. A number of schema transformation techniques have been proposed to improve data transformation process and resulted better query processing time when compared to the relational database query processing time. However, these approaches produced redundant tables in the resulted schema that in turn consume large unnecessary storage size and produce high query processing time due to the generated schema with redundant column families in the transformed column-oriented database. In this paper, an efficient data transformation technique from relational database to column-oriented database is proposed. The proposed schema transformation technique is based on the combination of denormalization approach, data access pattern and multiple-nested schema. In order to validate the proposed work, the proposed technique is implemented by transforming data from MySQL database to HBase database. A benchmark transformation technique is also performed in which the query processing time and the storage size are compared. Based on the experimental results, the proposed transformation technique showed significant improvement in terms query processing time and storage space usage due to the reduced number of column families in the column-oriented database.     

Improving water governance in Central Asia through application of data management tools

Contemporary water management decisions use many sources and forms of data. The paper discusses the implementation results of data management activities in the water sector carried out in five countries of the Central Asia region. Geoinformation systems, remote sensing tools and databases have been applied worldwide for improving water resources management with differing levels of success. Water management organisations, equipped with data management tools will have better capacities to adapt their decision-making in the changing availability and scarcity of water resources. Application of data management tools for improving collection, storage and processing of data and information are a first step towards improved water governance.     

The influence of delayed light curing on the degree of conversion and polymerization contraction stress in dual-cured resin luting agents

The aim of the study was to assess the effect of delayed photo-initiation on the polymerization contraction stress (PCS) and degree of conversion (DC) of a dual-cure resin-luting agent. Thirty-five disk (6 mm × 1 mm) samples (n = 10 each group) of dual cure resin luting agent for PCS assessment were fabricated and polymerized using two illuminated quartz rods. Based on the delay in photo-initiation, 30 disks were divided among six groups [group A-0 min (min) delay, group B-2 min, group C-4 min, group D-6 min, group E-8 min and group F-10 min]. A non-photoinitiated group (group G – chemical cure – n = 5) was included as control. The PCS for all specimens was assessed using a Tensometer. For DC evaluation thirty-five specimens were divided into seven groups with delays in photo-initiation (group H-0 min, group I-2 min, group J-4 min, group K-6 min, group L-8 min and group M-10 min, group N-chemical cure). DC was assessed using attenuated total reflectance spectroscopic technique. Statistical comparison among groups was performed using analysis of variance (α = 0.05). The maximum and minimum PCS and DC values with delayed photo-initiation was observed in group-C (3.34 MPa) & group-F (2.44 MPa); and group-M (0.78 MPa) and group-H (0.55 MPa) respectively. Chemically cured samples showed the least PCS (group-G, 1.94) and DC (group-N, 0.53) values in their respective categories. PCS significantly decreased with delayed photo-initiation. A significant increase in DC was noticed when photo-initiation was delayed in the dual cure resin luting agent.     

Integrated decision support system for waste minimization analysis in chemical processes

The need to build and operate environmentally friendly plants has challenged the chemical industry to consider waste minimization or even elimination starting from the early stages of process development. A thorough waste minimization analysis requires specialized expertise and is laborious, time-consuming, expensive, and knowledge-intensive. This has caused a major technical barrier for implementing waste minimization programswithin the industry. Previously, we had reported a systematic methodology and a knowledge-based system, called ENVOPExpert, for identifying waste minimization opportunities in chemical processes. In this paper, we propose an integrated qualitative-quantitative methodology to identify waste minimization alternatives and assess their efficacy in terms of environmental impact and process economics. A qualitative analysis is first conducted to identify the sources of wastes and to propose alternatives for eliminating or minimizing them. Environmental impact of each alternative is then calculated by doing a quantitative pollutant balance. The capital expenditure required for implementing the alternative and the resulting plant operating costs are also calculated and used in the evaluation of the waste minimization alternatives. Through this, practical and cost-effective options can be identified. This methodology has been implemented as an integrated decision support system and tested using the hydrodealkylation process case study with satisfactory results.     

Modeling and optimization of existing beam port facility of PSBR

Due to inherited design issues with the current arrangement of beam ports (BPs) and reactor core-moderator assembly in The Perm State Breazeale Reactor (PSBR), the development of innovative experimental facilities utilizing neutron beams is extremely limited. Therefore, a study has started to examine the existing BPs for neutron and gamma outputs and develop a new core-moderator location and BP geometry in PSBR. Although 7 BPs are placed in PSBR, 2 of them are using currently. In this study BP 4, one of the currently being used BP, is examined. With changing the location of the BP 4 and structure of the core assembly, some artificial models are developed and compared with the original model.     

Surgical correction of torsion of the penis

Torsion of the penis is a rare anomaly, believed to be due to abnormal skin attachment and not to any structural abnormality of the corpora. The rotation is usually to the left in a counter-clockwise fashion. The urethral meatus is placed in a oblique position and the median raphe makes a spiral curve from the base of the penis towards the meatus. Three boys with congenital torsion of the penis are reported. A corrective operative for this condition is described. Penile torsion was first described by Verneuil in 1857, but in the past no operative correction was recommended, since attempts to move the skin around were believed not to correct the spiral alignment of the corpora cavernosa.     

Characterization of silica-coated silver nanoparticles prepared by a reverse micelle and hydrolysis–condensation process

Described herein is the synthesis of individually silica-coated silver nanoparticles using a reverse micelle method followed by hydrolysis and condensation of tetraethoxysilane (TEOS). The size of a silica-coated silver nanoparticle can be controlled by changing the reaction time and the concentration of TEOS. By maintaining the size of a silver nanoparticle as a core particle at around 7 nm, the size of a silica-coated silver nanoparticle increased from 13 to 28 nm as the reaction time increased from 1 to 9 h due to an increase in silica thickness. The size of silica-coated silver nanoparticles also increased from 15 to 22 nm as the TEOS concentration increased from 7.8 to 40 mM. The size of a silica-coated silver nanoparticle can be accurately predicted using the rate of the hydrolysis reaction for TEOS. Neither the dispersion nor the film of silica-coated silver nanoparticles exhibited any peak shifting during surface plasmon resonance (SPR) at around 410 nm, whereas, without silica coating, the SPR peak of Ag film shifted to 466 nm.     

Neural networks for predicting compressive strength of structural light weight concrete

Neural networks procedures provide a reliant analysis in several science and technology fields. Neural network is often applied to develop statistical models for intrinsically non-linear systems because neural networks behave the advantages of simulating complex behavior of many problems. In this investigation, the neural networks (NNs) are used to predict the compressive strength of light weight concrete (LWC) mixtures after 3, 7, 14, and 28 days of curing. Two models namely, feed-forward back propagation (BP) and cascade correlation (CC), were used. The compressive strength was modeled as a function of eight variables: sand, water/cement ratio, light weight fine aggregate, light weight coarse aggregate, silica fume used in solution, silica fume used in addition to cement, superplasticizer, and curing period. It is concluded that the CC neural network model predicated slightly accurate results and learned very quickly as compared to the BP procedure. The finding of this study indicated that the neural networks models are sufficient tools for estimating the compressive strength of LWC. This undoubtedly will reduce the cost and save time in this class of problems.