Browse > Article
http://dx.doi.org/10.3745/KTSDE.2018.7.8.287

Automation Tool Design for PL/SQL Applications Conversion  

Jee, Jungeun (숭실대학교 컴퓨터학과)
Lee, Jeongkun (솔트웨어(주))
Choi, Yongrak (숭실대학교 SW특성화대학원)
Shin, Yongtae (숭실대학교 컴퓨터학부)
Publication Information
KIPS Transactions on Software and Data Engineering / v.7, no.8, 2018 , pp. 287-296 More about this Journal
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.
Keywords
Open Source DBMS; Conversion of Applications; Automatic Conversion Tool; Automatic Conversion to Java Stored Procedure;
Citations & Related Records
연도 인용수 순위
  • Reference
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 Open Source Software company handbook, Korea OSS Promotion Forum, 2014. (in Korean)
4 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)
5 SQLWays's Application conversion [Internet], http://www.-ispirer.com/application-conversion
6 Ispirer Systems Ltd, "Oracle to MySQL Migration," White Paper, Mar. 2009.
7 Composer CipherSoft [Internet], http://composer technologies.com/products/composer-ciphersoft
8 OpenText Composer CipherSoft [Internet], https://www.opentext.com/what-we-do/products/specialty-technologies/opentext-composer/opentext-composer-ciphersoft
9 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.
10 Terence Parr, Language Implementation Patterns, The Pragmatic Bookshelf, 2010.
11 Terence Parr, The Definitive ANTLR 4 Reference, 2nd Edition, The Pragmatic Bookshelf, 2013.
12 Sheila Moore, Oracle Database PL/SQL Language Reference, 11g Release2, Oracle, 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.   DOI
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.