A Methodology and Tool for Rapid Prototyping of Data Warehouses using Data Mining: Application to Birds Biodiversity

International audienceData Warehouses (DWs) are large repositories of data aimed at supporting the decision-making process by enabling flexible and interactive analyses via OLAP systems. Rapid prototyping of DWs is necessary when OLAP applications are complex. Some work about the integration of Data Mining and OLAP systems has been done to enhance OLAP operators with mined indicators, and/or to define the DW schema. However, to best of our knowledge, prototyping methods for DWs do not support this kind of integration. Then, in this paper we present a new prototyping methodology for DWs, extending [3], where DM methods are used to define the DW schema. We validate our approach on a real data set concerning bird biodiversity

Using Real-Time Area VOC Measurements to Estimate Total Hydrocarbons Exposures to Workers Involved in the Deepwater Horizon Oil Spill

Even though the Deepwater Horizon oil spill response and clean-up (OSRC) had one of the largest exposure monitoring efforts of any oil spill, a number of exposure groups did not have sufficient personal data available or there were gaps in days measured to adequately characterize exposures for the GuLF STUDY, an epidemiologic study investigating the health of the OSRC workers. Area measurements were available from real-time air monitoring instruments and used to supplement the personal exposure measurements. Objectives: The objective was to present a method that used real-time volatile organic compounds (VOCs) area measurements transformed to daily total hydrocarbons (THC) time-weighted averages (TWAs) to supplement THC personal full-shift measurements collected using passive charcoal badges. A second objective was to develop exposure statistics using these data for workers on vessels piloting remotely operated vehicle (ROV) vessels and other marine vessels (MVs) not at the job title level, but at the vessel level. Methods: From hourly vessel averages derived from ~26 million real-time VOC measurements, we estimated full-shift VOC TWAs. Then, we determined the relationship between these TWAs and corresponding full-shift THC personal measurements taken on the same vessel-day. We used this relationship to convert the full-shift VOC measurements to full-shift 'THC' TWA estimates when no personal THC measurements existed on a vessel-day. We then calculated arithmetic means (AMs) and other statistics of THC exposures for each vessel. Results: The VOC-derived estimates substantially supplemented the THC personal measurements, with the number of vessel-days for which we have exposure estimates increasing by ~60%. The estimates of the AMs are some of the highest observed in the GuLF STUDY. As expected, the AMs decreased over time, consistent with our findings on other vessels. Conclusions: Despite the inherent limitations of using real-time area measurements, we were able to develop additional daily observations of personal THC exposures for workers on the ROV vessels and other MVs over time. The estimates likely resulted in more representative estimates of the AMs in the GuLF STUDY. The method used here can be applied in other occupational settings and industries for personal exposure estimation where large amounts of area measurements and more limited numbers of personal measurements are available

Effects of salinity and alkalinity on growth and survival of all-male giant freshwater prawn (Macrobrachium rosenbergii De Man, 1879) juveniles

All-male giant freshwater prawns (AMGFPs) have been a popular crop cultivated in the Mekong Delta, Vietnam, due to their proven production efficiency compared to all-female or mixed-sex prawn cultures. However, the crucial water quality factors impacting AMGFP aquaculture efficiency have yet to be elaborately investigated. Two separate experiments were randomly arranged with three replicates to evaluate the effects of salinity or alkalinity on the growth and survival of AMGFP juveniles during the grow-out period. The results show that the prawn survival rate in the salinity range of 0–15‰ varied from 66.1 to 74.8％ and in a salinity range of 0–5‰ was relatively low compared to the range of 10-15‰; however, the difference was not significant among salinities after 90 days of culture (p > 0.05). All the prawn growth performance parameters significantly decreased with increasing salinities of 0, 5, 10, and 15‰ after 30, 60, and 90 days of culture (p 0.05), and both were significantly higher than those at salinities of 10 and 15‰ (p < 0.05) after 90 days of culture. In addition, the survival rate reached 82.5–84.4％ and did not significantly differ among alkalinities of 80, 100, 120, 140, and 160 mgCaCO3 L−1. However, the growth performance parameters and yield of AMGFPs at an alkalinity of 160 mg L−1 were significantly higher than those at lower alkalinities (80, 100, 120, and 140 mg CaCO3 L−1) after 90 days of culture. Therefore, it is recommended that a salinity range of 0–5‰ and alkalinity of 160 mgCaCO3 L−1 is optimal for the growth-out culture of AMGFP juveniles

Exposure Group Development in Support of the NIEHS GuLF Study

