• Title/Summary/Keyword: relational

Search Result 2,113, Processing Time 0.025 seconds

Spatial Partitioning for Query Result Size Estimation in Spatial Databases (공간 데이터베이스에서 질의 결과 크기 추정을 위한 공간 분할)

  • 황환규
    • Journal of the Institute of Electronics Engineers of Korea CI
    • /
    • v.41 no.2
    • /
    • pp.23-32
    • /
    • 2004
  • The query optimizer's important task while a query is invoked is to estimate the fraction of records in the databases that satisfy the given query condition. The query result size estimation in spatial databases, like relational databases, proceeds to partition the whole input into a small number of subsets called “buckets” and then estimate the fraction of the input in the buckets. The accuracy of estimation is determined by the difference between the real data counts and approximations in the buckets, and is dependent on how to partition the buckets. Existing techniques for spatial databases are equi-area and equi-count techniques, which are respectively analogous in relation databases to equi-height histogram that divides the input value range into buckets of equal size and equi-depth histogram that is equal to the number of records within each bucket. In this paper we propose a new partitioning technique that determines buckets according to the maximal difference of area which is defined as the product of data ranges End frequencies of input. In this new technique we consider both data values and frequencies of input data simultaneously, and thus achieve substantial improvements in accuracy over existing approaches. We present a detailed experimental study of the accuracy of query result size estimation comparing the proposed technique and the existing techniques using synthetic as well as real-life datasets. Experiments confirm that our proposed techniques offer better accuracy in query result size estimation than the existing techniques for space query size, bucket number, data number and data size.

Analysis on Relation between Rehabilitation Training Movement and Muscle Activation using Weighted Association Rule Discovery (가중연관규칙 탐사를 이용한 재활훈련운동과 근육 활성의 연관성 분석)

  • Lee, Ah-Reum;Piao, Youn-Jun;Kwon, Tae-Kyu;Kim, Jung-Ja
    • Journal of the Institute of Electronics Engineers of Korea CI
    • /
    • v.46 no.6
    • /
    • pp.7-17
    • /
    • 2009
  • The precise analysis of exercise data for designing an effective rehabilitation system is very important as a feedback for planing the next exercising step. Many subjective and reliable research outcomes that were obtained by analysis and evaluation for the human motor ability by various methods of biomechanical experiments have been introduced. Most of them include quantitative analysis based on basic statistical methods, which are not practical enough for application to real clinical problems. In this situation, data mining technology can be a promising approach for clinical decision support system by discovering meaningful hidden rules and patterns from large volume of data obtained from the problem domain. In this research, in order to find relational rules between posture training type and muscle activation pattern, we investigated an application of the WAR(Weishted Association Rule) to the biomechanical data obtained mainly for evaluation of postural control ability. The discovered rules can be used as a quantitative prior knowledge for expert's decision making for rehabilitation plan. The discovered rules can be used as a more qualitative and useful priori knowledge for the rehabilitation and clinical expert's decision-making, and as a index for planning an optimal rehabilitation exercise model for a patient.

Psychological distress and fertility quality of life (FertiQoL) in infertile Korean women: The first validation study of Korean FertiQoL

  • Chi, Hee-Jun;Park, Il-Hae;Sun, Hong-Gil;Kim, Jae-Won;Lee, Kyeong-Ho
    • Clinical and Experimental Reproductive Medicine
    • /
    • v.43 no.3
    • /
    • pp.174-180
    • /
    • 2016
  • Objective: To investigate psychological distress and fertility quality of life (FertiQoL) in infertile Korean women, and to investigate whether a correlation exists between psychological distress and FertiQoL. Methods: Participants in this study were made up of 141 infertile women and 65 fertile women. We conducted a survey on psychological distress (using the Depression Anxiety Stress Scales [DASS]-42 questionnaire) and administered a FertiQoL questionnaire. The levels of stress hormones (adrenocorticotropic hormone [ACTH] and cortisol) in serum were assessed. Results: The scores for depression ($13.7{\pm}8.4$), anxiety ($10.7{\pm}6.4$), and stress ($18.0{\pm}8.3$) among the infertile women were significantly higher than the scores for depression ($9.4{\pm}7.5$), anxiety ($6.6{\pm}6.0$), and stress ($12.2{\pm}8.3$, p<0.001) among the fertile women. There was no difference in the scores for depression ($13.5{\pm}8.2$, $13.8{\pm}8.6$), anxiety ($10.0{\pm}6.2$, $11.5{\pm}6.6$) and stress ($17.7{\pm}8.4$, $18.4{\pm}8.1$) between younger (${\leq}34$) and older (${\geq}35$) participants. The mind-body (r =-0.495) and emotional (r =-0.590) subscales showed a higher negative correlation with stress compared with other scales of psychological distress. At the same time, the social (r =-0.537) and relational (r =-0.385) subscales showed a higher negative correlation with depression. Levels of cortisol and ACTH in infertile women were $9.1{\mu}g/mL$ and 11.9 pg/mL, respectively, which are within normal ranges. Conclusion: The levels of psychological distress and quality of life in infertile Korean women seem to require psychological intervention. This study provides a baseline measurement of psychological distress and FertiQoL in infertile women in Korea, which will be available for developing psychological interventions for infertile Korean women.

