This work provides a survey of creation of the Business Intelligence by using QI information system data. The work concisely describes Business intelligence functions and its user's environment. QI system and the way of data storage are also defined in this dissertation. The following chapters describe the design and implementation of Business Intelligence itself over the actions made by registered employees. The proposal describes the design of a data storage system, a method of obtaining the necessary data from the QI information system, ETL process design, OLAP cubes design, and how to interpret the information in the form of reports. The last chapter then describes the realisation of all the proposed districts in MS SQL Server.

Implementation of web application for sport club with the support of CASE tool WebRatio and IFML notation. Diploma thesis. Brno: Mendel University in Brno, 2015. This diploma thesis deals with implementation of web application for sport club with the support of CASE tool WebRatio and IFML notation. The thesis describes software development method-ologies with a main focus on web applications and IFML notation. The practical part of this thesis deals with the implementation of a web application based on analysis of the current state of the problem domain and defined business requirements. Development process of entire application was conducted in accordance with the IFML notation. For the analysis and system modelling were used diagrams and models of UML2 and IFML languages. Models and diagrams were made by CASE tool WebRatio and Enterprise Architect. The application was implemented using ASP.NET MVC technology, Mi-crosoft SQL Server database tool and C# language.

SQL Injections are still a prominent threat on the web. Using a custom built tool, BlindCanSeeQL (BCSQL), we will explore how to automate Blind SQL attacks to discover database schema using fewer requests than the standard methods, thus helping avoid detection from overloading a server with hits. This tool uses a web crawler to discover keywords that assist with autocompleting schema object names, along with improvements in ASCII bisection to lower the number of requests sent to the server. Along with this tool, we will discuss ways to prevent and protect against such attacks.

This thesis work is a comparative study of technical features between three distinctivemethods for database access. A web store which offers software components to download,for registered users has been built with three different database access methods to drawcomparisons. 1. SQL Server 2005 with stored procedures 2. LINQ to SQL 3. Db4o Working in Visual Studio with three different methods for database access was not difficult.SQL Server with Stored procedures is efficient in performance and offers maintainability ofthe database access logic. LINQ to SQL makes queries to database as first-class languageconstruct providing type-safety and Intellisense. LINQ to SQL has relatively lowperformance compared to Stored procedures because of the translation of LINQ queries toSQL Queries to communicate with the database. Db4o solves the problem of impedancemismatch and making the development of Database model much simpler and similar to theapplication domain model. Although Db4o has its own drawbacks with database size andconcurrency. Db4o can be considered as an alternative to Relational Database ManagementSystems. Db4o works particularly well with applications which have a small data footprint.

This diploma thesis deals with building of large Data Warehouses on Microsoft SQL Server 2008 platform. First part of the thesis discuss about news in MS SQL Server 2008, which I have considered as being important for Business Intelligence area. Following chapters are focused on approach to implementation of real Data Warehouse for Customs Administration of Czech Republic on MS SQL Server 2008 basis. These parts of the thesis cover specifics of the Customs Administration of Czech Republic, current state of Data Warehouse and reasons for migrating to MS SQL Server 2008. Further the thesis describes both logical and physical architecture of proposed solution and a way of implementation Data Warehouse on MS SQL Server 2008. The main aim of the thesis is to create a list of critical success factors (CSF) of building large Data Warehouses on MS SQL Server 2008 platform. It's not only plain list CSF, but rather the best practices for MS SQL Server Data Warehouses implementation. The most significant contribution of this thesis is that it offers instruction manual for designing and implementing large Data Warehouse on MS SQL Server basis. Background for the creation of summary of CSV and recommendations were vendor's publications and especially my own experience with the product. My colleagues from company Adastra gave me an advisory opinion as well.

This thesis follows up the creation of data warehouse on Microsoft SQL Server for analysis of measured railway vehicle transits, with provided weather data by Dark Sky service. Thesis represents full data warehouse design (by Kimball Group model) with ETL processes to secure data initialization and automatic updates. Thesis also shows two approaches to presentation layer on data warehouse, by Microsoft Excel (linked to multidimensional cube) and by Power BI.

