• Title/Summary/Keyword: Database Optimization

Search Result 291, Processing Time 0.03 seconds

Optimization of Air Quality Monitoring Networks in Busan Using a GIS-based Decision Support System (GIS기반 의사결정지원시스템을 이용한 부산 대기질 측정망의 최적화)

  • Yoo, Eun-Chul;Park, Ok-Hyun
    • Journal of Korean Society for Atmospheric Environment
    • /
    • v.23 no.5
    • /
    • pp.526-538
    • /
    • 2007
  • Since air quality monitoring data sets are important base for developing of air quality management strategies including policy making and policy performance assessment, the environmental protection authorities need to organize and operate monitoring network properly. Air quality monitoring network of Busan, consisting of 18 stations, was allocated under unscientific and irrational principles. Thus the current state of air quality monitoring networks was reassessed the effect and appropriateness of monitoring objectives such as population protection and sources surveillance. In the process of the reassessment, a GIS-based decision support system was constructed and used to simulate air quality over complex terrain and to conduct optimization analysis for air quality monitoring network with multi-objective. The maximization of protection capability for population appears to be the most effective and principal objective among various objectives. The relocation of current monitoring stations through optimization analysis of multi-objective appears to be better than the network building for maximization of population protection capability. The decision support system developed in this study on the basis of GIS-based database appear to be useful for the environmental protection authorities to plan and manage air quality monitoring network over complex terrain.

Optimum Design of Reinforced Concrete Outrigger Wall Opening Using Piecewise Linear Interpolation (구간선형보간법을 이용한 철근콘크리트 아웃리거 벽체 개구부의 최적설계)

  • Lee, Hye-Lym;Kim, Han-Soo
    • Journal of the Computational Structural Engineering Institute of Korea
    • /
    • v.33 no.4
    • /
    • pp.217-224
    • /
    • 2020
  • In this study, a framework for optimizing the opening in an outrigger wall is proposed. To solve a constrained bounded optimization problem, an in-house finite element program and SQP algorithm in Python SciPy library are utilized. The openings of the outrigger wall are located according to the strut-tie behavior of the outrigger wall deep beam. A linear interpolation method is used to obtain differentiable continuous functions required for optimization, whereas a database is used for the efficiency of the optimization program. By comparing the result of the two-variable optimization through the moving path of the search algorithm, it is confirmed that the algorithm efficiently determines the optimized result. When the size of each opening is set to individual variables rather than the same width of all openings, the value of the objective function is minimized to obtain better optimization results. It was confirmed that the optimization time can be effectively reduced when using the database in the optimization process.

Cache Management Method for Query Forwarding Optimization in the Grid Database (그리드 데이터베이스에서 질의 전달 최적화를 위한 캐쉬 관리 기법)

  • Shin, Soong-Sun;Jang, Yong-Il;Lee, Soon-Jo;Bae, Hae-Young
    • Journal of Korea Multimedia Society
    • /
    • v.10 no.1
    • /
    • pp.13-25
    • /
    • 2007
  • A cache is used for optimization of query forwarding in the Grid database. To decrease network transmission cost, frequently used data is cached from meta database. Existing cache management method has a unbalanced resource problem, because it doesn't manage replicated data in each node. Also, it increases network cost by cache misses. In the case of data modification, if cache is not updated, queries can be transferred to wrong nodes and it can be occurred others nodes which have same cache. Therefore, it is necessary to solve the problems of existing method that are using unbalanced resource of replica and increasing network cost by cache misses. In this paper, cache management method for query forwarding optimization is proposed. The proposed method manages caches through cache manager. To optimize query forwarding, the cache manager makes caching data from lower loaded replicated node. The query processing cost and the network cost will decrease for the reducing of wrong query forwarding. The performance evaluation shows that proposed method performs better than the existing method.

  • PDF

Development of Elastic Shaft Alignment Design Program (선체변형을 고려한 탄성 축계정렬 설계 프로그램 개발)

  • Choung Joon-Mo;Choe Ick-Heung
    • Journal of the Society of Naval Architects of Korea
    • /
    • v.43 no.4 s.148
    • /
    • pp.512-520
    • /
    • 2006
  • The effects of flexibilities of supporting structures on shaft alignment are growing as ship sizes are Increasing mainly for container carrier and LNG carrier. But, most of classification societies not only do not suggest any quantitative guidelines about the flexibilities but also do not have shaft alignment design program considering the flexibility of supporting structures. A newly developed program, which is based on innovative shaft alignment technologies including nonlinear elastic multi-support bearing concept and hull deflection database approach, has S basic modules : 1)fully automated finite element generation module, 2) hull deflection database and it's mapping module on bearings, 3) squeezing and oil film pressure calculation module, 4) optimization module and 5) gap & sag calculation module. First module can generate finite element model including shafts, bearings, bearing seats, hull and engine housing without any misalignment of nodes. Hull deflection database module has built-in absolute deflection data for various ship types, sizes and loading conditions and imposes the transformed relative deflection data on shafting system. The squeezing of lining material and oil film pressures, which are relatively solved by Hertz contact theory and built-in hydrodynamic engine, can be calculated and visualized by pressure calculation module. One of the most representative capabilities is an optimization module based on both DOE and Hooke-Jeeves algorithm.

