Database-backed library web sites: a case study of the use of PHP and MySQL at the University of Nottingham

This paper discusses the advantages of database-backed websites and describes the model for a library website implemented at the University of Nottingham using open source software, PHP and MySQL. As websites continue to grow in size and complexity it becomes increasingly important to introduce automation to help manage them. It is suggested that a database-backed website offers many advantages over one built from static HTML pages. These include a consistency of style and content, the ability to present different views of the same data, devolved editing and enhanced security. The University of Nottingham Library Services website is described and issues surrounding its design, technological implementation and management are explored.

Aplicación Web para la Comercialización y Administración de la Asociación Cooperativa de Producción Pesquera y Servicios Múltiples “Bocana Lempa - Jaltepec de R.L”, en el Cantón Las Mesas del Municipio de Tecoluca del Departamento de San Vicente.

El trabajo de graduación describe el desarrollo de una Aplicación web desarrollada para la Asociación cooperativa de producción pesquera y servicios múltiples “Bocana Lempa - Jaltepec de R.L”, en el Cantón las Mesas del municipio de Tecoluca del departamento de San Vicente, con dicha aplicación se automatizaron los procesos de las áreas de comercialización y administración de la cooperativa, los cuales son, Activo fijo, Recursos Humanos, Facturación, Inventario y el desarrollo de una página web a la que accesan los clientes para la realización de pedidos. Con el desarrollo de dicha aplicación se ha obtenido una mayor agilización en los procesos, los cuales conllevan a adquirir mayores logros entre los cuales podemos mencionar: información detallada de los movimientos de inventario, presentación de informes, mejoras en el control de activo fijo, salarios, vacaciones, permisos de los empleados, registro de pedidos realizados desde la página web, impresión de facturas y la reducción del tiempo en el desarrollo de los procesos. SUMMARY The graduation work describes the development of a web application developed for the cooperative association of fish production and multiple services "Bocana Lempa - Jaltepec RL" in the Canton Tables Township Tecoluca the department of San Vicente, with such application they automated processes as the marketing and administration of the cooperative, which are, fixed Assets, Human Resources, Billing, Inventory and development of a website that access to customers for ordering. With the development of this application has gained greater streamlining processes, which lead to acquire greater achievements among which include: detailed information on inventory movements, reporting, improved control of fixed assets, wages holidays, permits employees record orders made from the website, print invoices and time reduction in development processes. Keywords : Online ordering , fixed assets, payroll employees , billing, control fishing. The graduation work describes the development of a web application developed for the cooperative association of fish production and multiple services "Bocana Lempa - Jaltepec RL" in the Canton Tables Township Tecoluca the department of San Vicente, with such application they automated processes as the marketing and administration of the cooperative, which are, fixed Assets, Human Resources, Billing, Inventory and development of a website that access to customers for ordering. With the development of this application has gained greater streamlining processes, which lead to acquire greater achievements among which include: detailed information on inventory movements, reporting, improved control of fixed assets, wages holidays, permits employees record orders made from the website, print invoices and time reduction in development processes.

Enterprise Collaboration Framework for Managing, Advancing and Unifying the Functionality of Multiple Cloud-Based Services with the Help of a Graph API

Part 5: Service Orientation in Collaborative Networks

2007-2008 Juvenile Court Services School Liaison Program Data, July 2008

Data are provided to CJJP through statistical summary forms completed by the JCSLs. Because forms are completed only when meaningful contact between a student and a liaison takes place, only a portion of the total population served is reported. Meaningful contact is defined as having at least five contacts within a 60-day period (at any point during the academic year) regarding at least one of the referral reasons supplied on the form. Data are entered into a web-based application by the liaisons and retrieved electronically by CJJP via the internet. Service information is submitted and uploaded only at the end of the academic year.

2010-2011 Juvenile Court Services School Liaison Program Data, July 2011

Data are provided to CJJP through statistical summary forms completed by the JCSLs. Because forms are completed only when meaningful contact between a student and a liaison takes place, only a portion of the total population served is reported. Meaningful contact is defined as having at least five contacts within a 60-day period (at any point during the academic year) regarding at least one of the referral reasons supplied on the form. Data are entered into a web-based application by the liaisons and retrieved electronically by CJJP via the internet. Service information is submitted and uploaded only at the end of the academic year.

2012-2013 Juvenile Court Services School Liaison Program Data, July 2013

