This diploma thesis deals with an analysis of SAP Business Intelligence platform (SAP NetWeaver BI 7.0) and compares its chosen tools with Microsoft SQL Server BI. The main aim of the thesis is to evaluate SAP BI system in a comprehensive way whereas extra attention is paid to certain areas, such as a data warehouse. One of the goals is the comparison of approaches and methods of the creation of the data warehouse with MS SQL Server BI solution. The thesis consists of theoretical insight into Business Intelligence, which is focused on the architecture of data warehouse, and OLAP technologies. There is an evaluation of the role of SAP in the BI market followed by the introduction of SAP NetWeaver, an application and integration platform. Included is also an analysis of the architecture of data warehouse, methods of storing data, ETL process and other chosen functions and tools (including presentation tools) in next sections. A sample application in the final part provides the reader with better understanding of different ETL approaches, which are analyzed into detail and evaluated. There is the comparison of OLAP technologies in the end and the comparison of basic reporting tools, as well.

The thesis describes implementation of Business Intelligence solution in mid-sized company which produces and sells animal nutrition products. Currently the company uses basic tools for reporting, mostly Excel application. Considering the data growth, that solution is about not to be sufficient. In the first part of the thesis, the Business Intelligence principals are introduced to the reader, so one is provided with enough knowledge to understand the issue of data processing, transforming and storing. Basics of data visualization used for decision making in the company are introduced as well. At the end of the chapter, there is a list of general rules for creating a dashboard. The secord part describes the Trouw Nutrition Biofaktory s.r.o. company, where the implementation of new Business Intelligence solution is going to take place. The reader will learn about the company size, structure and history. The last part contains a new procedure how to process data for reporting purposes. The design includes data loading to MS SQL 2012 database server and further processing for analytical purposes. In addition, OLAP cube is created as well as three monthly dashboards.

Windows Azure Platform is product of the Microsoft company aimed to host web applications. With this product, Microsoft is reacting on the new trend in IT -- cloud computing. This diploma thesis deals with all the aspects of developing and running PHP applications on Windows Azure Platform. Thesis is divided into two parts -- theoretical and practical. In the theoretical part, Windows Azure Platform is described in detail. The description consists of it's main parts, position in the world of cloud computing, price and main competitors. In the practical part, migration of school PHP application developed during 4IT445 course from LAMP platform to Windows Azure Platform is described. Except the migration itself, the benefits of new platform to application are described. In the thesis conclusion, development and running applications on both platforms is compared. The target of the thesis is to write first complete Czech text about running PHP applications on Windows Azure Platform and to help PHP developers to chose which way to go.

The thesis contains a complete theoretical overview of high availability technologies in Microsoft SQL Server. For each technology, guidance is provided for the deployment of technologies. Technologies are analyzed from a security perspective, they are determined advantages and disadvantages of using technology in practice and is determined the optimal variant of use of the technology. High availability technology are compared with each other and is given the availability of individual technologies in versions of MS SQL Server. The thesis contains three scenarios with practical examples of using technology for high availability in practice. It provides an analysis of high-availability features in Oracle and are subsequently compared high availability features in Oracle environments with high availability technology in MS SQL Server.

Syftet med detta examensarbete är att med avseende på Snow Softwares databas försöka att effektivisera samt omstrukturera de procedurer som hanterar deras regelverk. Den är ej inriktad på att utvärdera eller förändra de algoritmer som redan finns i Microsoft SQL Server. Ett flertal olika prototyper framställdes och utvärderades. Dessa var ej specifika för just denna databas och kan därför vara intressanta även i andra sammanhang. Den prototyp som visade sig vara mest effektiv implementerades så att den enkelt skulle kunna tas i bruk i det nuvarande systemet. Prototypen gav en ungefärlig förbättring i söktid på 18,8 %

Företaget Nordicstation hanterar stora datamängder åt Swedbank där datalagringen sker i relationsdatabasen Microsoft SQL Server 2012 (SQL Server). Då det finns andra databashanterare designade för stora datavolymer är det oklart om SQL Server är den optimala lösningen för situationen. Detta examensarbete har tagit fram en jämförelse med hjälp av prestandatester, beträffande exekveringstiden av databasfrågor, mellan databaserna SQL Server, Cassandra och NuoDB vid hanteringen av stora datamängder. Cassandra är en kolumnbaserad databas designad för hantering av stora datavolymer, NuoDB är en minnesdatabas som använder internminnet som lagringsutrymme och är designad för skalbarhet. Resultaten togs fram i en virtuell servermiljö med Windows Server 2012 R2 på en testplattform skriven i Java. Jämförelsen visar att SQL Server var den databas mest lämpad för gruppering, sortering och beräkningsoperationer. Däremot var Cassandra bäst i skrivoperationer och NuoDB presterade bäst i läsoperationer. Analysen av resultatet visade att mindre access till disken ger kortare exekveringstid men den skalbara lösningen, NuoDB, lider av kraftiga prestandaförluster av att endast konfigureras med en nod. Nordicstation rekommenderas att uppgradera till Microsoft SQL Server 2014, eller senare, där möjlighet finns att spara tabeller i internminnet. / The company Nordicstation handles large amounts of data for Swedbank, where data is stored using the relational database Microsoft SQL Server 2012 (SQL Server). The existence of other databases designed for handling large amounts of data, makes it unclear if SQL Server is the best solution for this situation.  This degree project describes a comparison between databases using performance testing, with regard to the execution time of database queries.  The chosen databases were SQL Server, Cassandra and NuoDB. Cassandra is a column-oriented database designed for handling large amounts of data, NuoDB is a database that uses the main memory for data storage and is designed for scalability. The performance tests were executed in a virtual server environment with Windows Server 2012 R2 using an application written in Java. SQL Server was the database most suited for grouping, sorting and arithmetic operations. Cassandra had the shortest execution time for write operations while NuoDB performed best in read operations. This degree project concludes that minimizing disk operations leads to shorter execution times but the scalable solution, NuoDB, suffer severe performance losses when configured as a single-node. Nordicstation is recommended to upgrade to Microsoft SQL Server 2014, or later, because of the possibility to save tables in main memory.

