Ing. Michal Valenta, Ph.D.

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

The purpose of this thesis is to design and implement a functional prototype module for the Manta Flow software, which will be able to analyze OBIEE (Oracle Business Intelligence Enterprise Edition) reporting tool documents and create a graph describing their data flows. The resulting graph is used to visualize data flows from data sources to single document items. The basis of this thesis is an analysis of OBIEE reporting tool and its objects, design of a possible solution to the problem, following implementation of the prototype and testing its different parts. The created prototype will be deployed into the existing Manta Flow product and expands the set of software supported tools.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Mgr. Monika Součková

Department of Software Engineering

This bachelor's thesis describes the design and implementation of the backend part of a system for management of surveys in the CTU environment. The backend handles the storing and retrieval of data and provides an application interface for communication with a frontend part of the system. The thesis deals with verification of respondent's identity while focusing on protecting anonymity of the submitted entry. Existing CTU services are used to authenticate users of the backend. The result of this thesis is an application interface in the form of a web service adhering to the rules of the REST architecture. For implementation the Symfony Framework and the PHP language were used.

Ing. Michal Valenta, Ph.D.

Ing. Vojtěch Polcar

Department of Software Engineering

This bachelor's thesis is dedicated to the expansion of a web application focused on the manufacturing of luxury watches. This thesis provides an analysis of a previous solution, and then outlines the design of visuals and functionalities of a new proposed solution. A component of the system containing descriptions of watch models is reworked, and is expanded by adding functionalities for file management and PDF document generation. This project was developed using React and Java Spring technologies. The resulting application is ready to be deployed for commercial use.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Monika Borkovcová, Ph.D.

Department of Software Engineering

The aim of this thesis is to develop a web application designated to find a repairing service for any kind of electronics, household appliances, vehicles, including other kinds of machinery, and to describe the whole process of its development. The thesis also describes the process of application analysis with examination of similar solutions. Besides the description of the development process, the final output of the thesis is also a working web application.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Filip Glazar

Department of Software Engineering

This work deals with the creation proccess of the client side of a web application for Czech electronic library project created by the Academy of Sciences of the Czech Republic. The primary use of the application is poetry anthology management intended as an innovation to the existing solution. An analysis and comparison of suitable technologies and approaches of web development was performed and based on its results, a set of requirements covering all functionalities was created. Based on its results, a user interface was designed and it was implemented into a working solution. The work includes proper testing and is supplied with sufficient documentation.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Marek Hakala

Department of Software Engineering

This bachelor thesis is dealing with desing and implementation of backend of portal EBIE (Extended Business Intelligence Encyclopedia). Portal is documented in the thesis, conceptual data schema is made and content management, metadata transformation from data warehouse and other backend requirements are designed. Content management is done by program Asciidoctor. Designs are tried and implemented.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Adam Šenk

Department of Software Engineering

This bachelor thesis concentrates on implemetation of changes in export of data in the application Students Inquiry System Generator on CTU. Analysis, design and implementation of an application interface for Students Inquiry System CTU also dealt with. The application interface is implemented as a RESTful web service based on PHP.

Ing. Michal Valenta, Ph.D.

Ing. Magda Friedjungová

Department of Software Engineering

With a growing amount of data generated, their changing and evolving, the concept of big data has become incredibly popular in last years. It provides a set of new approaches and techniques allowing to work efficiently with huge volumes of records. Nowadays, information is one of the most important resources; it can help with decision making and business processes optimization. However, to get actual insights and unlock a potential of data, it is necessary to process them and discover the information hidden inside it which is a goal of data analytics. Data analytic platforms allow to manipulate with raw data in order to find out what exactly they contain. These systems are complex and includes multiple components therefore their designing requires comprehensive analysis of available options. This thesis aims to describe how data analytics works for big data and how they are used in business. It gives an overview of existing technologies and approaches to building data analytics infrastructures. It also defines points that should be taken into consideration while choosing the most suitable software solution for a particular use case. The research is done by studying architectural principles of big data systems and investigating the market of data analytics software. The result of this work is a composite report including comparison of several technologies and a list of criteria considered. The final report can be used as a guideline for choosing the most suitable technology for implementing an analytical platform in a broad variety of organizations.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Karel Klouda, Ph.D.

Department of Software Engineering

This bachelor's thesis deals with the design by implementing and testing an application to provide all the data about the work done by the teacher during a specific semester in one place. It achieves its goal using a server-client architecture. It can display data from data sources, create own GraphQL queries over the data and enables administrative management. It also supports user authorization and authentication. The result of the work will serve all FIT CTU employees for monitoring the work done during individual semesters and towards potential career growth.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Marek Suchánek

Department of Software Engineering

Aim of this bachelor thesis is to design and implement mobile application on Android platform, which would track user's running activity. User would be able to save his running records and compare himself with other users by his point score. The functional and non-functional requirements and comparison with similar application is the topic of analysis chapter. Next section is devoted to application design. There is a summary of suitable technologies, application architecture, database model and user interface design. The implementation of prototype of the application and its testing is described in the implementation and the test part of the thesis. In the end the work results are evaluated and possible improvements are proposed.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Miroslav Balík, Ph.D.

Department of Software Engineering

The objective of this thesis is to analyze commonly used elements, concepts and methods which motivate players to play games and to make use of them to create a prototype of web application which simplifies educational process by representing it in an entertaining way. Created application allows user to design his or her own educational plan in any field of knowledge and to walk through it in the form of a role-playing game. Main contribution of the solution is its independence on the field of knowledge and its usage of all important game elements, especially talent trees, within the scope of one application. Usability of the solution is showcased using real-world examples, one of which is the study programme of the Faculty of Information Technology CTU. Appendices contain additional design and implementation materials.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Ivan Halaška

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Ing. Zdeněk Troníček, Ph.D.

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

