Using balanced scorecards to evaluate the data warehouse system utility

Dissertação de mestrado em Systems Engineering

Integração da área de negócio de retalho do grupo Riopele no Data Warehouse corporativo

Dissertação de mestrado integrado em Engenharia e Gestão de Sistemas de Informação

A domain-specific language for ETL patterns specification in Data Warehousing Systems

During the last few years many research efforts have been done to improve the design of ETL (Extract-Transform-Load) systems. ETL systems are considered very time-consuming, error-prone and complex involving several participants from different knowledge domains. ETL processes are one of the most important components of a data warehousing system that are strongly influenced by the complexity of business requirements, their changing and evolution. These aspects influence not only the structure of a data warehouse but also the structures of the data sources involved with. To minimize the negative impact of such variables, we propose the use of ETL patterns to build specific ETL packages. In this paper, we formalize this approach using BPMN (Business Process Modelling Language) for modelling more conceptual ETL workflows, mapping them to real execution primitives through the use of a domain-specific language that allows for the generation of specific instances that can be executed in an ETL commercial tool.

Categorização do consumo de energia em sistemas de povoamento de Data Warehouses

Os recursos computacionais exigidos durante o processamento de grandes volumes de dados durante um processo de povoamento de um data warehouse faz com que a necessidade da procura de novas implementações tenha também em atenção a eficiência energética dos diversos componentes processuais que integram um qualquer sistema de povoamento. A lacuna de técnicas ou metodologias para categorizar e avaliar o consumo de energia em sistemas de povoamento de data warehouses é claramente notória. O acesso a esse tipo de informação possibilitaria a construção de sistemas de povoamento de data warehouses com níveis de consumo de energia mais baixos e, portanto, mais eficientes. Partindo da adaptação de técnicas aplicadas a sistemas de gestão de base de dados para a obtenção dos consumos energéticos da execução de interrogações, desenhámos e implementámos uma nova técnica que nos permite obter os consumos de energia para um qualquer processo de povoamento de um data warehouse, através da avaliação do consumo de cada um dos componentes utilizados na sua implementação utilizando uma ferramenta convencional. Neste artigo apresentamos a forma como fazemos tal avaliação, utilizando na demonstração da viabilidade da nossa proposta um processo de povoamento bastante típico em data warehouses – substituição encadeada de chaves operacionais -, que foi implementado através da ferramenta Kettle.

Plataforma de apoio à decisão nos cuidados de ginecologia e obstetrícia

Dissertação de mestrado integrado em Engenharia Biomédica (área de especialização em Informática Médica)

Pervasive adaptive data acquisition gateway for critical healthcare

The data acquisition process in real-time is fundamental to provide appropriate services and improve health professionals decision. In this paper a pervasive adaptive data acquisition architecture of medical devices (e.g. vital signs, ventilators and sensors) is presented. The architecture was deployed in a real context in an Intensive Care Unit. It is providing clinical data in real-time to the INTCare system. The gateway is composed by several agents able to collect a set of patients’ variables (vital signs, ventilation) across the network. The paper shows as example the ventilation acquisition process. The clients are installed in a machine near the patient bed. Then they are connected to the ventilators and the data monitored is sent to a multithreading server which using Health Level Seven protocols records the data in the database. The agents associated to gateway are able to collect, analyse, interpret and store the data in the repository. This gateway is composed by a fault tolerant system that ensures a data store in the database even if the agents are disconnected. The gateway is pervasive, universal, and interoperable and it is able to adapt to any service using streaming data.

Step towards of a homemade business intelligence solution: A case study in textile industry

Nowadays, organizations are increasingly looking to invest in business intelligence solutions, mainly private companies in order to get advantage over its competitors, however they do not know what is necessary. Business intelligence allows an analysis of consolidated information in order to obtain more specific outlets and certain indications in order to support the decision making process. You can take the right decision based on the data collected from different information systems present in the organization and outside of them. The textile sector is a sector where concept of Business Intelligence it is not many explored yet. Actually there are few textile companies that have a BI platform. Thus, the article objective is present an architecture and show all the steps by which companies need to spend to implement a successful free homemade Business Intelligence system. As result the proposed approach it was validated using real data aiming assess the steps defined.

Step towards a patient timeline in intensive care units