Data are provided to CJJP through statistical summary forms completed by the JCSLs. Because forms are completed only when meaningful contact between a student and a liaison takes place, only a portion of the total population served is reported. Meaningful contact is defined as having at least five contacts within a 60-day period (at any point during the academic year) regarding at least one of the referral reasons supplied on the form. Data are entered into a web-based application by the liaisons and retrieved electronically by CJJP via the internet. Service information is submitted and uploaded only at the end of the academic year.

Iis--integrated Interactome System: A Web-based Platform For The Annotation, Analysis And Visualization Of Protein-metabolite-gene-drug Interactions By Integrating A Variety Of Data Sources And Tools.

High-throughput screening of physical, genetic and chemical-genetic interactions brings important perspectives in the Systems Biology field, as the analysis of these interactions provides new insights into protein/gene function, cellular metabolic variations and the validation of therapeutic targets and drug design. However, such analysis depends on a pipeline connecting different tools that can automatically integrate data from diverse sources and result in a more comprehensive dataset that can be properly interpreted. We describe here the Integrated Interactome System (IIS), an integrative platform with a web-based interface for the annotation, analysis and visualization of the interaction profiles of proteins/genes, metabolites and drugs of interest. IIS works in four connected modules: (i) Submission module, which receives raw data derived from Sanger sequencing (e.g. two-hybrid system); (ii) Search module, which enables the user to search for the processed reads to be assembled into contigs/singlets, or for lists of proteins/genes, metabolites and drugs of interest, and add them to the project; (iii) Annotation module, which assigns annotations from several databases for the contigs/singlets or lists of proteins/genes, generating tables with automatic annotation that can be manually curated; and (iv) Interactome module, which maps the contigs/singlets or the uploaded lists to entries in our integrated database, building networks that gather novel identified interactions, protein and metabolite expression/concentration levels, subcellular localization and computed topological metrics, GO biological processes and KEGG pathways enrichment. This module generates a XGMML file that can be imported into Cytoscape or be visualized directly on the web. We have developed IIS by the integration of diverse databases following the need of appropriate tools for a systematic analysis of physical, genetic and chemical-genetic interactions. IIS was validated with yeast two-hybrid, proteomics and metabolomics datasets, but it is also extendable to other datasets. IIS is freely available online at: http://www.lge.ibi.unicamp.br/lnbio/IIS/.

Effect Of Composite Containing An Iodonium Salt On The Bond Strength Of Brackets To Bovine Enamel.

This study investigated the effect of the incorporation of an iodonium salt in experimental composites, on the bond strength of metallic brackets bonded to bovine teeth. Two hundred and seventy bovine teeth were embedded in self-curing acrylic resin and divided into 18 groups (n=15), according to the experimental composite with an iodonium salt at molar concentrations 0 (control), 0.5, or 1%; the light-activation times (8, 20 and 40 s); and the storage times (10 min or 24 h). Metallic brackets were fixed on the tooth surface using experimental composites. Photoactivation was performed with a quartz-tungsten-halogen light-curing unit curing unit for 8, 20 and 40 s. The specimens were stored in distilled water at 37 °C for 10 min or 24 h and submitted to bond strength test at 0.5 mm/min. The data were subjected to three-way ANOVA and Tukey's test (α=0.05). The Adhesive Remnant Index (ARI) was used to classify the failure modes. The shear bond strengths (MPa) at 10 min for light-activation times of 8, 20 and 40 s were: G1 - 4.6, 6.9 and 7.1; G2 - 8.1, 9.2 and 9.9; G3 - 9.1, 10.4 and 10.7; and at 24 h were: G1 - 10.9, 11.1 and 11.7; G2 - 11.8, 12.7 and 14.2; G3 - 12.1, 14.4 and 15.8. There was a predominance of ARI score 3 for groups with 10 min storage time, and ARI score 2 for groups with 24 h storage time. In conclusion, the addition of iodonium salt (C05 and C1) to the experimental composite may increase the bond strength of brackets to bovine enamel using reduced light exposure times.

[access To Basic Health Services And Associated Factors: A Population-based Study].

This study sought to identify factors involved in access to the services of a basic health unit. It is a cross-sectional, population-based study involving 101 randomly-selected families residing in the area covered by the health unit. An adult resident of each household was interviewed. The response variable was whether or not the resident frequented the health unit if he/she or anyone in the family required assistance to resolve a health issue. The independent variables investigated were service provision aspects, demographic and socio-economic characteristics, individual habits, morbidities and use of the health unit. In addition to descriptive and univariate analysis, logistic regression was applied in the multivariate analysis. The results show that access to the basic health unit is associated with the treatment received previously (OR = 3,224) with accessibility (OR = 0,146) and micro-area of residence (OR = 10,918). These findings suggest that access is related to the impressions created by the care received at the health unit and is based on experiences with the service, but can also be strongly modulated by individual aspects and factors related to the territory.

