Analysing the Performance of NoSQL vs SQL Databases with Respect to Routing Algorithms

With the increased shift towards GeoSpatial Web Services on both the Web and mobile platforms especially in the usercentric services, there is a need to improve the query response time. The traditional routing algorithm requires server to process the query and send the results to a client but here we are focussing on query processing within the client itself. This paper attempts to evaluate the performance of an existing NoSQL database and SQL database with respect to routing algorithm and evaluate whether or not we can deploy the computations on the client system only. While SQL databases face the challenges of scalability and agility and are unable to take the advantage of the abundant memory and processing power available these days, NoSQL databases are able to use some of these features to their advantage. The nonrelational databases are more suited for handling the dynamic rise in the data storage and the increased frequency of data accessibility. For this comparative study, MongoDB is the NoSQL engine while the PostgreSQL is the chosen SQL engine. The dataset is a synthetic dataset of road network with several nodes and we find the distance between source and destination using various algorithms. As a part of paper The implementation we are planning on using pgRouting for the analysis which currently uses PostgreSQL at the backend and implements almost all the routing algorithms essential in practical scenarios. We have currently analyzed the performance of NoSQL databases for various spatial queries and have extended that work to routing. Initial results suggest that MongoDB performs faster by an average factor of 15x which increases exponentially as the path length and network data size increases in both indexed and nonindexed operations. This implies that nonrelational databases are more suited to the multiuser query systems and has the potential to be implemented in servers with limited computational power. Further studies are required to identify its appropriateness and incorporate a range of spatial algorithms within nonrelational databases

Performance Analysis of MongoDB Vs. PostGIS/PostGreSQL Databases For Line Intersection and Point Containment Spatial Queries

Relational databases have been around for a long time and Spatial databases have exploited this feature for close to two decades. The recent past has seen the development of NoSQL non-relational databases, which are now being adopted for spatial object storage and handling too. And this is gaining ground in the context of increased shift towards GeoSpatial Web Services on both the Web and mobile platforms especially in the usercentric services, where there is a need to improve the query response time. While SQL databases face scalability and agility challenges and fail to take the advantage of the cheap memory and processing power available these days, NoSQL databases can handle the rise in the data storage and frequency at which it is accessed and processed - which are essential features needed in geospatial scenarios, which do not deal with a fixed schema(geometry) and fixed data size. This paper attempts to evaluate the performance of an existing NoSQL database \u27MongoDB\u27 with its inbuilt spatial functions with that of a SQL database with spatial extension \u27PostGIS\u27 for two primitive spatial problems - LineIntersection and Point Containment problem, across a range of datasets, with varying features counts. For LineIntersection function, the dataset consisted of two independent layers of horizontal lines and vertical lines with incremental lengths and their size varied from ten lines to million lines in each layer and another dataset with two layers, one of random lines of variable size and shape and another layer of a single line which is intersecting many lines of layer1. For Point Containment problem, the dataset consists of two layers, one of polygons in space of different shape and size and another layer of random points in the space, some inside the polygons and some outside. All the data in the analysis was processed In-memory and no secondary memory was used. Initial results suggest that MongoDB performs better by an average factor of 25x for Line Intersection Problem and 10x for Point Containment Problem which increases exponentially as the data size increases in both indexed and nonindexed operations. Given these results NoSQL databases may be better suited for simultaneous multiple-user query systems including Web-GIS and mobile-GIS. Further studies are required to understand the full potential of NoSQL databases across various geometries and spatial query types

Analyzing the performance of NoSQL vs. SQL databases for Spatial and Aggregate queries

Relational databases have been around for a long time and spatial databases have exploited this feature for close to two decades. The recent past has seen the development of NoSQL non-relational databases, which are now being adopted for spatial object storage and handling, too. While SQL databases face scalability and agility challenges and fail to take the advantage of the cheap memory and processing power available these days, NoSQL databases can handle the rise in the data storage and frequency at which it is accessed and processed - which are essential features needed in geospatial scenarios, which do not deal with a fixed schema(geometry) and fixed data size. This paper attempts to evaluate the performance of an existing NoSQL database \u27MongoDB\u27 with its inbuilt spatial functions with that of a SQL database with spatial extension \u27PostGIS\u27 for two problems – spatial and aggregate queries, across a range of datasets, with varying features counts. All the data in the analysis was processed In-memory and no secondary memory was used. Initial results suggest that MongoDB performs better by an average factor of 10x-25x which increases exponentially as the data size increases in both indexed and non-indexed operations. Given these results, NoSQL databases may be better suited for simultaneous multiple-user query systems including Web-GIS and mobile-GIS. Further studies are required to understand the full potential of NoSQL databases across various geometries and spatial query types

