Data Types Diversity Quantitative Indicators in Relational Databases Physical Models

TEM Journal ◽  
2020 ◽  
pp. 862-867
Author(s):  
Alexander Aleksandrovich Rybanov ◽  
Makushkina Lidiya Aleksandrovna
Keyword(s):  
Comparative Analysis ◽  
Relational Databases ◽  
Diversity Index ◽  
Diversity Indices ◽  
Physical Models ◽  
Qualitative Assessment ◽  
Data Types ◽  
New Models ◽  
Evenness Index ◽  
Quantitative Indicators

The article compares diversity indices applicability used in ecology to assess data types distribution for physical database schemes. The following dominance measures are used to assess the data type's diversity in the physical database scheme: Simpson's diversity index, Shannon diversity index, Simpson's evenness index, Pielu evenness index. A comparative analysis of the data type's diversity indicators for physical database schemes showed that the values of some indices obey certain rules. It is proposed to use diversity indices for physical database schemes' qualitative assessment. The indices considered in this work can also be used to build new models for assessing database complexity.

scholarly journals Species enumeration and diversity of fire experimental plot at Olokemeji Forest Reserve, Ogun State, Nigeria

Agro-Science ◽  
2021 ◽  
Vol 20 (2) ◽  
pp. 37-41
Author(s):  
A.J. Oloketuyi ◽  
O.D. Akinyemi ◽  
D.M. Taiwo ◽  
O.R. Jeminiwa ◽  
A.A. Ayodele
Keyword(s):  
Diversity Index ◽  
Abundant Species ◽  
Diversity Indices ◽  
Shannon Index ◽  
Experimental Plot ◽  
Gmelina Arborea ◽  
Forest Reserve ◽  
Ogun State ◽  
Evenness Index ◽  
High Dominance

The fire experimental plot of a total landed area of 0.174 ha was divided into three equal parts designated Plot A, Plot B and Plot C, corresponding to the early burnt, the late burnt and the control plot, respectively. Out of the 15 species of trees identified, six species belong to Fabaceae- Mimosoideae family and other families represented are Combretaceae, Meliaceae, Lamiaceae, Rubiaceae, Anacardiaceae, Urtiaceae and Sapotaceae. Gmelina arborea was the most abundant species and it was found in plot A, B and C. The diversity indices enumerated were Dominance index, Simpson index, Shannon index or diversity index and evenness index. Plot C had the highest abundance (species count), followed by Plot A and Plot B. While Plot B depicted a high dominance, dominance was low in Plot A and lowest in Plot C. This means that a particular species was dominating Plot B, which was Gmelina arborea. This Gmelina arborea also dominated Plot A but to a lesser extent compared to Plot B. Plot C was richer in species than Plot A and Plot B. The Shannon index was low across the three plots, but considerably highest in Plot C. Evenness index was moderate at Plot C, implying that there was an even distribution of tree species in Plot C, while evenness was low at Plot A and Plot B. Comparing the present data with the older data, it is clear that the fire experimental plot has undergone deforestation over the years, which requires urgent attention and reforestation. Key words: cluster, dendogram, deforestation, burning, richness

scholarly journals Biodiversity of benthic macroinvertebrates in Sungai Kisap, Langkawi, Kedah, Malaysia

2021 ◽  
Vol 6 (1) ◽  
pp. 36-40
Author(s):  
S. Nurhafizah-Azwa ◽  
A.K. Ahmad
Keyword(s):  
Water Quality ◽  
Benthic Macroinvertebrates ◽  
Diversity Index ◽  
Strong Relationship ◽  
Biological Indicators ◽  
Diversity Indices ◽  
Average Value ◽  
Evenness Index ◽  
Moderate Condition ◽  
Richness Index

A study on macroinvertebrate diversity was conducted in Sungai Kisap, Langkawi, Kedah. Five stations were selected with a distance of approximately 500 metres apart with three replications of benthos and two replications of water sample. The results classified Sungai Kisap in Class I, which indicates very good water quality based on WQI recommended by the Department of Environment. A total of 2 phyla, 3 classes, 8 orders, 29 families, and 3564 individuals were successfully sampled and recorded. The presence of Hydropsychidae, Baetidae, and Chironomidae with a high abundance of the families show the potential to be used as biological indicators of a clean ecosystem. The analysis showed that the average value of Shannon Diversity Index, H’ (1.28), Pielou Evenness Index, J’ (0.45), and Margaleff Richness Index, DMG (2.80) indicates that Sungai Kisap is in moderate condition and the distribution of macroinvertebrates is uniform between stations. The correlation test showed that the WQI has a strong relationship with the diversity indices involved. BMWP, ASPT, and FBI showed that Sungai Kisap has good water quality.