Influence Of Successive Light-activation On Degree Of Conversion And Knoop Hardness Of The First Layered Composite Increment.

To evaluate the influence of light-activation of second, third and fourth increments on degree of conversion (DC) and microhardness (KHN) of the top (T) and bottom (B) surface of the first increment. Forty samples (n = 5) were prepared. In groups 1-4, after each increment light-activation (multiple irradiation), T and B of the first increment were measured in DC and KHN. In groups 5-8, only the first increment was made (single irradiation) and measurements of DC and KHN were taken at 15 min intervals. The light-activation modes were (XL) 500 mW/cm(2) × 38 s (G1/G5); (S) 1000 mW/cm(2) × 19 s (G2/G6), (HP) 1400 mW/cm(2) × 14 s (G3/G7); (PE) 3200 mW/cm(2) × 6 s (G4/G8). Data for DC and KHN were analyzed separately by using PROC MIXED for repeated measures and Tukey-Kramer test (α = 0.05). For KHN, B showed lower values than T. PE resulted in lower values of KHN in B surface. For single and multiple irradiations, T and B of first measurement showed the lowest KHN and the fourth measurement showed the highest, with significant difference between them. For single irradiation, first and second increments presented similar KHN, different from the third and fourth increment, which did not differ between them. For multiple irradiations, the second light-activation resulted in KHN similar to first, third and fourth increments. For DC, except QTH, T presented higher DC than B. The light-activation of successive increments was not able to influence the KHN and DC of the first increment.

Fracture resistance of weakened roots restored with composite resin and glass fiber post

This study evaluated the fracture resistance of weakened roots restored with glass fiber posts, composite resin cores and complete metal crowns. Thirty maxillary canines were randomly divided into 3 groups of 10 teeth each: teeth without weakened roots (control); teeth with partially weakened roots (PWR) and teeth with and largely weakened roots (LWR). The control group was restored with glass fiber posts and a composite resin core. Teeth in the PWR and LWR groups were flared internally to standardized dimensions in order to simulate root weakness. Thereafter, the roots were partially filled with composite resin and restored in the same way as in the control group. The specimens were exposed to 250,000 cycles in a controlled chewing simulator. All intact specimens were subjected to a static load (N) in a universal testing machine at 45 degrees to the long axis of the tooth until failure. Data were analyzed by one-way ANOVA and Dunnett's test for multiple comparisons (p=0.05). There were statistically significant difference differences (p<0.01) among the groups (control group = 566.73 N; PWR = 409.64 N; and LWR = 410.91 N), with significantly higher fracture strength for the control group. There was no statistically significant difference (p>0.05) between the weakened groups. The results of this study showed that thicker root dentin walls significantly increase the fracture resistance of endodontically treated teeth.

Effects of light-curing time on the cytotoxicity of a restorative composite resin on odontoblast-like cells

This in vitro study evaluated the cytotoxicity of an experimental restorative composite resin subjected to different light-curing regimens. METHODS: Forty round-shaped specimens were prepared and randomly assigned to four experimental groups (n=10), as follows: in Group 1, no light-curing; in Groups 2, 3 and 4, the composite resin specimens were light-cured for 20, 40 or 60 s, respectively. In Group 5, filter paper discs soaked in 5 µL PBS were used as negative controls. The resin specimens and paper discs were placed in wells of 24-well plates in which the odontoblast-like cells MDPC-23 (30,000 cells/cm²) were plated and incubated in a humidified incubator with 5% CO2 and 95% air at 37ºC for 72 h. The cytotoxicity was evaluated by the cell metabolism (MTT assay) and cell morphology (SEM). The data were analyzed statistically by Kruskal-Wallis and Mann-Whitney tests (p<0.05). RESULTS: In G1, cell metabolism decreased by 86.2%, indicating a severe cytotoxicity of the non-light-cured composite resin. On the other hand, cell metabolism decreased by only 13.3% and 13.5% in G2 and G3, respectively. No cytotoxic effects were observed in G4 and G5. In G1, only a few round-shaped cells with short processes on their cytoplasmic membrane were observed. In the other experimental groups as well as in control group, a number of spindle-shaped cells with long cytoplasmic processes were found. CONCLUSION: Regardless of the photoactivation time used in the present investigation, the experimental composite resin presented mild to no toxic effects to the odontoblast-like MDPC-23 cells. However, intense cytotoxic effects occurred when no light-curing was performed.

