Avaluació de l'estàndard SQL : 1999 respecte les característiques orientades a l'objecte que suporta i la seva implementació als SGBD object-relational

L'objectiu és estudiar les característiques orientades a l'objecte de l'estàndard SQL: 1999 i posar-les a prova amb un producte comercial que les suporti.

Avaluació de SQL : 1999 respecte les característiques orientades a objectes que suporta i la seva implementació en sistemes de gestió de Bases de Dades

El treball realitzat analitza la manera com l'estàndard SQL:1999 ha incorporat a la seva especificació una sèrie de característiques pròpies de la tecnologia d'orientació a l'objecte. D'aquesta manera, l'estàndard mira de proporcionar als sistemes de gestió de bases de dades algunes de les funcionalitats exigides als sistemes de tercera generació. Aquests sistemes han d'incorporar altres característiques, que estan recollides a l'article Third Generation Database System Manifesto.

Incidence of presumed endophthalmitis after intravitreal injection performed in the operating room: a retrospective multicenter study.

PURPOSE: To evaluate the incidence of presumed endophthalmitis (EO) after intravitreal injection (IVI) of anti-vascular endothelial growth factor agents performed in the operating room. METHODS: Retrospective study at 2 Swiss eye hospitals between 2004 and 2012. Hospital records were used to identify patients treated with an IVI of an anti-vascular endothelial growth factor agent between 2004 and 2012 and those treated for EO, defined as any intraocular inflammation treated with intravitreal antibiotics. All IVIs were performed using standard sterile technique in a Swiss Class 1 operating room. No patient received preinjection topical antibiotics. Postinjection topical antibiotics were used only in one hospital. RESULTS: A total of 40,011 IVIs were performed at the 2 centers during the study period. Of the IVIs, ranibizumab was injected in 36,398 (91%), bevacizumab in 3,518 (9%), aflibercept in 89 (0.2%), and pegaptanib in 6 (<0.1%). Three cases of post-IVI presumed EO occurred, yielding a combined incidence of 0.0075% per injection (95% confidence interval: 0.0026-0.0220%) or 1 case per 13,337 IVIs. Two of the three cases of EO occurred in patients using post-IVI antibiotics. All three cases followed ranibizumab injection and were culture negative by anterior chamber tap or vitreous biopsy. CONCLUSION: The risk of EO after IVI performed under the sterile conditions of the operating room was very low.

Imaging of inflammatory and infectious lesions after injection of radioiodinated monoclonal anti-granulocytes antibodies.

Successful detection of inflammatory lesions by planar scintigraphy and SPECT after injection of iodine-123 labelled monoclonal antibodies directed against human granulocytes (123I-Mabgc) is demonstrated. This new tracer has been compared with indium-111 labelled white blood cells (111In-WBC) in selected patients with proven infectious lesions. Scans were equally positive in all cases, but the methodical advantages of the new marker were obvious, namely, there is no need for cell separation and the images of inflammatory lesions were better defined. In addition, SPECT could be performed with 123I-Mabgc and allowed a better anatomic localization and a three-dimensional description of the lesions. No adverse reactions have been seen. It is concluded, therefore, that 123I-Mabgc is a promising agent for the detection of acute focal inflammatory lesions which may, with advantages, replace 111In-WBC.

SQL-Server 2008 i les noves característiques espacials

La finalitat d'aquest treball és analitzar les noves característiques espacials que ofereix SQLServer 2008. A continuació, com cas pràctic, desenvolupar una aplicació per Windows Mobile on una sèrie de dispositius mòbils puguin indicar la seva ubicació i poder consultar en un mapa, mitjançant el servei en línia Google Maps, la ubicació de la resta de dispositius.

Desarrollo de una interfaz gráfica para la creación de sentencias SQL

