• Title/Summary/Keyword: Database Optimization

Search Result 291, Processing Time 0.03 seconds

A Study on the Application of GIS and AHP for the Optimization of Route Selection

  • Lee, Hyung-Seok;Yun, Hee-Cheon;Kang, Joon-Mook
    • Korean Journal of Geomatics
    • /
    • v.1 no.1
    • /
    • pp.95-101
    • /
    • 2001
  • In a route plan, the route selection is a complicated problem to consider the spatial distribution and influence through overall related data and objective analysis on the social, economic and technical condition. The developed system in this study was compared and estimated by deciding a practical section for its validity and efficiency. Using Geographic Information System (GIS), the various information required for route selections in database was constructed, the characteristics of subject area by executing three-dimensional terrain analysis was grasped effectively, and the control point through buffering, overlay and location operation was extracted. An optimum route was selected by calculating the sum of alternatives to the sub-criteria weight, and from this result, there is a difference between real route and proposed route according to the prioritization of decision criteria based on the importance. This research could be constructed and applied geospatial information to the reasonable route plan and an optimum route selection efficiently using GIS. Therefore, the applications are presented by applying Analytic Hierarchy Process (AHP) to the decision-making of information needed in route selection.

  • PDF

Impacts of Hierarchy in Ethernet Ring Networks on Service Resiliency

  • Lee, Kwang-Koog;Ryoo, Jeong-Dong;Kim, Young-Lok
    • ETRI Journal
    • /
    • v.34 no.2
    • /
    • pp.199-209
    • /
    • 2012
  • In transport networks, a multi-ring architecture is very useful to facilitate network planning and to design and provide more resilient services for customers. Unlike traditional synchronous optical network multi-rings, the service resiliency of Ethernet-based multi-rings is significantly impacted by the ring hierarchy because a link or node failure in a certain level ring triggers filtering database flush actions in all higher level rings as well as in the ring with the failure, and consequently a large amount of duplicated data frames may be flooded. In this paper, we investigate how the ring hierarchy impacts the service resiliency of multi-ring networks. Based on extensive experiments on various single- and multiple-link failures, we suggest two effective inter-ring connection rules to minimize the transient traffic and to ensure more resilient multi-ring networks. In addition, we consider a flush optimization technique called e-ADV, and show that the combination of e-ADV and multi-ring structures satisfying our inter-ring connection rules results in a more attractive survivability performance.

A Genetic Algorithm for Minimizing Query Processing Time in Distributed Database Design: Total Time Versus Response Time (분산 데이타베이스에서의 질의실행시간 최소화를 위한 유전자알고리즘: 총 시간 대 반응시간)

  • Song, Suk-Kyu
    • The KIPS Transactions:PartD
    • /
    • v.16D no.3
    • /
    • pp.295-306
    • /
    • 2009
  • Query execution time minimization is an important objective in distributed database design. While total time minimization is an objective for On Line Transaction Processing (OLTP), response time minimization is for Decision Support queries. We formulate the sub-query allocation problem using analytical models and solve with genetic algorithm (GA). We show that query execution plans with total time minimization objective are inefficient from response time perspective and vice versa. The procedure is tested with simulation experiments for queries of up to 20 joins. Comparison with exhaustive enumeration indicates that GA produced optimal solutions in all cases in much less time.

An Effective View Management in a Mediator System for the Integration of Heterogeneous Distributed Database (미디에이터 시스템에서의 이질 분산데이타베이스의 통합을 위한 효율적인 뷰관리 방법)

  • Joo, Kil-Hong;Lee, Won-Suk
    • Journal of KIISE:Databases
    • /
    • v.28 no.4
    • /
    • pp.620-632
    • /
    • 2001
  • This paper proposes a mediator system which can provide a view management function in the today's heterogeneous computing environment including operating system database management systems and other software. while most mediators use view modification mechanism only, the use of view materialization is also considered in this research. In order to optimize the management cost for materialized views the proposed method applies a decay factor for modeling the access behaviors of views In other words, the most recently access pattern gets the highest attention in the optimization process all the necessary it with the CORBA.

  • PDF

Prediction of compressive strength of concrete modified with fly ash: Applications of neuro-swarm and neuro-imperialism models

  • Mohammed, Ahmed;Kurda, Rawaz;Armaghani, Danial Jahed;Hasanipanah, Mahdi
    • Computers and Concrete
    • /
    • v.27 no.5
    • /
    • pp.489-512
    • /
    • 2021
  • In this study, two powerful techniques, namely particle swarm optimization (PSO) and imperialist competitive algorithm (ICA) were selected and combined with a pre-developed ANN model aiming at improving its performance prediction of the compressive strength of concrete modified with fly ash. To achieve this study's aims, a comprehensive database with 379 data samples was collected from the available literature. The output of the database is the compressive strength (CS) of concrete samples, which are influenced by 9 parameters as model inputs, namely those related to mix composition. The modeling steps related to ICA-ANN (or neuro-imperialism) and PSO-ANN (or neuro-swarm) were conducted through the use of several parametric studies to design the most influential parameters on these hybrid models. A comparison of the CS values predicted by hybrid intelligence techniques with the experimental CS values confirmed that the neuro-swarm model could provide a higher degree of accuracy than another proposed hybrid model (i.e., neuro-imperialism). The train and test correlation coefficient values of (0.9042 and 0.9137) and (0.8383 and 0.8777) for neuro-swarm and neuro-imperialism models, respectively revealed that although both techniques are capable enough in prediction tasks, the developed neuro-swarm model can be considered as a better alternative technique in mapping the concrete strength behavior.