Effect of deproteinization and tubular occlusion on microtensile bond strength and marginal microleakage of resin composite restorations

Dentin adhesion procedure presents limitations, especially regarding to lifetime stability of formed hybrid layer. Alternative procedures have been studied in order to improve adhesion to dentin. OBJECTIVE: The aim of this study was to evaluate in vitro the influence of deproteinization or dentin tubular occlusion, as well as the combination of both techniques, on microtensile bond strength (µTBS) and marginal microleakage of composite resin restorations. MATERIAL AND METHODS: Extracted erupted human third molars were randomly divided into 4 groups. Dentin surfaces were treated with one of the following procedures: (A) 35% phosphoric acid gel (PA) + adhesive system (AS); (B) PA + 10% NaOCl + AS; (C) PA + oxalate + AS and (D) PA + oxalate + 10% NaOCl + AS. Bond strength data were analyzed statistically by two-way ANOVA and Tukey's test. The microleakage scores were analyzed using Kruskal-Wallis and Mann-Whitney non-parametric tests. Significance level was set at 0.05 for all analyses. RESULTS: µTBS data presented statistically lower values for groups D and B, ranking data as A>C>B>D. The use of oxalic acid resulted in microleakage reduction along the tooth/restoration interface, being significant when used alone. On the other hand, the use of 10% NaOCl alone or in combination with oxalic acid, resulted in increased microleakage. CONCLUSIONS: Dentin deproteinization with 10% NaOCl or in combination with oxalate significantly compromised both the adhesive bond strength and the microleakage at interface. Tubular occlusion prior to adhesive system application seems to be a useful technique to reduce marginal microleakage.

Abrasion wear resistance of different artificial teeth opposed to metal and composite antagonists

One of the most important properties of artificial teeth is the abrasion wear resistance, which is determinant in the maintenance of the rehabilitation's occlusal pattern. OBJECTIVES: This in vitro study aims to evaluate the abrasion wear resistance of 7 brands of artificial teeth opposed to two types of antagonists. MATERIAL AND METHODS: Seven groups were prepared with 12 specimens each (BIOLUX & BL, TRILUX & TR, BLUE DENT & BD, BIOCLER & BC, POSTARIS & PO, ORTHOSIT & OR, GNATHOSTAR & GN), opposed to metallic (M & nickel-chromium alloy), and to composite antagonists (C & Solidex indirect composite). A mechanical loading device was used (240 cycles/min, 4 Hz speed, 10 mm antagonist course). Initial and final contours of each specimen were registered with aid of a profile projector (20x magnification). The linear difference between the two profiles was measured and the registered values were subjected to ANOVA and Tukey's test. RESULTS: Regarding the antagonists, only OR (M = 10.45 ± 1.42 µm and C = 2.77 ± 0.69 µm) and BC (M = 6.70 ± 1.37 µm and C = 4.48 ± 0.80 µm) presented statistically significant differences (p < 0.05). Best results were obtained with PO (C = 2.33 ± 0.91 µm and M = 1.78 ± 0.42 µm), followed by BL (C = 3.70 ± 1.32 µm and M = 3.70 ± 0.61 µm), statistically similar for both antagonists (p>0.05). Greater result variance was obtained with OR, which presented the worse results opposed to Ni-Cr (10.45 ± 1.42 µm), and results similar to the best ones against composite (2.77 ± 0.69 µm). CONCLUSIONS: Within the limitations of this study, it may be concluded that the antagonist material is a factor of major importance to be considered in the choice of the artificial teeth to be used in the prosthesis.

Effect of laser welding on the titanium composite tensile bond strength

The aim of this study was to analyze the shear bond strength between commercially pure titanium, with and without laser welding, after airbone-particle abrasion (Al2O3) and 2 indirect composites. Sixty-four specimens were cast and divided into 2 groups with and without laser welding. Each group was divided in 4 subgroups, related to Al2O3 grain size: A - 250 µm; B - 180 µm; C- 110 µm; and D - 50 µm. Composite rings were formed around the rods and light polymerized using UniXS unit. Specimens were invested and their shear bond strength at failure was measured with a universal testing machine at a crosshead speed of 2.0 mm/min. Statistical analysis was carried out with ANOVA and Tukey's test (α=0.05). The highest bond strength means were recorded in 250 µm group without laser welding. The lowest shear bond strength means were recorded in 50 µm group with laser welding. Statistically significant differences (p<0.05) were found between all groups. In conclusion, airborne particle abrasion yielded significantly lower bond strength as the Al2O3 particle size decreased. Shear bond strength decreased in the laser welded specimens.