ESTABLISHING A STANDARD SCIENTIFIC GUIDELINE FOR THE EVALUATION AND ADOPTION OF MULTI-TENANT DATABASE

A thesis submitted in partial fulfilment of the requirements of the University of Wolverhampton for the degree of Doctor of Philosophy.A Multi-tenant database (MTD) is a way of deploying a Database as a Service (DaaS). A multi-tenant database refers to a principle where a single instance of a Database Management System (DBMS) runs on a server, serving multiple clients organisations (tenants). This technology has helped to discard the large-scale investments in hardware and software resources, in upgrading them regularly and in expensive licences of application software used on in-house hosted database systems. This is gaining momentum with significant increase in the number of organisations ready to take advantage of the technology. The benefits of MTD are potentially enormous but for any organisation to venture into its adoption, there are some salient factors which must be well understood and examined before venturing into the concept. This research examines these factors, different models of MTD, consider the requirements and challenges of implementing MTDs. Investigation of the degree of impact each of these factors has on the adoption of MTD is conducted in this research which focused mainly on public organisations. The methodology adopted in undertaking this study is a mixed method which involved both qualitative and quantitative research approaches. These strategies are used here to cover statistics (quantifiable data) and experts’ knowledge and experiences (abstract data) in order to satisfactorily achieve the aim and objectives and complete the research. Following the involvement of these strategies, a framework was developed and further refined after a second survey was carried out with a quantitative approach. This framework will help prospective tenants to make informed decisions about the adoption of the concept. The research also considers the direction of decisions about MTDs in situations where two or more factors are combined. A new MTD framework is presented that improves the decision making process of MTD adoption. Also, an Expert System (ES) is developed from the framework which was validated via a survey and analysed with the aid of SPSS software. The findings from the validation indicated that the framework is valuable and suitable for use in practice since majority of respondents accepted the research findings and recommendations for success. Likewise, the ES was validated with majority of participants accepting it and embracing the high level of its friendliness

A Review Of Multi-Tenant Database And Factors That Influence Its Adoption.

A Multi-tenant database (MTD) is a way of deploying a Database as a Service (DaaS). This is gaining momentum with significant increase in the number of organizations ready to take advantage of the technology. A multi-tenant database refers to a principle where a single instance of a Database Management System (DBMS) runs on a server, serving multiple clients organizations (tenants). This is a database which provides database support to a number of separate and distinct groups of users or tenants. This concept spreads the cost of hardware, software and other services to a large number of tenants, therefore significantly reducing per tenant cost. Three different approaches of implementing multi-tenant database have been identified. These methods have been shown to be increasingly better at pooling resources and also processing administrative operations in bulk. This paper reports the requirement of multi-tenant databases, challenges of implementing MTD, database migration for elasticity in MTD and factors influencing the choice of models in MTD. An insightful discussion is presented in this paper by grouping these factors into four categories. This shows that the degree of tenancy is an influence to the approach to be adopted and the capital and operational expenditure are greatly reduced in comparison with an on-premises solutio

Gastric adenomyoma: an uncommon cause of dyspepsia and a rare endoscopic finding.

Background: Gastric adenomyoma (GA) is a rare benign lesion comprising of ducts and glands embedded in smooth muscle stroma. Thirty-seven (37) cases of GA were identified until 1993, however, only 15 cases are said to have been reported from 1993 to 2016. Esophagogastroscopy has been widely used in evaluating GA. However, the diagnosis of GA remains exclusively histological. Case: We report a 26-year-old Nigerian woman who presented with recurrent dyspepsia with her endoscopic findings suggestive of GA. GA was confirmed by histology, and she was managed conservatively. Conclusion: This report will contribute to creating awareness of this uncommon condition and also reminding physicians in considering GA as a possible differential of dyspepsia. Keywords: gastric, adenomyoma, dyspepsia, endoscopy, Nigerian, woma

Statistical analysis of factors that influences the evaluation and adoption of multi-tenant databases

