|
|
Development and analysis of a database of reactions catalyzed by cytochrome P450 enzymes for machine learning applications
Komorníková, Natália ; Pluskal, Tomáš (advisor) ; Berka, Karel (referee)
Cytochrome P450 enzymes are hemoproteins showing extraordinary di- versity in the reactions they catalyze. We developed a database containing all the needed data to provide a comprehensive data source on reactions cat- alyzed by cytochrome P450 enzymes. This data mainly includes information about the substrates, products of characterized reactions, and the sequence of these enzymes. The database was developed by collecting data from reliable protein and reaction databases like UniProt and RHEA. The work presents an in-depth analysis of the created database of reactions catalyzed by cy- tochrome P450 enzymes. This database can be utilized for future machine learning approaches to predict the function of uncharacterized cytochrome P450s.
|
|
|
MySQL Database Synchronization
Dluhoš, Ondřej ; Rychlý, Marek (referee) ; Jaša, Petr (advisor)
This thesis deals with the MySQL database synchronization. The goal of this work was to get acquainted with database synchronization in a broader context, to choose the appropriate tools for real usage, and them to implement, evaluate and analyze these tools. From these techniques was selected MySQL replication technology that solves the synchronization task of distributed evidence database system of health implantable devices in the best way. The replication was implemented on this database system and after the testing was used in the company Timplant Ltd.
|
|
|
Data warehousing on technological platform TERADATA and Informatica in the insurance industry
Šiler, Zdeněk ; Maryška, Miloš (advisor) ; Hanušová, Jana (referee)
This thesis focuses on data warehousing on technological platform TERADATA and Informatica Power Center (further only IFPC). TERADATA provides a robust database system for storage of big volume data and query processing over such data. Product Informatica Powercenter is a tool for developing of ETL processes. Both of tools belong to mature technology for large data warehouse development which stores large volumes of data over the enterprise. The thesis analyses both tools to build data warehouse and the specifics of their use in the insurance sector. The thesis is divided into two main thematic sections - theoretical and practical part. The theoretical part describes database system TERADATA and ETL tool IFPC in details, including analysis of business intelligence architecture in the insurance segment, which often uses this platform for data warehouse development. The thesis describes the architecture of database system TERADATA and the way to data storage and query processing. Then specific features, on which is necessary to focus by TERADATA data warehouse development, are characterized. Also its advantages and disadvantages are analyzed. Database system TERADATA is faced with other competing database systems. The thesis deals with general characteristics of ETL tool IFPC -- software architecture a its components. It examines the advantages and disadvantages of IFPC compared to competitors on the market. Conclusion of the theoretical part analyzes the synergies between Teradata and IFPC. The thesis explains the real benefits of combination TERADATA and IFPC. The practical part of thesis demostrates the use of tools for data warehousing development on real project Unification of client data. This project describes the entire development process in a data warehouse from business requirements through functional and technical design to implementation of ETL mapping in Informatica Power Center. It deals with bug fixing during ETL development and testing methods. The pratical part focuses on implementation of chosen mapping in IFPC which is deployed in the insurance sector. Part of this thesis is a comparison of ETL tools IFPC with SSIS ETL tool integrated in MS SQL Server 2008 R2.
|
guest ::
