Meeting the Need for ETL Documentation: A Model-driven Framework for Customizable Documentation Generation

Within Business Intelligence systems (BI systems), ETL (extract, transform and load) processes move numerous data from heterogeneous sources to a data warehouse and become more complex with growing enterprise size. To keep costs and expenditure of time for maintenance and evolution of those systems slight, ETL processes should be documented. A well-documented system also leads to higher transparency regarding the origin and processing of data, which increases the system’s acceptance by business users. However, the preparation of high-quality software documentation is sophisticated and therefore it usually only takes place in the design or development phase of BI systems. To ensure that the documentation is always updated, an automatic generation is advantageous. The paper at hand presents a conceptual framework for automated configurable ETL documentation generation. The presented framework creates benefits for BI systems developers as well as business users

Umfrage 2011: „Dokumentation von Business-Intelligence-Systemen“ – Ergebnisse und Auswertung

Die Nachwuchsforschergruppe Computer-Aided Warehouse Engineering (CAWE) arbeitet seit August 2010 an einem vollständig modellgetriebenen Vorgehen zur Unterstützung des Lebenszyklus von Business-Intelligence-Systemen (BI-Systemen). Eine wichtige Funktionalität des in Bearbeitung befindlichen Prototyps besteht in der automatischen Erzeugung von BI-Systemdokumentation (Re-Dokumentation). Um das aktuelle Dokumentationsgeschehen sowie die Dokumentationsbedarfe für BI-Systeme in der Praxis zu erfassen, wurde in 2011 im Rahmen des Projektes eineUmfrage zu diesemThema beiPraxisvertretern durchgeführt.Der vorliegende Beitrag thematisiert die relevanten Forschungsaspekte, beschreibt das methodische Vorgehen zur Durchführung der Umfrage, stellt ausgewählte Ergebnisse vor und wertet diese aus

Clinical and virological characteristics of hospitalised COVID-19 patients in a German tertiary care centre during the first wave of the SARS-CoV-2 pandemic: a prospective observational study

Purpose: Adequate patient allocation is pivotal for optimal resource management in strained healthcare systems, and requires detailed knowledge of clinical and virological disease trajectories. The purpose of this work was to identify risk factors associated with need for invasive mechanical ventilation (IMV), to analyse viral kinetics in patients with and without IMV and to provide a comprehensive description of clinical course. Methods: A cohort of 168 hospitalised adult COVID-19 patients enrolled in a prospective observational study at a large European tertiary care centre was analysed. Results: Forty-four per cent (71/161) of patients required invasive mechanical ventilation (IMV). Shorter duration of symptoms before admission (aOR 1.22 per day less, 95% CI 1.10-1.37, p < 0.01) and history of hypertension (aOR 5.55, 95% CI 2.00-16.82, p < 0.01) were associated with need for IMV. Patients on IMV had higher maximal concentrations, slower decline rates, and longer shedding of SARS-CoV-2 than non-IMV patients (33 days, IQR 26-46.75, vs 18 days, IQR 16-46.75, respectively, p < 0.01). Median duration of hospitalisation was 9 days (IQR 6-15.5) for non-IMV and 49.5 days (IQR 36.8-82.5) for IMV patients. Conclusions: Our results indicate a short duration of symptoms before admission as a risk factor for severe disease that merits further investigation and different viral load kinetics in severely affected patients. Median duration of hospitalisation of IMV patients was longer than described for acute respiratory distress syndrome unrelated to COVID-19

Business-Intelligence-Umfrage 2011: Softwaregestütztes Lebenszyklusmanagement und aktuelles Dokumentationsgeschehen für Business-Intelligence-Systeme

Am Lehrstuhl Wirtschaftsinformatik II der TU Chemnitz arbeitet die Nachwuchsforschergruppe Computer-Aided Warehouse Engineering (CAWE), die seit August 2010 besteht, an einem vollständig modellgetriebenen Vorgehen zur Unterstützung des Lebenszyklus von Business-Intelligence-Systemen (BI-Systemen). Neben der Durchführung von Grundlagenforschung hat die Nachwuchsforschergruppe die Erstellung eines Software-Prototyps zum Ziel. Eine wichtige Funktionalität ist die automatische Erzeugung von Systemdokumentationen für verschiedene BI-Systeme mit dem Schwerpunkt auf den Architekturkomponenten. Im Rahmen des Forschungsprojektes führte die CAWE Nachwuchsforschergruppe unter der Leitung von Prof. Dr. Peter Gluchowski in 2011 eine bundesweite Umfrage bei mittelständischen bis großen Unternehmen zu folgendem Thema durch: „Softwaregestütztes Lebenszyklusmanagement und aktuelles Dokumentationsgeschehen für Business Intelligence-Systeme“

