Designing data warehouses for geographic OLAP querying by using MDA

Data aggregation in Geographic Information Systems (GIS) is a desirable feature, spatial data are integrated in OLAP engines for this purpose. However, the development and operation of those systems is still a complex task due to methodologies followed. There are some ad hoc solutions that deal only with isolated aspects and do not provide developer and analyst with an intuitive, integrated and standard framework for designing all relevant parts. To overcome these problems, we have defined a model driven approach to accomplish Geographic Data Warehouse (GDW) development. Then, we have defined a data model required to implement and query spatial data. Its modeling is defined and implemented by using an extension of UML metamodel and it is also formalized by using OCL language. In addition, the proposal has been verified against a example scenario with sample data sets. For this purpose, we have accomplished a developing tool based on Eclipse platform and MDA standard. The great advantage of this solution is that developers can directly include spatial data at conceptual level, while decision makers can also conceptually make geographic queries without being aware of logical details.This work has been partially supported by the ESPIA project (TIN2007-67078) from the Spanish Ministry of Education and Science and by the QUASIMODO project (PAC08-0157-0668) from the Castilla-La Mancha Ministry of Education and Science (Spain). Octavio Glorio is funded by the University of Alicante under the 11th Latin American grant program

Current HHT genetic overview in Spain and its phenotypic correlation: Data from RiHHTa registry

Background: Hereditary hemorrhagic telangiectasia (HHT) is a rare vascular disease with autosomal dominant inheritance. Disease-causing variants in endoglin (ENG) and activin A receptor type II-like 1 (ACVRL1) genes are detected in more than 90% of cases submitted to molecular diagnosis. Methods: We used data from the RiHHTa (Computerized Registry of Hereditary Hemorrhagic Telangiectasia) registry to describe genetic variants and to assess their genotype-phenotype correlation among HHT patients in Spain. Results: By May 2019, 215 patients were included in the RiHHTa registry with a mean age of 52.5 ± 16.5 years and 136 (63.3%) were women. Definitive HHT diagnosis defined by the Curaca¸o criteria were met by 172 (80%) patients. Among 113 patients with genetic test, 77 (68.1%) showed a genetic variant in ACVRL1 and 36 (31.8%) in ENG gene. The identified genetic variants in ACVRL1 and ENG genes and their clinical significance are provided. ACVRL1 mutations were more frequently nonsense (50%) while ENG mutations were more frequently, frameshift (39.1%). ENG patients were significantly younger at diagnosis (36.9 vs 45.7 years) and had pulmonary arteriovenous malformations (AVMs) (71.4% vs 24.4%) and cerebral AVMs (17.6% vs 2%) more often than patients with ACVRL1 variants. Patients with ACVRL1 variants had a higher cardiac index (2.62 vs 3.46), higher levels of hepatic functional blood tests, and anemia (28.5% vs 56.7%) more often than ENG patients. Conclusions: ACVRL1 variants are more frequent than ENG in Spain. ACVRL1 patients developed symptomatic liver disease and anemia more often than ENG patients. Compared to ACVRL1, those with ENG variants are younger at diagnosis and show pulmonary and cerebral AVMs more frequently

Bridging the accessibility gap in Open Educational Resources

Open Educational Resources (OER) are being fostered as a global movement for providing educational opportunities to all. However, people with disabilities are still excluded from full participation because of the lack of accessibility of OER websites, as well as of the resources themselves. This work presents a proposal for the design of OER websites that would enable equitable access for all users. This design aims to bridge the accessibility gap through the personalization of the whole OER environment to facilitate an accessible User Experience (UX) based on a user profile that includes the self-identification of disability status. This profile configures not only the “look and feel” of the interface but also the delivery of educational resources suitable for this user profile. To achieve this purpose, the design goes beyond compliance with the ISO/IEC 40500 W3C Web Content Accessibility Guidelines (WCAG) 2.0, since it includes the personalization of the accessible experience through usability considerations and adaptations of educational resources. The delivery of educational resources matches the user’s profile with regard to their sensory abilities, cognitive faculties and their requirements of functionality control, display layout and language. As a proof of concept, we have developed an OER website based on this design and have conducted a set of UX tests that include users with different disabilities. The test results confirm the feasibility and suitability of our design regarding accessible UX. Finally, the contribution of this document arises from the explicit recognition of the particular needs associated with the disability profiles to establish the response of the entire OER system which enables a truly inclusive experience by exempting the user from performing configuration tasks

A922 Sequential measurement of 1 hour creatinine clearance (1-CRCL) in critically ill patients at risk of acute kidney injury (AKI)

Meeting abstrac

The management of acute venous thromboembolism in clinical practice. Results from the European PREFER in VTE Registry

Venous thromboembolism (VTE) is a significant cause of morbidity and mortality in Europe. Data from real-world registries are necessary, as clinical trials do not represent the full spectrum of VTE patients seen in clinical practice. We aimed to document the epidemiology, management and outcomes of VTE using data from a large, observational database. PREFER in VTE was an international, non-interventional disease registry conducted between January 2013 and July 2015 in primary and secondary care across seven European countries. Consecutive patients with acute VTE were documented and followed up over 12 months. PREFER in VTE included 3,455 patients with a mean age of 60.8 ± 17.0 years. Overall, 53.0 % were male. The majority of patients were assessed in the hospital setting as inpatients or outpatients (78.5 %). The diagnosis was deep-vein thrombosis (DVT) in 59.5 % and pulmonary embolism (PE) in 40.5 %. The most common comorbidities were the various types of cardiovascular disease (excluding hypertension; 45.5 %), hypertension (42.3 %) and dyslipidaemia (21.1 %). Following the index VTE, a large proportion of patients received initial therapy with heparin (73.2 %), almost half received a vitamin K antagonist (48.7 %) and nearly a quarter received a DOAC (24.5 %). Almost a quarter of all presentations were for recurrent VTE, with >80 % of previous episodes having occurred more than 12 months prior to baseline. In conclusion, PREFER in VTE has provided contemporary insights into VTE patients and their real-world management, including their baseline characteristics, risk factors, disease history, symptoms and signs, initial therapy and outcomes

