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

검색결과 238건 처리시간 0.027초

데이터베이스 시스템 성능 향상을 위한 데이터베이스 관리 시스템 파라미터 튜닝 프로세스 (Database Management System Parameter Tuning Processes for Improving Database System Performance)

  • 최용락;윤병권;정기원
    • 한국전자거래학회지
    • /
    • 제7권1호
    • /
    • pp.107-127
    • /
    • 2002
  • Database system parameter tuning is one of database system tuning that achieve to improve performance of database system with application program tuning and data model tuning. By parameter tuning adjusts value of entry that is staled in data dictionary's parameter file that is included to database system, it is thing which make relevant database system can display performance of most suitable. And, it is that achievement is one o( possible tuning method immediately without occurrence of additional expense or involved hardware for database system performance elevation and ashes composition of software. But, it is actuality that administration about parameter practical use is not achieved, and is using Default Value of parameter that database management system offers just as it is systematically. So, this paper presents parameter tuning process that can :achieve Parameter tuning of database system that is operating present systematically, and parameter tuning process each activity important input urea and tuning achievement product. And explain about effect and result that happen by sort database system performance and parameters that it is affinity systematically, and grasp relationships between parameter, and change parameter of string database system. And not that parameter uses contents that specify by fixing when establish database administration system, is going to emphasize and explain that must utilize changing continuously during database system operation. It changes parameter entry value how in various kinds different operation environment and present if must apply, and will arrange effect that this parameter enoy value alteration gets in performance liking into account point that is actuality that is using parameter that define database administrators when install the database system just as it is continually without alteration.

  • PDF

TPC-W 성능 평가에서의 데이타베이스 시스템 성능 인자 튜닝 (Database System Parameter Toning in the TPC-W Benchmark)

  • 류문수;정회진;이상호
    • 한국정보과학회논문지:데이타베이스
    • /
    • 제31권4호
    • /
    • pp.373-383
    • /
    • 2004
  • 대량의 데이타를 관리하는 현대 데이타베이스 시스템 환경에서는 데이타베이스 시스템 튜닝에 대한 중요성이 증가하고 있다. 특히, 데이타베이스 시스템 성능 인자(performance parameters)를 시스템부하에 따라 적절하게 튜닝하여야 한다. 본 논문에서는 TPC-W 환경에서 데이타베이스 시스템의 단일 성능 인자 튜닝 전략 2가지(처리량 평가 방법, 응답시간 평가 방법)를 제시한다. 효과성을 입증하기 위하여 제시한 튜닝 전략은 두 개의 상용 데이타베이스 시스템에 적용하였다. 실험 결과는 제시된 튜닝 전략이 성능 향상에 기여함을 보인다.

Bayesian parameter estimation을 적용한 RC 접합부 전단거동의 주요영향 요인 결정 (Determination of Key Influence Parameters on RC Joint Shear Behavior Using the Bayesian Parameter Estimation)

  • 김재홍;양종호;임덕기
    • 한국전산구조공학회:학술대회논문집
    • /
    • 한국전산구조공학회 2011년도 정기 학술대회
    • /
    • pp.328-331
    • /
    • 2011
  • 준정적 횡하중을 재하 받는 철근콘크리트 보-기둥 접합부의 전단강도에 대한 주요 영향요인을 Bayesian parameter estimation의 신뢰성 이론 접목을 통해 검토하였다. 이와 같은 연구 scope의 수행을 위해 철근콘크리트 보-기둥의 실험 database가 구축되었다. 실험 database는 일정한 criteria을 적용하여 구축되었으며, 포함된 시편들은 최종적으로 접합부 내의 전단파괴가 지배하는 경우들이다. 포함된 시편들의 상세는 ACI (American Concrete Institute) 352R-02를 기준으로 평가되어졌다. 보-기둥 접합부의 전단강도에 영향 요인을 편중되지 않게 평가하고자, Bayesian parameter estimation의 신뢰성 이론을 적용하였다. Bayesian parameter estimation의 적용을 통해 전단강도에 영향이 적은 변수 (not informative parameter)를 순차적으로 제거 (stepwise removal process)함으로 주요 영향요인의 우선 순위를 확인할 수 있었다. 검토된 8개의 변수들 중에서, 횡하중을 재하 받는 철근콘크리트 보-기둥의 전단강도는 주로 콘크리트 압축강도, in-plane geometry, 종방향 보의 주철근 그리고 접합부 내의 구속철근 순으로 영향을 줌을 알 수 있었다.

  • PDF