TOWARDS A DESIGN MODEL FOR INTERDISCIPLINARY INFORMATION SYSTEMS CURRICULUM DEVELOPMENT, AS EXEMPLIFIED BY BIG DATA ANALYTICS EDUCATION

The need for interdisciplinary programs for problem-based education increases. However, there is a substantial shortage of skilled boundary-spanning students, as prominently evidenced in the field of big data analytics. To solve this problem, this paper suggests a generic interdisciplinary IS curriculum process design model. The model considers education of students with deep knowledge in more than one discipline who possess the right skills that are needed by their future employers. It is applicable to various disciplines and potential combinations of these disciplines. Based on skills representing the consensus of corresponding communities and professionals, the model allows the definition of university specific constraints which are considered in the curriculum design. Besides the process design model we have implemented a prototype for a curriculum generator which supports the generation of concrete curricula. Through our approach that is based on the design science research paradigm, we formalize the curriculum development process which allows the fast and easy design of interdisciplinary programs

Políticas e práticas de gestão ambiental: uma análise da gestão dos resíduos da construção civil na cidade de Belo Horizonte (MG)

Este artigo tem por objetivo estudar as práticas de gestão de resíduos da construção civil implementadas pelo poder público municipal na cidade de Belo Horizonte (MG). Para isso, empregou-se o método de estudo de caso articulado com o processo de triangulação das técnicas de coleta de dados. A natureza da problemática estudada exigiu a sistematização de um quadro de referências que inclui algumas reflexões teóricas sobre a relação entre Estado, políticas públicas e gestão ambiental. A análise dos resultados evidencia que o poder público da cidade de Belo Horizonte articulou e implementou um conjunto de políticas e práticas de gestão dos resíduos da construção que deu origem a uma policy network, a qual, além de ser por ele coordenada, envolve a participação de diversos atores sociais públicos e privados. Trata-se de uma configuração institucional com um padrão de relações interdependentes que servem de referência para a concretização das práticas de gestão de resíduos da construção civil. Os resultados deste estudo apontam também os benefícios econômicos, sociais e ambientais, além das dificuldades relativas ao processo de institucionalização das referidas políticas e práticas

Clinical and virological characteristics of hospitalised COVID-19 patients in a German tertiary care centre during the first wave of the SARS-CoV-2 pandemic: a prospective observational study

Purpose!#!Adequate patient allocation is pivotal for optimal resource management in strained healthcare systems, and requires detailed knowledge of clinical and virological disease trajectories. The purpose of this work was to identify risk factors associated with need for invasive mechanical ventilation (IMV), to analyse viral kinetics in patients with and without IMV and to provide a comprehensive description of clinical course.!##!Methods!#!A cohort of 168 hospitalised adult COVID-19 patients enrolled in a prospective observational study at a large European tertiary care centre was analysed.!##!Results!#!Forty-four per cent (71/161) of patients required invasive mechanical ventilation (IMV). Shorter duration of symptoms before admission (aOR 1.22 per day less, 95% CI 1.10-1.37, p &amp;lt; 0.01) and history of hypertension (aOR 5.55, 95% CI 2.00-16.82, p &amp;lt; 0.01) were associated with need for IMV. Patients on IMV had higher maximal concentrations, slower decline rates, and longer shedding of SARS-CoV-2 than non-IMV patients (33 days, IQR 26-46.75, vs 18 days, IQR 16-46.75, respectively, p &amp;lt; 0.01). Median duration of hospitalisation was 9 days (IQR 6-15.5) for non-IMV and 49.5 days (IQR 36.8-82.5) for IMV patients.!##!Conclusions!#!Our results indicate a short duration of symptoms before admission as a risk factor for severe disease that merits further investigation and different viral load kinetics in severely affected patients. Median duration of hospitalisation of IMV patients was longer than described for acute respiratory distress syndrome unrelated to COVID-19