• Journal of Computing Science and Engineering
• /
• v.1 no.2
• /
• pp.177-194
• /
• 2007

Index selection is one of the most important decisions to take in the physical design of relational data warehouses. Indices reduce significantly the cost of processing complex OLAP queries, but require storage cost and induce maintenance overhead. Two main types of indices are available: mono-attribute indices (e.g., B-tree, bitmap, hash, etc.) and multi-attribute indices (join indices, bitmap join indices). To optimize star join queries characterized by joins between a large fact table and multiple dimension tables and selections on dimension tables, bitmap join indices are well adapted. They require less storage cost due to their binary representation. However, selecting these indices is a difficult task due to the exponential number of candidate attributes to be indexed. Most of approaches for index selection follow two main steps: (1) pruning the search space (i.e., reducing the number of candidate attributes) and (2) selecting indices using the pruned search space. In this paper, we first propose a data mining driven approach to prune the search space of bitmap join index selection problem. As opposed to an existing our technique that only uses frequency of attributes in queries as a pruning metric, our technique uses not only frequencies, but also other parameters such as the size of dimension tables involved in the indexing process, size of each dimension tuple, and page size on disk. We then define a greedy algorithm to select bitmap join indices that minimize processing cost and verify storage constraint. Finally, in order to evaluate the efficiency of our approach, we compare it with some existing techniques.

• Korean Journal of Fisheries and Aquatic Sciences
• /
• v.43 no.3
• /
• pp.254-261
• /
• 2010

The feeding habits of six shark species, Scyliorhinus torazame, Mustelus manazo, Squalus megalops, Isurus oxyrinchus, Alopias pelagicus, and Carcharhinus plumbeus were studied using the stomach contents of 463 specimens collected between January and February 2007 in the southern sea of Korea. They consumed different prey items. S. torazame preyed mainly crustaceans, and M. manazo on crustaceans and fishes. S. megalops, I. oxyrinchus, A. pelagicus, and C. plumbeus consumed predominately fishes. Non-metric multi-dimensional scaling (NMDS) ordination plots emphasized that dietary similarities separated thesix shark species into three trophic groups based on similarities in percentage Index of Relative Importance (%IRI): Group I (crustacean feeders), Group II (fish and crustacean feeders), and Group III (fish feeders).

• Journal of the Optical Society of Korea
• /
• v.19 no.3
• /
• pp.284-296
• /
• 2015

It has been thought that males tend to use their brain hemispheres more laterally than females. However, recent fMRI studies have shown that there may be no difference in brain lateralization between genders. Functional near-infrared spectroscopy (fNIRS) presents a unique opportunity to acquire real time measurements of blood oxygenation changes to observe neural activity specific to the brain's left and right hemispheres. Using an in-house built multichannel fNIRS system, brain lateralization was observed from seven males and four females according to specially designed tasks for left and right hemisphere activation. The Pearson correlation coefficient and a modified Lateralization Index metric for continuous wave fNIRS systems were calculated to quantify brain lateralization. The preliminary results point to no significant difference in lateral hemodynamic changes between the genders. However, the correlation of symmetrical channel pairs decreased as the experiments progressed. To further develop this study, the subject's performance and the removal of global interference must be implemented for an improved study of brain lateralization.

• Korean Journal of Environmental Biology
• /
• v.31 no.2
• /
• pp.96-104
• /
• 2013

The objectives of this study were to analyze chemical the water quality related to the fish community and to evaluate the ecosystem health based on the faunal composition and guild structure in 2007 in Baekma River. Mean concentrations of biological oxygen demand (BOD) and chemical oxygen demand (COD) were 2.8 and $4.0mg\;L^{-1}$, respectively and total nitrogen (TN) and total phosphorus (TP) were $5.0mg\;L^{-1}$ and $158{\mu}g\;L^{-1}$, which is indicating that the river is in an eutrophic state. Especially, organic pollution and eutrophication occurred in the downstream reach of Baekma River. A total of 19 fish species were collected during the study and the most dominant species was Opsariichthys uncirostris amurensis accounted 48% of the total abundances. The proportion of sensitive species was low (2.3%), compared with that of tolerant species (71.8%). These results suggest that tolerant species and the biotic quality of the fish community was severely degraded. According to the multi-metric model, the Index of Biological Integrity (IBI), the mean model value of the fish community in Baekma River was estimated as 14.8 indicating a "poor" condition. The minimum values of the IBI were observed in the downstreams, and this was mainly attributed to chemical pollutions of nutrients (N, P) and organic matters.

