| Abstract [eng] |
In this paper Domain specific language usage for data transformations in relational SQL databases is investigated. Mentioned domain is analysed – main components are identified and described alongside with necessary processes. ETL tasks and execution is analysed. Possible tools which would benefit in creating the language are also identified and anlysed including analizators and ETL libraries. Based on identified entities of domain the requirements of a domain specific language are created and based on it a language – Relational DataRules – is constructed. Language’s grammar, syntax, ruleset and usage examples are provided. Domain specific language execution model is created by providing algorithms of how data transformations should be executed. Also, a prototype is created which executes Relational DataRules transformations. |