Исходя из актуальности, что управленческая деятельность всегда связана с риском, целью выпускной квалификационной работы была выбрана разработка информационной системы для управления рисками в организации Электро+. В соответствии с целью и темой работы, были поставлены следующие задачи: провести анализ тематической научно-методической литературы; описать деятельность организации Электро+; провести квалификацию возможных рисков; создать системы учета событий реализации рисков; спроектировать базу данных учета рисков; установить предложения по дальнейшему использованию базы данных для управления рисками. Как результат были выдвинуты предложения по дальнейшему использованию базы данных для противодействия рискам. А также представлены предложения по дальнейшей интеграции в информационную систему компании OZON. / Based on the relevance that managerial activity is always associated with risk, the purpose of the final qualification work was chosen to develop an information system for risk management in the Electro+ organization. In accordance with the purpose and topic of the work, the following tasks were set: to analyze the thematic scientific and methodological literature; to describe the activities of the Electro+ organization; to qualify possible risks; to create systems for recording events of risk realization; to design a database of risk accounting; establish proposals for further use of the database for risk management. As a result, proposals were put forward for the further use of the database to counteract risks. Proposals for further integration into the OZON information system are also presented.

<p>Rapporten presenterar skapandet av en produktkonfigurator och flera förslag på hur den kan förbättras. Uppdraget gavs av System Andersson till två studenter på Jönköpings Tekniska Högskola som genomförde detta som sitt examensarbete.</p><p>Rapporten diskuterar möjliga lösningar på en produktkonfigurator och visar ett resultat som utgår från dessa lösningar. Produktkonfiguratorn i rapporten består av två delar.</p><p>Dels konfigurationsdelen som hjälper användaren att skapa nya produkter utifrån valda artiklar. Artiklarna sorteras automatiskt av produktkonfiguratorn så att endast kompatibla artiklar kan sättas ihop. Detta sker med ett ”drag and drop” gränssnitt.</p><p>Dessutom innehåller produktkonfiguratorn en kompatibilitetsdel, vars uppgift är att underlätta vid definierandet av kompatibilitet mellan artiklar. Detta kan göras löpande under tiden en produkt konfigureras om så önskas. Användaren kan välja på två eller flera artiklar som ska vara kompatibla med varandra, eller hela kategorier.</p><p>Sist i rapporten diskuteras de val som gjorts under arbetets gång och möjliga förbättringar som kan göras på produktkonfiguratorn.</p>

Extract, Transformation, and Load (ETL) system is responsible for the extraction of data from several sources, their cleansing, conforming and insertion into a data warehouse. The thesis is focused on building ETL methodology to better understanding of ETL process and its application in the real environment. I've worked on project "BI Cookbook" with Clever Decision, a software consulting company that specializes in Business Intelligence. The aim was to create ETL part of the BI methodology. This methodology has been designed to provide ease of use, flexible and extensible material for the purpose of building ETL solution. The main goal of this work is to introduce created ETL methodology, all of its components and the way in which it could be used. Following goal is to discuss options of its implementation and modification for the wide range of use. The main contribution of this work is to provide ideas of creating and implementing ETL methodology or ideas for creating methodology in general. The thesis is divided into three parts. The first theoretical part deals with basic definition, architecture and implementing of ETL system. The second part presents the proposed methodology. The last part contains of the possible options for implementation a modification of the methodology.

This diploma thesis is focused on designing a prototype Business Intelligence solution for a company operating in financial markets. The company does not possess a full-scaled system for measuring enterprise performance and performs this task by the means of manual data collection. The current system is not sufficient for covering the growing number of the com-pany's dealings. The theoretical part of the thesis deals with introducing basic principles of Enterprise Per-formance Management, Balanced Scorecard and, subsequently, Business Intelligence. The practical part covers the defined strategic goals of the company using the Balanced Sco-recard method. The discovered strategic goals are transposed into a strategic map. Metrics for measuring these goals are assigned to them. Only some of the goals are chosen for the implementation of the Business Intelligence solution. Source data for assessing the reached values are defined for the given indicators. Data from the data source were transposed into the data hub. Subsequently, an OLAP cube connected to a reporting tool for displaying the calculated metrics is created.