This work deals with creation of database information system for employee training and bonus calculation with direct connection on existing personal systems in Honeywell production company. The project makes provision for solution on dynamic database server and maximal usage of its potentiality for application development. The system dispose of access privileges containing several user roles and role of administrator. The system concept is realized in UML modeling language. The implementation is realized on Microsoft technologies. The system is generally implmented in 3 tiers: user interface, database component, data base model. The user interface is implemented in ASP.NET 2.0 with utilization of ASP.NET AJAX 1.0 technology. The database component is implemented using object oriented language Visual .NET C# and ADO.NET classes. Data base is relized on SQL Server 2000 in Transact-SQL language. The integral part of the project is also testing on sample data and application in live business on Honeywells company intranet.

For growing organisations that have built their data flow around a monolithic database server, anever-increasing number of applications and an ever-increasing demand for data freshness willeventually push the existing system to its limits, prompting either hardware upgrades or anupdated data architecture. Switching from an approach of full extractions of data at regularintervals to an approach where only changes are extracted, resource consumption couldpotentially be decreased, while simultaneously increasing data freshness. The objective of this thesis is to provide insights into how implementing an event streamingsetup with Apache Kafka connected to SQL Server through the Debezium source connectoraffects resource consumption on the database server. Other studies in related work have oftenbeen focused on steps further downstream in the data pipeline. This thesis can thereforecontribute to an area where more knowledge is needed. Through an empirical study done using two different setups in the same system, traditional dataextraction in batches and extraction through event streaming is measured and compared. The point of measurement is the SQL Server database from which data is extracted. Both memoryutilisation and CPU utilisation is measured, using SQL Server Profiler. Different parameters fortable sizes, volumes of data and intervals between changes are used to simulate differentscenarios. One of the takeaways of the results is that, at the same number of total changes, the size of theindividual transactions has a large impact on the resource consumption caused by eventstreaming. The study shows that an overhead cost is involved with each transaction, and also thatthe regular polling that the source connector performs causes resource consumption even inidleness. The thesis concludes that event streaming can offer reduced resource consumption on thedatabase server. However, when the source table size is small, and the number of changes large,extraction in batches is less resource-intensive.

Detta projekts huvudsakliga syfte är att skapa ett frågespel där användare samtidigt kan spela mot andra genom att använda en mobil applikation. Den som startar en spelomgång får välja vilken kategori av frågor som ska ställas och ger därefter ut erhållen kod till vänner som i sin tur kan ansluta till spelet. Därefter exekveras spelomgång varpå resultat erhålls och vinnare utses. Teknisk lösning för detta projekt använder Unity3D för presentation av spelet på de mobila enheterna vilka sedan kommunicerar med en server som exekverar på plattform utvecklad med Microsoft .NET Core och SQL Server. För att administrera de kategorier och frågor som spelarna ställs inför används ASP.NET MVC på samma plattform. / The main purpose of this project is to create a quiz game where users are able to simultaneously play against others using a mobile application. Anyone who starts a game session can choose which category of questions to ask and then send out received code to friends who in their turn joins the game. A round is then started where players will answer questions, after which they obtain results and a winner is selected. Technical solution for this project uses Unity3D for presentation of the game on the mobile devices which then communicates with a server that executes on a platform developed with Microsoft .NET Core and SQL Server. ASP.NET MVC is used on the same platform to manage the categories and questions faced by the players.

The thesis compares the development time and performance of two types of Microsoft analytical models created in Visual Studio that are deployed on the local analytics servers and the Azure cloud server. Theoretical research will be summarizing business intelligence and data warehouses components, Microsoft tools for business intelligence realization and features using in-memory database technologies. The practical part introduces the AdventureWorks demonstration database,describes the implementation of both analytical models and compares both models with respect to the time-consuming development, performance and suitability of deployment.