Determination of seminal oxidation–reduction potential (ORP) as an easy and cost-effective clinical marker of male infertility

Oxidative stress (OS) is an important contributing factor to male infertility. While previous methods to measure seminal OS are time-consuming and limited to the use of freshly produced semen, oxidation reduction potential (ORP) is easier and quicker to perform and can also be used in frozen semen. Therefore, this study evaluated the clinical utility of ORP as a potential marker of male infertility. ORP was measured in semen samples from 293 patients and 15 fertile controls and categorised according to WHO criteria as normozoospermic, oligozoospermic, asthenozoospermic, teratozoospermic and oligoasthenoteratozoospermic. Receiver operating characteristic (ROC) curves were generated to differentiate these categories. Semen parameters were significantly different when subjects were grouped as control and patients or between the patient and normozoospermic group for concentration and morphology. ORP levels were significantly different between the control and normozoospermic group. When subjects were grouped based on concentration, motility, morphology or a combination of these, the area under the ROC curve, sensitivity, specificity, positive predictive value and cut-off values were significantly different. These differences were significant when combined with ORP and grouped with any two sperm abnormalities. In conclusion, ORP is a quick, easy, cost-effective and reliable marker of semen quality as well as oxidative stress for use in a clinical setting

Management of difficult airway in intratracheal tumor surgery

BACKGROUND: Tracheal malignancies are usual victim of delay in diagnosis by virtue of their symptoms resembling asthma. Sometimes delayed diagnosis may lead to almost total airway obstruction. For difficult airways, not leaving any possibility of manipulation into neck region or endoscopic intervention, femorofemoral cardiopulmonary bypass can be a promising approach. CASE PRESENTATION: We are presenting a case of tracheal adenoid cystic carcinoma (cylindroma) occupying about 90% of the tracheal lumen. It was successfully managed by surgical excision of mass by sternotomy and tracheotomy under femorofemoral cardiopulmonary bypass (CPB). CONCLUSION: Any patient with recurrent respiratory symptoms should be evaluated by radiological and endoscopic means earlier to avoid delay in diagnosis of such conditions. Femorofemoral cardiopulmonary bypass is a relatively safe way of managing certain airway obstructions

The systemic lupus erythematosus IRF5 risk haplotype is associated with systemic sclerosis

Systemic sclerosis (SSc) is a fibrotic autoimmune disease in which the genetic component plays an important role. One of the strongest SSc association signals outside the human leukocyte antigen (HLA) region corresponds to interferon (IFN) regulatory factor 5 (IRF5), a major regulator of the type I IFN pathway. In this study we aimed to evaluate whether three different haplotypic blocks within this locus, which have been shown to alter the protein function influencing systemic lupus erythematosus (SLE) susceptibility, are involved in SSc susceptibility and clinical phenotypes. For that purpose, we genotyped one representative single-nucleotide polymorphism (SNP) of each block (rs10488631, rs2004640, and rs4728142) in a total of 3,361 SSc patients and 4,012 unaffected controls of Caucasian origin from Spain, Germany, The Netherlands, Italy and United Kingdom. A meta-analysis of the allele frequencies was performed to analyse the overall effect of these IRF5 genetic variants on SSc. Allelic combination and dependency tests were also carried out. The three SNPs showed strong associations with the global disease (rs4728142: P = 1.34×10<sup>−8</sup>, OR = 1.22, CI 95% = 1.14–1.30; rs2004640: P = 4.60×10<sup>−7</sup>, OR = 0.84, CI 95% = 0.78–0.90; rs10488631: P = 7.53×10<sup>−20</sup>, OR = 1.63, CI 95% = 1.47–1.81). However, the association of rs2004640 with SSc was not independent of rs4728142 (conditioned P = 0.598). The haplotype containing the risk alleles (rs4728142*A-rs2004640*T-rs10488631*C: P = 9.04×10<sup>−22</sup>, OR = 1.75, CI 95% = 1.56–1.97) better explained the observed association (likelihood P-value = 1.48×10<sup>−4</sup>), suggesting an additive effect of the three haplotypic blocks. No statistical significance was observed in the comparisons amongst SSc patients with and without the main clinical characteristics. Our data clearly indicate that the SLE risk haplotype also influences SSc predisposition, and that this association is not sub-phenotype-specific

Association between promoter methylation of MLH1 and MSH2 and reactive oxygen species in oligozoospermic men—A pilot study

