|
|
Analysis of the Current Database and its Proposal for Improvement for a Small Company
Badura, Sebastián ; Klusák, Aleš (referee) ; Kříž, Jiří (advisor)
This thesis deals with the analysis of the company's database system and the subsequent database design based on the analysis. The company whose database is being designed is engaged in the installation and servicing of garage doors and operators. The first part of the thesis deals with the theoretical background and introduces the issues of the database. The following chapter analyses the current status of the database in the selected company. The third part builds on the second and contains the actual database design for this company.
|
|
|
SQL Database Optimization in a Manufacturing Company
Hrušovský, Adam ; Klusák, Aleš (referee) ; Kříž, Jiří (advisor)
Bachelor's thesis deals with the optimization of an existing SQL database in a manufacturing company. The thesis is divided into three main chapters. The first chapter deals with the theoretical background, which serves as a basis for the following parts. The second chapter deals with the analysis of the current state in the company. Subsequently, the third chapter proposes its own solutions to the problems.
|
|
| |
|
|
Proposal of Database for Pivní burza pub
Heneš, Radek ; Hrušková, Lenka (referee) ; Kříž, Jiří (advisor)
Restaurant and pub Pivní burza is first of its kind on Czech market. The Pub operates on the principle of exchange (organized market), where the price of beer is floating and with increasing demand for one product, price of the other products is changing in real time. Customer can monitor the price developments and realize an order on the touch panel, which is located on the restaurant tables. Thesis is focused on the analysis of the current status of the restaurant, own solution design and suggestions for future improvements.
|
|
|
Business Intelligence as Data Analysis Tool for Controlling the Company
Novák, Ondřej ; Hajn, Pavel (referee) ; Kříž, Jiří (advisor)
Designing and creating the finished OLAP solutions within Business Intelligence for an undertaking by the customer's requirements using standard technologies and practices that are designed for this purpose. This work describes the work of the design, creation and deployment of the finished project Business Intelligence solution that allows the customer to perform more accurate analysis of their own data in the context of controlling.
|
|
| |
|
| |
|
|
Association Rules Mining over Data Warehouses
Hlavička, Ladislav ; Chmelař, Petr (referee) ; Stryka, Lukáš (advisor)
This thesis deals with association rules mining over data warehouses. In the first part the reader will be familiarized with terms like knowledge discovery in databases and data mining. The following part of the work deals with data warehouses. Further the association analysis, the association rules, their types and mining possibilities are described. The architecture of Microsoft SQL Server and its tools for working with data warehouses are presented. The rest of the thesis includes description and analysis of the Star-miner algorithm, design, implementation and testing of the application.
|
|
|
Sequential Pattern Mining
Tisoň, Zdeněk ; Zendulka, Jaroslav (referee) ; Hlosta, Martin (advisor)
This master's thesis is focused on knowledge discovery from databases, especially on methods of mining sequential patterns. Individual methods of mining sequential patterns are described in detail. Further, this work deals with extending the platform Microsoft SQL Server Analysis Services of new mining algorithms. In the practical part of this thesis, plugins for mining sequential patterns are implemented into MS SQL Server. In the last part, these algorithms are compared on different data sets.
|
|
| |
guest ::
