An Online Analytical Processing Database for Environmental Water Quality Analytics

2018 ◽  
Author(s):  
Dallas Snider ◽  
John Derek Morgan ◽  
Matthew Schwartz ◽  
Austin Adkison ◽  
Delikarl Jean Baptiste
Keyword(s):  
Water Quality ◽  
Environmental Water ◽  
Online Analytical Processing ◽  
Analytical Processing

Formulating biossay data of chemicals and environmental water

2000 ◽  
Vol 42 (3-4) ◽  
pp. 115-123 ◽  
Author(s):  
R. Shoji ◽  
A. Sakoda ◽  
Y. Sakai ◽  
M. Suzuki
Keyword(s):  
Water Quality ◽  
Low Density Lipoprotein ◽  
Water Environment ◽  
Density Lipoprotein ◽  
Environmental Water ◽  
Toxicity Data ◽  
Human Beings ◽  
Environmental Waters ◽  
Bodies Of Water

The quality of environmental waters such as rivers is often deteriorated by various kinds of trace and unidentified chemicals despite the recent development of sewage systems and wastewater treatment technologies. In addition to contamination by particular toxicants, complex toxicity due to multi-component chemicals could be much more serious. The environmental situation in bodies of water in Japan led us to apply bioassays for monitoring the water quality of environmental waters in order to express the direct and potential toxicity to human beings and ecosystems rather than determinating concentrations of particular chemicals. However, problems arose from the fact that bioassays for pharmaceutical purposes generally required complicated, time-consuming, expert procedures. Also, a methodology for feedback of the resultant toxicity data to water environment management has not been established yet. To this end, we developed a novel bioassay based on the low-density lipoprotein (LDL) uptake activity of human hepatoblastoma cells. The assay enabled us to directly detect the toxicity of environmental waters within 4 hours of exposure. This is a significantly quick and easy procedure as compared to that of conventional bioassays. The toxicity data for 255 selected chemicals and environmental waters obtained by this method were organized by a mathematical equation in order to make those data much more effectively and practically useful to the management of environmental waters. Our methodology represents a promising example of applying bioassays to monitor environmental water quality and generating potential solutions to the toxicity problems encountered.

Schema Evolution in Multiversion Data Warehouses

2021 ◽  
Vol 17 (4) ◽  
pp. 1-28
Author(s):  
Waqas Ahmed ◽  
Esteban Zimányi ◽  
Alejandro A. Vaisman ◽  
Robert Wrembel
Keyword(s):  
Efficient Solution ◽  
Business Processes ◽  
Online Analytical Processing ◽  
User Requirements ◽  
Schema Evolution ◽  
Data Warehouses ◽  
Relational Schema ◽  
External Sources ◽  
Analytical Processing

Data warehouses (DWs) evolve in both their content and schema due to changes of user requirements, business processes, or external sources to name a few. Although multiple approaches using temporal and/or multiversion DWs have been proposed to handle these changes, an efficient solution for this problem is still lacking. The authors' approach is to separate concerns and use temporal DWs to deal with content changes, and multiversion DWs to deal with schema changes. To address the former, previously, they have proposed a temporal multidimensional (MD) model. In this paper, they propose a multiversion MD model for schema evolution to tackle the latter problem. The two models complement each other and allow managing both content and schema evolution. In this paper, the semantics of schema modification operators (SMOs) to derive various schema versions are given. It is also shown how online analytical processing (OLAP) operations like roll-up work on the model. Finally, the mapping from the multiversion MD model to a relational schema is given along with OLAP operations in standard SQL.

scholarly journals Perancangan Data Warehouse Rumah Sakit Berbasis Online Analytical Processing (OLAP)

2021 ◽  
Vol 8 (5) ◽  
pp. 1077
Author(s):  
Joko Purwanto ◽  
Renny Renny
Keyword(s):  
Information Technology ◽  
Health Services ◽  
Data Warehouse ◽  
Data Extraction ◽  
Online Analytical Processing ◽  
Data Source ◽  
Analytical Processing ◽  
Quality Of Health Services ◽  
Warehouse Design