MLH1 and MSH2 are important genes for DNA mismatch repair and crossing over during meiosis and are implicated in male infertility. Therefore, the methylation patterns of the DNA mismatch repair genes MLH1 and MSH2 in oligozoospermic males were investigated. Ten oligozoospermic patients and 29 normozoospermic donors were analysed. Methylation profiles of the MLH1 and MSH2 promotors were analysed. In addition, sperm motility and seminal reactive oxygen species (ROS) were recorded. Receiver operating characteristic (ROC) analysis was conducted to determine the accuracy of the DNA methylation status of MLH1 and MSH2 to distinguish between oligozoospermic and normozoospermic men. In oligozoospermic men, MLH1 was significantly (p = .0013) more methylated compared to normozoospermic men. Additionally, there was a significant positive association (r = .384; p = .0159) between seminal ROS levels and MLH1 methylation. Contrary, no association between MSH2 methylation and oligozoospermia was found. ROC curve analysis for methylation status of MLH1 was significant (p = .0275) with an area under the curve of 61.1%, a sensitivity of 22.2% and a specificity of 100.0%. This pilot study indicates oligozoospermic patients have more methylation of MLH1 than normozoospermic patients. Whether hypermethylation of the MLH1 promoter plays a role in repairing relevant mismatches of sperm DNA strands in idiopathic oligozoospermia warrants further investigation

High risk of tuberculosis during infliximab therapy despite tuberculosis screening in inflammatory bowel disease patients in India

Background/Aims The data on the risk of tuberculosis (TB) reactivation with infliximab (IFX) in patients with inflammatory bowel disease (IBD) from TB endemic countries, like India, is limited. The risk of TB reactivation on IFX and its predictors in patients with IBD was assessed. Methods This retrospective review included consecutive patients with IBD who received IFX, and were on follow-up from January 2005 to November 2017. The data was recorded on age/disease duration, indications for IFX, screening for latent tuberculosis (LTB) before IFX, response to IFX, incidence and duration when TB developed after IFX, and type of TB (pulmonary [PTB]/extra-pulmonary [EPTB]/disseminated). Results Of 69 patients (22 ulcerative colitis/47 Crohn’s disease; mean age, 35.6±14.5 years; 50.7% males; median follow-up duration after IFX, 19 months [interquartile range, 5.5–48.7 months]), primary non-response at 8 weeks and secondary loss of response at 26 and 52 weeks were seen in 14.5%, 6% and 15% patients respectively. Prior to IFX, all patients were screened for LTB, 8 (11.6%) developed active TB (disseminated, 62.5%; EPTB, 25%; PTB, 12.5%) after a median of 19 weeks (interquartile range, 14.0–84.5 weeks) of IFX. Of these 8 patients’ none had LTB, even when 7 of 8 were additionally screened with contrast-enhanced chest tomography. Though not statistically significant, more patients with Crohn’s disease than ulcerative colitis (14.9% vs. 4.5%, P=0.21), and those with past history of TB (25% vs. 9.8%, P=0.21), developed TB. Age, gender, disease duration, or extraintestinal manifestations could not predict TB reactivation. Conclusions There is an extremely high rate of TB with IFX in Indian patients with IBD. Current screening techniques are ineffective and it is difficult to predict TB after IFX

Process intensification for post combustion CO₂ capture with chemical absorption: a critical review

The concentration of CO₂ in the atmosphere is increasing rapidly. CO₂ emissions may have an impact on global climate change. Effective CO₂ emission abatement strategies such as carbon capture and storage (CCS) are required to combat this trend. Compared with pre-combustion carbon capture and oxy-fuel carbon capture approaches, post-combustion CO₂ capture (PCC) using solvent process is one of the most mature carbon capture technologies. There are two main barriers for the PCC process using solvent to be commercially deployed: (a) high capital cost; (b) high thermal efficiency penalty due to solvent regeneration. Applying process intensification (PI) technology into PCC with solvent process has the potential to significantly reduce capital costs compared with conventional technology using packed columns. This paper intends to evaluate different PI technologies for their suitability in PCC process. The study shows that rotating packed bed (RPB) absorber/stripper has attracted much interest due to its high mass transfer capability. Currently experimental studies on CO₂ capture using RPB are based on standalone absorber or stripper. Therefore a schematic process flow diagram of intensified PCC process is proposed so as to motivate other researches for possible optimal design, operation and control. To intensify heat transfer in reboiler, spinning disc technology is recommended. To replace cross heat exchanger in conventional PCC (with packed column) process, printed circuit heat exchanger will be preferred. Solvent selection for conventional PCC process has been studied extensively. However, it needs more studies for solvent selection in intensified PCC process. The authors also predicted research challenges in intensified PCC process and potential new breakthrough from different aspects