The Design And Implementation Of A Mutual Translation System For Non-text DSL And SQl In The Field Of Data Integration

In recent years, with the rapid development of the Internet industry, Internetdata growing era of big data has arrived; data integration in the field need to have amore efficient and high-quality approach to deal with the challenges brought by theera of big data; in order to improve efficiency and quality, the new forms of workusing methods and technology continue to produce. Data integration, work withconventional flow diagram form the visual theme has become, for example,translation is performed by the visualization by the data flow diagram language codeinto an object program to complete the data processing tasks. Work in this areadepend on the completion of a translator.In this paper, after a summary of relevant job content data integration field,citing domain-specific language (Domain Specific Language, abbreviated DSL)related to the concept of abstract set applies to the field of visual models, namely forData Integration non-textual DSL (Data Integration’s Graphic DSL, referred to as theDIG-DSL), and use the WEB technology, you can then display the browser.The system described herein is Tencent Technology(Shenzhen) Co., Ltd.(referred to as Tencent) data integration service centers(Data Integration ServicesHouse, short with Dish) heterogeneous language translation subsystem(referred to astranslation system) based on B/S architecture, translator in the field with the other,like the visual flow chart used to complete the translation work to the programminglanguage code, specifically to translate the DIG-DSL to SQL code in this article; inaddition, the translation system is able to translate DIG-DSL into SQL by reversefunction, this feature not only greatly improve the system availability also makesdata integration’s forms of work to be more richer.Through the translation system, the user can design data processing byDIG-DSL, and translated it into SQL. Because DIG-DSL assist users in processdesign with the tools provided by the translation system, a data processing workfrom the past to write complex SQL code logic operation becomes drawing; userscan focus on data processing logic rather than achieve. The SQL reverse function canhelp users to work accumulated over SQL converted into the form of a data flowdiagram; this can effectively reuse the results of past work, but also improve theavailability and flexibility of translation systems. Overall, the translation systemgreatly improves the efficiency of data integration and reduce operating costs.