doc. Ing. Karel Richta, CSc.

Department of Software Engineering

This work has several objectives: to describe the fundamental concepts of GraphQL Federation and demonstrate them in practice, to analyze its production readiness, and to explore its potential contributions to the university. To address these objectives, the first part of the work provides the necessary theoretical background while the second part focuses on the actual implementation of a prototype in Java using Netflix DGS framework, showcasing a wide range of functionalities required for creating a project based on the GraphQL Federation concept. The results of this work indicate that while GraphQL Federation offers significant benefits, there are several aspects that should be thoroughly considered before deciding to use the GraphQL Federation technology. For many projects, it may be too complex of a task. Instead, a smart combination of GraphQL and endpoint-based technologies may also bring significant improvements while requiring less effort.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Jiří Mlejnek

Department of Software Engineering

This bachelor's theses deals with design, analysis and implementation of data set from data warehouse of CVUT to web portal EBIE. For each data set were designed convenient forms of their prezentation at reports. The reports are designed for satisfaction of user's goals which emerged from the analysis of user's needs. The reports contents of data visualization at charts forms as well as at graphs forms. Depending on data structure the propriete types of graphs reflecting data connection were used. The visualization itself were realized by using D3.js library. The results of this process are interactive graphs at SVG form. The merit of this theses is easier data presentation from warehouse of CVUT and extension of this function at EBIE web portal. The demonstration of final prototypes of test data settings and the source code are placed at the supplement of the thesis.

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

The thesis is dealing with metadata analysis in IBM DB2 database, design and implementation of the tool for its extraction. At first it is focused on describing the structure of metadata and compares it with two representatives of competitive databases. Also methods of extraction and metadata accessibility are discussed. Based on this analysis the tool prototype is designed and implemented. At last its flawless function is tested.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

Getting data flows from data is a very popular concept in the business sphere. For managers and employees of large corporations who are working with a great deal of information, it is a good idea to have a tool that visualizes the data changes and data dependencies in the technologies used. A tool of this type will allow them to better work with data and improve efficiency. The creator of such a tool is Manta project, which provides the tool Manta Flow for its customers. This tool can visualize data flows for a number of well-known technologies, but currently does not offer Pig Latin support. Pig Latin is the language used in the Apache Pig platform to create programs that analyze and process data. Therefore, the aim of this paper is to design and implement a module for analysis and acquisition of data flows from Pig Latin programs that can be integrated into Manta Flow. This module performs syntactic and semantic code analysis and generates graph of data flows from the result. The module is designed and implemented to work with the Manta system, allowing for easy integration of this module into Manta Flow. The work contains a description of Pig Latin, documentation for the design and implementation of the resulting module, as well as a description of the module testing process.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Petr Košvanec

Department of Software Engineering

The aim of this thesis is to implement a module integrated into Manta software for metadata extraction from the tool Apache Kafka. The work begins with a general analysis of Kafka and its essential elements. Then it continues with the analysis of different approaches for metadata extraction. The second half of the work is focused on the design and implementation of the functional prototype using the methods examined in the analysis. The last chapter is dedicated to testing and evaluation of the used solution.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Karel Klouda, Ph.D.

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Ing. Petr Jendele

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Ing. Ivan Halaška

Department of Software Engineering

Survey CTU is a web application with which the Czech Technical University in Prague receives feedback from students. Currently, the application lacks a tool for running administrative activities, such as updating data in the database before starting the poll and evaluating the poll after it ends. These processes are implemented by running scripts that must be manually modified for each survey run and run directly in the application database. The content of this work is the analysis and documentation of administrative processes in the CTU Survey application, the proposal of a solution for how to run administrative processes from the backend of the application, and its implementation. The output of the work is the extension of the Oracle database used by the application with executable procedures that are mediated by administrative processes. In the future, it will be possible to extend the application's administrative module with a tool from which administrative processes can be started. Another benefit of this work is the documentation of some previously undescribed schemas in the database of the CTU Survey application.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Karel Klouda, Ph.D.

Department of Software Engineering

This bachelor thesis is about information system Support for the creation of teacher's harness which is used for the rating of teacher duties at The Faculty of Information Technology of CTU in Prague. Modification of this system were made during this thesis. This thesis contains a description of present version of the system and the modifications made on the system.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Karel Klouda, Ph.D.

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Ing. Pavel Karol

Department of Software Engineering

This bachelor's thesis addresses the parallelization of Extract, Transform, Load (ETL) processes within the Data Warehouse of Czech Technical Uni- versity (DW CTU) to improve performance. The existing solution, which relies on a sequential approach, is time-consuming and limits the system's efficiency. The primary objective of this study is to propose a new paral- lelization approach and implement a proof of concept (POC) using different technology as an alternative to the current Pentaho Data Integration (PDI) tool. A thorough literature review was conducted to identify potential solu- tions, with Apache Airflow emerging as a modern and reliable option. The implementation consists of two main components: hand-coded ETL processes in Python and Apache Airflow, which orchestrates, monitors, organizes, and schedules the parallel execution of the ETL tasks. The new solution success- fully decreased the loading time by half, demonstrating its effectiveness in enhancing the DW CTU's performance. The main contribution of this thesis is the development of a more efficient parallel ETL solution, which reduces the workload on the Computing and Information Centre (VIC) servers and frees up resources for other processes.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Mgr. Monika Součková

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Ing. Petr Malimánek

Department of Software Engineering