Multi-tenant Databases (MTD) are implemented in the deployment of database management services to Information Technology (IT) platform users. A database service provider hosts the Multi-tenant Database Management System (MTDMS) and each tenant subscribes to the service through a standard method such as a web service. Improved groupings of the factors that influence the adoption of MTDs are presented in this paper. A survey is presented here that involves forty one experts from the field of databases. A predictive analytical method called Relative Importance Index (RII) and other statistical tools have been adopted in the analysis. The result has led to the new framework in the adoption of MTDs. The research also considers the direction of decisions about MTDs in situations where two or more factors are combined. A new improved MTD framework is presented that improves the decision making process of MTD adoption.Published onlin

Carvenous hemangioma of the uterine cervix: A case report

Carvenous hemangioma of the uterine cervix is a rare clinical condition which has the potential of being life threatening. This rare clinical condition  can manifest with patients presenting with abnormal uterine bleeding, menorrhagia with eventual anaemia. The case report here is that of a 27 year old Para o+o lady who was admitted to the Accident and Emergency Unit of our hospital with a day history of a huge mass protruding per vagina and a history of significant bleeding per vagina. Packed cell volume was 16% on admission and she had 4 units of blood transfused. She subsequently had examination under anaesthesia and excision of the prolapsed mass done via the vaginal route. Histology of the excised mass was in keeping with  cavernous hemangioma of the uterus. Her Postoperative clinical state was satisfactory. Key words: Carvenous; hemangioma; uterus

Utilization of Tannic Acid by Bacteria in Tropical Aquatic and Soil Environments

Two bacterial strains designated as EO1 and EO2, were isolated by selective culture enrichment from Lagos lagoon water and mangrove soil samples. They were subsequently identified based on morphological and physiological characteristics as well as 16S rRNA gene sequence analysis as Klebsiella pneumoniae strain EO1 and Pantoea cypripedii strain EO2 with accession numbers KX355800 and KX355801. Microbial growth assessment was performed in triplicates under aerobic batch conditions. The two isolates were capable of utilizing tannic acid, gallic acid, glucose, succinate, benzoic acid, and protocatechuic acid as sole carbon sources. Growth experiments along with enzymatic studies indicated that the organisms hydrolyzed tannic acid through gallic acid and pyrogallol as metabolic intermediates. The organisms have potential for the elimination of polyphenolic pollutants such as gallotannins associated with wood residues in Nigerian estuarine environments

A Clinicopathological Review of Colonic Polyps in a Tertiary Hospital in North Central Nigeria

Background: Colorectal polyps, especially adenomas, are known as precursors of colorectal carcinomas. This study was aimed at determining the prevalence and histopathologic characteristics of colonic polyps among Nigerians that underwent colonoscopy at the University of Ilorin Teaching Hospital, Ilorin, Nigeria. The authors also determined the polyp detection rate and adenoma detection rate. Materials and Methods: This was a hospital-based cross-sectional study of all colonoscopy examinations performed at the University of Ilorin Teaching Hospital, Ilorin from March 2013 to September 2017. The endoscopy register was reviewed, and patients’ biodata, indications for colonoscopy and colonoscopic findings were recorded on a proforma. The histopathologic reports of the polyps were also retrieved and their diagnosis confirmed. Results: A total of 289 patients had colonoscopy carried out on them. The age of the patients ranged from 14 to 90 years with a mean ±SD of 57.0 ± 15.3 years and a median age of 58 years. There were 178 (61.6%) males and 111 (38.4%) females giving a M:F ratio of 1.6:1. The indications for colonoscopy were rectalbleeding 124 (42.9%); suspected colorectal cancer 67 (23.2%); abdominal pain 22 (7.6%); chronic diarrhea 18 (6.2%); surveillance colonoscopy 12 (4.2%); constipation 11 (3.8%); change in bowel habit 9 (3.1%); occult bleeding 6 (2.1%); others 20 (6.9%). Endoscopic findings were normal findings 89 (30.8%); hemorrhoids 88 (30.4%); colonic polyps 50 (17.3%); diverticulosis 34 (11.8%); rectal cancer 29 (10.0%); colon cancer 24 (8.3%); colitis 19 (6.6%); others 13 (4.5%). The findings were not mutually exclusive. The diagnostic yield was 69.2%. The overall polyp detection rate was 17.3%. Of the 50 patients with polyps, 33 (66.0%) were males (p = 0.481). Theadenoma detection rate was 4.8%. Conclusion: The authors conclude that their observed polyp detection rate is consistent with the estimated rates for Africa. Rectal bleeding and adenomatous polyps were the commonest presentation and histopathologic finding, respectively

