|
| |
|
| |
|
| |
|
| |
|
|
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.
|
|
|
Community website optimization for search engine
Schneider, Martin ; Bruckner, Tomáš (advisor) ; Žamberský, Martin (referee)
The bachelor work focuses on the problem of optimizing websites for search engines, which is currently very actual problem. It provides a comprehensive look at the process that will help us to better positions in the rankings of the most commonly used search engines and also helps us determine how those most widely used search engines work. In the theoretical part we discuss the various authorized and unauthorized modifications including optimization of the site outside the source code. In the practical part is analyzed different types of Web sites which using a lots of SEO tools. This can help us to know the difference in approaches in optimalization. Concurrently this analysis provide an overview of indicators, which is good to observe and way how this values find.
|
|
| |
|
| |
|
| |
|
|
Problems of information search on the Internet
Janů, Tomáš ; Sklenák, Vilém (advisor) ; Šubrta, Václav (referee)
This thesis adverts to the inadequacies and impediments which can be met by an ordinary user of the internet when searching for information. The process of searching itself represents an interaction between the request given by a user and the result displayed by a search engine. The result might be in a form of URL address of a concrete web page, picture, product, location etc. Some of the problems, which are described in detail in the thesis, are for example relevance and freshness of the search result, separation of global and local result, spam in the results or problems connected to the searching in the online maps. There is an emphasis on the local market, respectively on the Czech user, in the thesis. Furthermore, it focuses on the freshness of all data and on a practical sample in a picture form. The important data and statistics are recorded in the well-arranged tables and graphs. Among others, many interesting information and observations can be found in the thesis. These information and observations are marked with the blue arrow (->).
|
guest ::