This thesis covers the software design and realization of the Trackman service in the integration platform, Integromat. Trackman is a key component of the internal monitoring system of Integromat, and also plays a major role in the further distribution of collected data on the platform. The goal was to design the whole architecture of the service, mainly the database model and architecture of the application layer in JavaScript, as well as designing the communication between Trackman and third-party services while leveraging the existing integrations that are already offered by Integromat, and finally implementing the whole solution. The database layer is built on top of the PostgreSQL database management system and uses the Stored Procedures pattern. The application layer is then coded in JavaScript and thanks to the internal libraries of Integromat, it offers a high level of data abstraction and a wide range of possibilities for data transformation. At the time of finishing this thesis, Trackman is already running in the production environment, serving roughly half a million requests a day.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

The bachaleor thesis describes design and prototype of a tool which simplifies installation and update process of web applications. The tool is designed as a Java web application. Installations and updates are being realized on different applications at a same server. Merging of configuration files and resolving their collisions are also part of this thesis, using the Java Diff Utils library. The prototype was created in cooperation with Manta Tools Ltd. and was tested on their project Manta Flow. It is implemented in Java programing language while using standard libraries for files operations and Java Diff Utils library, which is used for merging of text files. Web user interface is designed with the help of Spring MVC, Bootstrap and FreeMarker.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

This thesis deals with analysis, design and prototype implementation of a tool that facilitates configuration of Manta Flow tool by Manta Tools s.r.o. Part of the thesis is an analysis of the current state of the configurations, which requires a more technically competent person. It explains why this condition is inadequate and suggests a solution in the form of Java web application that can be operated by a BI (Business Intelligence) analyst without significant technical knowledge. These are, therefore, dynamically generated forms based on defined rules, including validation of entered values to avoid errors on the part of the user. Based on the defined requirements, a prototype implementation was developed in the Java programming language, using Spring MVC and FreeMarker frameworks. There are also scripts written in JavaScript used on the frontend. Rules defining specific forms are written in JSON format and saved in files.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

doc. Ing. Jan Pour, CSc.

Department of Software Engineering

The goal of this work (bachelor thesis) is an analysis of user requirements for querying on relationships between the objects of the information base MBI (Management of Business Informatics), the design of a new query language above these objects and the design of the implementation. Based on the analysis, which is primarily focused on the needs for querying by users and the current status of MBI, the new data storage scheme is defined. Then above this scheme the query language is designed, outgoing also from the aforementioned analysis. The resultant language is compared with another domain-specific query langure afterwards. The feasibility of solution is demonstrated by the proof-of-concept form. The work also briefly discusses about the MBI, the graph database Neo4j and the bachelor thesis of Bc. Vojtěch Stránský, which the work further develops. The outcome is written analysis, the comprehensive description of the new data storage scheme and the design of the query language solution together with the implementation design. The alternative option for data mining from MBI objects should be provided for the users.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Tomáš Kalvoda, Ph.D.

Department of Software Engineering

Research of Apakrychle is a very complex scientific activity, with information sharing among researchers being an integral part of it. There are many ways to share information nowadays, but so far no social network has focused on this topic. Here comes the social network APAnet. APAnet will provide an easy way to share and view information, images, and suspicious locations of Apakrychle occurrence, speeding up the spread of knowledge about them. This will help attract both professional and amateur audiences to the topic of Apakrychle and its research.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Ing. Petr Košvanec

Department of Software Engineering

The work focuses on the implementation of a prototype scanner for the Manta tool. The prototype specializes in the analysis of database transformations performed by the Fivetran tool, in order to visualize them. The scanner achieves this by analyzing the metadata which loads into an internal data model. It then processes the data model and uses it to build a graph describing the data transformations. The Manta tool uses this graph for their visualization. The work also includes an analysis of the Fivetran and Looker tools describing all the transformations they perform with the data.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

In order to perform static analysis of an SQL script we need to have the information about database objects, which this script works with. The objects and the information they can be described by may vary depending on the database. The aim of this thesis is to explore the environment of Netezza database and collect knowledge about objects that can be found inside it, their descriptive data and ways to extract that data. The resultant theoretical material was tested on a practical example of designing and implementing a Netezza-specific extractor module for Manta Flow. Manta Flow tool is used to statically analyze SQL code and visualize the structure of a database. Our application contributes to bringing the support of Netezza databases into it. The result of the practical part of this thesis is a fully-functional extractor. Although it does not analyze SQL code by itself, it provides required data for future processing by other modules. The theoretical part can be useful for understanding data structures in Netezza.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Ivan Halaška

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Ing. Ivan Halaška

Department of Software Engineering

This thesis deals with the redesign of the filling module of the CTU Survey, which is used to collect feedback from students at the university. Because the original module contains bugs and flaws, the CTU Survey team decided to rewrite it in the new Vue.js framework. During the design and implementation, basic issues such as routing, language switching, various UX/UI designs, and redesign of the new filling module in the Vue.js framework were addressed. The result of this work is a functional and tested application that will be used in the future by students from the university. Another benefit of the work is the simplification of the work of the CTU Survey team in further development and sustainability of the system due to the complete documentation of the new module. The CTU Survey development team expects the new module to be integrated and deployed for production use by the end of 2021.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

prof. Ing. Hana Kubátová, CSc.

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Ing. Monika Borkovcová, Ph.D.

Department of Software Engineering

This thesis focuses on extending the web application AuxBox by adding additional functionalities which will introduce new use cases allowing the users to navigate and work with the application in a more interactive, social , convenient and extensive way along with a research on recommendation systems which is going to provide a road map of asserting trained data models that would be used to build the cores of a recommendation system based on the data provided by Auxbox/Spotify users

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

doc. Ing. Jan Pour, CSc.

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Ing. Jiří Kašpar

Department of Software Engineering

