온라인 거래 장애 방지를 위한 SQL 성능 기반 IT 응용프로그램 변경관리 프로세스 연구
A Study on SQL Performance-Based IT Application Change Management Process to Prevent Failures of Online Transactions
0
조회
0
다운로드
1
인용
0
참고문헌
키워드
초록
금융기관 및 통신사 등 대량의 데이터를 다루는 회사에서 테스트환경은 구축 비용문제로 인한 스토리지 용량의 한계및 중요정보 컬럼의 변환 등으로 운영환경과 항상 동일한 것은 아니다. 따라서, 이러한 테스트환경과 운영환경이 동일하지 않아 발생하는 SQL 성능저하는 예상치 못한 거래장애로까지 연결되어 기업의 금전적 손실 및 고객민원, 신뢰도하락을 발생시키는 중요 원인이 되고 있다. 그동안 SQL과 관련한 성능연구는 DBMS Optimizer와 관련한 튜닝연구중심으로 이루어져, 이러한 문제에 대해서는 다루어지지 않았다. 따라서, 본 논문에서는 테스트환경과 운영환경의 차이로 발생하는 SQL의 성능저하에 따른 온라인 거래장애 방지를 위해 개선된 SQL 성능 기반의 IT 응용프로그램 변경관리 프로세스를 제시하여 그 효과성을 검증한다.
Abstract
Test environment on the company that handles a large amount of data such as telecommunications companies and financialinstitutions, may not always be the same as the production environment, which is caused by conversion of important columnsabout information and limitation of storage capacity due to the construction cost. Therefore, SQL performance degradation thatoccurs when the test and production environments are not the same, which is an important cause of connecting to the unexpectedfailures of online transactions, and it generates financial loss of business, customer complaints, a decrease in reliability. In studiesrelated SQL performance, it has so far been conducted mainly studies of tuning associated with DBMS Optimizer, and it hasnot been addressed issues of this sector. Therefore, in this paper, I verify the validity about presentation of the advanced SQLPerformance-based IT application change management process, in order to prevent failures of the online transactions associatedwith poor performance of SQL generated by differences in test and production environments.
참고문헌 (13)
- "Overseas Mainstream System ‘Mainframe’is 50 years-old"[URL]
- "The Server OS market-share in 2013"[URL]
- IBM Corporation, "DB2 10 for LUW: Basic Administration for Linux and Windows", IBM Korea, ~ (2012)
- Eung-su Han, "The Guide for Data Architecture Professional", Korea Database Agency, 532~ (2010)
- "DB2 Access path Enhancements with DB 2"[URL]
- "4Definition of REXX"[URL]
- "The average salary of bank employees in 2013"[URL]
- Tom Picello, "IT ROI, Analysis the values of IT Investment", Daechung Media, 202~ (2004)
- Tom Picello, "IT ROI, Analysis the values of IT Investment", Daechung Media, 181~ (2004)
- The importance of strategic and reputational risks, and management methods, "Ji-hun Jung", Financial Supervisory Service, 95~ (2006)
- Reputational risk and IT: Six keys to effective reputational and IT risk management, "IBM Global Technology Service", IBM Corporation, ~ (2013)
- Reputational risk and IT: How security and business continuity and shape the reputation and value of your company, "IBM Global Technology Service", IBM Corporation, ~ (2012)
- Requires a new approach to reputational risk in the social media age, "Yong-deuk Kim", National IT Industry Promotion Agency, ~, pp.SW Insight 2013-11 (2013)