In the GuLF Study, a study investigating possible adverse health effects associated with work on the oil spill response and clean-up (OSRC) following the Deepwater Horizon disaster in the Gulf of Mexico, we used a job-exposure matrix (JEM) approach to estimate exposures. The JEM linked interview responses of study participants to measurement data through exposure groups (EGs). Here we describe a systematic process used to develop transparent and precise EGs that allowed characterization of exposure levels among the large number of OSRC activities performed across the Gulf of Mexico over time and space. EGs were identified by exposure determinants available to us in our measurement database, from a substantial body of other spill-related information, and from responses provided by study participants in a detailed interview. These determinants included: job/activity/task, vessel and type of vessel, weathering of the released oil, area of the Gulf of Mexico, Gulf coast state, and time period. Over 3000 EGs were developed for inhalation exposure and applied to each of 6 JEMs of oil-related substances (total hydrocarbons, benzene, toluene, ethylbenzene, total xylene, and n-hexane). Subsets of those EGs were used for characterization of exposures to dispersants, particulate matter, and oil mist. The EGs allowed assignment to study participants of exposure estimates developed from measurement data or from estimation models through linkage in the JEM for the investigation of exposure-response relationships

Development of a total hydrocarbon ordinal job-exposure matrix for workers responding to the Deepwater Horizon disaster: The GuLF STUDY

The GuLF STUDY is a cohort study investigating the health of workers who responded to the Deepwater Horizon oil spill in the Gulf of Mexico in 2010. The objective of this effort was to develop an ordinal job-exposure matrix (JEM) of airborne total hydrocarbons (THC), dispersants, and particulates to estimate study participants' exposures. Information was collected on participants' spill-related tasks. A JEM of exposure groups (EGs) was developed from tasks and THC air measurements taken during and after the spill using relevant exposure determinants. THC arithmetic means were developed for the EGs, assigned ordinal values, and linked to the participants using determinants from the questionnaire. Different approaches were taken for combining exposures across EGs. EGs for dispersants and particulates were based on questionnaire responses. Considerable differences in THC exposure levels were found among EGs. Based on the maximum THC level participants experienced across any job held, 1/414% of the subjects were identified in the highest exposure category. Approximately 10% of the cohort was exposed to dispersants or particulates. Considerable exposure differences were found across the various EGs, facilitating investigation of exposure-response relationships. The JEM is flexible to allow for different assumptions about several possibly relevant exposure metrics

Estimates of Inhalation Exposures to Oil-Related Components on the Supporting Vessels During the Deepwater Horizon Oil Spill

The Deepwater Horizon oil spill response and clean-up (OSRC) involved over 9000 large and small vessels deployed in waters of the Gulf of Mexico across four states (Alabama, Florida, Louisiana, and Mississippi). For the GuLF STUDY, we developed exposure estimates of oil-related components for many work groups to capture a wide range of OSRC operations on these vessels, such as supporting the four rig vessels charged with stopping the spill at the wellhead; skimming oil; in situ burning of oil; absorbing and containing oil by boom; and environmental monitoring. Work groups were developed by: (i) vessel activity; (ii) location (area of the Gulf or state); and (iii) time period. Using Bayesian methods, we computed exposure estimates for these groups for: total hydrocarbons measured as total petroleum hydrocarbons (THC), benzene, toluene, ethylbenzene, xylene, and n-hexane (BTEX-H). Estimates of the arithmetic means for THC ranged from 0.10 ppm [95% credible interval (CI) 0.04, 0.38 ppm] in time periods 2 and 3 (16 July-30 September 2010) to 15.06 ppm (95% CI 10.74, 22.41 ppm) in time period 1a (22 April-15 May 2010). BTEX-H estimates were substantially lower (in the parts per billion range). Exposure levels generally fell over time and differed statistically by activity, location, and time for some groups. These exposure estimates have been used to develop job-exposure matrices for the GuLF STUDY

Estimates of Inhalation Exposures among Land Workers during the Deepwater Horizon Oil Spill Clean-up Operations

Following the Deepwater Horizon oil spill disaster, thousands of workers and volunteers cleaned the shoreline across four coastal states of the Gulf of Mexico. For the GuLF STUDY, we developed quantitative estimates of oil-related chemical exposures [total petroleum hydrocarbons (THC), benzene, toluene, ethylbenzene, xylene, and n-hexane (BTEX-H)] from personal measurements on workers performing various spill clean-up operations on land. These operations included decontamination of vessels, equipment, booms, and personnel; handling of oily booms; hazardous waste management; beach, marsh, and jetty clean-up; aerial missions; wildlife rescue and rehabilitation; and administrative support activities. Exposure estimates were developed for unique groups of workers by (i) activity, (ii) state, and (iii) time period. Estimates of the arithmetic means (AMs) for THC ranged from 0.04 to 3.67 ppm. BTEX-H estimates were substantially lower than THC (in the parts per billion range). Both THC and BTEX-H estimates were substantially lower than their respective occupational exposure limits. The work group, 'Fueled engines' consistently was one of the higher exposed groups to THC and BTEX-H. Notable differences in the AM exposures were observed by activity, time and, to a lesser degree, by state. These exposure estimates were used to develop job-exposure matrices for the GuLF STUDY