An assessment of the levels of phthalate esters and metals in the Muledane open dump, Thohoyandou, Limpopo Province, South Africa

<p>Abstract</p> <p>Background</p> <p>This work reports the determination of the levels of phthalate esters (dimethyl phthalate (DMP), diethyl phthalate (DEP), dibutyl phthalate (DBP), diethyl hexyl phthalate (DEHP)) and metals (lead, cadmium, manganese, zinc, iron, calcium) in composite soil samples. The soil samples were collected randomly within the Muledane open dump, Thohoyandou, Limpopo province, South Africa. Control samples were collected about 200 m away from the open dump. The phthalate esters were separated and determined by capillary gas chromatography with a flame ionization detector, whilst the metals were determined by atomic absorption spectrophotometry.</p> <p>Results</p> <p>Open dump values for the phthalate esters and metals to be generally higher in comparison to control samples for DMP, DEP, DBP and DEHP – the mean values calculated were 0.31 ± 0.12, 0.21 ± 0.05, 0.30 ± 0.07, and 0.03 ± 0.01 mg/kg, respectively, for the open dump soil samples. Nonetheless, the mean open dump values for lead, cadmium, manganese, zinc, iron and calcium were 0.07 ± 0.04, 0.003 ± 0.001, 5.02 ± 1.92, 0.31 ± 0.02, 11.62 ± 9.48 and 0.12 ± 0.13 mg/kg, respectively. The results were compared statistically.</p> <p>Conclusion</p> <p>Our results revealed that the discarding of wastes into the open dump is a potential source of soil contamination in the immediate vicinity and beyond, <it>via </it>dispersal. Increased levels of phthalate esters and metals in the soil pose a risk to public health, plants and animals. Sustained monitoring of these contaminants is recommended, in addition to upgrading the facility to a landfill.</p

Clofibrate, a peroxisome proliferator–activated receptor-alpha (PPARα) agonist, and Its molecular mechanisms of action against sodium fluoride–induced toxicity

AVAILABILITY OF DATA AND MATERIALS : Data will be made available based on request from the corresponding author.Sodium fluoride (NaF) is one of the neglected environmental pollutants. It is ubiquitously found in the soil, water, and environment. Interestingly, fluoride has been extensively utilized for prevention of dental caries and tartar formation, and may be added to mouthwash, mouth rinse, and toothpastes. This study is aimed at mitigating fluoride-induced hypertension and nephrotoxicity with clofibrate, a peroxisome proliferator–activated receptor-alpha (PPARα) agonist. For this study, forty male Wistar rats were used and randomly grouped into ten rats per group, control, sodium fluoride (NaF; 300 ppm) only, NaF plus clofibrate (250 mg/kg) and NaF plus lisinopril (10 mg/kg), respectively, for 7 days. The administration of NaF was by drinking water ad libitum, while clofibrate and lisinopril were administered by oral gavage. Administration of NaF induced hypertension, and was accompanied with exaggerated oxidative stress; depletion of antioxidant defence system; reduced nitric oxide production; increased systolic, diastolic and mean arterial pressure; activation of angiotensin-converting enzyme activity and nuclear factor kappa-light-chain-enhancer of activated B cells (NF-κB); and testicular apoptosis. Treatment of rats with clofibrate reduced oxidative stress, improved antioxidant status, lowered high blood pressure through the inhibition of angiotensin-converting enzyme activity, mineralocorticoid receptor over-activation, and abrogated testicular apoptosis. Taken together, clofibrate could offer exceptional therapeutic benefit in mitigating toxicity associated with sodium fluoride.Cape Peninsula University of Technology and National Research Foundation (South Africa).https://link.springer.com/journal/12011hj2023Paraclinical Science