|
|
Extracting Information from Database Modeling Tools
Drobný, Denis ; Parízek, Pavel (advisor) ; Kopecký, Michal (referee)
Data lineage is a way of showing how information flows through complicated software systems. If the given system is a database, tables and columns are visualized along with transformations of the stored data. However, this picture may be difficult to understand for people with weaker technical background, as database objects usually obey naming conventions and do not necessarily represent something tangible. To improve lineage comprehension, we developed a software called Metadata Extractor that on one hand brings the further description of the database objects, as well as introduces a whole new perspective on data in a system through business lineage aimed for non-technical users. The additional metadata enriching data lineage is extracted from data modeling tools, such as ER/Studio and PowerDesigner, that are widely used in the database design process. The solution extends the Manta Flow lineage tool while taking advantage of its features at the same time. 1
|
|
|
Searching public transport connections based on transport timetables and individual transport
Matěna, Jakub ; Nečaský, Martin (advisor) ; Kopecký, Michal (referee)
This thesis deals with routing over open data in Prague. Its main purpose is to create server/client based application that makes connection searches combining both public transport and individual car transport. Server provides Protocol buffers \gls{api} that can be used by anyone to create client application for any available platform. Moreover demonstrative client application for Android devices was created as part of this project. All components were tested for usability, functionality and speed. Open data from several sources were used to demonstrate that publishing data can offer new possibilities and that we can achieve complex goals by combining them. It was shown that intermodal planning in Prague is possible and can save time, money and even environment.
|
|
|
Advantages and disadvantages of object persistency usage in Java language
Pravda, Michal ; Kopecký, Michal (advisor) ; Galamboš, Leo (referee)
JDBC is an interface for standard usage of relational databases in the Java language. It demands repeated sequences of commands and doesn't provide means for comfortable work. The result is that in a nontrivial application solving of persistency related problems consumes a significant portion of the development tíme. The Hibernate library encapsulates majority of the difficulties involved. It does enable the programmer to save and load objects to/from a database transparently. It uses predefined metadata to do it. At the beginning of the thesis, there is a list of main problems of working with JDBC, which emerge in a nontrivial application. Any programmer using plain JDBC without an additional tool must solve these. A chapter consisting of examples of a JDBS usage follows. After that the thesis gives attention to the usage of the Hibernate library. In the last chapter comparative measures are discussed. Powered by TCPDF (www.tcpdf.org)
|
|
|
Advantages and disadvantages of object persistency usage in Java language
Pravda, Michal ; Kopecký, Michal (advisor) ; Galamboš, Leo (referee)
JDBC is an interface for standard usage of relational databases in the Java language. It usually forces the programmer to repeatedly write similar sequences of commands and doesn't provide means for comfortable work. The result is that solving of persistency related problems consumes a significant portion of the development time. The Hibernate library encapsulates majority of the difficulties involved. It does enable the programmer to save and load objects to/from a database transparently. To get the necessary information the library uses predefined metadata. This thesis focuses on comparison of database application development using JDBC and Hibernate from many points of view. First, there is a description of main problems of working with JDBC, emerging in nontrivial applications. Chapters, consisting of examples of a JDBC and Hibernate library usage follow. Thesis then defines viewpoints for comparison of both systems and provides the comprehensive comparison based on them. In the end there is a review of obtained results and recommendations for effective work based on them. Powered by TCPDF (www.tcpdf.org)
|
|
|
Web application for concert database management
Scholleová, Klára ; Nečaský, Martin (advisor) ; Kopecký, Michal (referee)
Title: Web application for concert database management Author: Klára Scholleová Department: Department of Software Engineering Supervisor: doc. Mgr. Martin Nečaský, Ph.D., Department of Software Enginee- ring Abstract: The aim of the thesis is to develop a web application for concert da- tabase management to be used in the Czech Chamber Philharmonic Orchestra Pardubice. The application will allow the orchestra workers to add records of concerts played (and their details), displaying the data in the database, showing the records based on filters, and data aggregation in a user friendly interface. Based on the analysis of the client's requirements, a conceptual model of the database was made. The application is implemented in a web development fra- mework Django in conjunction with other technologies (HTML, CSS, JavaScript and Vue.js library) and is prepared for further development in the future. The application was tested from aspects of both user experience and performance. Keywords: web application, concert database, Django, Vue.js 1
|
|
|
The Presentation of Transforming Attributes in SQL for Data Governance Support
Bartoš, Michal ; Janoušek, Jan (advisor) ; Kopecký, Michal (referee)
This thesis examines extraction of attributes' transformation descriptions from Oracle SQL scripts and possibilities of their presentation to users. This thesis com- pares several variants of output format. Then it describes details of construction for the chosen format and choices that led to it. One of the main decisions was the choice of input data structures: abstract syntax tree and dataflow graph. Those data structures provide initial analysis of input SQL scripts but they also strongly influence the rest of processing. Results of this thesis were verified by prototype implementation in software Manta. The prototype confirmed suitability of the chosen approach for convenient presentation to users. 1
|
|
|
Recommender systems for culture events
Vytisková, Zuzana ; Peška, Ladislav (advisor) ; Kopecký, Michal (referee)
The diploma thesis deals with the topic of recommendation in culture. In the theoretical part, it compares the recommendation of digitally available works with event recommendations, which serves as the basis for describing recommendations on the cultural portal. Further, the thesis examines the domain model as several different interconnected types of objects. Using these relations to enrich data sets allows overcoming the low data density and improving the recommendations. The paper examines two common situations of practical recommendation, general user recommendation with minimal profile and recommendation to registered users with known history. As a part of the solution, hybrid algorithms have been implemented based on the introducing content information into existing collaborative filtering methods. The results are verified in offline tests on data sets consisting of both research and real-world data. The subjective quality of the resulting recommendations was examined through a user study.
|
|
|
Graph-based molecular representation and its utilization in virtual screening
Šťastná, Aneta ; Hoksza, David (advisor) ; Kopecký, Michal (referee)
Graphs are natural way of representing molecules. However, graph representations and algorithms are not being used for finding similarity of molecules in virtual screening. In this work we test the graph-based methods in ligand-based virtual screening. The similarity of molecular graphs is determined by maximum common subgraph and graph edit distance. We use implementations fmcs from chemoinformatic library RDKit for maximum common subgraph and GraphMatchingToolkit from K.Riesen to determine graph edit distance. We have found suitable combinations of parameters for aplication in ligand-based virtual screening. The results suggest that performance of graph based methods is comparable to the state-of-the-art methods.
|
|
|
Integration of legacy databases to current information systems
Navrátil, Jan ; Kopecký, Michal (advisor) ; Helmich, Jiří (referee)
The goal of this thesis is to design and implement a framework to support Legacy system access. Legacy systems are databases that use incompatible and obsolete technologies and can not be easily abandoned. The framework allows the abstraction of application logic from database platform and will enable full or incremental migration to a new, modern platform in the future. The framework also considers the option of encapsulation of an existing legacy application into the new system as a black box. The framework is well configurable and extendable and is independent on database platform or data context. A system based on proposed framework has been succesfully deployed in a company. The system facilitated the migration of the company to a new information system with an entirely different database platform. The practice shows the viability of the framework design. Powered by TCPDF (www.tcpdf.org)
|
|
|
Algorithms for business document detection using templates
Michalko, Jakub ; Skopal, Tomáš (advisor) ; Kopecký, Michal (referee)
Thesis deals with analysis and system design for automatic document recognition. The system explores the document and converts it into text data with information about the position of the word in original document. These data will then be reviewed and some of them will be assigned their importance. The way the data will be assigned is based on rules which may vary according to user needs. According to the data, their assignment and the importance of their position, the system finds a similar document and identifies the current document. Powered by TCPDF (www.tcpdf.org)
|
guest ::
