• Title/Summary/Keyword: Database Application Tuning

Search Result 17, Processing Time 0.027 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

A Study on the Construction of Database System for Automotive Shock Absorber (자동차용 충격흡수기의 데이터베이스 시스템 구축에 관한 연구)

  • 정영대;박재우;김명호
    • Proceedings of the Korean Society of Precision Engineering Conference
    • /
    • 1995.10a
    • /
    • pp.227-231
    • /
    • 1995
  • This paper describes a basic programming and interfacing modele which can link DataBase form experiments and dynamic analysis program of chock absorber within the limit of adequate reliability. The system developed can provid a user specific Database of shock absorber within the required damping performance and endurable tolerance, thus show a good application possibilities in commercial vehicle design.

  • PDF

A Study on the Construction of Database System for Automotive Shock Absorber (자동자용 충격흡수기의 데이터베이스 시스템 구축에 관한 연구)

  • 정영대;박재우;이석희;김영호
    • Proceedings of the Korean Society of Precision Engineering Conference
    • /
    • 1995.10a
    • /
    • pp.942-946
    • /
    • 1995
  • Using database obtained by means of experiments, or using the synamic behaviour analysis program of automotive shock absorber, database system is constructed within the limits of adequate reliability. Thus constructed data base can be used to find out corresponding specification of shock absorber design parameters to the required damping ability and tolerance.

  • PDF

Automatic Verification and Tuning of Transaction-based Database Applications (트랜잭션 기반 데이타베이스 응용프로그램의 안전성 자동 검증 및 자동 튜닝)

  • Kang Hyun-Goo;Yi Kwangkeun
    • Journal of KIISE:Databases
    • /
    • v.32 no.1
    • /
    • pp.86-99
    • /
    • 2005
  • In this paper, we suggest a system which automatically verifies and tunes transaction processing database applications based on program analysis technology. This system automatically verifies two kinds of transaction processing errors. The first case is the un-closed transaction. In this case, data is not updated as expected or performance of overall system can decrease seriously by locking some database tables until the process terminates. The second case is the miss-use of transaction isolation(inking) level. This causes runtime exception or abnormal termination of the program depending on runtime environment. This system automatically tunes two kinds of inefficient definition of transaction processing which decrease the performance of overall system. The first case happens when opened transaction is closed too late. And the second case happens when transaction isolation level is set too high.

Investigation on the Side Effects of Denormalizing Corporate Databases

  • Lee, Sang-Won;Kim, Nam-Gyu;Moon, Song-Chun
    • Journal of Information Technology Applications and Management
    • /
    • v.16 no.2
    • /
    • pp.135-150
    • /
    • 2009
  • Corporate databases are usually denormalized, due to the data modelers' impetuous belief that denormalization could improve system performance. By providing a logical insight into denormalization, this paper attempts to prevent every database modeler from falling into the denormalization pit. We indicate loopholes in the denormalization advocates' assertions, and then present four criteria to analyze the usefulness and validity of denormalization; 1) the level of concurrency among transactions, 2) the database independence of the application program, 3) the independence between the logical design and the physical one, and 4) the overhead cost to maintain database integrity under various query patterns. This paper also includes experimental results to evaluate performance of denormalized and fully normalized structures under various workloads.

  • PDF

Remote Fuzzy Logic Control System using SOAP (SOAP를 이용한 원격 퍼지 논리 제어시스템)

  • Yi, Kyoung-Woong;Choi, Han-Soo
    • Journal of Institute of Control, Robotics and Systems
    • /
    • v.13 no.4
    • /
    • pp.329-334
    • /
    • 2007
  • This paper deals with self-tuning of fuzzy control systems. The fuzzy logic controller(FLC) has parameters that an: input and output scaling factors to effect control output. Tuning method is proposed for the scaling factor. In this paper. it is studied to control and to monitor the remote system statues using SOAP for communicate between the server part and the client part. The remote control system is controlled by using a web browser or a application program. The server part is waiting for the request of client part that uses internet network for communication each other and then the request is reached. the server part saves client data to the database and send a command set to the client part and then the client part sends command to controller in a cool chamber. The administrator can control and monitor the remote system just using a web browser. The effects of membership functions, defuzzification methods and scaling factors are investigated in the FLC system.

