|
| |
|
|
Database Design for Transport Company
Záboj, Zdeněk ; Luhan, Jan (referee) ; Kříž, Jiří (advisor)
The aim of this thesis is to design a database for an incipient transport company, for which the solutions available on the market nowadays don´t make sense due to its size. Within this thesis I am going to concentrate on designing the structure of the database and its implementation on Microsoft SQL Server platform using Microsoft Management Studio tools.
|
|
|
Demonstration of Support for XML in Database Systems
Dvorštiak, Matej ; Fiala, Jiří (referee) ; Zendulka, Jaroslav (advisor)
This thesis is concerned with XML technologies and XML support of database systems. Especialy with Oracle database. Support is descripted in this work. Desription is aimed to an Oracle XML DB architecture, XML data type, work with XML schema, storing and quering options of XML data in Oracle database. Practical part describes aplication, demonstrates XML support for learning proposes. Theoretical and practical parts are appended with examples and pictures for better understanding of described problematic.
|
|
|
Information System for Project Administration
Sysel, Josef ; Burget, Radek (referee) ; Bartík, Vladimír (advisor)
This bachelor thesis deals with the creation of web-based information system for project management. The application should help a self-employed person or small businessman with the organization of the work, time, and coordination of people who cooperate with him. The system allows customers to create order in the form of a new project, to which then an administrator assigns a main worker who after that subsequently distributes tasks to other available workers. Also, an important part of the system is the option of online conversation between registered users, calendar with ongoing projects and tasks, statistics of work and recording of private or shared files. The Web application is implemented in the ASP.NET environment with using of Microsoft SQL Server and eXpress App Framework by DevExpress.
|
|
| |
|
|
Database System Analysis and Implementation
Třetina, Jan ; Ráb, Jaroslav (referee) ; Zendulka, Jaroslav (advisor)
With the increase of demands for the speed and availability of the information technologies, the process of optimization gains more and more importance. Concerning search engine optimization, optimization of operating systems or application optimization (source code), the goal is to gain faster, smaller and more maintainable solution. In my thesis I deal with optimization of database systems, which includes low level of database tuning - physical organization of data and indices, database management system tuning and query optimization. I focused on optimization of Microsoft SQL Servers 2005 in enterprise environment.
|
|
|
Database Design for a Selected Company
Bartoš, Jan ; Kříž, Jiří (referee) ; Luhan, Jan (advisor)
The aim of this thesis is to design a database for a selected company, which concerns the creation of production labels. Within this thesis I am going to concentrate on designing the structure of the database and its implementation. The database will be implemented on the Microsoft SQL Server platform using the tools of Microsoft Management Studio.
|
|
|
Collection of measurement and control data
Želinský, David ; Holek, Radovan (referee) ; Štohl, Radek (advisor)
This bachelor thesis introduces us to terms such as a smart building, smart electrical installation and measurement and control data collection, which relates to this topic. In the introductory part, it will be explained, what a smart building is, how the devices in said building communicate and the BACnet communication protocol used in these devices. Next it will be explained, what the measurement and control data are and what they are used for. The next part defines the term database, what it is for and all its types. SQL language, which is used in almost every database will be introduced next. After, a database model of a part of the Faculty of Electrical Engineering and Communication T12's building will be presented. A part will be about the Honeywell company's CoachAX software, which is used for measurement and control data processing. In the end a measurement and control data simulation will be created. These data will be appropriately displayed in a visualization realized in CoachAX program. At the end, a measurement and control data simulation will be created. This data will be saved into the Microsoft SQL server database and then processed by the user. This same data will then be displayed in visualization in CoachAX program.
|
|
|
Analysis of Public Data of the Czech Statistical Office
Pohl, Ondřej ; Burget, Radek (referee) ; Bartík, Vladimír (advisor)
The aim of this thesis is analysis of data of the Czech Statistical Office concerning foreign trade. At first, reader familiarize with Business Intelligence and data warehousing. Further, OLAP analysis and data mining basics are explained. In next parts the thesis deal with describing and analysis of data of foreign trade by the help of OLAP technology and data mining in MS SQL Server including selected analytical tasks implementation.
|
|
|
Using Data Mining in Various Industries
Fabian, Jaroslav ; Novotný, Jakub (referee) ; Kříž, Jiří (advisor)
This master’s thesis concerns about the use of data mining techniques in banking, insurance and shopping centres industries. The thesis theoretically describes algorithms and methodology CRISP-DM dedicated to data mining processes. With usage of theoretical knowledge and methods, the thesis suggests possible solution for various industries within business intelligence processes.
|
guest ::
