An Adaptive Algorithms Translating and Back-Translating of Object Constraint Language into Structure Query Language

This paper aims to develop the algorithms to translate and back-translate the OCL (Object Constraint Language) into SQL (Structure Query Language). The translation will use word substring and word comparing. The OCL or SQL to word substring and word compare the algorithm. To consider a table name, relation name and conditions can be set the three sections into language model and showed the result to the users. It can help reducing time and errors of the translation. Moreover, it increases convenience for the users to translate and back-translate of OCL constraints to SQL expressions.