This bachelor thesis deals with the analysis, design and implementation of a multiplatform mobile application using Flutter SDK. The thesis conducts a competitive analysis and provides a brief description of the technologies used. Each part of the thesis provides an insight into classical software development phases — requirements analysis, design, implementation and testing. The result is a functional mobile application that is used to provide jaw harp lessons in the form of videos and accompanying texts.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

This work aims to design and implement a functional module prototype that performs syntactic and semantic analysis of tasks in IBM InfoSphere DataStage. The module provides data flow analysis and generation of the graph, which represents data flows. Design and implementation support the trouble-free connection of the module to the Manta project. The work contains an in-depth analysis of the IBM InfoSphere DataStage tool, design documentation, implemented the module prototype and tests, which ensures module functionality.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Josef Gattermayer, Ph.D.

Department of Software Engineering

Bachelor thesis is devoted to the principles of blockchain technology. The thesis analyzes the mechanisms of functioning of the blockchain, analyzes the security and privacy protection of users, and assesses the possibility of using the blockchain technology by private companies, financial and public institutions. Part of the thesis is also an analysis of existing solutions and an analysis of requirements, on the basis of which a prototype of a bank system was developed using the blockchain to provide a bank loan.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Pavel Karol

Department of Software Engineering

This bachelor thesis deals with the parallelization of ETL processes of the CTU Data Warehouse. the aim is to analyze the capabilities of the currently used Pentaho Data Integration tool from the point of view of meeting the requirements and, if necessary, to extend the tool's resources by means of a custom application. the requirements are defined together with a parallel bachelor thesis that explores the solution using other tools. In the practical part, based on the analysis, appropriate functionalities of the current tool for data parallelization and also log management are used. For the implementation of task parallelization and other requirements, a Java application is developed using the Kettle Java API. the application stores the components required to load the data warehouse in the form of a directed acyclic graph, thus guaranteeing the correct order of execution of ETL processes. To store the necessary dependencies and component information or to manage metadata about ETL loads, database tables are used. An API interface is provided to interact with the application. In the conclusion of the thesis, the contribution of the implemented solution is evaluated in terms of its future use for the management of ETL processes of the CTU Data Warehouse.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Bc. Ivan Ryant

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

This thesis describes the process of designing overall ICT support for the Tichý svět organization. The process includes requirements gathering and specification, evaluation of the current system, design of a new system and testing and documentation of the final design. The result of this thesis is a design of a new system, presented as a clickable prototype and documented by OntoUML conceptual model.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Karel Quast

Department of Computer Systems

This bachelor thesis deals with the design and implementation of a graph database testing environment. Based on the analysis, the environment is realized by a set of scripts written in Python scripting language. The result of the practical part makes it easy to configure and run individual experiments over graph databases. The environment performs the monitoring of the executed experiments and allows the graphical display of the measured values. The main benefit of this work is to provide a testing environment and automated comparison of different graph databases.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Lukáš Bařinka

Department of Software Engineering

CTU Survey version 3 is currently missing a tool for straightforward administration of individual faculty surveys, which should be distinct, because each faculty requires a specific type of student feedback. That makes implementing individual survey changes difficult, time consuming and error prone, increasing risk of whole system failure. That is the reason why this bachelor's thesis pursues analysis of current user interfaces of the CTU Survey version 3 system and follows up with a design and an implementation of a new user interface of a new module designated to offer a user friendly administration of the CTU Survey system. The interface is then tested and deployed to production environment. Current interface solutions are analyzed primarily in terms of application design, code readability and sustainability and chosen softwares and libraries. The product is functional, tested and deployed solution of user interface which avoids mistakes of previous authors and therefore is easily sustainable and opens new options for next development. In conjunction with parallel bachelor's thesis of Duc Thang Nguyen aimed at server-side part of the application, provides a complete subsystem which is ready to simplify survey preparations for the following CTU Survey run.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Jiří Chludil

Department of Software Engineering

This bachelor thesis deals with the development of complete ordering software, that presents any sortiment in 3D view using the technology DirectX 11. The work examines presentation and application layer, describes application architecture as well as supporting software for developing purposes. Moreover, the thesis describes putting theory of Software engineering into practice including all risks and other alternatives.

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

This thesis describes the process of development of cross-platform mobile application, from the specification of requirements, through prototyping and testing of user interface, to the selection of the most suitable implementation environment and the implementation itself. The result of the thesis is a functional mobile application, providing help with the study of czech sign language.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Monika Borkovcová, Ph.D.

Department of Software Engineering

The goal of this thesis is to provide a web application for a small organization where they have to manage student accounts as per their requirements. Each student has a unique RFID card and through the application, they can mark their attendance and deposit/withdraw the organization’s virtual currency. To motivate the students, an incentive is added for each student’s attendance. This incentive adds an adjustable amount of the virtual currency to the stu- dent’s account. The more regular the attendance, the higher the incentive becomes. The virtual currency can be used when registering for events, buy- ing lunch or purchasing items from the organization’s store. The application has a dashboard for admins to able to manage students in the system. The application is written in Python using the Django web framework and is de- ployed to Google Cloud Platform using DevOps principles.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Petr Košvanec

Department of Software Engineering

This work aims to design and implement a prototype of a functional module that performs analysis of data flows in the cloud tool Matillion ETL. The input for the analysis is the metadata describing the tool elements. Based on the analysis, the implemented prototype generates a graph that visualizes data flows. The design and implementation ensure a seamless connection of the prototype to the data lineage platform called Manta. The first part of the work represents a general analysis of Matillion ETL, its key elements, ways to export metadata, as well as the analysis of its format and structure. The work then continues with the design and implementation parts of the functional module prototype and ends with the evaluation and testing of its correct functionality. Examples of the resulting data flow graphs generated by the prototype can be found in the appendix.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Mgr. Vladislav Severa, Ph.D.

Department of Software Engineering

