• Title/Summary/Keyword: Database Parameter

Search Result 238, Processing Time 0.041 seconds

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

  • 최용락;윤병권;정기원
    • The Journal of Society for e-Business Studies
    • /
    • v.7 no.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

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

  • 류문수;정회진;이상호
    • Journal of KIISE:Databases
    • /
    • v.31 no.4
    • /
    • pp.373-383
    • /
    • 2004
  • There have been an emerging interests in the importance of database tuning techniques under modem database environments in which very large-scale data should be managed. In Particular. database performance parameters should be tuned to reflect system loads appropriately. This paper presents two parameter tuning strategies, namely throughput-based and response-time-based, which tune each performance parameter accordingly. The proposed techniques are applied to two commercial database systems in the TPC-W benchmark to see the effectiveness of those methods. The results show that they can help improve system performance considerably.

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

  • Kim, Jae-Hong;Yang, Jong-Ho;Im, Duk-Ki
    • Proceedings of the Computational Structural Engineering Institute Conference
    • /
    • 2011.04a
    • /
    • 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 (데이타베이스 워크로드 분석 : 실험적 연구)

  • Oh, Jeong-Seok;Lee, Sang-Ho
    • The KIPS Transactions:PartD
    • /
    • v.11D no.4
    • /
    • pp.747-754
    • /
    • 2004
  • Database administrators should be aware of performance characteristics of database systems in order to manage database system effectively. The usages of system resources in database systems could be quite different under database workloads. The objective of this paper is to identify and analyze performance characteristics of database systems in different workloads, which could help database tuners tune database systems Under the TPC-C and TPC-W workloads, which represent typical workloads of online transaction processing and electronic commerce respectively, we investigated usage types of resource that are determined by fourteen performance indicator, and are behaved in response to changes of four tuning parameters (data buffer, private memory, I/O process, shared memory). Eight out of the fourteen performance indicators cleary show the performance differences under the workloads. Changes of data buffer parameter give a influences to database system. The tuning parameter that affects the system performance significantly is the database buffer size in the both workloads.

Joint Shear Behavior Prediction for RC Beam-Column Connections

  • LaFave, James M.;Kim, Jae-Hong
    • International Journal of Concrete Structures and Materials
    • /
    • v.5 no.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
    • /
    • v.35 no.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
    • /
    • v.74 no.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
    • /
    • v.13 no.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
    • /
    • v.10 no.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.

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

  • Lee, Sung-Youl;Kwak, Kyu-Sup
    • IE interfaces
    • /
    • v.15 no.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.