KIPS Transactions on Software and Data Engineering (정보처리학회논문지:소프트웨어 및 데이터공학)

Korea Information Processing Society (한국정보처리학회)
권호 표지
DOI QR코드

DOI QR Code

Automation Tool Design for PL/SQL Applications Conversion

PL/SQL 응용프로그램 전환을 위한 자동화 도구 설계

  • Received : 2018.02.20
  • Accepted : 2018.03.30
  • Published : 2018.08.31
Download PDF
⟨ Previous Next ⟩

Abstract

In the recent commercial DBMS market, as the users' burden and complaint which are related to high price licensing policy and late technical support service are increasingly rising, the concern for use of open source DBMS which has no problem with compatibility or stability is escalating. Due to the fact, the cases saving the cost are growing by converting Oracle Corporation's applications, which has about 60% share in the DBMS market, to an open source DBMS. However, in converting non-interchange sentences to an ANSI standard-based open source DBMS because of the use of PL/SQL in Oracle Corporation provides, a lot of manual work accompanies, so there is a lot of loss of time and money. Therefore, a tool that automatically converts PL/SQL to standard SQL is required. The proposed automation tool for the conversion of applications converts PL/SQL to Java Stored Procedure, an open source DBMS-based ANSI standard programming language. Through carrying out a test on the automation tool, it is proved that the tool will contribute to shortening time and saving cost by verifying the identity of input-output data and its reliability after correcting errors in converting to Java Stored Procedure.

최근 상용 DBMS 시장은 고가의 라이선스 정책과 신속하지 않은 기술 지원 서비스 등에 대한 사용자들의 부담과 불만이 커지면서, 호환성이나 안정성에 문제가 없는 오픈소스 DBMS의 사용에 대한 관심이 확대되고 있다. 이로 인해 DBMS 시장의 약 60% 점유율을 갖고 있는 오라클사 기반의 응용프로그램을 오픈소스 기반의 DBMS로 전환하여 비용을 절감하는 사례가 많아지고 있다. 그러나 오라클사에서 제공하는 PL/SQL의 사용으로 인한 비호환적 문장을 오픈소스 DBMS로 전환 시, 많은 수작업을 동반하게 되어 시간 및 비용 손실이 크다. 따라서 PL/SQL을 표준 SQL로 자동 전환해주는 도구가 요구된다. 제안하는 응용프로그램 전환을 위한 자동화 도구는 PL/SQL을 ANSI 표준 프로그래밍 언어인 Java SP (Stored Procedure)로 전환한다. 자동화 도구 테스트 실행을 통해 입출력 데이터의 동일성을 확인하고, 발생하는 Java SP 전환 오류 수정으로 신뢰성을 검증하여 응용프로그램 전환의 시간과 비용 절감에 기여할 수 있다는 것을 확인했다.

Keywords

References

  1. 2014 Year of the database industry market analysis report, Korea Database Agency, Dec. 2014. (in Korean)
  2. ANSI/ISO/IEC 9075-14:2006, "Database languages - SQL - Part14: XML-Related Specifications (SQL /XML)," International Organization for Standardization/International Electrotechnical Commission, Mar. 2011.
  3. Sheila Moore, Oracle Database PL/SQL Language Reference, 11g Release2, Oracle, 2013.
  4. Open Source Software company handbook, Korea OSS Promotion Forum, 2014. (in Korean)
  5. J. k. Lee, A Study of Modeling Automatic Translator from PL/SQL to Java Stored Procedure Based on ANTLR, Soongsil University, Jun. 2014. (in Korean)
  6. SQLWays's Application conversion [Internet], http://www.-ispirer.com/application-conversion
  7. Ispirer Systems Ltd, "Oracle to MySQL Migration," White Paper, Mar. 2009.
  8. Composer CipherSoft [Internet], http://composer technologies.com/products/composer-ciphersoft
  9. OpenText Composer CipherSoft [Internet], https://www.opentext.com/what-we-do/products/specialty-technologies/opentext-composer/opentext-composer-ciphersoft
  10. Y. Zhao, T. Wang, X. Ni, X. Wang, and Z. Xie, "Syntactic Representation Transformation in Operator Design Method Based on ANTLR Tool," Computer and Information Technology(CIT), 2012 IEEE 12th International Conference on., pp.115-118, Oct. 2012.
  11. Terence Parr, Language Implementation Patterns, The Pragmatic Bookshelf, 2010.
  12. Terence Parr, The Definitive ANTLR 4 Reference, 2nd Edition, The Pragmatic Bookshelf, 2013.
  13. T. J. Parr and R. W. Quong, "ANTLR: A predicated -LL(k) Parser Generator," Software-Practice and Experience, Vol.25(7), pp.789-810, 1995. https://doi.org/10.1002/spe.4380250705
  14. D. Cao and D. Bai, "Design and implementation for SQL parser based on ANTLR," 2010 2nd International Conference on Computer Engineering and Technology, Vol.4, pp.276-279, 2010.