The world is becoming increasingly digitized, and with this trend comes an increas-ing need for storing data for companies of all sizes. For smaller enterprises, thiscould prove to be a major challenge due to limitations in knowledge and financialassets. So the purpose of this study is to investigate how smaller companies cansatisfy their needs for data storage and which database management system to usein order to not let their shortcomings hold their development and growth back. Tofulfill this purpose, a small wood processing company in Sweden is examined andused as an example. To investigate and answer the problem, literary research is con-ducted to gain knowledge about data storage and the different options for this thatexist. Microsoft Access, MySQL, and MongoDB are selected for evaluation andtheir performance is compared in controlled experiments. The results of this studyindicates that, due to the small amount of data that the example company possesses,the simplicity of Microsoft Access trumps the high performance of its competitors.However, with increasingly developed internet infrastructure, the option of hostinga database in the cloud has become a feasible option. If hosting the database in thecloud is the desired solution, Microsoft Access has a higher operating cost than theother alternatives, making MySQL come out on top.

Rapporten behandlar utvecklingen av ett system som möjliggör för rapportering och granskning av avfallsdata. Systemet består av en mobilapplikation och en webbapplikation som utvecklats med React Native respektive React, en databas som utvecklats med MySQL och en back-end bestående av tjänster som erbjuds av Amazon Web Services. I AWS används tjänster som tillåter hantering av mobilapplikation, webbapplikation, databas och användare. Systemet utvecklades av åtta studenter vid Tekniska högskolan vid Linköpings universitet på uppdrag av det australiensiska företaget EcCell. Projektet resulterade i framtagningen av produkten Trace the Waste med nästan alla önskade funktionaliteter. I rapporten diskuteras även vad som hade kunnat göras annorlunda i utvecklingen med hjälp av andra verktyg. Rapporten drar slutsatser om bland annat varför produkten ger värde för kunden och hur den agila arbetsmetoden Scrum påverkat studenternas arbete under distansläge. Varje student har också skrivit ett individuellt bidrag där olika områden relaterade till projektet utreds. Bidragen finns i slutet av rapporten.

Data används i stora mängder i dagens samhälle. Sjukvården är inget undantag och i den branschen kan analyser av data rädda liv eller uppfinna läkemedel. För att kunna bruka data i modern tid måste ett databassystem användas. Att välja rätt databassystem kan vara svårt och kräver att man vet varför man väljer den ena över den andra. Här jämförs två databaser för att generera data på om det skilljer sig mellan operationstiderna hos en relationsdatabas och en dokumentbaserad databas. Studien har valt att göra ett tekniskt experiment där MySQL brukas som relationsdatabas medans MongoDB används som dokumentbaserad databas. Node.js används som ramverk för att skapa applikationer där testning sker. Data är hämtad från U.S. Department of Health &amp; Human Services (2023) och representerar sjukvårdsdata från COVID. Operationstyperna INSERT och SELECT är de två som undersöks i denna studien. Resultatet bevisar att båda de framlagda hypoteserna stämmer. MongoDB var i båda testerna mer effektiv och producerade lägre operationstider för INSERT och SELECT. / <p>Stavningskorrigerad titel: MySQL och MongoDB operationer med Node.js som ramverk</p>

Masters of Science / Coders of databases repeatedly face the problem of checking their Structured Query Language (SQL) code. Instructors face the difficulty of checking student projects and lab assignments in database courses. We collect and categorize common MySQL programming errors into three groups: data definition errors, data manipulation errors, and transaction control errors. We build these into a comprehensive list of MySQL errors, which novices are inclined make during database programming. We collected our list of common MySQL errors both from the technical literature and directly by noting errors made in assignments handed in by students. In the results section of this research, we check and summarize occurrences of these errors based on three characteristics as semantics, syntax, and logic. These data form the basis of a future static MySQL checker that will eventually assist database coders to correct their code automatically. These errors also form a useful checklist to guide students away from the mistakes that they are prone to make.

The identification of known asteroids on existing CCD pictures would allow us to obtain accurate astrometric and photometric asteroid properties. Some asteroids might have ambiguous orbital elements, thus their identification along with their exact positions on multiple picture frames could significantly improve their orbital elements. Furthermore, the possibility of identifying known asteroids on older pictures, sometimes preceding their discovery date, might allow the study of non-gravitational effects like the Yarkovsky effect. Identifying a potential Yarkovsky effect on asteroids is challenging because it is extremely weak. However, this effect cumulates with time, therefore, it is necessary to find astronomical pictures that are as old as possible. In addition, we need to collect high quality CCD pictures and use a methodology that would allow obtaining a statistically significant sample of asteroids. To accomplish this, we decided to use the online archive of the Subaru telescope at Mauna Kea Hawaii because it has a prime-focus camera with a very high resolution of 80 millions pixels very well suited to capture serendipitous asteroids. In addition, the Subaru online archive has pictures from the last 10 years. iv The methodology used in this thesis is to build a database that contains the orbital elements of all the known asteroids, allowing us to write a program that calculates the approximate position of all the asteroids at the date and time of each CCD picture we collect. To obtain a more precise position, the program also interfaces the JPL NASA Horizons on-line computation service. Every time an asteroid is found on a picture, Horizons sends its theoretical location back to the program. A later visual identification of this asteroid at this theoretical location on the picture triggers its input into our sample for further study. This method allowed us to visually confirm 508 distinct asteroids on 692 frames with an average diameter of 3.6 km. Finally, we use the theory (given in appendix A) to calculate the theoretical drift of these asteroids that we compare with the one we measured on the CCD pictures.