This bachelor thesis deals with the creation of conceptual and logical (relational and graph) data models in the domain of recommendation systems for education. Furthermore, it deals with the creation and application of procedures for the management and administration of this data. The thesis uses the OntoUML notation to create and maintain the domain and the Neo4j graph database together with the MySQL relational database for data storage. The work's original proposal is design of the transformation process of OntoUML schema into the Neo4j graph database.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Marek Hakala

Department of Software Engineering

This thesis is about integration of new portal EBIE with identity provider and ticket system. For user sign-in is used authentication server Zuul. Integration with ticket system is one by JIRA REST API. The result of this thesis is demo application showing proposed solution.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Ivan Halaška

Department of Software Engineering

The bachelor thesis deals with analysis, design and implementation of an application for a small business running a pawn shop. The finished application that is deployed in the business itself supports pawn shop managers to manage maintained contracts and customers, calculate price of an item based on internet survey and analyse various different data about contracts or customers.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

doc. Ing. Robert Pergl, Ph.D.

Department of Software Engineering

This bachelor thesis focuses on application Anketa ČVUT, analysis of it's current state and possible optimalization. This application is used for gathering feedback from students on all faculties of Czech Technical University in Prague. This thesis contains models of key processes of feedback gathering on Faculty of Information Technology in their current state, forming documentation of the system. Thesis also contains research on application users (students, teachers and faculty management). Based on current state models and this research, weak spots of processes are identified and steps for optimalization are suggested. Result of this thesis is a set of process models in uniform modelling notation BPMN, which is intuitive and easy to understand. These models serve for documentation purposes and also suggest future improvements and extensions of the application.

Ing. Michal Valenta, Ph.D.

Ing. Petra Pavlíčková, Ph.D.

Department of Software Engineering

The goal of this work is to analyze the existing methods for navigation in the MBI database (Management of Business Informatics), devise and design a new, intuitive way of navigation and verify the design on a prototype application. Based on the analysis of the current state of MBI and the existing methods of navigation a new graphical query language for navigation in MBI is designed. The language is then compared with one of the previous methods of navigation from the work of Ondřej Batík, and a possible implementation of the language is devised. Finally, a prototype application of the language is designed and implemented in the framework Angular with visualization libraries D3.js and popoto.js and a data storage in the Neo4j database. This prototype demonstrates the fundamentals of the new query language. The result of this work is the analysis and design of a graphical query language along with a concept for possible full-fledged implementation and a prototype which demonstrates the fundamentals of using the new language. Users are thus offered an alternative method to gain information from the MBI database in an interactive way without complex user interfaces.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Marek Suchánek, Ph.D. et Ph.D.

Department of Software Engineering

The master's thesis deals with the transformation of ontological conceptual models into graph databases and with the implementation of related integrity constraints. At first, the thesis analyzes the suitability of several different graph database systems and justifies the choice of the Neo4j graph database as the most suitable one for the given purpose. Next, it introduces a comprehensive procedure for the transformation of OntoUML diagrams into a list of specific integrity constraints and describes the precise implementation of these integrity constraints in the Neo4j. The mentioned procedure is subsequently used for the instantiation of an example OntoUML model. Instantiated model is also tested in order to verify the correctness of the transformation procedure. Finally, the thesis discusses the achieved results and addresses possible future work. As a result, this thesis shows that it is possible to instantiate a valid OntoUML model in a graph database, yet it is not possible to use the same principles of instantiation for all types of graph databases.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Petr Jendele

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Ing. Pavel Loupal, Ph.D.

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Ing. Ivan Halaška

Department of Software Engineering

This master thesis deals with analysis, design and implementation of information system for small czech company engaged in production of luxury watches. Implemented information system is deployed in the company enviroment. The main functions of the system are production management, customer order management and supervising of tasks and activities related to the orders. Information system is implemented as responsive web application which is functional on desktop and mobile devices.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Pavel Loupal, Ph.D.

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Ing. Ivan Halaška

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Ing. Magda Friedjungová

Department of Software Engineering

This master thesis is dealing with analysis of data flows in data warehouse of ČVUT and with the design of suitable documentation, using portal EBIE (Extended Business Intelligence Encyclopedia). For the proposed areas of documentation are implemented a tested supporting generators, written in Ruby, which generate new content and update existing ones.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

Although products of graph databases intended for distributed environments already exist, the data are usually distributed randomly on particular physical hosts without any subsequent load examination and possible data reorganization. This thesis analyses the current practices of data storage in distributed graph databases. According to this analysis, it designs and implements a new module of the general graph computing framework TinkerPop for logging the traffic generated with user queries. A separate implementation for storage of such logged data in the JanusGraph database is provided. It also executes a redistribution algorithm proposing a more efficient distribution of data. An existing Pregel-compliant algorithm of Vaquero et al. with substantial enhancements is applied. Results with 70-80% improvement of communication among physical hosts of the cluster are obtained, which is comparable to another well-known method Ja-be-Ja with much higher computational demands. On the other hand, the method in this thesis imposes a necessary slight imbalance of the cluster nodes. Finally, this thesis introduces suggestions for future extensions and enhancements.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

doc. Ing. Robert Pergl, Ph.D.

Department of Software Engineering

The thesis deals with the compilation of a complex plan containing a deployment plan for the pilot portal EBIE (Extended Business Intelligence Encyclopedia) and an integration plan, which consists of the outputs of works defined in the assignment. This plan is subsequently realized by the author of the work in the role of project manager. The second and the main task, which is being solved in this thesis, is analyzing and modeling processes for the maintenance, fulfillment and dissemination of EBIE content. The DEMO methodology is used for process modeling, and for some processes also the BPMN notation. The basic principles of these modeling techniques are presented in the thesis. The thesis, among the other things, briefly discusses data purity, data warehouse and EBIE. The outcome of the thesis is comprehensive deployment and integration plan, its evaluation and, above all, analyzed and modeled processes. At the end of the thesis itself, a simulation of the content publishing process on the EBIE portal is performed. The outcoming processes should find appropriate use.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Radek Holý, Ph.D.