Aquest treball tracta sobre la creació d'un projecte de programari lliure, portada a terme des del seu inici fins a la seva conversió, en un projecte que conta amb el suport d'una comunitat d'usuaris. Específicament, la finalitat del projecte de programari lliure generat, és la creació d'una aplicació que sigui capaç de guiar de forma gràfica, ràpida i intuïtiva a l'usuari a través del procés de creació de consultes SQL per a la base de dades postgreSQL.

A controlled trial of the benefits of ultrasound-guided steroid injection for shoulder pain.

OBJECTIVES: We studied the value of ultrasound (US) to define shoulder pathology and guide local steroid injection in comparison with a standard injection in the management of the acute painful shoulder. METHODS: Seventy consecutive patients with acute shoulder pain were assessed clinically and by US. Patients were randomized to receive either a standard subacromial infiltration of 7 mg of betamethasone or a US-guided injection according to the US diagnosis. Follow-up evaluations were performed by an independent assessor who was blinded to the results of the initial US and clinical assessments. RESULTS: Sixty-seven patients completed the study. Both groups showed a significant reduction in both daytime and night pain compared to baseline. The US injection group had significantly less pain at rest at 2 and 6 weeks (NRS: 1.6 vs 3.3, P<0.005; 3 vs 4.2, P<0.04). The percentage of good responders was significantly higher in US group at 2 weeks, (81% vs 54%, P<0.005) and 6 weeks (64% vs 38%, P<0.05). At 2 and 6 weeks, responder rate and activity pain scores as well as Constant score were in favour of US, though did not reach statistical significance. CONCLUSION: Local steroid injection for shoulder pain leads to significant improvements in pain and function for up to 12 weeks. An US examination to define the origin of shoulder pain as well as to guide injection provides significant additional benefits for up to 6 weeks. We recommend routine US examination as part of the management of acute shoulder pain.

Intracoronary injection of bone marrow-derived mononuclear cells early or late after acute myocardial infarction: effects on global left ventricular function.

BACKGROUND: Intracoronary administration of autologous bone marrow-derived mononuclear cells (BM-MNC) may improve remodeling of the left ventricle (LV) after acute myocardial infarction. The optimal time point of administration of BM-MNC is still uncertain and has rarely been addressed prospectively in randomized clinical trials. METHODS AND RESULTS: In a multicenter study, we randomized 200 patients with large, successfully reperfused ST-segment elevation myocardial infarction in a 1:1:1 pattern into an open-labeled control and 2 BM-MNC treatment groups. In the BM-MNC groups, cells were administered either early (ie, 5 to 7 days) or late (ie, 3 to 4 weeks) after acute myocardial infarction. Cardiac magnetic resonance imaging was performed at baseline and after 4 months. The primary end point was the change from baseline to 4 months in global LV ejection fraction between the 2 treatment groups and the control group. The absolute change in LV ejection fraction from baseline to 4 months was -0.4±8.8% (mean±SD; P=0.74 versus baseline) in the control group, 1.8±8.4% (P=0.12 versus baseline) in the early group, and 0.8±7.6% (P=0.45 versus baseline) in the late group. The treatment effect of BM-MNC as estimated by ANCOVA was 1.25 (95% confidence interval, -1.83 to 4.32; P=0.42) for the early therapy group and 0.55 (95% confidence interval, -2.61 to 3.71; P=0.73) for the late therapy group. CONCLUSIONS: Among patients with ST-segment elevation myocardial infarction and LV dysfunction after successful reperfusion, intracoronary infusion of BM-MNC at either 5 to 7 days or 3 to 4 weeks after acute myocardial infarction did not improve LV function at 4-month follow-up. CLINICAL TRIAL REGISTRATION: URL: http://www.clinicaltrials.gov. Unique identifier: NCT00355186.

Single-injection or continuous femoral nerve block for total knee arthroplasty?

