用于数据仓库管理的领域特定语言开发
Pengembangan Domain Specific Language Untuk Pengelolaan Data Warehouse
AI总结:
本研究针对银行交易服务性能优化需求,开发了用于数据仓库数据传输的DSL应用,通过词法、语法等四阶段分析生成可执行命令,可降低非技术人员数据传输的命令编写错误,支持按数据规模进行Oracle传输决策。
摘要:
可通过数据留存提升银行交易服务的性能,即依据银行内部规则将生产数据库中的历史数据裁剪至数据仓库,以降低生产数据库的数据量。用于处理数据仓库数据传输的领域特定语言(Domain Specific Language,DSL)应用的设计与实现分为词法分析、语法分析、语义分析和代码生成四个部分,各部分具备不同特性,共同生成可执行命令。本研究已开发出一款采用DSL方法的应用,该应用有助于降低非技术人员以常规方式进行数据传输时的命令编写错误。测试结果表明,该方法在Oracle传输方案中可根据特定数据规模量级进行决策。
英文摘要:
Efforts to improve the performance of services on the transaction at a bank can be done by performing data retention, reduce the volume of data in the database production by cutting the historical data in accordance with the rules in a bank to a data warehouse. Design and implementation of applications Domain Specific Language (DSL) for handling the data transfer on the data warehouse is divided into lexical analysis, syntax analysis, semantic analysis and code generation. Each part has different characteristics to produce an executable command. Has been developed an application with the DSL method, which is beneficial to reduce the error of writing a command for a normal (non-technical) way to transfer data. From the test result in a decision Oracle transfer method according to the size scale of a particular data.
机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。