Department of Software Engineering

This thesis is about access control for REST API providing data from data warehouse. New role design and its use for access control is discussed. The result of this thesis is fully working authorization layer for existing aplication.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Marek Suchánek, Ph.D. et Ph.D.

Department of Software Engineering

This thesis deals with a complete re-design of the current information system for evaluation of pedagogical performance, Úvazkostroj version 3.2, which is originally written in PHP. The shortcomings and errors of the current system are evaluated in this thesis. Subsequently, the thesis deals with the classical software development cycle (analysis, design, implementation, testing) for the implementation of the new version of the system, which will come under the administration of the Faculty ICT at the beginning of 2023. The newly developed system version 4.0 will be divided into frontend and backend parts, which will provide a REST API for possible integration with other systems within the faculty network. These components will be rewritten into the newer technologies Koa.js and Next.js to meet the needs of future ICT administration.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Pavel Loupal, Ph.D.

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

Goal of the project is to create a platform for automatic testing of network configuration. Platfrom will use virtualization computers on host machine. At the beginning, I will deal with the platform from a conceptual point of view. Further explore the possibilities of PC virtualization and software networking. The third chapter is devoted to the implementation of the platform with the selected technologies. In the last chapter I will present a platform created from the user's point of view and create sample tests.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Mgr. Vladislav Severa, Ph.D.

Department of Software Engineering

This master's thesis deals with the analysis, design and creation of a multi-layer recommendation module for an educational portal, the main part of which is collaborative filtering. It is designed and used specifically for the needs of the portal. The module is based on the efficient use of Neo4J graph database implementation. The module also uses layers that rely on the MySQL relational database that underlies the Neo4J database.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

The purpose of this thesis is to analyze and implement incremental updates of data lineage storage in the software tool Manta Flow. The basis of this work is the study of current data lineage storage in Manta Flow, research of existing solutions of incremental updates in version control systems, research of incremental backups in databases, analysis and design of a new solution of incremental updates in Manta Flow and a subsequent prototype implementation and performance testing execution. The resulting prototype can be deployed into the existing Manta Flow product, reducing time complexity of updates in data lineage storage in orders of magnitude.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Petr Jendele

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

The work deals with optimally storing different hierarchies of data in a graph database. The work examines definition of equivalent nodes and their search.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

This thesis introduces a new method for indexing graph patterns within a graph database. The new method is analyzed, designed and implemented for Neo4j graph database engine. It enables to create, use and update indexes that are used to speed-up the process of matching graph patterns. The thesis provides a comparison between queries with and without using indexes. It also provides a comparison of the method with an alternate method that is presented in a concurrent master's thesis.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

The aim of this thesis is to analyze the way data is stored in Microsoft Excel files and to design a data model that approprietly describes the structure of the objects that can appear in Excel worksheets. Furthermore it is necessary to design and implement extension of the product Manta Flow that processes Excel files. The result of the processing is a graph, where each node represents an object of an Excel sheet and edges represent data flows of those nodes.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Jakub Moravec

Department of Applied Mathematics

This master thesis describes the problematics of the application implementation for remote metadata extraction. The application design and implementation ensure smooth integration of the application to the Manta Flow application. The results of this work are the analysis, design, and implementation of the Agent application.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Jan Scherks

Department of Software Engineering

This thesis contains roles analysis of CTU's IDM. Further, it describes design, implementation, deployment and testing of an application for roles analysis and roles check which was successfully deployed in Computing and Information Centre of CTU.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

The aim of this work is to analyze the ways of implementing temporality into the project Manta, which analyzes data flows. The object of this work is research of existing solutions of introducing time components in relational databases, design possible solutions in graph databases, evaluate effectiveness, the selection of an optimal solution for the project Manta and subsequent implementation and testing.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

This thesis in the first part analyzes indexing graph patterns in graph databases. Subsequently, the analysis, design and implementation of prototype designs of the index with chosen a graph database. At the end of the work is complete performance testing several typical patterns at the appropriate sample data.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

RNDr. Jiřina Scholtzová, Ph.D.

Department of Software Engineering

This thesis aims to showcase the possibilities of gamification of study on the Faculty of Information Technology CTU in Prague. It results in a web application prototype enabling its users to define and walk through their study plans in a gamified form using web services provided by CTU. The thesis describes usage of gamification elements in the domain of study on FIT CTU and includes available data source analysis, breakdown of legislative context necessary to deploy the application legally and usability testing. The main contribution is a detailed description of a specific solution making use of gamification with respect to the needs of FIT CTU and an example of its implementation. Resulting prototype provides suitable foundation for the follow-up works. Appendices contain additional design materials and usage examples.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

RNDr. Lukáš Hermann

Department of Software Engineering

This work aims to design and implement a functional prototype of a web application for Manta Flow software. The application will allow extending the existing data lineage with new data such as assets and flows. The application is intended to upgrade an existing solution, which consists of manually creating specific CSV files. The basis of the thesis is the collection of requirements, analysis, design, and implementation of a prototype web application. The created prototype will be included in the existing MANTA Flow software as another module in the Admin GUI application.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Karel Quast

Department of Software Engineering

This diploma thesis deals with design and prototype implementation of application layer over metadata storage. Metadata storage is implemented as graph database with very complex and vast data model. The goal of this thesis is to design application layer the way, it will hide complicated technical details from user and provides simple usage. Application layer must provide interface with atomic operations and make possible to import and export serialized graph. Mandatory feature of the solution is also domain specific language (DSL), that will provide support for implementation of complex analysis over metadata storage.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Marián Hlaváč