BACKGROUND: The ideal local anesthetic regime for femoral nerve block that balances analgesia with mobility after total knee arthroplasty (TKA) remains undefined. QUESTIONS/PURPOSES: We compared two volumes and concentrations of a fixed dose of ropivacaine for continuous femoral nerve block after TKA to a single injection femoral nerve block with ropivacaine to determine (1) time to discharge readiness; (2) early pain scores and analgesic consumption; and (3) functional outcomes, including range of motion and WOMAC scores at the time of recovery. METHODS: Ninety-nine patients were allocated to one of three continuous femoral nerve block groups for this randomized, placebo-controlled, double-blind trial: a high concentration group (ropivacaine 0.2% infusion), a low concentration group (ropivacaine 0.1% infusion), or a placebo infusion group (saline 0.9% infusion). Infusions were discontinued on postoperative Day (POD) 2. The primary outcome was time to discharge readiness. Secondary outcomes included opioid consumption, pain, and functional outcomes. Ninety-three patients completed the study protocol; the study was halted early because of unanticipated changes to pain protocols at the host institution, by which time only 61% of the required number of patients had been enrolled. RESULTS: With the numbers available, the mean time to discharge readiness was not different between groups (high concentration group, 62 hours [95% confidence interval [CI], 51-72 hours]; low concentration group, 73 hours [95% CI, 63-83 hours]; placebo infusion group 65 hours [95% CI, 56-75 hours]; p = 0.27). Patients in the low concentration group consumed significantly less morphine during the period of infusion (POD 1, high concentration group, 56 mg [95% CI, 42-70 mg]; low concentration group, 35 mg [95% CI, 27-43 mg]; placebo infusion group, 48 mg [95% CI, 38-59 mg], p = 0.02; POD 2, high concentration group, 50 mg [95% CI, 41-60 mg]; low concentration group, 33 mg [95% CI, 24-42 mg]; placebo infusion group, 39 mg [95% CI, 30-48 mg], p = 0.04); however, there were no important differences in pain scores or opioid-related side effects with the numbers available. Likewise, there were no important differences in functional outcomes between groups. CONCLUSIONS: Based on this study, which was terminated prematurely before the desired sample size could be achieved, we were unable to demonstrate that varying the concentration and volume of a fixed-dose ropivacaine infusion for continuous femoral nerve block influences time to discharge readiness when compared with a conventional single-injection femoral nerve block after TKA. A low concentration of ropivacaine infusion can reduce postoperative opioid consumption but without any important differences in pain scores, side effects, or functional outcomes. These pilot data may be used to inform the statistical power of future randomized trials. LEVEL OF EVIDENCE: Level II, therapeutic study. See Guidelines for Authors for a complete description of levels of evidence.

A pilot study of delayed versus immediate serial casting after botulinum toxin injection for partially reducible spastic equinus.

BACKGROUND: Serial casting is often prescribed after botulinum toxin injections to improve joint ranges of motion and to potentiate the decrease in hypertonia. The aim of this study was to compare delayed versus immediate serial casting as an adjunct to botulinum toxin therapy for partially reducible spastic equinus. METHODS: Twelve children who presented spastic equinus associated with mild gastrosoleus contracture took part. Five of them had a diagnosis of spastic diplegia, whereas 7 had a diagnosis of congenital hemiplegia. Children were randomized to immediate serial casting (same day) or delayed serial casting (4 weeks later) after botulinum toxin injection to their gastrosolei. Casts were replaced weekly for 3 weeks. RESULTS: Three children complained of pain that required recasting in the immediate casting group versus none in the delayed casting group (P = 0.08). At 3 months, there was a 27-degree improvement in the fast dorsiflexion angle (Tardieu R1) in the delayed casting group versus 17 degrees in the immediate casting group (P = 0.029). At 6 months, a 19-degree improvement persisted in the delayed group compared with 11 degrees in the immediate group (P = 0.010). CONCLUSIONS: There is a clear benefit in delaying serial casting after the injection of botulinum toxin in the recurrence of spasticity at the gastrosoleus that may also offer an advantage regarding the incidence of painful episodes associated with casting. Most importantly, reducing the recurrence of spasticity by delayed serial casting may offer the possibility of decreasing the frequency of botulinum toxin reinjections.

