|
|
An automatic generation of logging database triggers
Matásek, Luboš ; Matouš, Václav (advisor) ; Mlýnková, Irena (referee)
In the thesis we study automatic generation of logging database triggers. As the result an application called Database Logger for logging triggers management was developed. The application allows DML events logging (insert, update, delete) including column update triggers. Current version supports two database platforms: Oracle and PostgreSQL. The log format preserves the maximum of information value and brings the possibility of easy querying. Users can also create historical tables to produce historical data views. Application supports log and historical table querying and their export into XML.
|
|
|
Using XML technologies to apply design patterns
Hála, Vojtěch ; Bednárek, David (advisor) ; Mlýnková, Irena (referee)
Although contemporary programming style involves massive use of design patterns, programming languages does not offer suitable means tu support their application. Aim of this work is to show in practice that modern XML technologies, namely XSL Transformations, allow developers to avoid some routine tasks required by the objective language itself. This reduces the probability of errors, allows developers to focus on the key parts of the design, and makes maintaining the code markedly easier. These benefits come to light especially in large projects with hundreds to thousands of classes with complicated relations. In this Thesis we demonstrate these ideas on an example of a C++ compiler project.
|
|
|
User-Defined XML-to-Relational Mapping
Kohan, Tomáš ; Mlýnková, Irena (advisor) ; Nečaský, Martin (referee)
In the present work we study opportunities of mapping the XML data into relational systems. In the first part we describe basic terminology used in this work and subsequently also basic techniques for mapping XML data into the relational database. In the next part we engaged in theoretical methods like MXM and ShreX, which were proposed on premises of a university or by a research group. In the third part we describe mapping methods, that are used in some commercial systems like Oracle, DB2 and MS SQL. In the whole second half of this work we propose a new mapping method (XRM), which bring in several new features, while the origin positive features are kept. At the end we analyze the prototype implementation of the proposed mapping method.
|
|
|
XML Data in (Object-) Relational Databases
Mlýnková, Irena ; Pokorný, Jaroslav (advisor) ; Krátký, Michal (referee) ; Osswald, R. (referee)
As XML has become a standard for data representation, it is inevitable to propose and implement techniques for e±cient managing of XML documents. A natural alternative is to exploit features and functions of (object-)relational database management systems, i.e. to rely on their long theoretical and practical history. The main concern of such techniques is the choice of an appropriate XML-to-relational mapping strategy. In this thesis we focus on further enhancing of current most e±cient XML-to-relational storage strategies { so-called adaptive methods. Firstly, we perform a detailed analysis of existing works and especially remaining open issues. Secondly, we propose their enhancing which can be characterized as a hybrid user-driven adaptive mapping strategy, i.e. a combination of so-called user-driven and adaptive methods. In the enhancing we focus especially on deeper exploitation of user-given information, i.e. schema annotations, and we propose an approach which enables to identify new annotation candidates and thus to help users to nd a more appropriate mapping strategy. For this purpose we propose a similarity measure which focuses mainly on structural similarity of the given data and an algorithm which enables reasonable tuning of its parameters on the basis of results of statistical analysis of...
|
|
|
User-Defined XML-to-Relational Mapping
Kohan, Tomáš ; Mlýnková, Irena (advisor) ; Nečaský, Martin (referee)
In the present work we study opportunities of mapping the XML data into relational systems. In the first part we describe basic terminology used in this work and subsequently also basic techniques for mapping XML data into the relational database. In the next part we engaged in theoretical methods like MXM and ShreX, which were proposed on premises of a university or by a research group. In the third part we describe mapping methods, that are used in some commercial systems like Oracle, DB2 and MS SQL. In the whole second half of this work we propose a new mapping method (XRM), which bring in several new features, while the origin positive features are kept. At the end we analyze the prototype implementation of the proposed mapping method.
|
|
|
An automatic generation of logging database triggers
Matásek, Luboš ; Matouš, Václav (advisor) ; Mlýnková, Irena (referee)
In the thesis we study automatic generation of logging database triggers. As the result an application called Database Logger for logging triggers management was developed. The application allows DML events logging (insert, update, delete) including column update triggers. Current version supports two database platforms: Oracle and PostgreSQL. The log format preserves the maximum of information value and brings the possibility of easy querying. Users can also create historical tables to produce historical data views. Application supports log and historical table querying and their export into XML.
|
|
|
Using XML technologies to apply design patterns
Hála, Vojtěch ; Bednárek, David (advisor) ; Mlýnková, Irena (referee)
Although contemporary programming style involves massive use of design patterns, programming languages does not offer suitable means tu support their application. Aim of this work is to show in practice that modern XML technologies, namely XSL Transformations, allow developers to avoid some routine tasks required by the objective language itself. This reduces the probability of errors, allows developers to focus on the key parts of the design, and makes maintaining the code markedly easier. These benefits come to light especially in large projects with hundreds to thousands of classes with complicated relations. In this Thesis we demonstrate these ideas on an example of a C++ compiler project.
|
guest ::
