|
|
Teradata Database System Optimization
Krejčík, Jan ; Chlapek, Dušan (advisor) ; Štaud, Karel (referee)
The Teradata database system is specially designed for data warehousing environment. This thesis explores the use of Teradata in this environment and describes its characteristics and potential areas for optimization. The theoretical part is tended to be a user study material and it shows the main principles Teradata system operation and describes factors significantly affecting system performance. Following sections are based on previously acquired information which is used for analysis and optimization in several areas of described environment.
|
|
|
Problems of using information sources in the academic environment
Harant, Petr ; Sklenák, Vilém (advisor) ; Šubrta, Václav (referee)
This bachelor thesis deals with problems of exploiting electronic information sources. Defines main difficulties in which can students, producers, providers (libraries) and experts or teachers run into. Thesis focuses on particular problems and suggests possible improvements. For defining problems and finding possible solutions author cooperated with specialists from information domain specialists, who made (in cooperation with author) a list of problems, which should be solved for better exploatation of information sources. Specialist also introduced some solutions which are currently in development. Thesis is divided into two parts, first is more theoretical and introduces main concepts (information, information need, information behavior and information literacy), techniques for browsing and searching through informational sources. Also multidomain database Proquest 5000 is discussed. Second part focuses on particular problems and possible solutions for searching in electronic information sources.
|
|
|
Access to databases in the PHP framework Zend and Nette
Moravec, Petr ; Pavlíček, Luboš (advisor) ; Burkoň, Lukáš (referee)
The main asset of the essay is a very detailed documentation of PHP frameworks and more detailed view on database layer. The essay pays attention to a database layer in Zend and Nette Frameworks. Both Frameworks are described separately. The essay also analyses Data Source Architectural Patterns of Martin Fowler. These patterns are explained in details and shown in practical examples in each separate Frameworks. They are mainly patterns of Table Data Gateway, Row Data Gateway , Active Record and Data Mapper. The last part of the essay is focused on an access to a Database in selected Frameworks, describes the main libraries and demostrates practical examples. Finally there are presented empirical tests which can help to analyse advantages and disadvantages of each Database layer.
|
|
|
Overview and comparison of Oracle database system administration tools
Chovítek, Jakub ; Macák, Petr (advisor) ; Buus, Martin (referee)
The aim of this work was to create an overview of applications suitable for the administration of Oracle database system and then to compare these applications. Another aim, which is directly linked to the previous, was to test these instruments in acts carried out by the database administrator. This work compares the tools from different aspects, such as graphic design, lucidity, functionality and price. Reader can make an idea of what tools can be used for administration of Oracle database system and how the different instruments work. If the reader is interested in the purchasing of such tools, this work can give him the recommendation based on the comparison.
|
|
|
Reaction to errors and alerts in ETL
Klimt, Roman ; Pour, Jan (advisor) ; Zajíc, Ján (referee)
This work deals with information systems called Business Intelligence (BI). Especially, it focuses on one part, whose task is to extract data from primary information systems. This stage is known as extract, transform, load (ETL). ETL is one of the most important stage in BI solutions because the quality of data depends on this stage. These data are used for all analyses and created reports. The goal of this work is to suggest solution for active projects, which are short of automated controlling mechanism. This mechanism should inform users of BI solutions about errors in data. If data from primary systems are in such bad state that ETL process is not able to match primary keys to them, the data are stored in special tables and are not used for future analyses. This is a very serious problem because analyses and reports based on the data may be misrepresentative. This problem must be solved by repairing the data in primary information systems. The administrator of primary information system has to know about the incorrect so that the data could be repaired. Therefore, an automated e-mailing system has been designed to inform about the incorrect data.
|
|
|
Sourcing optimization in Thermo Fisher Scientific company
Spejchal, Luděk ; Toman, Prokop (advisor) ; Dudová, Lenka (referee)
The aim of this diploma thesis is a detailed view of a process and way of managing all the sourcing activities in the company Thermo Fischer Scientific. The focus (of my work) is a czech site of mentioned company situated in Mukařov, which, apart from production itself, is engaged also in sourcing for its own needs (where in most cases it has a decision power in its own hands) as well as for the whole company in the global measure (where it operates just as an intermediate searching for possible business partners, without any powers of decision). The main contribution of my work lies in the comparison of both of these variations and detailed investigation and description of all the activities that could help to optimize the global sourcing. I found out that entire optimizations are based on communication improvements among all the sourcing managers and technologists within the global corporation. On the basis of this fact I have projected models of documents the sourcing managers should work with, suppliers database and an information server. The result of my work is a process scheme which should contribute to the outsourced projects optimization.
|
|
|
Possibilities of using Caché database system
Brož, Ondřej ; Palovská, Helena (advisor) ; Vedral, Pavel (referee)
Structure of this work is divided into a few main chapters. The biggest part is focused on a creation relational and object schema of a specific example and their realization in Caché database. The next goals are theoretically describe database, object model, its characteristics as well and comparison the object principles in Caché and Oracle database. After a few words whose describe the most important facts in a history of databases the reader can learn something about the Caché database. Mainly its architecture which is the greatest advantage against the competition. Next charter quickly show how to successfully install and access the database. In charter 4 the basic database tools are mentioned such as development environment Caché Studio, command line Caché Terminal and web interface for administration called Caché System Management Portal. The fifth and sixth chapter covers the main goal of this work. In fifth chapter the object model (relational model only in part), its basic principles (defined in ODMG standards) and object characteristics are described. The sixth chapter show the creation process of the object schema "step by step" together with possible ways how to insert data and select them. Final codes for structure and data are placed at the end of work . In last chapter I am trying to compare object characteristics in Caché and Oracle database(version 10gR2). The contribution of this work is in explanation of object principles with the "step by step" processes of creating and realization object schema shown on a concrete example (the official documentation doesn't obtain them).
|
|
|
Database model design for informational, community and e-learning portal focused on driving license applicants
Demuth, Jan ; Palovská, Helena (advisor) ; Klas, Jan (referee)
This work is concerned with the process of designing and documentation of a web portal covering informational, community and e-learning application functionality focused on the field of driving schools and driving license applicants training and education. The emphasis lies on the phase of optimal database model design independent of the final technological solution of the developed application and documentation of relations and purpose of all entities in the system influenced by the process of design and further development of the physical database.
|
|
|
The design of database for the company Foram spol. s r.o.
Gottwald, Karel ; Palovská, Helena (advisor) ; Klas, Jan (referee)
The work deals with the definition of terms, mention of history and theory of design databases. The main objective was to propose a solution for the company Foram spol. s r.o. on the basis of theoretical knowledge in order to be usable in practice. The logic was to capture the reality of the best capturing given situation. It was necessary to communicate with the company and analyze their requirements. They defined the basis for drawing up a conceptual and physical model. Diagrams were created in PowerDesigner version 12.0. Finally, the functionality of the proposal was verified on the test data.
|
|
| |
guest ::