데이타베이스 워크로드 분석 : 실험적 연구 (Database Workload Analysis : An Empirical Study)

  • 오정석;이상호
    • 정보처리학회논문지D
    • /
    • 제11D권4호
    • /
    • pp.747-754
    • /
    • 2004
  • 데이타베이스 시스템을 효율적으로 사용하기 위해 데이타베이스 관리자는 데이타베이스 시스템의 성능 특징들을 알아야 한다 데이터베이스 시스템에서 자원 사용은 워크로드에 따라 다르게 나타난다. 본 논문의 목적은 상이할 워크로드에서 데이타베이스 튜닝에 도움이 될 수 있도록 데이타베이스 시스템의 성능 특징 분석하고 식별하는 것이다. 이를 위해, OLTP 환경을 나타내는 TPC-C 워크로드와 웹기반의 전자상거래 환경을 나타내는 TPC-W워크로드에서 14개의 성능 지표에 의해 결정되는 자원 사용 형태를 분석하고 4개(데이타 버퍼, 개인 메모리, I/O 프로세스, 공유 메모리)의 자원 할당 변경에 따른 자원 사용 형태의 변화를 분석한다. 분석에 대한 결과로서 14개 중 8개의 성능 지표는 워크로드에서 성능차이를 보이고, 데이타 버퍼 자원의 변경은 데이타베이스 시스템에 영향을 준다. 본 논문의 결과는 데이타베이스 시스템 자동 튜닝의 기초 자료로서 사용될 수 있다.

Joint Shear Behavior Prediction for RC Beam-Column Connections

  • LaFave, James M.;Kim, Jae-Hong
    • International Journal of Concrete Structures and Materials
    • /
    • 제5권1호
    • /
    • pp.57-64
    • /
    • 2011
  • An extensive database has been constructed of reinforced concrete (RC) beam-column connection tests subjected to cyclic lateral loading. All cases within the database experienced joint shear failure, either in conjunction with or without yielding of longitudinal beam reinforcement. Using the experimental database, envelope curves of joint shear stress vs. joint shear strain behavior have been created by connecting key points such as cracking, yielding, and peak loading. Various prediction approaches for RC joint shear behavior are discussed using the constructed experimental database. RC joint shear strength and deformation models are first presented using the database in conjunction with a Bayesian parameter estimation method, and then a complete model applicable to the full range of RC joint shear behavior is suggested. An RC joint shear prediction model following a U.S. standard is next summarized and evaluated. Finally, a particular joint shear prediction model using basic joint shear resistance mechanisms is described and for the first time critically assessed.

Development of a Quality Assurance Safety Assessment Database for Near Surface Radioactive Waste Disposal

  • Park J.W.;Kim C.L.;Park J.B.;Lee E.Y.;Lee Y.M.;Kang C.H.;Zhou W.;Kozak M.W.
    • Nuclear Engineering and Technology
    • /
    • 제35권6호
    • /
    • pp.556-565
    • /
    • 2003
  • A quality assurance safety assessment database, called QUARK (QUality Assurance Program for Radioactive Waste Management in Korea), has been developed to manage both analysis information and parameter database for safety assessment of low- and intermediate-level radioactive waste (LILW) disposal facility in Korea. QUARK is such a tool that serves QA purposes for managing safety assessment information properly and securely. In QUARK, the information is organized and linked to maximize the integrity of information and traceability. QUARK provides guidance to conduct safety assessment analysis, from scenario generation to result analysis, and provides a window to inspect and trace previous safety assessment analysis and parameter values. QUARK also provides default database for safety assessment staff who construct input data files using SAGE(Safety Assessment Groundwater Evaluation), a safety assessment computer code.