Integrated Structural Design Operation by Process Decomposition and Parallelization (프로세스 분할 병행에 의한 통합 구조설계 운용)

  • Hwang, Jin-Ha;Park, Jong-Hoi
    • Journal of the Computational Structural Engineering Institute of Korea
    • /
    • v.21 no.1
    • /
    • pp.113-124
    • /
    • 2008
  • Distributed operation of overall structural design process, by which product optimization and process parallelization are simultaneously implemented, is presented in this paper. The database-interacted hybrid method, which selectively takes the accustomed procedure of the conventional method in the framework of the optimal design, is utilized here. The staged application of design constraints reduces the computational burden for large complex optimization problems. Two kinds of numeric and graphic processes are simultaneously implemented by concurrent engineering approach in the distributed environment of PC networks. The former is based on finite element optimization method and the latter is represented by AutoCAD using AutoLISP programming language. Numerical computation and database interaction on servers and graphic works on independent clients are communicated through message passing. The numerical experiments for some steel truss models show the validity and usability of the method. This study has sufficient adaptability and expandability, in that it is based on general methodologies and industry standard platforms.

Optimum seismic design of reinforced concrete frame structures

  • Gharehbaghi, Sadjad;Moustafa, Abbas;Salajegheh, Eysa
    • Computers and Concrete
    • /
    • v.17 no.6
    • /
    • pp.761-786
    • /
    • 2016
  • This paper proposes an automated procedure for optimum seismic design of reinforced concrete (RC) frame structures. This procedure combines a smart pre-processing using a Tree Classification Method (TCM) and a nonlinear optimization technique. First, the TCM automatically creates sections database and assigns sections to structural members. Subsequently, a real valued model of Particle Swarm Optimization (PSO) algorithm is employed in solving the optimization problem. Numerical examples on design optimization of three low- to high-rise RC frame structures under earthquake loads are presented with and without considering strong column-weak beam (SCWB) constraint. Results demonstrate the effectiveness of the TCMin seismic design optimization of the structures.

Bit-map Indexes and Their Selection Problem for Efficient Processing of Star Joins in Object Databases (객체 데이터베이스에서 스타 조인의 빠른처리를 위한 비트맵 색인 기법과 그의 선정 문제)

  • 조완섭;정태성;이현철;장혜경;안명상
    • Journal of Information Technology Applications and Management
    • /
    • v.10 no.2
    • /
    • pp.19-31
    • /
    • 2003
  • We propose an indexing technique and an index selection algorithm for optimal OLAP query processing in object database systems, Although there are many research results on the relational database systems for OLAP Query processing, few researches have been done on the object database systems. Since OLAP queries represent complex business logic on a huge data ware-house, object database systems supporting the OLAP queries should have higher performance. Proposed bitmap index structure is an extension of conventional bitmap indexes for adapting object databases and provides higher performance with lower space overhead. We also propose a linear time solution of the index selection problem that will be used in the OLAP query optimization process.

  • PDF

Optimization of DB Server and Web Server to Enhance the Performance of ECM

  • Lee, Sun-Woo;Kim, Jong-Soo;Kim, Tai-Suk
    • Journal of Korea Multimedia Society
    • /
    • v.16 no.12
    • /
    • pp.1446-1453
    • /
    • 2013
  • In order to develop ECM system, there are a number of methodologies. Adopting Microsoft's solution and methodology is one of them. ECM has a large number of users to save the documentations in various types of multimedia data. So, managing multimedia database is very critical in ECM. Therefore the unit and integration test to evaluate the performance can detect the flaws of the system early on, and it has to be enables to reflect the user's requirements thru the user acceptance test. In this paper, we are discussing how to optimize the SQL database before the ECM system is built and used in the real situation thru unit and integration tests.

Development of Missile Design Computer Framework for the Multidisciplinary Optimization (유도무기 통합최적화설계를 위한 전산프레임워크 개발연구)

  • Kim Woo-Hyun;Lee Seung-Jin;Lee Jae-Woo;Byun Yung-Hwan
    • Proceedings of the Computational Structural Engineering Institute Conference
    • /
    • 2006.04a
    • /
    • pp.307-314
    • /
    • 2006
  • Missile system. which requires high speed/high maneuverability is getting more important as a defensive weapon system. Integrated design environment which includes all related resources during the missile development process, is a very useful development tool, Therefor the design framework can perform the operation analysis and utilize design information for the efficient missile design. For this purpose, various analysis computer codes under heterogeneous platforms and operating systems, the database, the optimization module, and Ideas a commercial CAD are integrated using distributed. middleware. and the complicated GUI design has been made for the specific missile system design. Under the various constraint, maximize missile range and loadfactor with missile design computer framework.

  • PDF