This diploma thesis is focused on operation and maintenance of BI systems based on Microsoft's SQL Server 2008 R2 platform. This work covers regular activities related to BI system management that means monitoring, performance tuning, maintenance, administration, backup and recovery tasks. System management is based mainly on SQL Server's native management tools along with Microsoft's applications System Center: Essentials and System Center: Data Protection Manager. The main goal of this work is to create BI system operations and maintenance methodology in cooperation with Clever Decision which is specialized in BI area. Partial goals are to design a way of monitoring components of BI system, including to outline backup and recovery posibilities, maintenance and performance tuning of the SQL Server platform. Each chapter contains methods, best practices, summary tables and appropriate tools which help DBA to achieve the specified goals. The main contribution of this work is operations and maintenance methodology created according to Clever Decision's needs. Among the other contributions of this thesis also belongs the definition of using tools for monitoring and maintenance and their relations to the SQL Server's components. The work also contains simple backup and performance tuning methodology for SQL Server. At least, this diploma thesis represents comprehensive material which is strictly focused on OLAP databases operation and maintenance.

The problems associated with the effective design and uses of databases are increasing. The information contained in a database is becoming more complex and the size of the data is causing space problems. Technology must continually develop to accommodate this growing need. An inquiry was conducted in order to find effective guidelines that could support queries in general in terms of performance and productivity. Two database management systems were researched to compare die theoretical aspects with the techniques implemented in practice. Microsoft SQL Sewer and MySQL were chosen as the candidates and both were put under close scrutiny. The systems were researched to uncover the methods employed by each to manage queries. The query optimizer forms the basis for each of these systems and manages the parsing and execution of any query. The methods employed by each system for storing data were researched. The way that each system manages table joins, uses indices and chooses optimal execution plans were researched. Adjusted algorithms were introduced for various index processes like B+ trees and hash indexes. Guidelines were compiled that are independent of the database management systems and help to optimize relational databases. Practical implementations of queries were used to acquire and analyse the execution plan for both MySQL and SQL Sewer. This plan along with a few other variables such as execution time is discussed for each system. A model is used for both database management systems in this experiment. / Thesis (M.Sc. (Computer Science))--North-West University, Potchefstroom Campus, 2007.

The theoretical part of this thesis is focused on possibilities of the WebML modeling language and the WebRatio CASE tool. The practical part of this thesis deals with design and analysis of web application supporting the processes associated with the telecommunications and processing of data obtained by PBX. For the process will be used WebML based on acquired knowledge.

Stored procedures are used as the current database logic for SAAB’s data model of the fighter aircraft JAS-39 Gripen electrical schemas. Since the database model was developed in 2000, a research and tests needed to be carried out to decide on whether updating the database to today's technology is applicable. Therefore, Object-Relational Mapping (ORM) is to be researched, tested and compared to stored procedures using test-driven development (TDD)concerning an important factor, that Stored procedures are well-known for, which is querying performance of the database. Moreover, how maintainability and flexibility [1] can affect decision between Stored procedures or migrating to ORM based on our subjective experience. NHibernate and Entity Framework are the two ORM solutions considered sinceSAAB uses C# in this project. The process of this project is run using scrum of the agile software development to maintain an iterative progress throughout the project timeline. In this paper, the process and methodology are covered in details and also the comparison with the test results. These results eventually lead us to the answer that ORM is not a suitable technology, and stored procedures still dominate the querying performance for SAAB’scurrent database.

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 purpose of this project is to create a design and subsequently the web application for a database management which uses the system catalogue of the Microsoft SQL database system. The introduction deals with the principle of the relational databases and includes the list of the most widespread database systems. The next chapter of the theoretical part describes the syntax of the SQL query language, and the next chapter deals with the properties of the system catalogue which were utilized. Finally, the last of the theoretical chapters is centred on the .NET platform and its technologies – particularly the ASP.NET and the ADO.NET technologies. The former is used for creating dynamical web pages, and the latter is an object library used for the data access. The practical part of this work comprises the web application scheme on which is the final web application based. The most emphasized issues in this part are the security and the supposed program design of the web application. The final part of the work contains a description of the finished web application, especially the configuration and the functions which the application provides to a user. And finally, the whole project is briefly evaluated in the conclusion.

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.

Digitalisering i Sverige har ökat under de senaste åren, och kommer att fortsätta stiga. På grund av detta har säkerhetsåtgärder vidtagits så som GDPR som är till för att skydda användarens data och känsliga information, särskilt när det kommer till digital kommunikation mellan användare och kund. Det är därför ytterst viktigt att ha användares säkerhet i fokus när digitala system byggs upp, vilket även är kärnan i detta arbete. I projektet har en pålitligt databas samt en trygg mobilapplikation och webbapplikation byggts upp som förenklar kommunikationen mellan kommun och invånare. I mobilapplikationen kan användaren snabbt och enkelt felanmäla, se sina ärenden samt få information från kommunen angående pågående händelser i kommunen. I webbapplikationen kan kunden, det vill säga kommunen, kontrollera inskickade felanmälningar och markera de som åtgärdade och även skicka ut information till sina invånare. Detta sker utan att kunden får tillgång till användarens personliga data som endast finns i databasen och inte webbapplikationen. Efter de litteraturstudier som har gjorts är databasen och applikationerna säkra för både användare och kund. Åtgärder har vidtagits för att säkra att ingen fientlig applikation eller användare kan nå användarens känsliga data, samt ha möjligheten att modifiera databasen på egen hand. Till följd av detta kan kommunens invånare ha en närmare kontakt med kommunen på ett tryggt sätt. / The digitization in Sweden has increased rapidly during the last few years, and will continue doing so. As a result of this, precaution have been taken, for instance GDPR which was invented to protect users’ data and sensitive information, especially when it comes to digital communication between user and client. Therefore it is utterly important to have the user’s safety in focus when digital systems are implemented, which is also the core of this project. In this project, a reliable database as well as a safe mobile application and web application has been created to simplify the communication between citizens and counties. In the mobile application, the user has the possibility to report errors, verify their submitted errands along with getting information from the county about ongoing events in the county in an efficient way. In the web application the customer, which in this case is the county, can check the errors that has been sent in and mark them as fixed as well as giving their citizens information. This takes place without the customer having access to the user’s personal data that only exists in the database and not in the web application. After the literature studies that have been made, the database and the applications are safe for both the user and the customer. Actions have been made to ensure that no hostile application or user can reach sensitive data or has the possibility to modify the database on their own. As a result of this the county’s citizens can have a closer contact and communication with the county in a safe way.