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.

<p>This master’s thesis was performed at PartnerTech AB in Åtvidaberg. It addresses the problem of managing test results obtained from testing electronics manufactured by PartnerTech. PartnerTech has developed a test system, called Tor, which performs tests on manufactured boards and stores the test results in files. The Tor system consists of both hardware and software part, where the software runs on an ordinary PC with MS DOS/Windows 2000. The effects on the existing Tor system that this thesis implies are minimal. </p><p>This work focuses on a way of storing the produced test files in a database. In this work a data model has been developed, implemented, and evaluated together with a system that imports test files into the database and a graphical user interface that allows a user to easily search and browse the stored test results. It is also possible to print test reports from the Tor system. For implementing the database system Microsoft SQL Server 2000 was chosen as database server and an XML based data format was chosen to import and export data to and from the database. Two alternative graphical user interface applications were developed and compared - one server based on Microsoft IIS and one client based in Microsoft Access. For advanced data manipulation certain parts of the system were developed in Microsoft Excel.</p>

<p>Report writers (sv rapporteringsverktyg) används för att skapa och hantera databasbaserade rapporter. Detta examensarbete handlar om Reporting Services, ett helt nytt rapporteringsverktyg från Microsoft. Syftet med examensarbetet var att utvärdera Reporting Services för att se vad verktyget har att erbjuda i förhållande till rapporteringsverktyg från andra tillverkare. En jämförelse mellan Reporting Services och rapporteringsverktyg från tre andra betydande tillverkare har gjorts. En djupare utvärdering av Reporting Services, där arkitektur, funktionalitet och andra egenskaper gåtts igenom grundligt, har också genomförts. Arbetet har visat att problemet att jämföra olika rapporteringsverktyg med varandra är ganska komplext och att olika verktyg lämpar sig olika bra i olika situationer och kontexter. Verktygens arkitektur skiljer sig åt och de erbjuder olika funktionalitet. Arbetet har också visat att Reporting Services definitivt är ett bra alternativ för företag som använder SQL Server, inte minst ur ekonomisk synvinkel. Verktyget ger användarna en god kontroll över utformningen av rapporter, det är lätt att exportera rapporter till olika format och det finns flera bra möjligheter att distribuera rapporter till läsare.</p>

<p>Denna rapport handlar om framtagandet av en webbaserad rapporteringsplattform för Sandvik IT. Uppsatsen bryter ner och illustrerar de delar i processen som krävs för konverteringen från en dokumentbaserad till en webbaserad rapporteringsmetod genom att utgå från Sandvik IT’s rapporteringsscenario. Den dokumentbaserade rapporteringsmetoden utgörs av Excel och den webbaserade av Reporting Services. Många implementeringstekniska delar som kan vara av intresse för utvecklare tas upp. Uppsatsen täcker in kostnadsfrågor för hela livcykeln av webbplattformen och en jämförelse görs av de båda rapporteringsscenariorna En stor tyngd läggs även på att visa de problem som kan uppstå på vägen från rapporteringsscenariot med Excel till Reporting Services. Metoden för arbetet är platsundersökning, litteraturstudie samt en systemutvecklingsmetod som kallas för Agile. I slutet av uppsatsen finns det bilagor som visar hur de slutgiltiga rapporterna kan se ut.</p>

This work contains the design solution and implementation of importing data mining tool Weka to the Visual Studio and Microsoft SQL Server 2012 by Managed Plug-in algorithm. In this thesis is describe, how is possible to create new Managed Plug-In algorithm and how is possible to import tool Weka into it. To use tool Weka in the new Managed Plugin Algorithm, is used the IKVM port. The IKVM can create from Weka tool new C# library, which can be used by Managed Plug-in Algorithm.

This thesis deals with different approaches in the development of an analytical model of the data warehouse with a focus on tabular mode and its associated technologies and tools from the Microsoft company. In the theoretical part the thesis introduces the principles of Business Intelligence and also the concept of the semantic model. It also states tabular model as a new approach of creating an analytical database stored in the RAM memory. The tabular model is developed on the top of the data warehouse of a fictitious company Contoso in the practical part. The emphasis is put mainly on the comparison between the tabular and multidimensional model. The work ends with deploying both models on a virtual server with a comparison of their computing power for each of the designed scenarios.

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.

Detta examensarbete omfattar utveckling och test av en metod för distribution av data i ett multidatabassystem. Testen av metoden har gjorts genom att den har implementerats i en fallstudie. Fallstudien berör en organisation som har behov av att integrera tre av sina databassystem. Detta för att information ska kunna utbytas mellan dessa. Integrationen av databassystemen har gjorts på ett sådant sätt att de data som distribueras från dessa skickas till en central databas, med SQL Server som databashanterare. Det verktyg som har valts att användas i examensarbetet för att lösa uppgiften är Data Transformation Services, DTS, i SQL Server.

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 master’s thesis was performed at PartnerTech AB in Åtvidaberg. It addresses the problem of managing test results obtained from testing electronics manufactured by PartnerTech. PartnerTech has developed a test system, called Tor, which performs tests on manufactured boards and stores the test results in files. The Tor system consists of both hardware and software part, where the software runs on an ordinary PC with MS DOS/Windows 2000. The effects on the existing Tor system that this thesis implies are minimal. This work focuses on a way of storing the produced test files in a database. In this work a data model has been developed, implemented, and evaluated together with a system that imports test files into the database and a graphical user interface that allows a user to easily search and browse the stored test results. It is also possible to print test reports from the Tor system. For implementing the database system Microsoft SQL Server 2000 was chosen as database server and an XML based data format was chosen to import and export data to and from the database. Two alternative graphical user interface applications were developed and compared - one server based on Microsoft IIS and one client based in Microsoft Access. For advanced data manipulation certain parts of the system were developed in Microsoft Excel.