• Journal of Environmental Impact Assessment
• /
• v.18 no.3
• /
• pp.151-160
• /
• 2009

In order to use fundamental data for conservation of species diversity and stream health with dam development, fish investigation in up- and downstream of Pyeonglim Dam was seasonally conducted in 2007~2008. In addition, data of water qualities, investigated for environmental impact assessment, were used to determine a water quality standard level in Pyeonglim Stream, and it revealed that water environment condition was good in the stream. During the study period, a total number of fish caught from the 4 study sites was 5,449 representing 9 families 25 species, and there were 8 Korean endemic species (32.0%) including Rhodeus uyekii, Squalidus gracilis majimae, and Microphysogobio yaluensis. Two species of Zacco temminckii (37.5%) and Zacco platypus (26.3%) were dominant and subdominant in all sites. There were few individuals of the $2^{nd}$-class endangered species (Sand lamprey, Lampetra reissneri) and the introduced species (Bluegill, Lepomis macrochirus), found in the upstream of the dam. and further investigation for conservation of the endangered species and for prevention of the introduced species is needed in future. With fish fauna and multi-metric health assessment model in each sampling attempt, index of biotic integrity(IBI) was evaluated and it resulted mostly in good(26~35) and excellent(36~40) condition in all sites. The results indicate that it is very important to study not only environmental impact assessment with fish composition but also stream health assessment in order to conserve healthy aquatic ecosystem.

• Journal of Environmental Impact Assessment
• /
• v.21 no.6
• /
• pp.841-857
• /
• 2012

Preliminary ecological environmental assessments including physico-chemical constituents, water quality, fish fauna analysis, physical habitat health, and ecological health assessment were conducted as a primary step for Jeungchon micro-habitat ecosystem restoration in 2012. Water chemistry analysis of conductivity, dissolved oxygen, chlorophyll-a and etc. indicated that there were no significant differences(p < 0.05) among 6 sites between the headwaters and downstream. Multi-metric model analysis of Qualitative Habitat Evaluation Index(QHEI) showed that brooklets were at "good condition" as a mean QHEI of 158.7(n = 6) and the longitudinal differences of the model values between the sites were minor(QHEI range: 153 - 165). Total fish species and the number of individuals were 12 and 481, respectively, and dominant species were Zacco platypus(49.5%) and Zacco koreanus(36.8%). Tolerance guild analysis showed that the proportion of sensitive species($S_S$) had a negative linear function[$S_S=86.35-0.31(D_H)$; $R^2$ = 0.892, p < 0.01] with a distance from the headwaters, while the proportion of tolerant species($T_S$) had a positive linear function($R^2$ = 0.950, F = 90.28, p < 0.001) with the distance. Trophic feeding guild analysis showed that the proportion of insectivore species($I_n$) had a negative linear function($R^2$ = 0.934, p < 0.01) with a distance from the headwaters, while the proportion of omnivore species($O_m$) had a positive linear function($R^2$ = 0.958, p < 0.001) with the distance. Index of Biological Integrity(IBI) model, based on fish assemblages, showed a "fair condition" as a mean IBI of 23(n = 6), and there was a distinct differences of ecological health between the headwaters(S1 = 30; "good condition") and the downstreams(S6 = 14; "poor condition"). Overall, the preliminary environmental impact assessments suggest that water quality, physical habitat conditions(QHEI model), and ecological health(IBI model) were maintained well, even if the state was not an excellent conditions.

• Journal of Ecology and Environment
• /
• v.40 no.2
• /
• pp.107-119
• /
• 2016

Background: Previous studies on the biological integrity on habitat and landuse patterns demonstrated ecological stream health in the view of regional or macrohabitat scale, thus ignored the mesoscale habitat patterns of pool, riffle, and runs in the stream health analysis. The objective of this study was to analyze influences on the mesohabitat structures of pool, riffle, and run reaches on the fish guilds and biological integrity in Geum-River Watershed. Results: The mesohabitat structures of pool, riffle, and run reaches influenced the ecological stream health along with some close relations on the fish trophic and tolerance guilds. The mesoscale components altered chemical water quality such as nutrients (TN, TP) and BOD and these, then, determined the primary productions, based on the sestonic chlorophyll-a. The riffle-reach had good chemical conditions, but the pool-reach had nutrient enrichments. The riffle-reach had a predominance of insectivores, while the pool-reach has a predominance of omnivores. Also, the riffle-reach had high proportions of sensitive fish and insectivore fish, and the pool-reach had high proportions of tolerant species in the community composition. The intermediate fish species in tolerance and omnivorous fish species in the food linkage dominated the community in the watershed, and the sensitive and insectivorous fishes decreased rapidly with a degradation of the water quality. All the habitat patterns were largely determined by the land-use patterns in the watershed. Conclusions: Trophic guilds and tolerance guilds of fish were determined by land-use pattern and these determined the stream health, based on the Index of Biological Integrity. This study remarks the necessity to include additional variables to consider information provided by mesohabitats and land-use distributions within the selected stream stretch. Overall, our data suggest that land-use pattern and mesohabitat distribution are important factors to be considered for the trophic and tolerance fish compositions and chemical gradients as well as ecological stream health in the watershed.

