• Title/Summary/Keyword: Execution Plan

Search Result 358, Processing Time 0.032 seconds

Design and Implementation of Database Cache engine based on Similarity Query Matching (유사 질의 매칭 기반 데이터베이스 캐쉬 엔진 설계 및 구현)

  • Han, Yun-Hee;Lee, Jeong-Joon
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2007.10c
    • /
    • pp.119-124
    • /
    • 2007
  • 인터넷 웹사이트의 급격한 증가와 함께 이용자도 증가하고 있으며, 이용 목적은 주로 자료검색과 조회서비스 이다. 조회 요청이 많을수록 질의의 증가를 야기하며, 데이터베이스 서버의 질의 분석(Parse), 질의 실행 계획(Query Execution Plan)을 과도하게 발생시킨다. 즉 데이터베이스 서버에서 처리하는 작업량의 과부하로 인하여 병목현상을 초래한다. 데이터베이스 서버의 조회를 위한 질의처리량을 감소시키는 작업이 필요하다. 그리고 조회 대상이 데이터는 웹사이트에서 자주 갱신되지 않거나, 데이터가 주기적으로 갱신되는 특징이 있다. 이 데이터를 대상으로 데이터베이스 캐쉬 엔진을 구성하면 데이터베이스 서버의 과부하률 해소 할 수 있다. 본 논문에서는 유사 질의 매칭 기반 데이터베이스 캐친 엔진을 설계하고 구현한다. 유사 질의 매칭 기반으로 하여 적중률을 높여 데이터베이스 병목현상을 해결하여, 검색서비스에 더욱 효과적일 것으로 사료되며, 웹사이트의 성능 향상을 기대한다.

  • PDF

A Basic Study on the BIM Service Based SLA for Setting the Application Level of BIM in the Procurement Phase (발주단계에서 BIM의 적용수준 설정을 위한 SLA 기반의 BIM 서비스에 관한 기초연구)

  • Kim, Ji-Yun;Yun, Seok-Heon
    • Proceedings of the Korean Institute of Building Construction Conference
    • /
    • 2016.05a
    • /
    • pp.251-252
    • /
    • 2016
  • Recently policy and clouding system to mandate the introduction of BIM in construction industry, various sensors technology, BIM in ICT technology and fusion, such as 3D scanning and printing technology has been further activated. However, the expression level of diversification associated with it, plan within one of the BIM project, design, engineering, it is difficult to have a different application has been consistent for each field, such as construction. Thus fell the efficiency of BIM apply, it is difficult to determine the appropriate level of BIM in the business early stage in order destination of position. In this study, in order to solve this problem, by utilizing SLA used in the IT field, it attempts to explore scheme which can be evaluated targeted level of BIM suitable for business in the planning phase.

  • PDF

Study of the Enhancement of Military Operation Supporting System (비상시 정부의 효율적인 군사작전 지원방안 연구)

  • Choi, Jae-Kyung
    • Journal of National Security and Military Science
    • /
    • s.5
    • /
    • pp.87-130
    • /
    • 2007
  • ROK and the United States finally reached accord on the controversial transition of Wartime Operational Control on February, 2007, and ROK Government needs to strengthen the role of supporting for the comprehensive threats of futuristic warfare. The crucial point of the supporting for Military Operation depends on the nation's mobilization capabilities. For the effective mobilization the following facets can be improved further. First of all, the organizational integrity of the mobilization network within the government can be bolstered along the vertical command chain. The process of mobilization must be improved and it is import to utilize the information system. On the other side the government plan to distribute timely the mobilized resources must be made up for the weak points and developed continuously. We can expect these points to be improved steadily with the execution of the National Defence Reform 2020.

  • PDF

The research regarding the grief flag solution plan of the outside travel goods. (국외여행상품 비수기 극복방안 연구)

  • 최동렬;장양례
    • Culinary science and hospitality research
    • /
    • v.7 no.2
    • /
    • pp.243-266
    • /
    • 2001
  • In order to attain the research objective which it sees with method of research the literature research which investigates an existing system with triangular position of one concept the relationship literature, a statistical data and information back from data analysis it arranged the data which is necessary in foundation, it applied. Travel ep with direct conversation investigation of the person in charge and experience of the researcher it accomplished a research with character during that time. The research result with afterwords provides a same current events point First. It is a diversification of marketing. Secondth. It is an exhibition and exhibition travel goods wool visitor concentrating. Thirdth. It attempts a travel agency merger anger. Fourthth, goods reservation it sleeps and the pro wool of the on-line travel agency against syen it is. Fifth. Advance reservation discount my execution or it is a customer objective card my introduction. Sixth. Must promote an individual travel goods development and an order travel goods development.

  • PDF

The Current Status and Tasks of Marsh snail Restocking Project based on Economic Performance Evaluation (다슬기 방류사업의 현황 및 과제 -경제효과분석을 중심으로-)

  • SONG, Jung-Hun;KANG, Jong-Ho
    • Journal of Fisheries and Marine Sciences Education
    • /
    • v.28 no.2
    • /
    • pp.450-455
    • /
    • 2016
  • Reinforcement for reduced daseulgi jawonryang protect natural resources, and form an artificial seed production and resource recovery in technology development and chipaebangryu doemeuroseo interested local governments, water 04, KEPCO daseulgi at promoting and stocking a lot of business, but are stocked in Format breed, stocking density, and a systematic way that does not occur in siljeong is discharged. Therefore, this study conducted by the appropriate discharge plan presented daseulgi smooth business execution and discharge of the business to be its primary purpose.