Evolution of the use of corticosteroids for the treatment of hospitalised COVID-19 patients in Spain between March and November 2020: SEMI-COVID national registry

Objectives: Since the results of the RECOVERY trial, WHO recommendations about the use of corticosteroids (CTs) in COVID-19 have changed. The aim of the study is to analyse the evolutive use of CTs in Spain during the pandemic to assess the potential influence of new recommendations. Material and methods: A retrospective, descriptive, and observational study was conducted on adults hospitalised due to COVID-19 in Spain who were included in the SEMI-COVID- 19 Registry from March to November 2020. Results: CTs were used in 6053 (36.21%) of the included patients. The patients were older (mean (SD)) (69.6 (14.6) vs. 66.0 (16.8) years; p < 0.001), with hypertension (57.0% vs. 47.7%; p < 0.001), obesity (26.4% vs. 19.3%; p < 0.0001), and multimorbidity prevalence (20.6% vs. 16.1%; p < 0.001). These patients had higher values (mean (95% CI)) of C-reactive protein (CRP) (86 (32.7-160) vs. 49.3 (16-109) mg/dL; p < 0.001), ferritin (791 (393-1534) vs. 470 (236- 996) µg/dL; p < 0.001), D dimer (750 (430-1400) vs. 617 (345-1180) µg/dL; p < 0.001), and lower Sp02/Fi02 (266 (91.1) vs. 301 (101); p < 0.001). Since June 2020, there was an increment in the use of CTs (March vs. September; p < 0.001). Overall, 20% did not receive steroids, and 40% received less than 200 mg accumulated prednisone equivalent dose (APED). Severe patients are treated with higher doses. The mortality benefit was observed in patients with oxygen saturation </=90%. Conclusions: Patients with greater comorbidity, severity, and inflammatory markers were those treated with CTs. In severe patients, there is a trend towards the use of higher doses. The mortality benefit was observed in patients with oxygen saturation </=90%

Data Mapping Diagrams for Data Warehouse Design with UML

In Data Warehouse (DW) scenarios, ETL (Extraction, Transformation, Loading) processes are responsible for the extraction of data from heterogeneous operational data sources, their transformation (conversion, cleaning, normalization, etc.) and their loading into the DW. In this paper, we present a framework for the design of the DW back-stage (and the respective ETL processes) based on the key observation that this task fundamentally involves dealing with the specificities of information at very low levels of granularity including transformation rules at the attribute level. Specifically, we present a disciplined framework for the modeling of the relationships between sources and targets in di#erent levels of granularity (including coarse mappings at the database and table levels to detailed inter-attribute mappings at the attribute level)

Accessibility of university websites worldwide: a systematic literature review

[eng] The identity and institutional image of universities are presented to the world through their websites. On their websites, universities publish their academic offerings, their mission, their vision, their academic objectives, their achievements, their regulations, their news, and all their university work. Hence, the importance of university websites is accessible. The accessibility of university websites has been evaluated several times in the past, but there is no work that has summarized all the evaluations performed to provide a general overview of the situation. Therefore, in this research, we have performed a systematic literature review (SLR) to consolidate, analyze, synthesize and interpret the accessibility results of university websites published in 42 papers that have been selected for this study. The methodology used in this SLR was that proposed in Kitchenham's guidelines, which includes three stages: planning the review, conducting the review, and reporting the review. The results present the analysis and synthesis of the evaluations of 9,140 universities in 67 countries. Of these, 38,416 web pages, 91,421 YouTube videos, and 28,395 PDF documents were evaluated. Manual methods, methods with automatic tools, and the combination of both methods were used for the evaluation. Most websites were evaluated using the ISO/IEC 40500:2012 and Section 508 standards. The accessibility guidelines most commonly violated in the evaluations were: adaptable, compatible, distinguishable, input assistance, keyboard accessible, navigable, predictable, readable, and text alternatives. In conclusion, the university websites, YouTube videos, and PDF documents analyzed in the 42 papers present important accessibility problems. The main contribution of this SLR is the consolidation of the results of the 42 studies selected to determine the findings and trends in the accessibility of university websites around the world

A model-driven approach for enforcing summarizability in multidimensional modeling

The development of a data warehouse system is based on a conceptual multidimensional model, which provides a high level of abstraction in the accurate and expressive description of real-world situations. Once this model has been designed, the corresponding logical representation must be obtained as the basis of the implementation of the data warehouse according to one specific technology. However, there is a semantic gap between the dimension hierarchies modeled in a conceptual multidimensional model and its implementation. This gap particularly complicates a suitable treatment of summarizability issues, which may in turn lead to erroneous results from business intelligence tools. Therefore, it is crucial not only to capture adequate dimension hierarchies in the conceptual multidimensional model of the data warehouse, but also to correctly transform these multidimensional structures in a summarizability-compliant representation. A model-driven normalization process is therefore defined in this paper to address this summarizability-aware transformation of the dimension hierarchies in rich conceptual models.This work has been partially supported by the following projects: SERENIDAD (PEII-11-0327-7035) from Junta de Comunidades de Castilla-La Mancha (Spain) and by the MESOLAP (TIN2010-14860) project from the Spanish Ministry of Education and Science