• 제목/요약/키워드: Database Optimization

검색결과 291건 처리시간 0.025초

느슨히 결합된 데이타베이스 시스템에서 최적의 저장점 유도 (Optimal Savepoint in a Loosely-Coupled Resilient Database System)

  • 최재화;김성언
    • Asia pacific journal of information systems
    • /
    • 제6권1호
    • /
    • pp.21-38
    • /
    • 1996
  • This paper investigates the performance improvement opportunities through a resiliency mechanism in the distributed primary/backup database system. Recognizing that a distributed transaction executes at several servers during its lifetime, we propose a resiliency mechanism which allows continuous transaction processing in distributed database server systems in the presence of a server failure. In order to perform continuous transaction processing despite failures, every state change of a transaction processing can be saved in the backup server. Obviously, this pessimistic synchronization may give more burdens than benefits to the system. Thus, the tracking needs not be done synchronously with the transaction progress. Instead, the state of all transaction processing in a system is saved periodically. This activity is referred to as a savepoint. Then, the question is how often the savepoint has to be done. We derive the optimal savepoint to identify the optimization parameters for the resilient transaction processing system.

  • PDF

Multi-Institutional Database System for The Aid of Improvement in Radiotherapy Results

  • Ishibashi, Masatoshi;Harauchi, Hajime;Kou, Hiroko;Kumazaki, Yu;Shimizu, Keiji;Harano, Masako;Numasaki, Hodaka;Yoshioka, Munenori;Inamura, Kiyonari
    • 한국의학물리학회:학술대회논문집
    • /
    • 한국의학물리학회 2002년도 Proceedings
    • /
    • pp.126-128
    • /
    • 2002
  • A learning system was built into an on-line, multi-institutional radiotherapy database, where the treatment history records and the results in each institution were integrated, each radiotherapy planning was supported, and it led to the improvement in treatment results.

  • PDF

Tall Building Database-assisted Design: a Review of NIST Research

  • Yeo, DongHun;Potra, Florian A.;Simiu, Emil
    • 국제초고층학회논문집
    • /
    • 제8권4호
    • /
    • pp.265-273
    • /
    • 2019
  • The purpose of this review paper is to briefly describe main the features of novel procedures developed by the National of Standards and Technology (NIST) for the design of tall buildings. Topics considered in the paper include: the division of tasks between wind and structural engineers; the determination of wind effects with specified mean recurrence intervals by accounting for wind directionality; the risk-consistent design of structures subjected to multiple wind hazards; iterative dynamic analyses and member sizing, including the use of modern optimization approaches; and commonalities of and differences between Database-assisted Design (DAD) and Equivalent Static Wind Loads procedures. An example of the application of the DAD procedure is presented for a reinforced concrete structure. Also included in the paper is an introduction to ongoing research on the estimation of wind load factors or of augmented design mean recurrence intervals commensurate with the uncertainties in the factors that determine the wind effects.

오프라인 프로그래밍에서 유전자 알고리즘을 이용한 로봇의 경로 최적화 (Path Optimization Using an Genetic Algorithm for Robots in Off-Line Programming)

  • 강성균;손권;최혁진
    • 한국정밀공학회지
    • /
    • 제19권10호
    • /
    • pp.66-76
    • /
    • 2002
  • Automated welding and soldering are an important manufacturing issue in order to lower the cost, increase the quality, and avoid labor problems. An off-line programming, OLP, is one of the powerful methods to solve this kind of diversity problem. Unless an OLP system is ready for the path optimization in welding and soldering, the waste of time and cost is unavoidable due to inefficient paths in welding and soldering processes. Therefore, this study attempts to obtain path optimization using a genetic algorithm based on artificial intelligences. The problem of welding path optimization is defined as a conventional TSP (traveling salesman problem), but still paths have to go through welding lines. An improved genetic algorithm was suggested and the problem was formulated as a TSP problem considering the both end points of each welding line read from database files, and then the transit problem of welding line was solved using the improved suggested genetic algorithm.

초고온 진공로 통합설계 최적화 소프트웨어 개발 (Development of Integrated Design and Optimization Software for the High Temperature Furnace Design)

  • 김우현;이재우;변영환
    • 시스템엔지니어링학술지
    • /
    • 제1권1호
    • /
    • pp.14-19
    • /
    • 2005
  • High temperature vacuum furnaces or high standard electric furnaces demand high technology level and high production cost. Therefore, an iterative design process and the optimization approach under integrated computing environment are required to reduce the development risk. Moreover, it also required to develop an integrated design software that can manage the centralized database system between factory and design department, and the automated furnace design and analysis. The developed software is dedicated to the development of the vacuum (electric) furnaces. Based on the distribute middleware system, the GUI module, the CAD module, the thermal analysis module and the optimization module are integrated. For the DBMS, Microsoft Access is employed, the GUI is developed using Visual Basic language, and AutoCAD is utilized for the configuration design. By investigating the analysis code interface, the analysis and optimization process, and the data communication method, the overall system architecture, the method to integrate the optimizer and ana lysis codes, and the method to manage the data flow are proposed and verified through the optimal furnace design.

  • PDF