Estimating national-level syringe availability to injecting drug users and injection coverage: Switzerland, 1996-2006.

BACKGROUND: Measuring syringe availability and coverage is essential in the assessment of HIV/AIDS risk reduction policies. Estimates of syringe availability and coverage were produced for the years 1996 and 2006, based on all relevant available national-level aggregated data from published sources. METHODS: We defined availability as the total monthly number of syringes provided by harm reduction system divided by the estimated number of injecting drug users (IDU), and defined coverage as the proportion of injections performed with a new syringe, at national level (total supply over total demand). Estimates of supply of syringes were derived from the national monitoring system, including needle and syringe programmes (NSP), pharmacies, and medically prescribed heroin programmes. Estimates of syringe demand were based on the number of injections performed by IDU derived from surveys of low threshold facilities for drug users (LTF) with NSP combined with the number of IDU. This number was estimated by two methods combining estimates of heroin users (multiple estimation method) and (a) the number of IDU in methadone treatment (MT) (non-injectors) or (b) the proportion of injectors amongst LTF attendees. Central estimates and ranges were obtained for availability and coverage. RESULTS: The estimated number of IDU decreased markedly according to both methods. The MT-based method (from 14,818 to 4809) showed a much greater decrease and smaller size of the IDU population compared to the LTF-based method (from 24,510 to 12,320). Availability and coverage estimates are higher with the MT-based method. For 1996, central estimates of syringe availability were 30.5 and 18.4 per IDU per month; for 2006, they were 76.5 and 29.9. There were 4 central estimates of coverage. For 1996 they ranged from 24.3% to 43.3%, and for 2006, from 50.5% to 134.3%. CONCLUSION: Although 2006 estimates overlap 1996 estimates, the results suggest a shift to improved syringe availability and coverage over time.

AlcoNQL : Herramienta de consulta SQL por medio de lenguaje natural

Herramienta de transformación de sentencias en lenguaje natural en consultas SQL, realización de peticiones a la base de datos y muestra de los resultados.

Time of injection determines the effect of alpha-MSH antiserum on DA neurons in psychological stress

Male rats were subjected to "psychological stress" which consisted in 10 sec footshock on the first day followed 24 hr later by a 10 sec stay in the experimental chamber without shock. Intravenous antiserum against alpha-MSH markedly changed the functional state of mesencephalic and hypothalamic DA neurons (assessed by histochemical microfluorimetry) when administered before the second session but not when given before the first session. These observations reveal an interesting parallelism in the temporal characteristics of the effects of alpha-MSH on avoidance behavior and central DA systems.

Management of corn stalk waste as reinforcement for polypropylene injection moulded composites

The main objective of this study was the management of corn stalk waste as reinforcement for polypropylene (PP) injection moulded composites as an alternative to wood flour and fibers. In the first step, corn stalk waste was subjected to various treatments, and four different corn stalk derivatives (flour and fibers) able to be used as reinforcement of composite materials were prepared and characterized. These derivatives are corn stalk flour, thermo-mechanical, semi-chemical, and chemical fibers. They were characterized in terms of their yield, lignin content, Kappa number, fiber length/diameter ratio, fines, coarseness, viscosity, and the length at the break of a standard sheet of paper. Results showed that the corn stalk derivatives have different physico-chemical properties. In the second step, the prepared flour and fibers were explored as a reinforcing element for PP composites. Coupled and non-coupled PP composites were prepared and tested for tensile properties. For overall trend, with the addition of a coupling agent, tensile properties of composites significantly improved, as compared with non-coupled samples. In addition, a morphological study revealed the positive effect of the coupling agent on the interfacial bonding. The composites prepared with semichemical fiber gave better results in comparison with the rest of the corn stalk derivatives due to its chemical characteristics