This master’s thesis is focused on description of .NET Framework, versions, architecture, assembly and data formats. Describes programming language C#, his supporting programming processes and architecture. Contains description of ASP.NET, characteristics, used directories, control items and design model Model-View-Controller. Next part describes usability .NET background for creation of aplication and comparsion with PHP. Shortly introduces with ADO.NET, databinding, databases, his types and SQL language and content management system. At the end is desribed database structure of content management system, user administration and his parts and functions.

The purpose of thesis is optimization information system and its upgrade with some new functions. Optimization is based on users experience and edit using processes. Upgrade will be make new chances and functions which will help company in decision processes and it contributes to more effective work with firm’s data.

The aim of this thesis was the implementation of technological data management for individual tools and tool assembly in the information system NAHOS. This management in NAHOS system is accomplished by user forms, which are created by XML and SQL languages. The theoretical part of this thesis deals with tool management and information systems in general. The practical part of this thesis presents my own individual modifications in the information system NAHOS.

Der Betrag skizziert die Konzeption und Realisierung eines interaktiven, web-basierten SQLTrainers. Der SQL-Trainer wurde im Rahmen des Verbundprojekts „Bildungsportal Sachsen“ entwickelt und ist unter der URL http://sql-trainer.uni-leipzig.de mit einem Gast-Login zum Testen erreichbar.

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.

Meepo AB was investigating the possibility of developing a social rating and recommendation service. In a recommendation service, the user ratings are collected in a database, this data is then used in recommendation algorithms to create individual user recommendations. The purpose of this study was to find out which  demands are put on a DBMS, database management system, powering a recommendation service, what impact the NoSQL databases have on the performance of recommendation services compared to traditional relational databases, and which DBMS is most suited for storing the data needed to host a recommendation service. Five distinct NoSQL and Relational DBMS were examined, from these three candidates were chosen for a closer comparison. Following a study of recommendation algorithms and services, a test suite was created to compare DBMS performance in different areas using a data set of 100 million ratings. The results show that MongoDB had the best performance in most use cases, while Neo4j and MySQL struggled with queries spanning the whole data set. This paper however never compared performance for real production code. To get a better comparison, more research is needed. We recommend new performance tests for MongoDB and Neo4j using implementations of recommendation algorithms, a larger data set, and more powerful hardware. / Meepo AB undersökte möjligheten att utveckla en social betygs- och rekommendationstjänst. I en rekommendationstjänst samlas användarbetyg i en databas, för att sedan användas i en rekommendationsalgoritm för att skapa individuella rekommendationer till användarna. Syftet med studien var att ta reda på vilka krav som ställs på ett DBMS, databassystem, som driver en rekommendationstjänst, vilken inverkan NoSQL-databaser har på prestandan för rekommendationstjänster jämfört med traditionella relationsdatabaser och vilket DBMS som är mest lämpat för användning i en rekommendation tjänst. Fem olika NoSQL- och Relationsdatabaser undersöktes, från dessa valdes tre kandidater ut för en närmare jämförelse. Efter en studie i rekommendationsalgoritmer och rekommendationstjänster skapades en testsvit för att jämföra databasernas prestanda i olika områden. Till detta användes ett dataset med 100 miljoner betyg. Resultaten visar att MongoDB hade bäst prestanda i flest användningsfall, medan Neo4j och MySQL hade problem med sökningar som sträcker sig över hela datasetet. I denna uppsats jämförs dock inte prestandan med riktig produktionskod. För en bättre jämförelse behövs mer forskning. Vi rekommenderar nya prestandamätningar för MongoDB och Neo4j med implementationer av rekommendationsalgoritmer, ett större dataset och mer kraftfull hårdvara.

Software as a service (SaaS) has become a common business model for application providers. However, this success has lead to scalability issues for service providers. Their user base and processing needs can grow rapidly and it is not always clear how a SaaS provider should optimally scale their service. This thesis summarizes the technological (both software and hardware) related solutions to scaling, but will also cover financial and managerial aspects of scalability. Unfortunately, there is no existing out of the box solution for managing scalability, every situation and application is currently viewed as a unique problem, but there exists a lot of good advice from many sources about scaling. Obviously there are practical solutions to scaling, as there are successful SaaS providers, but it is not clear if there exists some fundamental principles that every SaaS provider could use to address the issue of scalability. This thesis seeks to find such fundamental principles though previous research, articles and finally a case analysis of Quinyx FlexForce AB. The thesis concludes that there are many principles of scaling a 3-tier web system and that most principles can be applied by SaaS providers. / Software as a Service (SaaS) har blivit en allt vanligare lösning för företag. Detta har dock lett till skalbarhets problem för många leverantörer av SaaS. En SaaS leverantör kan få problem med skalning ifall deras användarbas eller beräkningsbehov växer för snabbt. Denna avhandling sammanfattar de tekniska (mjukvara och hårdvara) relaterade lösningar på skalning. Avhandlingen kommer även kortfattat att omfatta ekonomiska och administrativa aspekter av skalbarhet. Tyvärr finns det inga befintliga universallösningar för hantering skalbarhet utan varje situation och tillämpning måste ses som ett unikt problem. Det finns många goda råd från många källor om skalning och uppenbarligen finns det praktiska lösningar på att skala, då det finns framgångsrika SaaS leverantörer. Det är dock oklart om det finns några grundläggande principer som varje SaaS-leverantör kan använda för att underlätta skalbarhet. Avhandlingen syftar till att hitta sådana grundläggande principer och grundar sig på tidigare forskning, aktuella artiklar och avslutats med en analys av Quinyx FlexForce AB. Avhandlingen drar slutsatsen att det finns grundläggande principer som SaaS leverantörer kan tillämpa vid skalning av ett ”3-tier” webserver system.

Context: This study compares the popularity and the performance of two DBMS. The two systems are SQL and NoSQL. The objective of the study is to determine which DBMS junior developers should learn first, in order to provide a head-start to their future career. Methods: To determine the most popular DBMS, surveys are collected from the Internet and are meta-analyzed. In order to determine the best performing DBMS, a SLR method that leads to a meta-analysis is conducted and tests the execution time of the read operation. Results: The research findings suggest that SQL is a more popular DBMS than the NoSQL system. This is verified statistically through the Fisher-Freeman-Halton Test, p <.001. As far as performance goes, the SQL DMBS performs a bit better compared to the NoSQL system if descriptive statistics is considered for 100 (M=12.4, SD=19.11),(M=174.4, SD=284.6) and 1000 (M=50.77, SD=113.5), (M=228.8, SD=276.6) records. However, once the t-test is performed it reveals that there is no statistical significance. Thus, the statistical test suggests that both DBMS perform equally well for both 100 and 1000 records t (8) = 1.27, p = .24 and t (8) = 1.11, p = .3 with a small effect size Cohen’sd, (d1=0.27) and (d2=0.28) respectively. Conclusion: Based on our research results and accounting for the importance of the date that this study has been conducted (2021), we recommend that junior developers should focus on learning a SQL DBMS first as their primary backend skillset for the foreseeablefuture.

The goal of this master thesis is to analyze Open Source resources for loadbalancing and high availability, with aim on areas of its typical usage. These areas are particularly solutions of network infrastructure (routers, loadbalancers), generally network and internet services and parallel filesystems. Next part of this thesis is analysis of design, implementation and plans of subsequent advancement of an fast growing Internet project. The effect of this growth is necessity of solving scalability on all levels. The last part is performance analysis of individual loadbalancing methods in the Linux Virtual Server project.

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.