Adaptive Control Design for Missile using Neural Networks Augmentation of Existing Controller (기존제어기와 신경회로망의 혼합제어기법을 이용한 미사일 적응 제어기 설계)

  • Choi, Kwang-Chan;Sung, Jae-Min;Kim, Byoung-Soo
    • Journal of Institute of Control, Robotics and Systems
    • /
    • v.14 no.12
    • /
    • pp.1218-1225
    • /
    • 2008
  • This paper presents the design of a neural network based adaptive control for missile is presented. The application model is Exocet MM40, which is derived from missile DATCOM database. Acceleration of missile by tail Fin control cannot be controllable by DMI (Dynamic Model Inversion) directly because it is non-minimum phase system. So, the inner loop consists of DMI and NN (Neural Network) and the outer loop consists of PI controller. In order to satisfy the performances only with PI controller, it is necessary to do some additional process such as gain tuning and scheduling. In this paper, all flight area would be covered by just one PI gains without tuning and scheduling by applying mixture control technique of conventional controller and NN to the outer loop. Also, the simulation model is designed by considering non-minimum phase system and compared the performances to distinguish the validity of control law with conventional PI controller.

Application Tuning For Increased Database System Performance (어플리케이션 튜닝을 통한 데이터베이스 시스템 성능 향상)

  • 이병헌;최용락;정기원
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2001.04b
    • /
    • pp.187-189
    • /
    • 2001
  • 기존 시스템에서 보다 정확하고 신속한 정보의 제공에 대한 사용자들의 요구사항을 충족시키기 위해서는 시스템의 개선이나 현재 운영중인 시스템의 조율이 필수적으로 여겨지고 있다. 시스템 개발자는 관계형 데이터베이스 시스템의 성능을 저하 시키는 용인 중 응용 프로그램들과 저장 포로시저, 트리거, 패키지, 뷰 등에 대한 성능 향상을 위하여 튜닝을 고려하여야만 한다. 특히, 응용 어플리케이션 수행에 많은 시간을 소요하거나, 많은 자원을 필요로 하는 응용 프로그램들을 중심적으로 분석하여 적절한 튜닝을 수행한다. 또한, 오라클에서 제공하는 도구들을 이용하여 자료나 질의문의 특성을 파악한 후에 효과적인 개선을 통하여 데이터베이스 시스템의 성능 및 효율을 높이는 방법에 관심을 두고 있다.

  • PDF

차세대 엔터프라이즈웨어 마이포스 소개

  • 정창현
    • Proceedings of the Korea Database Society Conference
    • /
    • 1995.12a
    • /
    • pp.3-19
    • /
    • 1995
  • 시스템 Technology ★ Server Technology - 운영환경구축 ★ Network 구성설계 - ATM, FDDI, NMS ★ Client/Server시스템 구성별 Bench Marking ★ Windows 메뉴 및 GUI 설계 ★다기능 PC 운영환경 설정 시스템 Technology ★ Data Base Technology - DB Administration - BB Performance Tuning ★ System Integration Technology - Application Integration - System Flow Control - Task Control - Applicational Interface - S/W Down Load 시스템 Technology ★ Memory Optimization ★ IBM/Facom Host API ★ 영상전화 Customizing - Intel Proshare ★ Auto Dialing - CTI Link ★ IC-Card Interface 시스템 Technology ★ Sound 처리 - Voice Mail - 음절 처리 ★ Image 처리 ★도움말 처리 - Hyper Text 시스템 Technology ★ Socket Programming - 긴급메일 - Peer to peer message switching ★ Set Up Programming -Install Shield ★ DB Access Programming - DB-Library ★ TCP/IP Programming(중략)

  • PDF

A Study on Improving the Performance of High Resolution Image Web GIS System (WEB GIS시스템을 통한 고해상도 영상지도의 속도향상을 위한 연구)

  • Jeong, Myeong-Hun;Suh, Yong-Cheol
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.11 no.4
    • /
    • pp.161-171
    • /
    • 2008
  • Nowdays the need of modeling a real world using computers leads to increase the importance of GIS. Moreover, the wide spread of the Internet service has brought about Web GIS Development. Especially, the tuning of Web GIS system has a crucial role in improving the performance of high resolution image Web GIS system. Thus, this study provides a variety of ways to improve the performance of high resolution image Web GIS system. We have tuned IBM AIX operation system, Oracle, ArcSDE in the database level and Tomcat, ArcIMS in the application level. What is more, we propose ways of coding which can have a positive impact on performance. As a result, the proposed methods guarantee high resolution image Web GIS system to improve performance.

  • PDF