Assemblage Patterns of Hymenoptera at Different Elevations of Gunung Datuk, Rembau

2017 ◽  
Vol 14 (2) ◽  
pp. 1 ◽  
Author(s):  
Noor Nasuha Abd Aziz ◽  
Siti Khairiyah Mohd Hatta ◽  
Idris Abd Ghani ◽  
Saiyid Jalaluddin Saiyid Shaifuddin
Keyword(s):  
Species Richness ◽  
Diversity Index ◽  
High Elevation ◽  
Significant Difference ◽  
Index Site ◽  
Evenness Index ◽  
Abundance And Diversity ◽  
Richness Index ◽  
Paired T Test ◽  
Malaise Traps

A study on abundance and diversity of Hymenoptera was conducted in Gunung Datuk, Rembau. Samplings were conducted from November 2014 to February 2015 using six Malaise traps. Three traps were placed at Site 1 at 700m height for high elevation and the remaining traps were placed at Site 2 at 200m height for low elevation. A total number of 221 Hymenopteran were collected which consist of nine families namely Ichneumonidae, Formicidae, Braconidae, Bethylidae, Evaniidae, Tiphiidae, Vespidae, Pompilidae and Apidae. In this study, 93 individuals were obtained from Site 1, comprising nine families and 43 morphospecies while 127 individuals were obtained from Site 2 with nine families and 45 morphospecies. Formicidae was the most dominant family collected from both sites with a total of 104 individuals while the least family recorded was Apidae with only one individual. Shannon’s Weiner Diversity Index (H’) showed Site 1 had the higher diversity value with H’ = 3.17 compared to Site 2 with value H’ = 3.12. For Evenness Index, Site 1 had higher value compared to Site 2 with E’ = 0.84 and E’ = 0.82 respectively. Moreover, for Margalef Richness Index, Site 1 recorded R’ = 9.24 while site two recorded R’ = 9.08 which concluded that Site 1 had higher species richness compared to Site 2. Paired t-test showed that both sites had no significant difference with p>0.05. Overall study showed that the diversity and abundance of Hymenoptera in Gunung Datuk were low since the value of H’ is less than 3.50.

scholarly journals On a Variational Definition for the Jensen-Shannon Symmetrization of Distances Based on the Information Radius

Entropy ◽  
2021 ◽  
Vol 23 (4) ◽  
pp. 464
Author(s):  
Frank Nielsen
Keyword(s):  
Diversity Index ◽  
Diversity Indices ◽  
Shannon Diversity Index ◽  
Probability Measures ◽  
Variational Optimization ◽  
Shannon Diversity ◽  
Concept Of Information ◽  
Jensen Shannon Divergence

We generalize the Jensen-Shannon divergence and the Jensen-Shannon diversity index by considering a variational definition with respect to a generic mean, thereby extending the notion of Sibson’s information radius. The variational definition applies to any arbitrary distance and yields a new way to define a Jensen-Shannon symmetrization of distances. When the variational optimization is further constrained to belong to prescribed families of probability measures, we get relative Jensen-Shannon divergences and their equivalent Jensen-Shannon symmetrizations of distances that generalize the concept of information projections. Finally, we touch upon applications of these variational Jensen-Shannon divergences and diversity indices to clustering and quantization tasks of probability measures, including statistical mixtures.

scholarly journals Comparative Analysis of Epidermal Differentiation Genes of Crocodilians Suggests New Models for the Evolutionary Origin of Avian Feather Proteins

2018 ◽  
Vol 10 (2) ◽  
pp. 694-704 ◽  
Author(s):  
Karin Brigit Holthaus ◽  
Bettina Strasser ◽  
Julia Lachner ◽  
Supawadee Sukseree ◽  
Wolfgang Sipos ◽  
...  
Keyword(s):  
Comparative Analysis ◽  
Epidermal Differentiation ◽  
Evolutionary Origin ◽  
New Models

COMPARATIVE ANALYSIS OF THE PHYSICOCHEMICAL PROPERTIES OF VARIETAL RED WINES RESEARCHED BY DIFFERENT METHODS