Particle Swarm Optimization을 이용한 소아고노출 생활자계 추정식 개발 (Development of the Estimating Equation for Children's High-Exposure to Habitat's Magnetic Field using Particle Swarm Optimization)

  • 황기현
    • 한국정보통신학회논문지
    • /
    • 제14권5호
    • /
    • pp.1085-1092
    • /
    • 2010
  • 본 논문에서는 최적화 알고리즘인 PSO를 이용하여 한국인의 생활자계 노출실태 조사 시 확보한 16세 이하의 미취학 아동, 초등학생, 중학생 실측 데이터베이스를 활용하여, 자계노출의 정도를 실측에 의하지 않고 추정할 수 있는 '24시간 소아고노출 생활자계 추정식'을 개발하였다. 24시간 개인자계 노출량 추정식의 입력 데이터는 성, 연령, 주거형태, 주거지 크기, 선로이격거리 및 송전전압을 사용하였다. 그리고 16세 이하에 대해서 24시간 고노출 개인자계 노출분포, 자계노출의 특성, 특정 조건별 자계노출특성 등을 분석하였다.

데이터베이스 기반 유전 알고리즘을 이용한 효율적인 에어포일 형상 최적화에 대한 연구 (Study on the Airfoil Shape Design Optimization Using Database based Genetic Algorithms)

  • 권장혁;김진;김수환
    • Journal of Advanced Marine Engineering and Technology
    • /
    • 제31권1호
    • /
    • pp.58-66
    • /
    • 2007
  • Genetic Algorithms (GA) have some difficulties in practical applications because of too many function evaluations. To overcome these limitations, an approximated modeling method such as Response Surface Modeling(RSM) is coupled to GAs. Original RSM method predicts linear or convex problems well but it is not good for highly nonlinear problems cause of the average effect of the least square method(LSM). So the locally approximated methods. so called as moving least squares method(MLSM) have been used to reduce the error of LSM. In this study, the efficient evolutionary GAs tightly coupled with RSM with MLSM are constructed and then a 2-dimensional inviscid airfoil shape optimization is performed to show its efficiency.

A FRAMEWORK FOR QUERY PROCESSING OVER HETEROGENEOUS LARGE SCALE SENSOR NETWORKS

  • Lee, Chung-Ho;Kim, Min-Soo;Lee, Yong-Joon
    • 대한원격탐사학회:학술대회논문집
    • /
    • 대한원격탐사학회 2007년도 Proceedings of ISRS 2007
    • /
    • pp.101-104
    • /
    • 2007
  • Efficient Query processing and optimization are critical for reducing network traffic and decreasing latency of query when accessing and manipulating sensor data of large-scale sensor networks. Currently it has been studied in sensor database projects. These works have mainly focused on in-network query processing for sensor networks and assumes homogeneous sensor networks, where each sensor network has same hardware and software configuration. In this paper, we present a framework for efficient query processing over heterogeneous sensor networks. Our proposed framework introduces query processing paradigm considering two heterogeneous characteristics of sensor networks: (1) data dissemination approach such as push, pull, and hybrid; (2) query processing capability of sensor networks if they may support in-network aggregation, spatial, periodic and conditional operators. Additionally, we propose multi-query optimization strategies supporting cross-translation between data acquisition query and data stream query to minimize total cost of multiple queries. It has been implemented in WSN middleware, COSMOS, developed by ETRI.

  • PDF

Collaborative Optimization을 이용한 지구관측위성의 다분야 통합 최적 개념설계 (Multidisciplinary Design Optimization of Earth Observation Satellite Conceptual Design using Collaborative Optimization)

  • 김홍래;장영근
    • 한국항공우주학회지
    • /
    • 제43권6호
    • /
    • pp.568-583
    • /
    • 2015
  • 본 논문에서는 다분야 통합 설계최적화(MDO : Multidisciplinary Design Optimization)를 적용한 지구관측위성의 개념설계 과정 및 결과를 기술하였다. 현재까지 구축된 지구관측 위성의 데이터베이스를 기반으로 주요 파라미터에 대한 개념설계식을 정립하였으며, 다분야 통합 최적설계 아키텍처 중 CO(Collaborative Optimization) 기반을 이용하여 지구관측 위성 시스템의 최적 개념설계를 수행할 수 있는 설계 도구를 개발하였다. 주어진 제약조건을 만족시키면서 위성의 총 질량을 최소화하는 것을 설계 목표로 설정하였으며, 최적화 알고리즘으로는 SQP(Sequential Quadratic Programming)를 이용하였다. 다분야 통합 최적설계를 적용한 개념설계 결과와 ASNARO-1 및 IKONOS-2 위성 규격의 비교를 통해 해당설계도구의 유용성을 검증하였다.

웨이블릿을 이용한 QRS complex 검출 알고리즘의 고정 소수점 연산 최적화 (Fixed-point Optimization of a QRS complex Detection Algorithm Using Wavelet Transform)

  • 박영철
    • 한국정보전자통신기술학회논문지
    • /
    • 제7권3호
    • /
    • pp.126-131
    • /
    • 2014
  • 본 논문에서는 웨이블릿 변환을 통하며 QRS complex를 검출 하며, 32비트 고정 소수점 연산이 가능한 프로세서에도 동작하도록 알고리즘 최적화 기법을 제시한다. 먼저 입력 ECG 신호를 밴드 패스 필터를 통과 시키고, 3개의 서로 다른 웨이블릿 함수를 하나로 병합한 웨이블릿 함수를 이용하여 웨이블릿 변환을 하며, 다음으로 시간 평균 함수를 뒤에 마지막으로 QRS complex를 검출 한다. 제안 알고리즘은 MIT-BIH arrhythmia database에 적용하여 검증한다. 모든 과정은 32비트 고정 소수점 연산으로 구현되며, 삼각함수 같은 복잡한 연산은 테이블화 하였다. 검출 알고리즘은 컴퓨터 시뮬레이션을 통해 평가 한다.