20.500.12556/RUL-30509 Performance module for BI4Dynamics platform bachelor's thesis Performančni modul za BI4Dynamics platformo BI4Dynamics is an analytical Business Intelligence (BI) solution for Microsoft Dynamics ERPs. The solution deploys a data warehouse on a Microsoft SQL server and creates an analytical database on a Microsoft Analysis server; accordingly, due to SQL’s flexibility, it offers an excellent platform for developing custom BI modules; OLAP cubes and dimensions. This paper describes how the BI4Profiler, which is a performace module for BI4Dynamics platform, was developed. In this process my task was to design the core architecture of the module and oversee project development. The BI4Profiler module grew out of our partners’ and our own need for a tool when benchmarking and optimizing custom developed SQL scripts. We wanted to use the existing framework so this tool was packed as a module, thus it can be analyzed using any BI compatible front end tool. To ensure independency of statistic data, the BI4Profiler deploys its own separate data warehouse with staging and presentation area, as well as an OLAP cube with a set of dimensions. Although module, it has an additional core functionality that we had to integrate into the existing framework. During the execution of the scripts, this separate thread pools the SQL Server using DMVs (Dynamics Management Views) for statistics, which first saves said statistics to the data warehouse, thence builds and processes the analytical database. Ker smo hoteli zagotoviti neodvisnost in obstojnost teh statističnih podatkov tudi v primeru, ko uporabnik na novo namesti podatkovno skladišče, smo za modul uvedli novo ločeno podatkovno skladišče in analitično bazo, ki pa se namestita samo ob prvi namestitvi originalnega podatkovnega skladišča in se nato ne spreminjata. Podatki v njih pa se obdelajo po tem, ko se obdelajo vsi podatki v originalnem podatkovnem skladišču in analitični bazi. BI BI4Dynamics OLAP data warehouse benchmarking DMV DMV computer science diploma BI podatkovno skladišče zmogljivostna analiza DMV OLAP BI4Dynamics računalništvo univerzitetni študij diplomske naloge true false false [N. Ostrc] Angleški jezik Slovenski jezik Diplomsko delo 2015-01-19 10:30:05 2015-01-19 10:30:07 2024-07-29 11:08:58 0000-00-00 00:00:00 2015 0 0 58 str. 0000-00-00 NiDoloceno NiDoloceno NiDoloceno 0000-00-00 0000-00-00 0000-00-00 14975 1536203971 Ostrc_Nino_-_Performancni_modul_za_BI4Dynamics_platformo.pdf Ostrc_Nino_-_Performancni_modul_za_BI4Dynamics_platformo.pdf 1 29CAE86BDEB9391EB104688F55550F10 6e35af75f56ebe9e6e3463c4db43be59ace335a47558a34c87a8c8af89729c1c 4973ab77-a1ad-11eb-a523-00155dcfd717 20.500.12556/rul/55058b11-f954-4c6c-897a-dd67750ed103 https://repozitorij.uni-lj.si/Dokument.php?lang=slv&id=30503 Fakulteta za računalništvo in informatiko 0 0 0