2021 ◽  
Author(s):  
О.Н. ШЕЛУДЬКО ◽  
Н.К. СТРИЖОВ ◽  
Е.С. КОСАРЕВ ◽  
Н.О. ШЕЛУДЬКО
Keyword(s):  
Comparative Analysis ◽  
Organic Acids ◽  
Vitis Vinifera ◽  
Alkaline Earth ◽  
Optical Spectra ◽  
Alkaline Earth Metals ◽  
Qualitative Assessment ◽  
Red Wines ◽  
Vitis Labrusca ◽  
Titration Curves

Проведен сравнительный анализ вида кривых титрования, оптических спектров, содержания органических кислот и катионов щелочных и щелочноземельных металлов красных сортовых вин с нахождением критериальных маркеров. Объекты исследования – красные сортовые вина, произведенные по одной технологии из выращенного в центральной зоне Краснодарского края винограда сортов Каберне Совиньон, Мерло, Саперави, Изабелла. Установлено, что кривые титрования индивидуальны, позволяют дать качественную оценку подлинности винодельческой продукции по начальной величине рН (обусловлена содержанием калия), виду кривых титрования до начала скачка (обусловлен содержанием винной и яблочной кислот). Определено количественное содержание титруемых кислот, а также маркерные значения, подтверждающие подлинность вин: рНо, tk, dpH/dt. Оптические свойства вин не позволяют дать количественную оценку фенольных веществ, но расширяют возможности применения данного метода в качестве интегральной характеристики сортовых красных вин по виду оптического спектра и значению оптической плотности D и длине волны λ. Отношение катионов щелочных и щелочноземельных металлов между собой можно применять в качестве дополнительного маркера сортовых вин, произведенных из винограда вида Vitis vinifera или Vitis labrusca. Показано, что отличие форм кривых титрования разных вин, а также оптических спектров и различия содержания органических кислот и катионов щелочных и щелочноземельных металлов можно использовать как графические образы винодельческой продукции конкретного наименования в рамках национальной системы защиты вин, обладающих особыми качествами. A comparative analysis of the type of titration curves, optical spectra, the content of organic acids and cations of alkaline and alkaline earth metals of red varietal wines with the search for criteria markers was carried out. The objects of the study are red varietal wines produced using the same technology from grapes grown in the central zone of the Krasnodar Territory, the variety: Cabernet Sauvignon, Merlot, Saperavi, Isabella. It is established that the titration curves are individual, allowing us to give a qualitative assessment of the authenticity of wine products by the initial pH value (due to the potassium content), by the type of titration curves before the jump (due to the content of tartaric and malic acids). The quantitative content of titrated acids was determined, as well as marker values confirming the authenticity of the wines: pH, tk, dpH/dt. The optical properties of wines do not allow us to give a quantitative assessment of phenolic substances, but they expand the possibilities of using this method as an integral characteristic of varietal red wines by the type of optical spectrum and the value of the optical density D and the wavelength λ. The ratio of cations of alkali and alkaline earth metals to each other can be used as an additional marker of varietal wines produced from grapes of the Vitis vinifera or Vitis labrusca species. It is shown that the difference in the shapes of the titration curves of different wines, as well as the optical spectra and differences in the content of organic acids and cations of alkaline and alkaline earth metals can be used as graphic images of wine products of a specific denomination within the framework of the national system for the protection of wines with special qualities.

scholarly journals Distance Effects on Diversity and Abundance of the Flower Visitors of Ocimum kilimandscharicum in the Kakamega Forest Ecosystem

2018 ◽  
Vol 2018 ◽  
pp. 1-7 ◽  
Author(s):  
Hellen K. Mandela ◽  
Mugatsia H. Tsingalia ◽  
Mary Gikungu ◽  
Wilbur M. Lwande
Keyword(s):  
Species Diversity ◽  
Diversity Index ◽  
Land Use Changes ◽  
Species Abundance ◽  
Diversity Indices ◽  
Forest Edge ◽  
Flower Visitors ◽  
Kakamega Forest ◽  
Species Invasions ◽  
Wiener Diversity Index