A study on the determination of location of the detention pond in trunk sewer for reducing runoff amounts (우수유출저감을 위한 간선저류지 위치선정에 관한 연구)

  • Lee, Sung Ho;Yoon, Sei Eui;Lee, Jae Joon
    • Journal of Korea Water Resources Association
    • /
    • v.50 no.4
    • /
    • pp.223-232
    • /
    • 2017
  • The ability to defend against floods in urban areas was weakened, because the increase in the impervious rate of urban areas due to urbanization and industrialization and the increase in the localized torrential rainfall due to abnormal climate. In order to reduce flood damage in urban areas, various runoff reduction facilities such as detention ponds and infiltration facilities were installed. However, in the case of domestic metropolitan cities, it is difficult to secure land for the installation of storm water reduction facilities and secure the budget for improving the aged pipelines. Therefore, it is necessary to design a storage system (called the detention pond in trunk sewer) that linked the existing drainage system to improve the flood control capacity of the urban area and reduce the budget. In this study, to analyze the effect of reducing runoff amounts according to the volume of the detention pond in trunk sewer, three kinds of virtual watershed (longitudinal, middle, concentration shape) were assumed and the detention pond in trunk sewer was installed at an arbitrary location in the watershed. The volume of the detention pond in trunk sewer was set to 6 cases ($1,000m^3$, $3,000m^3$, $5,000m^3$, $10,000m^3$, $20,000m^3$, $30,000m^3$), and the installation location of the detention pond in trunk sewer was varied to 20%, 40%, 60%, and 80% of the detention pond upstream area to the total watershed area (DUAR). Also, using the results of this study, a graph of the relationship and relational equation between the volume of the detention pond in trunk sewer and the installation location is presented.

Experiments of Individual Tree and Crown Width Extraction by Band Combination Using Monthly Drone Images (월별 드론 영상을 이용한 밴드 조합에 따른 수목 개체 및 수관폭 추출 실험)

  • Lim, Ye Seul;Eo, Yang Dam;Jeon, Min Cheol;Lee, Mi Hee;Pyeon, Mu Wook
    • Journal of Korean Society for Geospatial Information Science
    • /
    • v.24 no.4
    • /
    • pp.67-74
    • /
    • 2016
  • Drone images with high spatial resolution are emerging as an alternative to previous studies with extraction limits in high density forests. Individual tree in the dense forests were extracted from drone images. To detect the individual tree extracted through the image segmentation process, the image segmentation results were compared between the combination of DSM and all R,G,B band and the combination of DSM and R,G,B band separately. The changes in the tree density of a deciduous forest was experimented by time and image. Especially the image of May when the forests are dense, among the images of March, April, May, the individual tree extraction rate based on the trees surveyed on the site was 50%. The analysis results of the width of crown showed that the RMSE was less than 1.5m, which was the best result. For extraction of the experimental area, the two sizes of medium and small trees were extracted, and the extraction accuracy of the small trees was higher. The forest tree volume and forest biomass could be estimated if the tree height is extracted based on the above data and the DBH(diameter at breast height) is estimated using the relational expression between crown width and DBH.

Development of relationship equation for vehicle sensor signal and observed rainfall (차량용 강우센서의 Signal과 관측강우의 관계식 개발)

  • Lee, Suk Ho;Kim, Young Gon;Kim, Byung Sik
    • Journal of Korea Water Resources Association
    • /
    • v.50 no.1
    • /
    • pp.29-35
    • /
    • 2017
  • A vehicle rainfall sensor is made to control the operating speed of wipers depending on rainfall. Therefore this is the apparatus to determine the velocity phase of the wipers roughly based on the amount of rainfall. However, the technology which can judge the size of rainfall amount besides determining speed level of the wipers is developing according to the development of the function of rainfall sensor due to the development of technology. In this study, a rainfall measurement by using light scattering by precipitation particles was used. This measurement is to use light signal reflection from front glass and the bigger particle is the less detection of light by light scattering. The detection area of the rainfall sensor and detection channel were extended sizes to increase the accuracy of the rainfall. Also the W-S-R relational expression was developed by using a relationship between the specific precipitation (R) and the amount of sensor detection (S) when there is speed change of the wipers (W) and an indoor rainfall apparatus was used to convert sensing signal to rainfall. The signal system of vehicle rainfall sensor can be converted to the actual rainfall amount by using this formula and if this is provided to users then the vehicle observation network can produce higher-resolution than actual observation network can be produced.