The use of databases for managing spatial data is widespread due to the efficiency of traditional SQL databases like Azure SQL. However, the exponential growth of data from sources like social media has led to the popularity of NoSQL databases such as MongoDB that handle large volumes of data effectively. NoSQL databases, including MongoDB, have built-in support for geospatial queries, making them suitable for managing geospatial data. Geospatial data combines geometric and geographic information and is represented by spatial datatypes like Point, LineString, and Polygon. MySQL and MongoDB both support geospatial data, but limited studies are comparing their performance in geospatial queries. An experiment was conducted to compare the fetch speed of geospatial data in these databases. The results were analyzed using graphs and related studies to draw conclusions, which showed that MongoDB performed slower fetch requests than MySQL. Future studies can use more data points and different queries.

No description available.

The proliferation of web based technologies has resulted in new forms of communities and organizations with enormous implications for design of learning and education. This thesis explores learning occurring within open source software (OSS) communities. OSS communities are a dominant form of organizing in software development with implications not only for innovative product development but also for the training of a large number of software developers. The central catalyst of learning within these communities is expert-novice interactions. These interactions between experts and novices or newcomers are critical for the growth and sustenance of a community and therefore it is imperative that experts are able to provide newcomers requisite advice and support as they traverse the community and develop software. Although prior literature has demonstrated the significance of expert-novice interactions, there are two central issues that have not been examined. First, there is no examination of the role of external events on community interaction, particularly as it relates to experts and novices. Second, the exact nature of expert help, particularly, the quantity of help and whether it helps or hinders newcomer participation has not been studied. This thesis studies these two aspects of expert-novice interaction within OSS communities. The data for this study comes from two OSS communities. The Java newcomer forum was studied as it provided a useful setting for examining external events given the recent changes in Java's ownership. Furthermore, the forum has a rating system which classifies newcomers and experienced members allowing the analysis of expert-novice interactions. The second set of data comes from the MySQL newcomer forum which has also undergone organizational changes and allows for comparison with data from the Java forum. Data were collected by parsing information from the HTML pages and stored in a relational database. To analyze the effect of external events, a natural experiment method was used whereby participation levels were studied around significant events that affected the community. To better understand the changes contextually, an extensive study of major news outlets was also undertaken. Findings from the external event study show significant changes in participation patterns, especially among newcomers in response to key external events. The study also revealed that the changes in participation of newcomers were observed even though other internal characteristics (help giving, expert participation) did not change indicating that external events have a strong bearing on community participation. The effect of expert advice was studied using a logistic regression model to determine how specific participation patterns in discussion threads led to the final response to newcomers. This was supported by social network analysis to visually interpret the participation patterns of experienced members in two different scenarios, one in which the question was answered and the other where it was not. Findings show that higher number of responses from experienced members did not correlate with a response. Therefore, although expert help is essential, non-moderated or unguided help can lead to conflict among experts and inefficient feedback to newcomers. / Master of Science

<p>This thesis will look into what kind of solutions a company or a private person can use if they want to create a dynamic website using only free software. To do this we divided our work in two parts. In the first part, we developed a dynamic website for a Swedish company. On the server side we used exclusively free software with open source code. There are different meanings in how the term “free” should be used when referring to software, which we will explain in the thesis. We have also chosen to work with the XMLtechnology to see if it lives up to its expectations and to see if we could benefit from the technology. Alongside with the development of our site, another company developed a site for the same company as us, by using non-free software. We have described both implementations and compared them to see if it is possible to do the same thing with both free and non-free software. </p><p>The investigating part of our work consisted of getting information about what other people think about the free software phenomenon. To do so we created an online questionnaire where we randomly picked 100 Swedish web agencies and asked them to answer 8 questions about what kind of software they used in their company, and what they thought about free software. To get some more opinions we also interviewed two persons involved in these kinds of topics. Jan Sandred, who is a well known expert advisor in topics concerning the Information Technology area and Richard Stallman, the founder of GNU and the Free Software Movement. </p><p>The reason for dividing the thesis in two parts was to get an overall picture on the subject. We did not only want to base our results on other people’s thoughts. We wanted to make our own conclusions based on the implementation we did. This approach showed out to be very good. We got to try working with free software ourselves to see its pros and cons and build our own opinions about it. We could then proceed to compare our impressions to other people’s impressions about free software.</p>

Die Arbeit diskutiert Lösungsvarianten und beschreibt die Implementation eines Prototyps zur Re-Organisation der Nutzerverwaltung des URZ. Besondere Schwerpunkte liegen auf der Erstellung eines Web-Interfaces zur Datenverwaltung und auf der Untersuchung relationaler Datenbanksysteme hinsichtlich der Eignung zur Lösung der Aufgabe. Der Prototyp stellt lediglich eine beispielhafte Implementierung einiger Teilkomplexe des Gesamtsystems dar.