Shear strength prediction for SFRC and UHPC beams using a Bayesian approach

  • Cho, Hae-Chang;Park, Min-Kook;Hwang, Jin-Ha;Kang, Won-Hee;Kim, Kang Su
    • Structural Engineering and Mechanics
    • /
    • 제74권4호
    • /
    • pp.503-514
    • /
    • 2020
  • This study proposes prediction models for the shear strength of steel fiber reinforced concrete (SFRC) and ultra-high-performance fiber reinforced concrete (UHPC) beams using a Bayesian parameter estimation approach and a collected experimental database. Previous researchers had already proposed shear strength prediction models for SFRC and UHPC beams, but their performances were limited in terms of their prediction accuracies and the applicability to UHPC beams. Therefore, this study adopted a statistical approach based on a collected database to develop prediction models. In the database, 89 and 37 experimental data for SFRC and UHPC beams without stirrups were collected, respectively, and the proposed equations were developed using the Bayesian parameter estimation approach. The proposed models have a simplified form with important parameters, and in comparison to the existing prediction models, provide unbiased high prediction accuracy.

Parameter Identification of 3R-C Equivalent Circuit Model Based on Full Life Cycle Database

  • Che, Yanbo;Jia, Jingjing;Yang, Yuexin;Wang, Shaohui;He, Wei
    • Journal of Electrical Engineering and Technology
    • /
    • 제13권4호
    • /
    • pp.1759-1768
    • /
    • 2018
  • The energy density, power density and ohm resistance of battery change significantly as results of battery aging, which lead to decrease in the accuracy of the equivalent model. A parameter identification method of the equivale6nt circuit model with 3 R-C branches based on the test database of battery life cycle is proposed in this paper. This database is built on the basis of experiments such as updating of available capacity, charging and discharging tests at different rates and relaxation characteristics tests. It can realize regular update and calibration of key parameters like SOH, so as to ensure the reliability of parameters identified. Taking SOH, SOC and T as independent variables, lookup table method is adopted to set initial value for the parameter matrix. Meanwhile, in order to ensure the validity of the model, the least square method based on variable forgetting factor is adopted for optimizing to complete the identification of equivalent model parameters. By comparing the simulation data with measured data for charging and discharging experiments of Li-ion battery, the effectiveness of the full life cycle database and the model are verified.

Parameter Extraction Procedure for Ion Implantation Profiles to Establish Robust Database based on Tail Function

  • Suzuki, Kunihiro;Kojima, Shuichi
    • JSTS:Journal of Semiconductor Technology and Science
    • /
    • 제10권4호
    • /
    • pp.251-259
    • /
    • 2010
  • We proposed a tail function parameter extraction procedure for the establishment of a robust ion implantation database. We showed that, for the expression of ion implantation profiles, there are many local minimum values set for the third and fourth moment parameters of $\gamma$ and $\beta$ for the Pearson function that comprises the standard dual Pearson and tail functions. We proposed the use of a joined tail function as a mediate function to extract $\gamma$ and $\beta$, and demonstrated that this enables us to extract the parameters uniquely. Other parameters associated with channeling phenomena can also be simply and uniquely extracted by our procedure.

GT를 이용한 Web 기반 절삭변수 검색시스템의 개발 (The Development of the Web Based Cutting Parameter Selection System Using Group Technology)

  • 이성열;곽규섭
    • 산업공학
    • /
    • 제15권3호
    • /
    • pp.308-315
    • /
    • 2002
  • This study presents the web based cutting parameter selection system using Group Technology (GT). The GT is basically applied to classify and code the work material and cutting process which are main factors to affect cutting parameter selection. The proposed system has been designed to electronically select proper cutting conditions based on the stored GT database. The existing approaches used in most small and medium sized companies are basically to use manufacturing engineer's experience or to find the recommended values from the manufacturing engineers handbook. These processes are often time consuming and inconsistent, especially when a new engineer is involved. Consequently, the proposed system could automatically and consistently generate the proper cutting conditions (feed, depth of cut, and cutting speed) as soon as relatively simple data input is given thanks to the classified GT database.