<p class="BodyCxSpFirst">Pemanfaatan teknologi informasi sangat penting bagi rumah sakit, karena berpengaruh pula terhadap kualitas pelayanan kesehatan yang secara manual diubah menjadi digital dengan menggunakan teknologi informasi.Dalam penelitian ini penulis menggunakan metodologi <em>Nine step</em> sebagai acuan dalam merancang suatu <em>data warehouse</em><em>,</em> untuk pemodelan menggunakan skema konstelasi fakta dengan 3 tabel fakta dan 11 tabel dimensi. Perbedaan penelitian ini dengan penelitian sebelumnya terletak pada sumber data yang diekstrak langsung dari <em>database</em> SIMRS yang digunakan rumah sakit, sehingga tidak ada ekstraksi data secara manual.Penelitian ini bertujuan untuk menghasilkan desain data warehouse berbasis Online Analytical Processing (OLAP) sebagai sarana penunjang kualitas pelayanan kesehatan rumah sakit. OLAP yang dihasilkan akan berupa desain data warehouse dengan berbagai dimensi yang akan menghasilkan tampilan informasi berupa Chart maupun Grafik sehingga informasinya mudah dibaca dan dipahami oleh berbagai pihak.</p><p class="BodyCxSpFirst"> </p><p class="BodyCxSpFirst"><em><strong>Abtract</strong></em></p><p class="BodyCxSpFirst"><em>The use of information technology is very important for hospitals, because it also affects the quality of health services, which manualy changed to digital using information technology. In this study, the authors used the Nine step methodology as a reference in designing a data warehouse for modeling using a fact constellation schema with 3 fact tables and 11 dimension tables. the different in this study from previous research is that the data source was taken directly from the SIMRS database used by the hospital, so there is no manual data extraction.</em><em>The aim of this research is to be able to produce a Data Warehouse design based on Online Analytical Processing (OLAP) as a means of supporting the quality of hospital health services. The resulting OLAP will be a data warehouse design with various dimensions will produce the displays information in the form of a graph or chart so that the information is easy to read and understand by various parties.</em></p><p class="BodyCxSpLast"><em> </em></p><p class="BodyCxSpFirst"><em><strong><br /></strong></em></p>

scholarly journals What Are Nutrient-Dense Fish Feeds and Their Importance in Aquaculture?

EDIS ◽  
2007 ◽  
Vol 2007 (17) ◽  
Author(s):  
Richard D. Miles ◽  
Frank A. Chapman
Keyword(s):  
Water Quality ◽  
Environmental Water ◽  
Manufacturing Technology ◽  
Animal Performance ◽  
Fact Sheet ◽  
Feed Manufacturing ◽  
Fish Feeds ◽  
Aquaculture Industry ◽  
Aquatic Sciences

FA-145, a 4-page fact sheet by Richard D. Miles and Frank A. Chapman, describes the key nutrition concepts in aquaculture, the role of nutrient-dense feed in animal performance and environmental water quality, and the potential for improved feed manufacturing technology improve the profitability and sustainability of the aquaculture industry. Published by the UF Department of Fisheries and Aquatic Sciences, March 2007. FA145/FA145: What Are Nutrient-Dense Fish Feeds and Their Importance in Aquaculture? (ufl.edu)

scholarly journals Loading, transport, and treatment of emerging chemical and biological contaminants of concern in stormwater

2021 ◽  
Author(s):  
Sumaiya Saifur ◽  
Courtney M. Gardner
Keyword(s):  
Water Quality ◽  
Health Knowledge ◽  
Antibiotic Resistance Genes ◽  
Environmental Water ◽  
The United States ◽  
Urban Environments ◽  
Transport Behavior ◽  
Rural And Urban ◽  
Biological Contaminants ◽  
Quality Water

Abstract Stormwater is a largely uncontrolled source of pollution in rural and urban environments across the United States. Concern regarding the growing diversity and abundance of pollutants in stormwater as well as their impacts on water quality has grown significantly over the past several decades. In addition to conventional contaminants like nutrients and heavy metals, stormwater is a well-documented source of many contaminants of emerging concern, which can be toxic to both aquatic and terrestrial organisms and remain a barrier to maintaining high quality water resources. Chemical pollutants like pharmaceuticals and personal care products, industrial pollutants such as per- and polyfluoroalkyl substances, and tire wear particles in stormwater are of great concern due to their toxic, genotoxic, mutagenic and carcinogenic properties. Emerging microbial contaminants such as pathogens and antibiotic resistance genes also represent significant threats to environmental water quality and human health. Knowledge regarding the transport, behavior, and the remediation capacity of these pollutants in runoff is key for addressing these pollutants in situ and minimizing ecosystem perturbations. To this end, this review paper will analyze current understanding of these contaminants in stormwater runoff in terms of their transport, behavior, and bioremediation potential.

Sign in / Sign up

Export Citation Format

Share Document