Development of a New Lunar Regolith Simulant using an Automated Program Framework

  • GyeongRok Kwon;Kyeong Ja Kim;Eungseok Yi
    • Journal of Astronomy and Space Sciences
    • /
    • v.41 no.2
    • /
    • pp.79-85
    • /
    • 2024
  • Nowadays, the trend in lunar exploration missions is shifting from prospecting lunar surface to utilizing in-situ resources and establishing sustainable bridgehead. In the past, experiments were mainly focused on rover maneuvers and equipment operations. But the current shift in trend requires more complex experiments that includes preparations for resource extraction, space construction and even space agriculture. To achieve that, the experiment requires a sophisticated simulation of the lunar environment, but we are not yet prepared for this. Particularly, in the case of lunar regolith simulants, precise physical and chemical composition with a rapid development speed rate that allows different terrains to be simulated is required. However, existing lunar regolith simulants, designed for 20th-century exploration paradigms, are not sufficient to meet the requirements of modern space exploration. In order to prepare for the latest trends in space exploration, it is necessary to innovate the methodology for producing simulants. In this study, the basic framework for lunar regolith simulant development was established to realize this goal. The framework not only has a sample database and a database of potential simulation target compositions, but also has a built-in function to automatically calculate the optimal material mixing ratio through the particle swarm optimization algorithm to reproduce the target simulation, enabling fast and accurate simulant development. Using this framework, we anticipate a more agile response to the evolving needs toward simulants for space exploration.

Fail Over Analysis and Management for the Database Implement of the High Availability Solution (고가용성 데이터베이스 구축을 통한 장애 극복 분류 및 관리 기법)

  • Lee, Byoung-Yup
    • The Journal of the Korea Contents Association
    • /
    • v.10 no.7
    • /
    • pp.49-54
    • /
    • 2010
  • In these days, Internet environment are very quickly development as well On-line service have been using a online for the mission critical business around the world. As the amount of information to be processed by computers has recently been increased there has been cluster computing systems developed by connecting workstations server using high speed networks for high availability. As a result, this study on a cluster based DBMS and common solution of DBMS venders has been studying with a wide range, as well as It is not good study a management skill for the cluster-based DBMS efficiently and optimization. accordingly, This study find out optimization managements skill and theory of he High availability solution on cluster-based DBMS.

An Adaptive Classification Algorithm of Premature Ventricular Beat With Optimization of Wavelet Parameterization (웨이블릿 변수화의 최적화를 통한 적응형 조기심실수축 검출 알고리즘)

  • Kim, Jin-Kwon;Kang, Dae-Hoon;Lee, Myoung-Ho
    • Journal of Biomedical Engineering Research
    • /
    • v.30 no.4
    • /
    • pp.294-305
    • /
    • 2009
  • The bio signals essentially have different characteristics in each person. And the main purpose of automatic diagnosis algorithm based on bio signals focuses on discriminating differences of abnormal state from personal differences. In this paper, we propose automatic ECG diagnosis algorithm which discriminates normal heart beats from premature ventricular contraction using optimization of wavelet parameterization to solve that problem. The proposed algorithm optimizes wavelet parameter to let energy of signal be concentrated on specific scale band. We can reduce the personal differences and consequently highlight the differences coming from arrhythmia via this process. The proposed algorithm using ELM as a classifier show high discrimination performance between normal beat and PVC. From the experimental results on MIT-BIH arrhythmia database the performances of the proposed algorithm are 98.1% in accuracy, 93.0% in sensitivity, 96.4% in positive predictivity, and 0.8% in false positive rate. This results are similar or higher then results of existing researches in spite of small human intervention.

Development of Formulas for Predicting Radio Noise from Overhead HVAC Transmission Lines using Least Squares Optimization Method (최소자승법에 의한 초고압 가공 송전선로의 라디오 잡음장해 예측계산식 개발)

  • Yang, Gwang-Ho;Ju, Mun-No;Myeong, Seong-Ho;Sin, Gu-Yong;Lee, Dong-Il
    • The Transactions of the Korean Institute of Electrical Engineers A
    • /
    • v.49 no.1
    • /
    • pp.37-42
    • /
    • 2000
  • The radio noise produced by corona discharge in high voltage transmission lines is one of the most important line design considerations. Therefore it is necessary for transmission line designers to pre-evaluate radio noise using prediction formulas or field test results. In this paper, more accurate and useful formulas for predicting radio noise during fair and foul weathers in high voltage AC transmission lines were proposed through comparison with the existing formulas. Also it was verified by comparing with the long-term measured data from operating lines that the proposed formulas are more accurate. The proposed prediction formulas are developed by the applications of nonlinear least squares optimization method to radio noise database collected from lines throughout the world.

  • PDF

Efficient Vocabulary Optimization Management using VCOR (VCOR를 이용한 효율적인 어휘 최적화 관리)

  • Oh, Sang-Yeob
    • Journal of Korea Multimedia Society
    • /
    • v.13 no.10
    • /
    • pp.1436-1443
    • /
    • 2010
  • In vocabulary recognition system has it's bad points of processing vocabulary unseen triphone and then no got distribution of confidence measure by cannot normalization. According to this problem to improve suggested VCOR(Version Control for Out-of Rejection) system by out-of vocabulary rejection algorithm use vocabulary management optimization and then phone data search support. In VCOR system to provide vocabulary information efficiently offering for user's vocabulary information using extend facet classification that improved for vocabulary measure management function offering accuracy of recognition for vocabulary. In this paper proposed system performance as a result of represent vocabulary dependence recognition rate of 97.56%, vocabulary independence recognition rate of 96.23%.