A Study on Feature Classification and Data Dictionary of Digital Map (수치지도 지형지물 분류체계 개선 및 자료사전에 관한 연구)

  • 조우석;이동구;윤영보
    • Spatial Information Research
    • /
    • v.10 no.3
    • /
    • pp.455-468
    • /
    • 2002
  • Toward the systematic and efficient management of national land, National Geography Institute(NGI, National mapping agency) has been producing national basemap in automated process since middle of 1980's. Under the National Geographic Information System(NGIS) Development Plan, NGI began to produce digital maps in the scales of 1:1,000, 1:5,000, 1:25,000 since 1995. However, those of digital maps that have been generated under NGIS Development Plan need to be modified and corrected due to lack of technology and experience in making digital maps. In this context, those digital maps generated are currently in great need for improving the data dictionary. It is fully appreciated in previous research that data dictionary will be a key element far users and generators of digital maps to rectify the existing problems in digital maps as well as to maximize the application of digital maps. In this paper, we analyzed existing problems in digital maps based on previous researches and interviews with engineers in different fields of geospatial engineering. And then, the existing data dictionary has been redefined and modified. In the line of modification process, a relational matrix was established fur each topographic feature defined in the existing feature classification system. This paper presents newly proposed data dictionary which conforms to newly defined feature classification system from previous research performed by NGI.

  • PDF

Analysis of Relationship between Land Cover Change and Vegetation Temperature Condition Index in Central Dry Zone of Myanmar (미얀마 건조지 토지피복 변화와 식생온도조건지수간의 관계분석)

  • Choi, Sol-E;Lee, Woo-Kyun;Yu, Hangnan;Kang, Ho-Duck;Kim, Yong-Suk
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.17 no.2
    • /
    • pp.82-94
    • /
    • 2014
  • The purpose of this study is to investigate the cause of increasing dry zones through analyzing relationships between land cover and Vegetation Temperature Condition Index(VTCI) using Landsat 4-5 TM satellite images in Central Dry Zones of Myanmar. As a result of land cover classifications, while vegetation areas gradually decrease, residential area and cropland were increased. VTCI analysis shows that region (a) showed a gradual decrease in the area of severely arid, and increase in the area of moderate dry and wet, which sums up to a slight decrease in aridity. Region (b) also showed to increase in dry areas and severe aridity. The result of relational analysis between VTCI and land cover change showed high ratio of land cover change, from severe arid area to forest and residential farmland. The average VTCI decreased in the changed land covers, which indicates the relationship between aridity and land cover change and a gradual increase in the arid area was identified.

A study on the formation process of opportunism in strategic alliance (전략적 제휴에서의 기회주의행동 유발과정에 관한 연구)

  • Kang, Inwon;Park, Kyungsin
    • International Commerce and Information Review
    • /
    • v.17 no.3
    • /
    • pp.225-250
    • /
    • 2015
  • While strategic alliance of multinational corporation has boost, opportunistic behavior is also increased recently. This study examines the cause of opportunism in strategic alliance by focusing on the development of opportunistic behavior, a process in which resource complementarity and risk perception decides attitudinal direction, ultimately leading to opportunism. Empirical test based on 257 alliance participants shows that risk perception had a greater influence on firms' attitudinal and behavioral directions compared to benefit perception. Notably, relational risk heavily influenced firms' competitive attitude and opportunistic behavior. Finally, the study concludes that firms' competitive and independent attitude caused by risk perception negatively influence alliance outcome. Based on the results, it is drawn that alongside the external tools such as surveillance, control, monitoring or legalistic pleas, management of risk perception during the alliance process has significance influence on the achievement of alliance goals.

  • PDF

Improvement of Non-linear Estimation Equation of Rainfall Intensity over the Korean Peninsula by using the Brightness Temperature of Satellite and Radar Reflectivity Data (기상위성 휘도온도와 기상레이더 반사도 자료를 이용한 한반도 영역의 강우강도 추정 비선형 관계식 개선)

  • Choi, Haklim;Seo, Jong-Jin;Bae, Juyeon;Kim, Sujin;Lee, Kwang-Mog
    • Journal of the Korean earth science society
    • /
    • v.39 no.2
    • /
    • pp.131-138
    • /
    • 2018
  • The purpose of this study is to improve the quantitative precipitation estimation method based on satellite brightness temperature. The non-linear equation for rainfall estimation is improved by analysing precipitation cases around the Korean peninsula in summer. Radar reflectivity is adopted the CAPPI 1.5 and CMAX composite fields that provided by the Korea Meteorological Agency (KMA). In addition, the satellite data are used infrared, water vapor and visible channel measured from meteorological imager sensor mounted on the Chollian satellite. The improved algorithm is compared with the results of the A-E method and CRR analytic function. POD, FAR and CSI are 0.67, 0.76 and 0.21, respectively. The MAE and RMSE are 2.49 and 6.18 mm/h. As the quantitative error was reduced in comparison to A-E and qualitative accuracy increased in compare with CRR, the disadvantage of both algorithms are complemented. The method of estimating precipitation through a relational expression can be used for short-term forecasting because of allowing precipitation estimation in a short time without going through complicated algorithms.