• Korean Journal of Environmental Biology
• /
• v.31 no.4
• /
• pp.393-401
• /
• 2013

The objectives of this study were to analyze structures of fish community and the ecological health using a multi-metric fish model, the Index of Biological Integrity (IBI) in the Backje Weir of Geum River during two periods namely before-the-fishkill ($B_f$) and after-the-fishkill ($A_f$). The total number of fish species observed were 32 and among them 10 species (35%) were Korean endemic species. The exotic species observed were 3 which decreased by 0.4% after-the-fishkill ($A_f$). The dominant species were Opsariichthys uncirostris amurensis (13%) at the Bf period and Squalidus japonicus coreanus (17%) at the Af period in the Backje Weir. At after the fishkill ($A_{f-I}$) total biomass was about 10 times lower than the biomass before-the-fishkill ($B_f$). The biomass of Carassius auratus decreased 98% after-the-fishkill and as time passed by the biomass recovered to nearly 100%. Similar decrease in the biomass occurred in the population of Opsariichthys uncirostris amurensis, while Rhinogobius brunneus population increased. According to the structure analysis of fish community, species richness index, evenness index and species diversity index were high but after-the fishkill, the values of indices decreased. Tolerant species (64%) dominated the fish community, and the sensitive species (2%) were rare, indicating the degradation of the ecosystem. According to analysis of the multi-metric model (IBI), the mean model value of the fish community in Backje Weir was estimated as 17.5 indicating a "fair condition".

• Korean Journal of Environment and Ecology
• /
• v.34 no.4
• /
• pp.282-293
• /
• 2020

This study investigated a long-term variation trend of water quality, fish compositions, and ecological health conditions in the Gwanpyeong stream located in the nearby Daejeon metropolitan city to understand the impact of urban development projects on the aquatic ecosystem. The sampling was made in four surveys (2009, 2010, 2016, 2019) before and after urbanization. The urban development was conducted in 2008, resulting in the stream's ecological disturbance, and the stream restoration was conducted in 2012. Thus, stream monitoring was conducted to analyze the ecological trends before and after the restoration. The multi-metric models for Fish Assessment Index(FAI) and necropsy-based Health Assessment Index(HAI) were applied in the fish community and organ-level, respectively, to assess the ecological health of the stream. Minimum turbidity and chlorophyll-a(Chl-a) occurred in the mid-stream(St. 2), and this was probably due to rapid current velocity in the riffle zone. We collected 18 fish species, and the dominant species was Zacco platypus (40.6%). In 2016 immediately after the stream restoration, the relative proportions of sensitive species and insectivore species were the highest along with highest values in the species diversity and species richness index, resulting in the best condition in the ecological health, based on FAI model values. However, the ecological health, based on the FAI, became worse in the latest survey conducted in 2019. The analysis of the HAI model based on the organ-level approach showed skin erosion in the fish of upper stream, kidney defects in downstream, and the liver and gill defects observed in all sites, indicating that the anatomical health was also affected.

• Journal of KIISE:Software and Applications
• /
• v.36 no.9
• /
• pp.749-757
• /
• 2009

A Internet user can easily access to the target information by web searching using some key-words or categories in the present Internet environment. When some meta-data which represent attributes of several data structures well are used, then more accurate result which is matched with the intention of users can be provided. This study proposes a multiple dimensional vector tagging method for the small web user group who interest in maintaining and sharing the bookmark for common interesting topics. The proposed method uses vector tag method for increasing the effect of categorization, management, and retrieval of target information. The vector tag composes with two or more components of the user defined priority. The basic vector space is created time of information and reference value. The calculated vector value shows the usability of information and became the metric of ranking. The ranking accuracy of the proposed method compares with that of a simply link structure, The proposed method shows better results for corresponding the intention of users.