Darbe analizuojama xBase komandų transformavimo į SQL užklausas problema. Pateikiamas konceptualus transformavimo problemos sprendimas, kurį sudaro dvi dalys: transformavimo algoritmas ir transformavimo taisyklių saugykla. Pagal pasiūlytą modelį sukurta programinė įranga, kuri leidžia atlikti xBase komandų transformavimą į SQL užklausas. Taip pat sukurtoje programinėje įrangoje įdiegtas ir papildomas funkcionalumas: duomenų bazės lentelių duomenų peržiūra, koregavimas, duomenų perkėlimas iš senų *.dbf lentelių į serverinės duomenų bazės lenteles. Sukurtas sprendimas palengvina sistemos perkėlimą iš navigacinės duomenų bazių sistemos į šiuolaikines kliento serverio architektūros sistemas veikiančias serverinių dbvs pagrindu. / The conversion problem of xBase commands into SQL queries is analysed in this work. Solution to conversion problem was proposed. It consists of two parts: conversion algorithm and conversion rules storage. A software for conversion of xBase commands into SQL queries was developed using the proposed model. Additional functionality was implemented in the software: viewer and editor of database tables, loader of *.dbf tables into servers database tables. A solution to facilitate migration from ISAM database to modern client-server DBMS systems was developed.

The primary aim of this research project was to investigate techniques to replace the complicated process of testing embedded systems in automotive domain. The multi-component domain was composed of different hardware to be used in testing procedure which increased the level of difficulty in testing for an operator. As a result, an existing semi-automated testing procedure was replaced by more simpler and efficient framework (ViBATA). A key step taken in this scenario was the replacement of manual GUI interface with the scriptable one to enhance the automation. This was achieved by building a Domain-specific language which allowed test definition in the form of human readable scripts which could be stored for later use. A DSL is a scripting language defined for a particular domain with compact expressiveness. In this case the domain is testing embedded systems in general and automotive systems in particular. The final product was a test case specification document in the form of XML as an output of generated code from this DSL which will be input to ViBATA to make test specification component automated. In this research a comparative analysis of existing DSLs for alternative domains and investigation of their applicability to the presented domain was also performed. The technologies used in this project are Xtext to define the DSL grammar, Xtend to generate code in Java and Simple framework to generate output in XML. The stages involved in DSL development and how these stages were implemented is covered in this thesis. The developed DSL for this domain is tested for automotive and calculator systems in this thesis which proved that this is more general and flexible. The DSL is consistent, efficient and automated test specification component of testing framework in embedded systems.