Minimizing Project Quality Costs by Activity-Based Prevention (활동기준예방에 의한 프로젝트 품질코스트 최소화)

  • Kim, Jong-Yul;Kang, Chang-Wook;Hwang, In-Keuk
    • Journal of Korean Society of Industrial and Systems Engineering
    • /
    • v.34 no.4
    • /
    • pp.89-97
    • /
    • 2011
  • Traditional quality control for manufacturing or service sector is not suitable for the quality control of a project as the project is one-time task constrained by time, cost, and quality. To meet the internal and external customers' requirements, quality costs approach to the project will be effective. Hence, we propose PONC (price of nonconformance) estimation procedure and a mathematical model, which are focused on activity-based prevention in the execution step and warranty step of EPLC (extended project life cycle). This procedure and model will help project manager develop preventive action plan for project quality costs minimization from nonconformance risk activities and PONC estimates information.

Optimization of Two Plate Girders Bridge (2주형 판형교의 최적설계)

  • 김건희;유선미;조선규
    • Proceedings of the KSR Conference
    • /
    • 2002.10a
    • /
    • pp.690-695
    • /
    • 2002
  • Two plate girders bridge has an advantage for execution of works and quality control because of its simplicity of super-structure caused by decreasing in amount of members and also is distinguished as aesthetic bridge type. Recently this has been adopted for structure of highway as well railway and introduced into domestic. In order to plan or design two plate girders bridge more rationably, it is necessary to comprehend its structural behavior as well as to consider the critical resign factors. Thus, in this study the formulation of optimum design for two plate girders bridge is proposed and the critical resign variables ani restraints are considered and founded by caring out optimum design. The objective function of optimization is formulated as a minimum cost design problem. And the thickness and length of I-shaped section are decided as resign variables. The design constraints are formulated based on Design Criteria for Railroad(Bridges). By comparing the optimum results with those of the conventional resign, the effectiveness of proposed optimum design formulation is investigated. From the results, the way to do optimum design of two plate girders bridge is suggested.

  • PDF

The Improvement Plan of Information Management of Interior Finishing Work at Apartment in Korea (국내 집합 공동주택 내장마감공사 정보관리 개선방안)

  • Kim, Jin-Ho
    • Journal of the Korea Institute of Building Construction
    • /
    • v.3 no.3
    • /
    • pp.99-106
    • /
    • 2003
  • The purpose of this study is to suggest the rational plans of Information Management in the interior finishing work. The results of this study are summarized as follows; I) Analytical survey of actual construction progress of interior finishing work 2) Review of computer-based development in construction planning & information management of interior finishing work 3) Structure of interior finishing work Planning and Management Support System And the expectancies of this paper are that it can be used as efficient data for improvement of system to systematize planning and execution of interior finishing work in korea.

The Implementation of Tool for overcoming the limit of Oracle optimizer (Oracle DBMS 질의 최적화기 한계 극복을 위한 진단 도구 구현)

  • Seo, Min-Sun;Hwang, Yoon-Jae;Lee, Sang-Won
    • Annual Conference of KIPS
    • /
    • 2003.11c
    • /
    • pp.1371-1374
    • /
    • 2003
  • 관계형 DBMS 질의 최적화기는 기본적으로 통계정보(statistics), 선택도(selectivity), 카디널리티(cardinality), 비용(cost) 순으로 특정 실행 계획(Execution Plan)의 수행비용을 예측한다. 질의 최적화기가 최적의 실행 계획을 선택하는데 있어서 정확한 통계정보 유지와 올바른 선택도 그리고 카디널리티 예측이 무엇 보다 중요하다. 이 논문에서는 관계형 DBMS의 질의 최적화기가 비용을 계산하는 과정에서 발생할 수 있는 오류의 종류와 원인을 밝히고 각각의 오류에 대한 해결 방안을 진단 도구를 통하여 제시하도록 하겠다. 질의 최적화기의 오류로 인해 발생하는 잘못된 선택도와 카디널리티 예측을 인지하고 사용자에게 적절한 해결책을 제시한 후 실행 계획이 어떻게 바뀌었는지, 성능이 얼마나 향상되었는지를 확인하기 위해 진단 도구를 개발하고 그 결과를 분석하였다. 실험을 통해 본 논문에서 제시하는 질의 최적화기의 오류로 인한 문제를 가시적으로 확인할 수 있었으며, 부정확한 통계정보 유지와 잘못된 선택도 예측으로 인해 발생하는 문제가 어느 정도 해결된 것을 확인할 수 있었다.

  • PDF

Application Examples of CFD at the Planning Stage of High-Rise Buildings

  • Hiroto, Kataoka;Yoshiyuki, Ono;Kota, Enoki;Yuichi, Tabata;Satoko, Kinashi
    • International Journal of High-Rise Buildings
    • /
    • v.11 no.3
    • /
    • pp.145-156
    • /
    • 2022
  • Application examples of computational fluid dynamics (CFD) in the planning stage of high-rise buildings are introduced. First, we introduce examples of applications in the environmental field. The pedestrian wind environment was one of the earliest practical examples of CFD. CFD was also employed to validate the heat island mitigation measures proposed as part of the new construction plan. Second, application examples of wind-force evaluations are introduced. Prediction examples are presented for the peak wind pressure around a complex-shaped building and the wind force evaluation for a base-isolated building. The results prove that the results of the proper execution of CFD are equivalent to those of the wind tunnel experiment. As examples of CFD applications of other issues related to high-rise building planning, we introduce snow accretion on outer walls and high-temperature exhaust from emergency generators. Finally, the future prospects for the use of CFD are discussed.