Built-In Indicators to Support Business Intelligence in OLAP Databases

Author(s):  
Jérôme Cubillé ◽  
Christian Derquenne ◽  
Sabine Goutier ◽  
Françoise Guisnel ◽  
Henri Klajnmic ◽  
...  

This chapter is in the scope of static and dynamic discovery-driven explorations of a data cube. It presents different methods to facilitate the whole process of data exploration. Each kind of analysis (static or dynamic) is developed for either a count measure or a quantitative measure. Both are based on the calculation, on the fly, of specific statistical built-in indicators. Firstly, a global methodology is proposed to help a dynamic discovery-driven exploration. It aims at identifying the most relevant dimensions to expand. A built-in rank on dimensions is restituted interactively, at each step of the process. Secondly, to help a static discovery-driven exploration, generalized statistical criteria are detailed to detect and highlight interesting cells within a cube slice. The cell’s degree of interest is determined by the calculation of either test-value or Chi-Square contribution. Their display is done by a color-coding system. A proof of concept implementation on the ORACLE 10g system is described at the end of the chapter.

2019 ◽  
Vol 55 (4) ◽  
pp. 600-616
Author(s):  
Chiemezie Scholastica Atama ◽  
Uzoma Odera Okoye ◽  
Amelia Ngozi Odo ◽  
Aloysius Odii ◽  
Uche Teresa Okonkwo

Despite the benefit of modern contraception, its use remains low in Nigeria. This study examined belief system as a barrier to the use of modern contraceptives among the Idoma of Benue State, North Central Nigeria. Questionnaire ( n = 1107), in-depth interview ( n = 6) and focus group discussion ( n = 52) were used to collect data from three local government areas (LGAs). The results showed high levels of knowledge (88.0%), however, only 37.8% used modern contraceptives. The male condom had the highest percentage use (56.7%). Chi-square results showed that LGA, education and occupation were significantly related to the use of modern contraceptives. Being of greater age increased the likelihood of use, whereas higher levels of education and income decreased the likelihood of modern contraceptive use ( p < 0.05). Qualitative data indicated that married women were expected to eschew modern contraceptives due to their belief in Alekwu, the community deity. Designing interventions that are culturally specific could promote use of modern contraceptives among the group.


2014 ◽  
Vol 52 (8) ◽  
pp. e92-e93
Author(s):  
Sophia Richardson ◽  
Lilia Wong ◽  
Jeremy Richardson ◽  
Muammar Abu-Serriah
Keyword(s):  

Circulation ◽  
2021 ◽  
Vol 144 (Suppl_2) ◽  
Author(s):  
Alexandra Weissman ◽  
Mariam Bramah Lawani ◽  
Thomas Rohan ◽  
Clifton W CALLAWAY

Introduction: Pneumonia is common after OHCA but is difficult to diagnose in the first 72 hours following ROSC, this results in early untargeted antibiotic administration based on non-specific imaging and laboratory findings. Antibiotic resistance is rising, is influenced by untargeted antibiotic administration, and can increase patient morbidity and mortality as well as healthcare costs. Precision methods of bacterial pathogen detection in OHCA patients are needed to improve patient care. This proof-of-concept pilot study aimed to assess feasibility of bacterial pathogen sequencing and comparability of sequencing results to clinical culture after OHCA. Methods: Blood and bronchoalveolar lavage (BAL) were obtained from residual clinical specimens collected within 12 hours of ROSC. Bacterial DNA was extracted using the Qiagen PowerLyzer PowerSoil DNA kit, sequenced using the MinION nanopore sequencer, and analyzed with Oxford Nanopore Technologies’ EPI2ME bioinformatics software. Sequencing results were compared to culture results using McNemar’s chi-square statistic. Study-defined pneumonia was based on presence of at least two characteristics within 72 hours of ROSC: fever (temperature ≥38°C); persistent leukocytosis >15,000 or leukopenia <3,500 for 48 hours; persistent chest radiography infiltrates for 48 hours per clinical radiology read; bacterial pathogen cultured. Results: We enrolled 38 consecutive OHCA subjects: mean age 61.8 years (18.0); 16 (42%) female; 25 (66%) White, 7 (18%) Black, 6 (16%) “Other” race; 7 subjects (18%) survived and 31 (82%) died; 16 (42%) subjects had pneumonia. Sequencing results were available in 12 hours while culture results were available in 48-72 hours after collection. There was a non-significant difference in the proportion of the same pathogens identified for each method per McNemar’s chi-square: p = 0.38, difference of 0.095 (-0.095, 0.286). Conclusions: Nanopore sequencing detects pathogenic bacteria comparable to clinical microbiologic culture and in less time. This technology can produce a paradigm shift in early bacterial pathogen detection in OHCA survivors, which can improve patient care. The technology is applicable to other patient populations and for viral and fungal pathogens.


2018 ◽  
Vol 45 (11) ◽  
pp. 5305-5316 ◽  
Author(s):  
Ludovic De Marzi ◽  
Annalisa Patriarca ◽  
Catherine Nauraye ◽  
Eric Hierso ◽  
Rémi Dendale ◽  
...  

2015 ◽  
Vol 737 ◽  
pp. 181-186
Author(s):  
Xiao Yun Huang ◽  
Fei Jin Peng ◽  
Hong Yuan Huang ◽  
Zhi Wen Xie

Abstract: On the condition of protecting the critical load, it is necessary to restore the service of outage area without fault as soon as possible after the occurrence of fault in smart distribution system. A fast service restoration method is proposed for medium-voltage distribution system with distributed generations, which combines intentional islanding of DGs for network reconfiguration. Under the condition of safety limits, the out of service areas are achieved maximization of restoration, making full use of DGs. The whole process of restoration is regarded as a multi-stages decision problem, and divided into four stages. Compared to the existing algorithms, this method can effectively avoid the time-consuming and search results problems, and the simulation results are better. The effectiveness and practicality of the propose approach is demonstrated by simulations on a PG&E 69-nodes system with DGs.


Sign in / Sign up

Export Citation Format

Share Document