Estimates of Occupational Inhalation Exposures to Six Oil-Related Compounds on the Four Rig Vessels Responding to the Deepwater Horizon Oil Spill

Background: The 2010 Deepwater Horizon (DWH) oil spill involved thousands of workers and volunteers to mitigate the oil release and clean-up after the spill. Health concerns for these participants led to the initiation of a prospective epidemiological study (GuLF STUDY) to investigate potential adverse health outcomes associated with the oil spill response and clean-up (OSRC). Characterizing the chemical exposures of the OSRC workers was an essential component of the study. Workers on the four oil rig vessels mitigating the spill and located within a 1852 m (1 nautical mile) radius of the damaged wellhead [the Discoverer Enterprise (Enterprise), the Development Driller II (DDII), the Development Driller III (DDIII), and the HelixQ4000] had some of the greatest potential for chemical exposures. Objectives: The aim of this paper is to characterize potential personal chemical exposures via the inhalation route for workers on those four rig vessels. Specifically, we presented our methodology and descriptive statistics of exposure estimates for total hydrocarbons (THCs), benzene, toluene, ethylbenzene, xylene, and n-hexane (BTEX-H) for various job groups to develop exposure groups for the GuLF STUDY cohort. Methods: Using descriptive information associated with the measurements taken on various jobs on these rig vessels and with job titles from study participant responses to the study questionnaire, job groups [unique job/rig/time period (TP) combinations] were developed to describe groups of workers with the same or closely related job titles. A total of 500 job groups were considered for estimation using the available 8139 personal measurements. We used a univariate Bayesian model to analyze the THC measurements and a bivariate Bayesian regression framework to jointly model the measurements of THC and each of the BTEX-H chemicals separately, both models taking into account the many measurements that were below the analytic limit of detection. Results: Highest THC exposures occurred in TP1a and TP1b, which was before the well was mechanically capped. The posterior medians of the arithmetic mean (AM) ranged from 0.11 ppm ('Inside/Other', TP1b, DDII; and 'Driller', TP3, DDII) to 14.67 ppm ('Methanol Operations', TP1b, Enterprise). There were statistical differences between the THC AMs by broad job groups, rigs, and time periods. The AMs for BTEX-H were generally about two to three orders of magnitude lower than the THC AMs, with benzene and ethylbenzene measurements being highly censored. Conclusions: Our results add new insights to the limited literature on exposures associated with oil spill responses and support the current epidemiologic investigation of potential adverse health effects of the oil spill

Linear Relationships Between Total Hydrocarbons and Benzene, Toluene, Ethylbenzene, Xylene, and n-Hexane during the Deepwater Horizon Response and Clean-up

Objectives: Our objectives were to (i) determine correlations between measurements of THC and of BTEX-H, (ii) apply these linear relationships to predict BTEX-H from measured THC, (iii) use these correlations as informative priors in Bayesian analyses to estimate exposures. Methods: We used a Bayesian left-censored bivariate framework for all 3 objectives. First, we modeled the relationships (i.e. correlations) between THC and each BTEX-H chemical for various overarching groups of measurements using linear regression to determine if correlations derived from linear relationships differed by various exposure determinants. We then used the same linear regression relationships to predict (or impute) BTEX-H measurements from THC when only THC measurements were available. Finally, we used the same linear relationships as priors for the final exposure models that used real and predicted data to develop exposure estimate statistics for each individual exposure group. Results: Correlations between measurements of THC and each of the BTEX-H chemicals (n = 120 for each of BTEX, 36 for n-hexane) differed substantially by area of the Gulf of Mexico and by time period that reflected different oil-spill related exposure opportunities. The correlations generally exceeded 0.5. Use of regression relationships to impute missing data resulted in the addition of >23 000 n-hexane and 541 observations for each of BTEX. The relationships were then used as priors for the calculation of exposure statistics while accounting for censored measurement data. Conclusions: Taking advantage of observed relationships between THC and BTEX-H allowed us to develop robust exposure estimates where a large amount of data were missing, strengthening our exposure estimation process for the epidemiologic study