Pollination is an important ecosystem service in the maintenance of biodiversity and most importantly in food production. Pollination is on the decline due to habitat loss, exotic species invasions, pollution, overharvesting, and land use changes. This study analyzed the abundance and diversity of flower visitors’ of Ocimum kilimandscharicum in Kakamega forest with increasing distance from the forest edge. Data were collected through direct observation and sweep netting. Six study sites were identified along two transects each 2.5 km long and labeled A to F. Distance in metres from the forest edge to each site was A=221, B=72, C=83, D=198, E=113, and F=50. Sampling was done from 7:30 am to 4:00 pm, three days in a week for five months consecutively. Diversity indices of different flower visitors were calculated using the Shannon-Wiener diversity index. One-way analysis of variance was used to compare differences between sites and a two-sample t-test was used to identify mean significant differences in species diversity between the closest and the furthest sites. A total of 645 individuals belonging to 35 species were captured from 4 families. The highest diversity was at site F (H’= 2.38) which was closest to the forest edge and the lowest diversity was from site A (H’=1.44) which was furthest from the forest edge. Distance from the forest edge significantly influenced species diversity (F(3, 20)=14.67, p=0.024). Distance from the forest edge also significantly influenced species abundance between the furthest sites A, D, and E and the nearest sites F, B, and C to the forest edge (t=4.177; p=0.0312) and species richness (t=3.2893; p=0.0187). This study clearly demonstrates that Ocimum kilimandscharicum flower visitors play essential roles in pollination and their higher number of visits translates into higher numbers of seeds set. Many of these pollinators are associated with the forest and hence the need to conserve the Kakamega forest as a source pool for pollinators.

Formalizing the Mapping of UML Conceptual Schemas to Column-Oriented Databases

2018 ◽  
Vol 14 (3) ◽  
pp. 44-68 ◽  
Author(s):  
Fatma Abdelhedi ◽  
Amal Ait Brahim ◽  
Gilles Zurfluh
Keyword(s):  
Big Data ◽  
Data Warehouse ◽  
Relational Databases ◽  
Traditional Approach ◽  
Physical Models ◽  
Decision Making Process ◽  
Nosql Databases ◽  
Care Field ◽  
Sufficient Degree

Nowadays, most organizations need to improve their decision-making process using Big Data. To achieve this, they have to store Big Data, perform an analysis, and transform the results into useful and valuable information. To perform this, it's necessary to deal with new challenges in designing and creating data warehouse. Traditionally, creating a data warehouse followed well-governed process based on relational databases. The influence of Big Data challenged this traditional approach primarily due to the changing nature of data. As a result, using NoSQL databases has become a necessity to handle Big Data challenges. In this article, the authors show how to create a data warehouse on NoSQL systems. They propose the Object2NoSQL process that generates column-oriented physical models starting from a UML conceptual model. To ensure efficient automatic transformation, they propose a logical model that exhibits a sufficient degree of independence so as to enable its mapping to one or more column-oriented platforms. The authors provide experiments of their approach using a case study in the health care field.

scholarly journals THE ANALYSIS OF OIL CONTENT IN SEDIMENT AND COMMUNITY STRUCTURE OF MACROZOOBENTHOS IN BELAWAN WATERS OF MEDAN CITY, NORTH SUMATERA PROVINCE

2020 ◽  
Vol 3 (2) ◽  
pp. 167-178
Author(s):  
Doli Juna Setia Tanjung ◽  
Bintal Amin ◽  
Syafruddin Nasution
Keyword(s):  
Community Structure ◽  
Linear Regression ◽  
Oil Content ◽  
Diversity Index ◽  
The Other ◽  
Regression Analyses ◽  
Simple Linear Regression ◽  
Dominance Index ◽  
Ocypode Quadrata ◽  
Evenness Index

This research was conducted in March 2019 to determine the oil content in sediment, it’s community structure of macrozoobenthos and it’s a relationship in Belawan Waters of Medan City, North Sumatera. Four sampling stations with five replications in each station were surveyed. The results showed that the average oil content in sediments exceeded the threshold had set by the National Academy of Science. Macrozoobenthos found consists of Ocypode quadrata, Scyla serrate, Rotun dicauda, Penaeus sp, Murex tribulus, and Nassarius olivaccus. The highest abundance was in Station 3 and the lowest was in Station 2. The diversity index in each station was generally very low. Dominance Index in Station 4 was medium, whilst the other stations were high. Evenness index showed in Station 3 and 4 were in high population, Station 1 was in medium population and Station 2 was in low population. Simple linear regression analyses between oil content in sediment with community structure of macrozoobenthos indicated negative correlation ( Y = 10,5-0,0001x , R2 = 0,0004 and r = 0,02 ) which indicated that the higher the oil content, the lower the macrozoobenthos abundance in sediment.

Sign in / Sign up

Export Citation Format

Share Document