• Title/Summary/Keyword: database model

Search Result 3,006, Processing Time 0.036 seconds

A Pipelined Hash Join Method for Load Balancing (부하 균형 유지를 고려한 파이프라인 해시 조인 방법)

  • Moon, Jin-Gue;Park, No-Sang;Kim, Pyeong-Jung;Jin, Seong-Il
    • The KIPS Transactions:PartD
    • /
    • v.9D no.5
    • /
    • pp.755-768
    • /
    • 2002
  • We investigate the effect of the data skew of join attributes on the performance of a pipelined multi-way hash join method, and propose two new hash join methods with load balancing capabilities. The first proposed method allocates buckets statically by round-robin fashion, and the second one allocates buckets adaptively via a frequency distribution. Using hash-based joins, multiple joins can be pipelined so that the early results from a join, before the whole join is completed, are sent to the next join processing without staying on disks. Unless the pipelining execution of multiple hash joins includes some load balancing mechanisms, the skew effect can severely deteriorate system performance. In this paper, we derive an execution model of the pipeline segment and a cost model, and develop a simulator for the study. As shown by our simulation with a wide range of parameters, join selectivities and sizes of relations deteriorate the system performance as the degree of data skew is larger. But the proposed method using a large number of buckets and a tuning technique can offer substantial robustness against a wide range of skew conditions.

Estimation of the Flood Warning Rainfall with Backwater Effects in Urban Watersheds (도시 유역의 배수위 영향을 고려한홍수 경보 강우량 산정)

  • Kim, Eung-Seok;Lee, Seung-Hyun;Yoon, Ki-Yong
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.16 no.1
    • /
    • pp.801-806
    • /
    • 2015
  • The incidence of flood damage by global climate change has increased recently. Because of the increased frequency of flooding in Korea, the technology of flood prediction and prevalence has developed mainly for large river watersheds. On the other hand, there is a limit on predicting flooding through the most present flood forecasting systems because local floods in small watersheds rise quite quickly with little or no advance warning. Therefore, this study estimated the flood warning rainfall using a flood forecasting model at the two alarm trigger points in the Suamcheon basin, which is an urban basin with backwater effects. The flood warning rainfall was estimated to be 25.4mm/120min ~ 78.8mm/120min for the low water alarm, and 68.5mm/120min ~ 140.7mm/120min for the high water alarm. The frequency of the flood warning rainfall is 3-years for the low water alarm, and 80-years for the high water alarm. The results of this analysis are expected to provide a basic database in forecasting local floods in urban watersheds. Nevertheless, more tests and implementations using a large number of watersheds will be needed for a practical flood warning or alert system in the future.

Normalization of Face Images Subject to Directional Illumination using Linear Model (선형모델을 이용한 방향성 조명하의 얼굴영상 정규화)

  • 고재필;김은주;변혜란
    • Journal of KIISE:Software and Applications
    • /
    • v.31 no.1
    • /
    • pp.54-60
    • /
    • 2004
  • Face recognition is one of the problems to be solved by appearance based matching technique. However, the appearance of face image is very sensitive to variation in illumination. One of the easiest ways for better performance is to collect more training samples acquired under variable lightings but it is not practical in real world. ]:n object recognition, it is desirable to focus on feature extraction or normalization technique rather than focus on classifier. This paper presents a simple approach to normalization of faces subject to directional illumination. This is one of the significant issues that cause error in the face recognition process. The proposed method, ICR(illumination Compensation based on Multiple Linear Regression), is to find the plane that best fits the intensity distribution of the face image using the multiple linear regression, then use this plane to normalize the face image. The advantages of our method are simple and practical. The planar approximation of a face image is mathematically defined by the simple linear model. We provide experimental results to demonstrate the performance of the proposed ICR method on public face databases and our database. The experimental results show a significant improvement of the recognition accuracy.