Department of Software Engineering

The thesis describes development of a multi-platform mobile application for sign language education and its integration with an existing e-learning system. The mobile application is based on a functional prototype created during Alžbeta Gogoláková's bachelor thesis using the Flutter framework. For integration with the web-based e-learning portal built on top of Moodle, a web service was created using the PHP framework Symfony. The web service reads data from an existing database with study materials and performs user authentication using JWT tokens. The completed mobile application communicates with the web service and is ready for production use. Automated quality control scripts using GitHub Actions have been implemented by applying the Continuous Integration approach. In addition, Continuous Delivery scripts were implemented to build the iOS and Android app and automatically deliver it to the Google Play and AppStore. To simplify and speed up the distribution of test versions of the app, the ability to run and deploy it to a web environment was established. The thesis provides useful know-how regarding the automation of repetitive tasks during mobile application development.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Marek Suchánek, Ph.D. et Ph.D.

Department of Software Engineering

This master's thesis deals with designing and implementing an information system described in the existing bachelor's thesis in microservices architecture. The goal is to rewrite the original architecture, automatically test and ensure containerization. Based on the analysis of the area of microservices, suitable variants of the architecture were chosen and adapted. Due to the scope of the work, some functionality was partially transferred to future development. In conclusion, the new solution is compared with the previous, and the result is evaluated.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Ivan Halaška

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Ing. Marek Suchánek, Ph.D. et Ph.D.

Department of Software Engineering

In this thesis, we will evaluate relational and graph databases for use in metadata storage and data lineage visualisation. We will process the data lineage for use in various scenarios and enhance it for efficient use in visualisation. We will devise a process to visualise various kinds of data lineage into static objects, as well as in a dynamic environment, where the user can go through the lineage on-demand in a realtime.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

This master thesis describes problematics of execution a lot of long-running processes. It describes the possibilities of orchestrating such processes in the context of MANTA, and part of the work is also devoted to planning processes using parallel running capabilities. Last but not least, it details the possibility of logging and monitoring the Workflow and Scenario progress.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Zdeněk Troníček, Ph.D.

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Ing. Ivan Halaška

Department of Software Engineering

This diploma thesis describes the development of a new application Anketa ČVUT. Requirements from the thesis of my colleague Knap are analyzed and possible designs are listed and compared. Author describes available client-server technologies and development tools. Selected technologies and tools were used for the implementation. The client part uses React and the server uses Java with Spring Boot framework. Agile development was applied. The test results from individual iterations were used for the next version. The implementation was tested by selected end users. Source code can be found in the attachment.

Thesis on DSpace

Ing. Jaroslav Šmolík

Ing. Jaroslav Kuchař, Ph.D.

Department of Software Engineering

This masters thesis is focused on developing an application that enables management of meme templates and creating memes from them. It evaluates some existing meme generators and describes their functionality. The final application is built into a docker image and deployed to production. The application was tested using end-to-end tests and in usability testing.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Tomáš Vondra, Ph.D.

Department of Software Engineering

Big data processing has been in high demand in recent years despite its many challenges. Data in different volumes and formats needs to be collected, stored and processed. To address the nature of big data, data systems must be designed in a reliable, scalable and maintainable manner. Over the last few years, the requirements have become even more demanding, as the data needs to be processed not only on a large scale, but also in real time. This thesis proposes a system design focused on high availability, low latency and horizontal scalability. It is inspired by well-established Lambda architecture but also reflects certain technological trends, such as public cloud computing and container technology. This thesis also describes the implementation of a cloud-based system prototype that was created as part of the project and discusses its results

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Ivan Halaška

Department of Software Engineering

The diploma thesis is focused on the creation of a backend of a web application for the Institute of Czech Literature. This application allows for an easy way to browse and manage digitized collections of poems. First of all, an analysis of requirements is performed and described. This analysis is mainly based on the existing solution, which does not allow easy management and coordination of data. In the next chapter, an analysis of the actual works is performed and a common model of digitized collections is created. Based on the analysis of requirements and data analysis, a design and implementation of a database is realized, as well as the REST API, which is used by the frontend of the application, which then works with the data. MongoDB system, which falls into the NoSQL category of databases, was used for the implementation of the data layer. Application server was implemented using Node.js and Express.js technologies and is ready for future extensions. The last part of thesis is focused on testing of the functionality and performance of the implemented solution.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Tomáš Chvosta

Department of Software Engineering

The Czech Technical University uses the Anket digital solution to survey student's satisfaction factor with taught subjects. However, last modification of the application core was implemented several years ago, and is therefore outdated compared to rapid technological progress. At the same time, it contains some security risks. This work is dedicated to the innovative solution design and refactoring of the backend component for filling surveys. This should eliminate potential security risks and improve software scalability.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

doc. Ing. Jan Pour, CSc.

Department of Software Engineering

The aim of this Master's thesis is to design and implement a software that enables interactive browsing and querying of MBI (Management of Business Informatics) objects. Based on an analysis and a design, a web application is created using the AngularJS javascript framework, the D3.js library and the Neo4j graph database which is used as the data storage. Using these technologies the MBIQL graph query language, which is translated into the Neo4j database language, is implemented into the application. The query results are displayed by the D3 library in the form of a graph. The result of this thesis is a software system that uses the MBIQL language and allows the user not only to query and browse MBI objects but also to store and sort the generated queries. The user is offered an alternative option to retrieve information from MBI, which is an interactive method that uses the new query language and the Neo4j database.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Jiří Daněček

Department of Software Engineering

