Business Intelligence and Analytics: On-demand ETL over Document Stores

International audienceFor many decades, Business Intelligence and Analytics (BI&A) has been associated with relational databases. In the era of big data and NoSQL stores, it is important to provide approaches and systems capable of analyzing this type of data for decision-making. In this paper, we present a new BI&A approach that both: (i) extracts, transforms and loads the required data for OLAP analysis (on-demand ETL) from document stores, and (ii) provides the models and the systems required for suitable OLAP analysis. We focus here, on the on-demand ETL stage where, unlike existing works, we consider the dispersion of data over two or more collections

Peste des Petits Ruminants

Heartwater (or cowdriosis) is a tick-borne disease caused by Ehrlichia ruminantium, an obligatory intracellular bacterium of the order Rickettsiales, transmitted by several ticks of the genus Amblyomma. The organism is genetically highly variable which prevented until now the development of efficient vaccines. The disease is enzootic in sub-Sahelian Africa and in some Caribbean islands. It affects domestic and wild ruminants, the susceptibility to cowdriosis varying greatly between breeds and species: African wildlife shows mainly asymptomatic infections; local cattle breeds are generally protected due to enzootic stability; and introduced cattle breeds and small ruminants, even in enzootic regions, are usually susceptible to heartwater and can suffer high mortality rates. Cowdriosis is characterized by a sudden and acute fever followed by nervous, respiratory, and gastrointestinal symptoms and by hydrothorax and hydropericardium during postmortem examination. In West Africa, the only vector is Amblyomma variegatum, present in areas where pluviometry is higher than 500 mm. Therefore, animals of a high proportion of the Sahelian region are usually not infested by the tick and not infected by the bacterium. They are thus susceptible when introduced in southern parts of the Sahel or in the subhumid neighboring areas of the West African countries, for example during transhumance. Tetracyclines are effective drugs to treat heartwater when administered before occurrence of the nervous symptoms. Various vaccines have been tested, and are still developed, but, up to now, none of them showed enough effectiveness against all the field strains of E. ruminantium to allow its marketing. Prevention is therefore mainly achieved by drastic vector control or, on the contrary, acquisition of enzootic stability following tick infestation combined with tetracycline treatment as soon as hyperthermia occurs