A Study to Develop Monthly Cover Management Factor Database for Monthly Soil Loss Estimation (월단위 토양유실가능추정치를 위한 지표피복인자의 산정 방안 연구)

  • Sung, Yun Soo;Jung, Yunghun;Lim, Kyoung Jae;Kim, Jonggun;Kim, Ki-Sung;Park, Seung Ki;Shin, Min Hwan;Kum, Dong Hyuk;Park, Youn Shik
    • Journal of The Korean Society of Agricultural Engineers
    • /
    • v.58 no.6
    • /
    • pp.23-30
    • /
    • 2016
  • Soil loss is an accompanying phenomenon of hydrologic cycle in watersheds. Both rainfall drops and runoff lead to soil particle detachment, the detached soil particles are transported into streams by runoff. Here, a sediment-laden water problem can be issued if soil particles are severely detached and transported into stream in the watershed. There is a need to estimate or simulate soil erosion in watersheds so that an adequate plan to manage soil erosion can be established. Universal Soil Loss Equation (USLE), therefore, was developed and modified by many researchers for their watersheds, moreover the simple model, USLE, has been employed in many hydrologic models for soil erosion simulations. While the USLE has been applied even in South-Korea, the model is often regarded as being limited in applications for the watersheds in South-Korea since monthly conditions against soil erosion on soil surface are not capable to represent. Thus, the monthly USLE factors against soil erosion, soil erodibility and crop management factors, were established for four major watersheds, which are Daecheong-dam, Soyang-dam, Juam-dam, and Imha-dam watersheds. The monthly factors were established by recent fifteen years from 2000 to 2015. Five crops were selected for the monthly crop management factor establishments. Soil loss estimations with the modified factors were compared to conventional approach that is average annual estimations. The differences ranged from 9.3 % (Juam-dam watershed) to 28.1 % (Daecheong-dam watershed), since the conventional approaches were not capable of seasonally and regionally different conditions.

A Study on the Effective VTS Communications Analysis by the Method of VCDF in Busan Port (VCDF 방식을 통한 효율적인 VTS 통신 데이터 분석에 관한 연구 - 부산항을 대상으로 -)

  • Kim, Bong-Hyun;Park, Young-Soo
    • Journal of the Korean Society of Marine Environment & Safety
    • /
    • v.22 no.4
    • /
    • pp.311-318
    • /
    • 2016
  • The VTS concept was located as a principal methods of maritime safety administration in world's major harbors and expected to become the pivotal role for the future of the maritime and harbor society with e-Navigation epoch. If recent limelight concept of big-data has been included in aspect of information gathering and analysis with various studies, it's required advanced studies to improve the information analysis capability and application range of the data that can be mining by the VTS. In this study, contrast to other studies that aimed quantitative analysis as communication number, it can be mining the time information and each of the communication VTS for the target vessel, including qualitative analysis, such as the purpose or the type of communication. This comparison across multiple items of the collected information, and presenting the VTS data mining model (VCDF) that can be analyzed for the purpose of analyzing way, type and number of communication by ship's type, also number of violations through VTS communication. First, In Busan port case, it shows frequently information service and shows frequently communicating with particular types of vessels. Second, Passive VTS carried out notwithstanding many kinds of traffic violations due to communication congestion. This arranged information can be used as data for the analysis, as possible the level of traffic for VTSO situational awareness, which pointed to the 'workloads' in 'IALA Guideline' and could be used as a database for future research of e-Navigation.

ERD Representation using Auto-Generated Form and SQL (자동 생성 폼과 SQL을 이용한 ERD 표현)

  • Ra, Young-Gook
    • The Journal of the Korea Contents Association
    • /
    • v.9 no.5
    • /
    • pp.61-75
    • /
    • 2009
  • Generally, the development of the database application includes the requirement analysis phase of creating ERD (Entity Relationship Diagram) and process models, coding, and testing. From the above phases, the analysis phase is not most formalized. It is usually hard task because (1) customers don't know the details of the desired system; (2) developers can't with ease understand the business logic of the customers; (3) the outcomes of the analysis, which are ERD and process models, are not easy to understand to the customers. This paper propose that the executional forms, which are better to understand the systems, should be presented to the customers instead of the ERD. These forms should accept the data input so that customers can review the various aspects of the outcome models. The developers should be able to instantly implement the business logic and also should be able to visually demonstrate the logic in order to get the details of it. For this goal, the customer supplied business logic should be able to be implemented by the references between forms, actions, constraints from the perspective of the data flow. The customers try to execute the forms implementing the business logic and review their supplied logic find new necessary business logic of their own. Iterating these processes for the requirement analysis would result in the success of the analysis which is sufficiently detailed without conflicts.

Modeling of High-throughput Uranium Electrorefiner and Validation for Different Electrode Configuration (고효율 우라늄 전해정련장치 모델링 및 전극 구성에 대한 검증)

  • Kim, Young Min;Kim, Dae Young;Yoo, Bung Uk;Jang, Jun Hyuk;Lee, Sung Jai;Park, Sung Bin;Lee, Han soo;Lee, Jong Hyeon
    • Journal of Nuclear Fuel Cycle and Waste Technology(JNFCWT)
    • /
    • v.15 no.4
    • /
    • pp.321-332
    • /
    • 2017
  • In order to build a general model of a high-throughput uranium electrorefining process according to the electrode configuration, numerical analysis was conducted using the COMSOL Multiphysics V5.3 electrodeposition module with Ordinary Differential Equation (ODE) interfaces. The generated model was validated by comparing a current density-potential curve according to the distance between the anode and cathode and the electrode array, using a lab-scale (1kg U/day) multi-electrode electrorefiner made by the Korea Atomic Energy Research Institute (KAERI). The operating temperature was $500^{\circ}C$ and LiCl-KCl eutectic with 3.5wt% $UCl_3$ was used for molten salt. The efficiency of the uranium electrorefining apparatus was improved by lowering the cell potential as the distance between the electrodes decreased and the anode/cathode area ratio increased. This approach will be useful for constructing database for safety design of high throughput spent nuclear fuel electrorefiners.