The goal of this diploma thesis is to re-write the backend of a faculty system called Akrmat with the use of more modern and up-to-date technologies. Requirements are gathered and previous version is analyzed including the identification of its flaws. New system is designed and implemented based on this information. The result is a new functional backend of Akrmat, which is ready to be connected to the new frontend of this system, which is planned to be developed.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Adam Šenk

Department of Software Engineering

This thesis introduces all possible types of integrity constraints which can be implemented into Neo4j graph database. This work is divided into two parts, a theoretical and a practical. The aim of the theoretical part is to draw various restrictions relating to the integrity constraints and substantive reasons by the usability itself, inter alia, form of time complexity. Theoretical part also discusses and proposes a new syntax of Cypher Query Language for defining new integrity constraints. A prototype interface implementation is designed in the practical part with ability to start a validation process on the bases of defined integrity constraints on data in Neo4j graph database.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Ivan Halaška

Department of Software Engineering

This diploma thesis deals with the problem of insufficient support in deploying Oracle APEX applications among different environments and versioning of applications. It also describes the APEX environment, its difference between versions 4.2 and 5.1 and method of rapid development of applications by using this environment.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Monika Borkovcová, Ph.D.

Department of Software Engineering

The goal of this diploma thesis is the analysis, design, and proof-of-concept of a crowd-sourcing system that allows people interested in genealogy to transcript registry books. The next goal is to review existing alternatives. The main result of this thesis is the analysis of the domain and the basis for implementation. Furthermore, a proof-of-concept solution, which shows that the system design is valid, is created.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

The essence of this thesis is to understand data structures in reporting tools, which are a critical part of any major firm's strategic decision-making. Knowledge of data flows helps maintain the quality of corporate data, reduce the impact of infrastructure changes, or comply with legislation, for example. Based on the analysis of several large players in the field of reporting software, a model representing data flow objects is created within the work. The main goal of implementation was to create a prototype module based on the model for Manta Flow software, which deals with visualization of data flows in a wide range of technologies. This module, also referred to as a connector, was successfully created for the IBM Cognos tool, and in addition to the fact that the product is about to be deployed and really used, this work may also serve as inspiration for other similar modules for reporting tools.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Tomáš Chvosta

Department of Software Engineering

This thesis is about a rework of the current website solution representing the Czech electronic library for the Institute for Czech Literature of Academy of Sciences of the Czech Republic. At first a large scaled analysis of the requirements has been made, after that models representing design of the website have been created. These models have been tested, approved and used during the implementation process. The brand new User Interface of the new frontend web solution has been tested, deployed and documented.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Department of Software Engineering

Main focus of this thesis is an analysis of the current state of graph database environemnt and potential suitability of individual solutions for data lineage tool of project Manta.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Lucie Svitáková

Department of Applied Mathematics

This work focuses on the migration of the graph algorithms from the Titan graph database's imperative approach into the Neo4j graph database's procedural approach using the Cypher query language. The goal is also to optimize these algorithms and introduce parallelism, which can be a quite challenging task due to database locking, as well as the other constraints originating from the parallelized algorithms.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Ivan Halaška

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Ing. Kristián Vadkerti

Department of Software Engineering

The subject of this diploma thesis is to carry out a case study of the use of NoSQL databases as a part of a data warehouse at VZP. That includes a research of NoSQL databases, an analysis of the current solution and an analysis of queries that are commonly issued to the data warehouse. Another partial goal is to select two of the NoSQL databases and compare them to the current solution which is an Oracle Database. The results of this comparison will be utilized when deciding whether the selected technologies are suitable replacements for a part of the data warehouse. I identified some requirements for a potential solution based on the analysis of the current solution and sample queries. Based on these requirements and the research of NoSQL databases, I chose Apache Impala and Apache Impala connected to Apache HBase. I installed these two technologies and compared them to the original solution in Oracle Database using sample data. The comparison was based on measuring response times for the sample queries. The results from the experiments suggest that with increasing volume of data, the selected NoSQL solutions provide better response times for the sample queries.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

doc. Ing. Robert Pergl, Ph.D.

Department of Software Engineering

This master thesis focuses on improving data quality in data warehouse of an organization, performed using process analysis and data analysis. The work describes the problem of the data quality and fundamentals of DEMO and OntoUML methodologies. The conceptual as well as the process analysis of an organization is performed, which is a source of conceptual and process recommendations, which will result in a better quality of data.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Josef Gattermayer, Ph.D.

Department of Software Engineering

Ing. Michal Valenta, Ph.D.

Ing. Ivan Halaška

Department of Software Engineering

The main goal of this master's thesis is extending the functionality of an information system called AKRMAT, which is used for creating and managing accreditation documents at Faculty of Information Technology CTU in Prague. This thesis focuses on conducting an analysis of the current implementation of the system and on discovering its issues. Based on the gathered information new system upgrades have been designed and implemented. One of those upgrades is a brand new user interface. The output of this thesis is a new, fully functional version of the information system AKRMAT, which is a more powerful tool for managing accreditation documents than its previous version.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

doc. Ing. Robert Pergl, Ph.D.

Department of Software Engineering

There are described NoSQL databases at the beginning of the master thesis and their properties connected with CAP. In the next chapter there is a description of normalized systems based on the book Normalized Systems [15] and its informal understanding. The main part is description of usage NoSQL databases in NS theory and existing implementation based on EJB technology.

Thesis on DSpace

Ing. Michal Valenta, Ph.D.

Ing. Ivan Halaška

Department of Software Engineering

This master thesis fully focuses on complete refactoring of the databaze layer in the application Inquiry System on CTU and also on the definition of systematic maintenance of its source code. It also solves problem of additional requirements and other modules dependent on the databaze layer.

Thesis on DSpace