In Intensive Medicine, the presentation of medical information is done in many ways, depending on the type of data collected and stored. The way in which the information is presented can make it difficult for intensivists to quickly understand the patient's condition. When there is the need to cross between several types of clinical data sources the situation is even worse. This research seeks to explore a new way of presenting information about patients, based on the timeframe in which events occur. By developing an interactive Patient Timeline, intensivists will have access to a new environment in real-time where they can consult the patient clinical history and the data collected until the moment. The medical history will be available from the moment in which patients is admitted in the ICU until discharge, allowing intensivist to examine data regarding vital signs, medication, exams, among others. This timeline also intends to, through the use of information and models produced by the INTCare system, combine several clinical data in order to help diagnose the future patients’ conditions. This platform will help intensivists to make more accurate decision. This paper presents the first approach of the solution designed

A relational algebra approach to ETL modeling

The MAP-i Doctoral Programme in Informatics, of the Universities of Minho, Aveiro and Porto

Pervasive patient timeline

Dissertação de mestrado integrado em Engenharia e Gestão de Sistemas de Informação

Exploração de dados para soluções de retalho em business intelligence

Dissertação de mestrado integrado em Engenharia de Gestão e Sistemas de Informação

Scarless laparoscopic repair of epigastric hernia in children

Background Despite the small size of the incision, the scar left by open repair of epigastric hernia in children is unaesthetic. Few laparoscopic approaches to epigastric hernia repair have been previously proposed, but none has gain wide acceptance from pediatric surgeons. In this study, we present our experience with a scarless laparo- scopic approach using a percutaneous suturing technique for epigastric hernia repair in children. Methods Ten consecutive patients presenting with epi- gastric hernia 15 mm or further from the umbilicus were submitted to laparoscopic hernia repair. A 5-mm 308-angle laparoscope is introduced through a umbilical trocar and a 3-mm laparoscopic dissector is introduced through a stab incision in the right flank. After opening and dissecting the parietal peritoneum, the fascial defect is identified and closed using 2–0 polyglactin thread through a percutaneous suturing technique. Intraoperative and postoperative clinical data were collected. Results All patients were successfully submitted to la- paroscopic epigastric hernia repair. Median age at surgery was 79 months old and the median distance from the um- bilicus to the epigastric defect was 4 cm. Operative time ranged from 35 to 75 min. Every hernia was successfully closed without any incidents. Follow-up period ranges from 2 to 12 months. No postoperative complications or recurrence was registered. No scar was visible in these patients. Conclusion This scarless laparoscopic technique for epi- gastric hernia repair is safe and reliable. We believe this technique might become gold standard of care in the near future.

HPV DNA testing with cytology triage in cervical cancer screening: Influence of revealing HPV infection status

BACKGROUND: Knowledge of cervical human papillomavirus (HPV) status might influence a cytotechnician's assessment of cellular abnormalities. The authors compared original cytotechnicians' Papanicolaou (Pap) readings for which HPV status was concealed with Pap rereads for which HPV status was revealed separately for 3 screening populations. METHODS: Previously collected cervical Pap smears and clinical data were obtained from the Canadian Cervical Cancer Screening Trial (study A), the Democratic Republic of Congo Community-Based Screening Study (study B), and the Brazilian Investigation into Nutrition and Cervical Cancer Prevention (study C). Smears were reread with knowledge of HPV status for all HPV-positive women as well as a sample of HPV-negative women. Diagnostic performance of Pap cytology was compared between original readings and rereads. RESULTS: A total of 1767 Pap tests were reread. Among 915 rereads for HPV-positive women, the contrast between "revealed" and "concealed" Pap readings demonstrated revisions from negative to positive results for 109 women (cutoff was atypical squamous cells of undetermined significance or worse) and 124 women (cutoff was low-grade squamous intraepithelial lesions [LSIL] or worse). For a disease threshold of cervical intraepithelial neoplasia of grade 2 or worse, specificity significantly declined at the atypical squamous cells of undetermined significance cutoff for studies A (86.6% to 75.3%) and C (42.5% to 15.5%), and at the LSIL cutoff for study C (61.9% to 37.6%). Sensitivity remained nearly unchanged between readings, except in study C, in which reread performance was superior (91.3% vs 71.9% for the LSIL cutoff). CONCLUSIONS: A reduction in the diagnostic accuracy of Pap cytology was observed when revealing patients' cervical HPV status, possibly due to a heightened awareness of potential abnormalities, which led to more false-positive results. Cancer (Cancer Cytopathol) 2015. (c) 2015 American Cancer Society.

Real-time monitoring of progression towards renal failure in primary care patients

First published online: December 16, 2014.