English Phoneme Recognition using Segmental-Feature HMM (분절 특징 HMM을 이용한 영어 음소 인식)

  • Yun, Young-Sun
    • Journal of KIISE:Software and Applications
    • /
    • v.29 no.3
    • /
    • pp.167-179
    • /
    • 2002
  • In this paper, we propose a new acoustic model for characterizing segmental features and an algorithm based upon a general framework of hidden Markov models (HMMs) in order to compensate the weakness of HMM assumptions. The segmental features are represented as a trajectory of observed vector sequences by a polynomial regression function because the single frame feature cannot represent the temporal dynamics of speech signals effectively. To apply the segmental features to pattern classification, we adopted segmental HMM(SHMM) which is known as the effective method to represent the trend of speech signals. SHMM separates observation probability of the given state into extra- and intra-segmental variations that show the long-term and short-term variabilities, respectively. To consider the segmental characteristics in acoustic model, we present segmental-feature HMM(SFHMM) by modifying the SHMM. The SFHMM therefore represents the external- and internal-variation as the observation probability of the trajectory in a given state and trajectory estimation error for the given segment, respectively. We conducted several experiments on the TIMIT database to establish the effectiveness of the proposed method and the characteristics of the segmental features. From the experimental results, we conclude that the proposed method is valuable, if its number of parameters is greater than that of conventional HMM, in the flexible and informative feature representation and the performance improvement.

A Study on Development of the Tidal Database for the Philippines (필리핀을 위한 조석 데이터베이스 개발에 관한 연구)

  • PARK, Eung-Hyun;AHN, Se-Jin;SHIM, Moon-Bo;JEON, Hae-Yeon;KANG, Ho-Yun;KIM, Dae-Hyun
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.22 no.4
    • /
    • pp.158-168
    • /
    • 2019
  • Korea Hydrographic and Oceanographic Agency(KHOA) carried out a research project named 'Marine Fisheries Infrastructure Construction and Technology Training for the Philippines' as part of the 1st Official Development Assistance(ODA) from 2015 to 2018. It is preparing for the 2nd ODA project which will begin in 2020. Besides, recently, the Philippines is paying attention to marine territory management and response capability due to problems such as the sea-level rise and coastal erosion caused by climate change. Therefore, before 2nd ODA to the Philippines, this study analyzed the vertical ocean model on the vertical datum in Korea and suggests the direction of development of the vertical ocean modeling system for the vertical datum in the Philippines using the observed data from the permanent tide station which was built by the Philippines ODA research project over the last four years. Moreover, as a pilot study, the Sulu Sea in the Philippines was selected and analyzed by harmonic analysis method. At each tide station, constants for correction had been computed. And the grid-based tidal model was constructed based on this study. As a result of the study, similar tidal characteristic were observed when the prediction and the measured tide were compared by applying the constants for correction between two station in the sea area with similar tidal level. These results could be used as basic data for the 2nd ODA to the Philippines, and contributed to construct and maintain a close cooperation and friendship between Korea and the Philippines.

Model Verification of a Safe Security Authentication Protocol Applicable to RFID System (RFID 시스템에 적용시 안전한 보안인증 프로토콜의 모델검증)

  • Bae, WooSik;Jung, SukYong;Han, KunHee
    • Journal of Digital Convergence
    • /
    • v.11 no.4
    • /
    • pp.221-227
    • /
    • 2013
  • RFID is an automatic identification technology that can control a range of information via IC chips and radio communication. Also known as electronic tags, smart tags or electronic labels, RFID technology enables embedding the overall process from production to sales in an ultra-small IC chip and tracking down such information using radio frequencies. Currently, RFID-based application and development is in progress in such fields as health care, national defense, logistics and security. RFID structure consists of a reader that reads tag information, a tag that provides information and the database that manages data. Yet, the wireless section between the reader and the tag is vulnerable to security issues. To sort out the vulnerability, studies on security protocols have been conducted actively. However, due to difficulties in implementation, most suggestions are concerned with theorem proving, which is prone to vulnerability found by other investigators later on, ending up in many troubles with applicability in practice. To experimentally test the security of the protocol proposed here, the formal verification tool, CasperFDR was used. To sum up, the proposed protocol was found to be secure against diverse attacks. That is, the proposed protocol meets the safety standard against new types of attacks and ensures security when applied to real tags in the future.