Dissertations / Theses on the topic 'Microsoft SQL (Computer file)'

Back in May of 1990, Windows was brought into the arena of viable operating environment due to the significant improvements Windows 3.0 made over its predecessor, Windows 2.11. Windows 3.1, another significant upgrade, was released in May, 1992. As the popularity of Windows has soared, the number of applications developed specifically for Windows has also sky-rocketed. This has translated into a huge demand for Windows programmers.Writing Windows code, however, is never an easy task. In fact, Windows has the reputation of being easy for users but hard for programmers. The difficulties in learning to program in Windows plus the increasing number of beginning Windows programmers lead to an urgent need to provide a solution to the problem: How to ease the learning curve of Windows programming?This is thus the theme of the thesis: building a comprehensive on-line Windows programming tutorial that helps ease the daunting learning curve. Through the use of interesting illustrations, example programs with on-line explanations, this tutorial makes Windows programming easier and more fun to learn.
Department of Computer Science

I dagens samhälle så blir vi allt mer och mer beroende av den teknik vi utvecklar, därför är det av större vikt att vi alltid skall ha tillgång till den information som vi behöver för att kunna göra våra dagliga sysslor. Detta lägger större press på att de system som utvecklas skall fungera felfritt och man skall ha snabba responstider för att allt ska flyta på så bra som möjligt och om det så skulle bli en kritisk systemkrasch så skall inte informationen gå helt förlorad. Därför har det blivit populärt att ändra från att ha personliga servrar till att köra allt mer och mer applikationer och information i det så kallade ”molnet”.  Därför är det av allt större intresse att ha koll på några av de större leverantörerna av molntjänster och hur man kan använda dessa för att få en bättre verksamhet. Därför kommer denna rapport att handla om hur ett arbete utförts på TeamNorrs begäran för att göra en jämförelse mellan Microsoft Azure, Google Cloud Platform och Amazon Web Services. Den kommer även gå igenom hur responstiderna ser ut till några av världens datacenter med en utgångspunkt från TeamNorrs huvudkontor i Umeå. Rapporten går även igenom hur man själv kan testa på Microsoft Azure, Google Cloud Platform och Amazon Web Services, och hur man i Microsoft Azure kan göra en så kallad ”Site to Cloud” lösning med en VPN tunnel för att kunna skapa en MSSQL backup i molnet. Sedan diskuteras för och nackdelar med det arbete som utförts, samt vilka förbättringar som skulle kunna vara aktuella i framtiden.
In todays society we become more and more dependent on the technology we develop, so it is of greater importance that we always have access to the information we need to do our daily tasks. It is more pressing than ever that the developed systems should work well and that you should have quick response times for everything to flow as smooth as possible and if there would be a critical system crash, the information should not be completely lost. Therefore, it has become more popular to go from, having personal servers to use more and more applications and information in the so-called "cloud". That´s why it is becoming increasingly important to keep track of some of the major cloud service providers and how to use them to archive a better business. This report will be about how a work was done at TeamNorrs request to make a comparison between Microsoft Azure, Google Cloud Platform and Amazon Web Services. It will also review the response times to some of the worlds data centers with a starting point from TeamNorrs headquarters in Umeå. It also describe how you can put up your own environment to test Microsoft Azure, Google Cloud Platform and Amazon Web Services, and how to do a so-called "Site to Cloud" solution with a Virtual Private Network tunnel in Microsoft Azure, where it will also show you how you can create an MSSQL backup in the cloud. Then discusses the pros and cons of the work done and what improvements could be relevant for the future.

The purpose of this thesis is to develop a software system simulating Turing machines using a Microsoft Windows' Interface.Developed in the 1930's by Alan Turing and Emil Post, Turing machines are defined as "abstract computers" . These machines seem able to solve all problems a modern computer can solve, however complex the problems may be. A Turing machine is a basic computational model for algorithms.The software provides a practical tool to students with a relative notion of Turing machines. The software contains introduction and general information on Turing machines that gives the beginner enough background to use the program. The user can create, modify or run Turing machines saved onto MS-DOS files. Some examples of Turing machines are preloaded. These examples give more help to the beginner.An on-line help facility is provided in order to direct and inform the learning student at each level of the software.The Microsoft Windows' Interface makes the software easy and friendly to use. The software has the modularity which will ease any future enhancement.
Department of Computer Science

My thesis is to design a Controlled Area Network (CAN) simulator For Microsoft Windows. In a modern world we deal with complex mechanical systems that require special electronic control to guarantee ultimate safety and efficiency. These electronic control systems are responsible for monitoring subsystems within the mechanical systems. A good example of this is the motor vehicles that are being driven on the road today. These vehicles have been designed with increased safety and efficiency, such as electronic controlled anti lock breaks, fuel injection, and power control steering. To run all of these components, the car needs a very well designed protocol to be able to control series of messages being passed from one subsystem to another. To determine which message being passed has higher priority than any other messages. To deal with such circumstances, the Controlled Area Network (CAN) was designed. The purpose of the CAN simulator is to gather statistical information concerning the arbitration, message transfer, error detection, error signaling, and retransmision. The CAN simulating model will consist of one to sixty nodes. Each node is considered as a subsystem for the CAN simulator. The subsystems will be characterized as the breaks, engine, transmission, or any part of a car which needs to be connected to the CAN system. Each node will send one to ten messages through the CAN system. The CAN system will take the messages from the nodes and place them into an Arrival queue. Each node will have its own Arrival queue, and no nodes can have two messages on the bus at the same time. The messages will be sorted in the queues in the order of the time needed to be released onto the bus. There will be an internal clock that will monitor the time for when the messages are needed to be placed onto the bus. If there is a situation where two messages need to be sent at the same time, the arbitrator will determine the priority of the messages to be placed onto the bus. Once the message is on the bus, it will go to a transfer queue. Periodically, there will be an error signal sent with the message that will be detected by the error detection, and it will be required that the message to be retransmitted. At critical points on the simulation, statistical information will be gathered for an analyzation. Some examples of information to be analyzed are 1) verification of the simulation performance on a single node with a single message, 2) network load which is a rate of a utilized bus time to the total bus time, 3) network throughput which is a total number of messages that are transmitted per second, and 4) average response time which will be the average time taken by all messages to gain bus access.PLATFORM DESCRIPTIONThe computer to be used in this project will be an Intel Pentum 100 with 16 megs RAM, two 853 megabyte harddrive, and a 17 inch super VGA monitor. The user interface will be windows 3.1 application. The compiling language to be used will be Microsoft Visual C++.
Department of Computer Science

The hypercube is one of the most versatile and efficient networks yet discovered for parallel computation. It is well suited for both special-purpose and general-purpose tasks, and it can efficiently simulate many other networks of the same size. The size of subgraphs can be used to estimate the efficient communications of hypercube computer systems.The thesis investigates induced subgraphs of a hypercube, discusses sizes of subgraphs, and provides a formula to give bounds on the size of any subgraph of the hypercube.The concept of spanning graphs and line graphs is useful for studying properties of graphs. An MS WINDOWS based graphical system is developed which allows the creation and display of graphs and their spanning graphs, line graphs and super line graphs.
Department of Computer Science

SQL Injections are still a prominent threat on the web. Using a custom built tool, BlindCanSeeQL (BCSQL), we will explore how to automate Blind SQL attacks to discover database schema using fewer requests than the standard methods, thus helping avoid detection from overloading a server with hits. This tool uses a web crawler to discover keywords that assist with autocompleting schema object names, along with improvements in ASCII bisection to lower the number of requests sent to the server. Along with this tool, we will discuss ways to prevent and protect against such attacks.

I mätrummet på Sandvik Coromant finns en lösning för att visualisera maskinhälsa, mäthistorik och servicetider för olika mätinstrument. Lösningen för datavisualiseringen nyttjar verktyget Power BI och är kopplad till Excelfiler. När data väl hämtats in görs en rad modifieringar på tabellerna för att få fram visualiserbar data. Dessa modifieringar i kombination med många Excelark resulterar i att ledtiderna för att uppdatera en Power BI rapport blir väldigt långa. Nu önskas det att istället nyttja en databaslösning för den data dessa Excelfiler innehåller och därmed förbättra dessa ledtider. Således skapades en databas utifrån den data dessa Excelfiler innehöll. Power BI tillåter användaren att importera data från en databas till applikationen på två sätt, via Import Mode eller DirectQuery. Import Mode läser in samtliga tabeller som efterfrågas och lagrar dessa i minnet. DirectQuery ställer frågor direkt till databasen utifrån vad som efterfrågas. I och med denna skillnad i importsätt finns metoder för att optimera den databas som data läses in ifrån. Studien undersöker hur olika typer av indexering och olika typer av kompression av dessa index påverkar svarstiden på frågor ställda av Power BI för att besvara följande två forskningsfrågor: Hur påverkar olika typer av indexering av en databas datahämtningshastigheten vid användning av Power BI? Hur påverkar olika typer av kompression av index datahämtningshastigheten vid användning av Power BI? Studien utfördes genom att studera execution plans och exekveringshastighet för de frågor som ställdes mot databasen av Power BI. Med hjälp av T-SQL kunde exekveringshastigheten för en specifik fråga tas fram. Denna exekveringshastighet jämfördes sedan för de olika typerna av index och kompression mot exekveringshastigheten för samma fråga mot en tabell helt utan index. Detta utfördes sedan på tabeller med varierande antal rader, där antalet rader som testades var 33 001, 50 081, 100 101, 500 017 och 1 000 217. Resultatet av studien visar att för Import Mode är det bästa typen av index ett clustered rowstore index utan kompression, med undantag för tabeller med över 1 001 217 rader där radkompression presterade bättre. För DirectQuery presterade non-clustered rowstore index bäst, men för vilken kompression var resultatet tvetydigt. Detta eftersom samtliga typer av kompression presterade bäst för olika antal rader i tabellen. För tabeller med fler än 500 017 rader presterade dock ingen kompression allra bäst.
In the measurement room at Sandvik Coromant there is a solution for visualizing machine health, measurement history and service times for different measuring instruments. The data visualization solution uses Power Bi and connects to Excel files. Once the data has been collected, a number of modifications are made on the tables to produce something that is possible to visualize. These modifications in combination with many Excel sheets result in very long lead times for updating a Power BI report. Now it is desired to use a database solution for the data contained in the Excel files and thus improve these lead times. For this, a database was created based on the data that these Excel files contained. Power BI allows the user to import data from a database into the application in two ways, via Import Mode or DirectQuery. Import Mode loads all the requested tables and stores them in memory. DirectQuery runs queries directly to the database, based on what is requested. Due to this difference, there are methods to optimize the database from which the data is loaded. This study examines how different types of indexing and different types of compression affect the response time for queries ran by Power BI to answer the following two research questions: How do different types of indexing affect a database's data retrieval rate when using Power BI? How do different types of compression affect the data retrieval rate when using Power BI? This was done by studying execution plans and execution rate for the queries that was done towards the database by Power BI. With the help of T-SQL, the execution rate for a specific query was obtained. The execution rate for different types of index and compression was then compared against a table without an index. This was then performed on tables with varying numbers of rows, where the numbers of rows that were tested was 33 001, 50 081, 100 101, 500 017 and 1 000 217. The results of the study show that for Import Mode, the best type of index is a clustered rowstore index without compression, with the exception of tables with over 1 001 217 rows where row compression performed better. For DirectQuery, non-clustered rowstore index performed best, but for which compression the result was ambiguous. This was because all types of compression performed best for different number of rows in the table. However, for tables with more than 500 017 rows, no compression performed best.

Multi-tier enterprise systems consist of more than two distributed tiers. The design of multi-tier systems is considerably more involved than two tier systems. Not all systems should be designed as multi-tier, but if the decision to build a multi-tier system is made, there are benefits to this type of system design. CSCources is a system that tracks computer science course information. The requirements of this system indicate that it should be a multi-tier system. This system has three tiers, client, business and data. Microsoft tools are used such as Visual Basic (VB) that was used to build the client tier that physically resides on the client machine. VB is also used to create the business tier. This tier consists of the business layer and the data layer. The business layer contains most of the business logic for the system. The data layer communicates with the data tier. Microsoft SQL Server (MS SQL) is used for the data store. The database containsseveral tables and stored procedures. The stored procedures are used to add, edit, update and delete records in the database. Microsoft Transaction Server (MTS) is used to control modifications to the database. The transaction and security features available in the MTS environment are used. The business tier and data tier may or may not reside on the same physical computer or server. Active Server Pages (ASP) was built that accesses the business tier to retrieve the needed information for display on a web page. The cost of designing a distributed system, building a distributed system, upgrades to the system and error handling are examined.Ball State UniversityMuncie, IN 47306
Department of Computer Science

The aim of this study was to investigate the role Excel could play in influencing Mathematics and Mathematical literacy learners’ interpretation of functions and their attitude towards Mathematics. I used a Mathematical Graphical Diagnostic (MGD) test, an attitude questionnaire, a reflective questionnaire and semi-structured interviews as instruments. The MGD test and the attitude questionnaire were given to 72 volunteer grade 11 learners at a former Model C school in Port Elizabeth, in the Eastern Cape. This group included 50 pure Mathematics learners and 22 Mathematical literacy learners. From this group, a smaller group of 10 learners further took part in the rest of the study were they went through an intervention were Excel was used as a teaching tool, covering concepts concerning functions. This group included 6 pure Mathematics and 4 Mathematical literacy learners. The 10 learners then re-wrote the MDG test and refilled the attitude questionnaire after the intervention. A reflective questionnaire was administered to the 10 learners after the intervention, with 5 learners from the 10 undergoing interviews in order to meet the objectives of the study. The administration of the MDG test and attitude questionnaire, interviews and reflective questionnaire enabled me to explore the relationship between learner performance and their attitude towards Mathematics as a subject, as well as the comparing the attitudes and performances between pure Mathematics and Mathematical Literacy learners. The study followed a qualitative research design, with an element of quantitative research. The qualitative data yielded findings that revealed the effectiveness of using Excel in teaching functions while the quantitative data revealed the difference in attitude and ability between pure Mathematics and Mathematical Literacy leaners. The findings of the study revealed that Excel played a major role in improving pure Mathematics learners’ results but not those of the Mathematical Literacy learners. The study also showed that technology does not necessarily impact on learners’ attitudes positively.

Axel Spetz AB är ett anrikt företag som driver en järnhandel i Falköping. Företaget har tidigare använt sig av marknadsföring i lokaltidningen men insåg fördelen med att använda Internet som verktyg. Deras idé var en ”Blocket.se”-liknande funktion på deras hemsida som skulle göra det möjligt för dem att marknadsföra artiklar.

Formuleringen på deras behov och det som legat till grunden för detta projekt var: Hur tillverkar man en avancerad publiceringsfunktion som är lätt att använda?

Inledningsvis gjordes en teoretisk studie inom områdena databaser, SQL, .NET och Visual Studio. Valet föll så här eftersom det var områden jag ville lära mig mer om.

Under utvecklingsarbetet i ovan nämnda tekniker hölls en tät kontakt med representanter från företag för att de snabbt skulle kunna ge respons på arbetet. Projektet resulterade i två olika saker:

-En lösenordsskyddad administrationsdel där all administration såsom publicering av artiklar, hantering av artiklar och kategorier, intresseanmälningar, ändring av öppettider m.m. kan skötas på ett enkelt sätt.

-Företagets hemsida där besökare kan ta del av aktuella erbjudanden, bläddra bland artiklar, kontakta företaget, läsa företagsinformation, lämna intresseanmälningar på artiklar m.m.

All programmering har gjorts med slutanvändarna, dvs. anställda på företaget och besökare på hemsidan i åtanke. Ett antal felkontroller både färdiga och egentillverkade har använts för att se till att fel inte uppstår i arbetet med databasen. Istället för ”riktiga” felmeddelanden visas förklarande texter om vad som måste åtgärdas.

I projektets slutskede så lanserades Axel Spetz nya hemsida och den började direkt användas som ett verktyg i företagets marknadsföring. Jag anser att det är ett bra bevis på att projektet var lyckat.

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.

Children with autism typically exhibit deficits in behavior and also in visual processing. Development and implementation of visually-cued instructional procedures, combined with electronic technology, have been used successfully to teach children with autism complex behavior chains. This study used photographic activity schedules on computer slideshow software to teach two children with autism to follow computer-mediated cues and engage in four play activities, and to transition between each activity in their homes without the presence of a trained behavior therapist. Results of this study demonstrated that these technologies can be utilized in children's homes to promote computer-mediated play behavior while eliminating the necessary cost of a home behavior therapist to prompt and supervise such activities.

Thule Sweden AB utvecklar, tillverkar och marknadsför kompletta och funktionella lasthållarsystem för bilar. De erbjuder en mycket stor bredd av olika lasthållare till över 1500 bilmodeller. De tillverkar lasthållare som cykelhållare, boxar, skidhållare, hållare för vattensport och andra tillbehör. För att en bil skall kunna bära en takbox måste det tillverkas en lasthållare som placeras mellan biltaket och takboxen. En del i denna lasthållare kallas för takbleck och dess form tas fram med en speciell takskanner vilken analyserar biltakets form vid kanterna.

Till detta har en mjukvara tagits fram som Thule kan använda för att söka/lägga till/redigera takbleck, istället för att manuellt söka i en pärm bland 700 olika ritningar. Programvaran var först utvecklad i Microsoft® Visual Studio 2003 (.NET Framework 1.1), men på senare tid omarbetad från grunden i den nyare utvecklingsmiljön Microsoft® Visual Studio 2005 (.NET Framework 2.0).

Innan programmeringen av mjukvaran sattes igång utformades en kravspecifikation från Thule om vad de ville ha för funktioner i programmet. Denna kravspecifikation har under utvecklingens tid ändrats, både under de möten som hållits och på en speciell webbplats som skapats för återkoppling av programmet (”TBS Felhanterings-center”), i form av buggar/ändringar/annat.

Förutom en avdelning i rapporten som behandlar hur denna programvara är uppbyggd, vilka problem som uppstod och hur de löstes, finns även teoretisk information om databaser, XML och andra teknologier.

Resultatet av projektet blev en applikation för hantering av takbleck som kan användas ute i fält (hos kund) utan uppkoppling mot en gemensam databas hos företaget (mot vilken all information synkroniseras). All information som läggs till/redigeras sparas på användarens lokala dator i form av XML som sedan kan synkroniseras mot den gemensamma server-databasen på företaget.

Thule Sweden AB develop, manufacture, and market complete and functional load carriers for cars. They provide a large amount of different load carriers for over 1500 car models. They also manufacture carriers such as bike carriers, roof boxes, ski carriers and water sport carriers. To be able to put a roof carrier on a car, a load carrier must be manufactured and be placed between the car roof and the roof carrier.

We have developed software that the group of workers at Thule can use to search/add/edit brackets, instead of manually search in a folder containing over 700 drawings. The program was first developed in Microsoft Visual Studio 2003 (.NET Framework 1.1), but has been rewritten in Microsoft’s new develop environment Visual Studio 2005 (.NET Framework 2.0).

Before we started to write the program, Thule gave us a specification of requirements that contained information of possible functions in the program. The specification of requirements has been changed a couple of times during our work. We have also put up a website where bugs and changes could be reported.

Except a part in this report, where we describe how the program is built, how we have solved problems, there is also theoretical information about how databases, XML and other techniques work.

The result of this project became an application, which the personnel at Thule can use while they visit their customers. The saved information can later be synchronised with the server.

New hardware devices are continually being released to the public by hardware manufactures around the world. For these new devices to be usable under a PC operating system, device drivers that extend the functionality of the target operating system have to be constructed. This work examines and compares the device driver architectures currently in use by two of the most widely used operating systems, Microsoft’s Windows and Linux. The IEEE1394 (high speed serial bus) device driver stacks on each operating system are examined and compared as an example of a major device driver stack implementation, including driver requirements for the upcoming IEEE1394.1 bridging standard.

Rapporten presenterar skapandet av en produktkonfigurator och flera förslag på hur den kan förbättras. Uppdraget gavs av System Andersson till två studenter på Jönköpings Tekniska Högskola som genomförde detta som sitt examensarbete.

Rapporten diskuterar möjliga lösningar på en produktkonfigurator och visar ett resultat som utgår från dessa lösningar. Produktkonfiguratorn i rapporten består av två delar.

Dels konfigurationsdelen som hjälper användaren att skapa nya produkter utifrån valda artiklar. Artiklarna sorteras automatiskt av produktkonfiguratorn så att endast kompatibla artiklar kan sättas ihop. Detta sker med ett ”drag and drop” gränssnitt.

Dessutom innehåller produktkonfiguratorn en kompatibilitetsdel, vars uppgift är att underlätta vid definierandet av kompatibilitet mellan artiklar. Detta kan göras löpande under tiden en produkt konfigureras om så önskas. Användaren kan välja på två eller flera artiklar som ska vara kompatibla med varandra, eller hela kategorier.

Sist i rapporten diskuteras de val som gjorts under arbetets gång och möjliga förbättringar som kan göras på produktkonfiguratorn.

To develop leaders for the 21st century, schools must be able to prepare students to meet the high academic, technical and workforce challenges. Charter schools are increasingly attempting to meet these challenges by educating students through innovative means and by creating effectual educational programs that are more conducive to the needs of the student. This document provides a computer literacy curriculum, which will facilitate student learning of computer literacy skills.

My independent work has been to modernize a user interface in a 10-year-old MVC Framework application used by Skärblacka mills within the BillerudKorsnäs Group. The concept of modernization also means increasing its quality; to replace older knowledge and technology with new and modern technology such as be able to click on the text of a checkbox that is considered to be more relevant for its time. The framework chosen for the implementation was ASP.NET Core MVC, which is an open source for the most common platforms. The implementation of the porting meant that server code that is well-functioning has been maintained to a large extent. JavaScript is also pretty much the same except in a few places. To get a good and durable structure, the application is layered in the form of 3 layers with Controller, BusinessLayer and Repository. The database with SQL Server is basically the same except that Identity has been introduced. To be able to communicate with the database, ORM EF Core has been chosen, which is a slim version of EF. A lot of what is in the old MVC framework has been redesigned because it is not supported in Core MVC. The application consists of an assembly with a logical development tree that consists of the files included in the application.Ajax has been used to get soft desktop-like updates.The application, which is complex with a lot of complicated things, made time run away.
Mitt självständiga arbete har varit att modernisera ett användargränssnittet i en 10 år gammal MVC Framework applikation som används av Skärblacka bruk inom BillerudKorsnäs koncernen. I begreppet modernisera ligger också innebörden att öka dess kvalité; att byta ut äldre kunskaper och teknik mot ny och modern teknik som t.ex. kunna klicka på texten till en checkbox som anses vara av mer relevans för sin tid. Det ramverk som valdes för implementationen var ASP.NET Core MVC som är ett open sourse för de vanligaste plattformarna. Genomförandet av porteringen innebar att serverkod som är väl fungerande har bibehållits i stora delar. Även JavaScript är i stort sett densamma förutom på några få ställen. För att få en bra och hållbar struktur är applikationen skiktad i form av 3 lager med Controller, BusinessLayer och Repository. Databasen med SQL Server är i stort sett densamma förutom att Identity har införs. För att kunna kommunicera med databasen har man valt ORM EF Core som är en slimmad version av EF. En hel del av det som finns i den gamla MVC framework är omgjort eftersom det stöds in i Core MVC. Applikationen består av en assembly med ett logiskt utvecklingsträd som utgörs av de filer som ingår i applikationen. Ajax har används för att få mjuka desktop liknade uppdateringar. Applikationen som är komplex med en hel del komplicerade saker gjorde att tiden rann iväg.

This item is only available in print in the UCF Libraries. If this is your Honors Thesis, you can help us make it available online for use by researchers around the world by following the instructions on the distribution consent form at http://library.ucf
Bachelors
Arts and Sciences
Organizational Communication

The nature of Internet and Intranet Web applications has changed from a static content-distribution medium into an interactive, dynamic medium, often used to serve multimedia from back-end object-relational databases to Web-enabled clients. Consequently, developers need to make an informed technological choice for developing software that supports a Web-based application for distributing multimedia over networks. This decision is based on several factors. Among the factors are ease of programming, richness of features, scalability, and performance. The research focuses on these key factors when distributing images from an Oracle9i database using Java Servlets, JSP, ASP, and ASP.NET as the server-side development technologies. Prototype applications are developed and tested within each technology: one for single image serving and the other for multiple image serving. A matrix of recommendations is provided to distinguish which technology, or combination of technologies, provides the best performance and development platform for image serving within the studied envirorunent.
KMBT_363
Adobe Acrobat 9.54 Paper Capture Plug-in

This independent work includes refactoring a website application. In simpler sense, it means modernizing existing code by increasing its quality and making it more understandable; to exchange old knowledge of methods and concepts into something that is more relevant to its time. This refactoring has also meant to transform the UI into something that is more appealing, and more userfriendly. The website that has gone through the refactoring is Nordyr (”https://nordyr.com/”). Nordyr is a Nordic Film & Series Database that shares information about Nordic films and tv-series, and everyone involved. They also offer social tools such as user profiles and various tools to simplify the exploration and interaction between Nordic movies and consumers. This was made possible by using vanilla PHP, JavaScript/jQuery, and the MariaDB database for information storage and management. The implementation of the refactoring meant retaining PHP for the backend, but applying the Laravel framework, and likewise for JavaScript, but applying ReactJS (a powerful JavaScript library). Nordyr retains MariaDB for its information storage and management, however, its SQL queries have been adapted to Laravel’s query-builder and Eloquent ORM, which means that the majority of SQL queries have been rewritten and the majority of data tables are now represented by models. The restructuring of Nordyr has shown that the website now has the ability to scale better, and the development environment will also be more pleasant for those involved.
Det här självständiga arbetet har innefattat att omstrukturera en hemsida. Det innebär i enklare mening att modernisera kod och öka dess kvalité; att byta ut äldre kunskaper om metoder och koncept till något som anses vara av mer relevans för sin tid. Refaktoreringen har också inneburit att dess UI gjorts om till att bli mer tilltalande och användarvänlig. Hemsidan som gått igenom refaktoreringen är Nordyr (”https://nordyr.com/”). Nordyr är en Nordisk Film- & Serie-databas som delar information om nordiska filmer och tv-serier och alla inblandade. De erbjuder även sociala verktyg som användarprofiler och diverse verktyg för att förenkla upptäckandet och interaktionen mellan nordiska titlar och konsumenter. Detta gjordes möjligt med hjälp av vanilj PHP, JavaScript/jQuery, och databasen MariaDB för informationslagring och hantering. Genomförandet av refaktoreringen innebar att behålla PHP för backend men tillämpa ramverket Laravel, och likaså för frontend, JavaScript stod kvar men ReactJS (”JavaScript bibliotek”) tillämpades. Nordyr behåller MariaDB, men dess förfrågningar i SQL har anpassats till Laravels query-builder och Eloquent ORM, vilket innebar att majoriteten av SQL frågor skrivits om och majoriteten av tabeller representeras nu av modeller (”Models”). Omstruktureringen av Nordyr har visat på att hemsidan nu har förmågan att skala bättre, och utvecklingsmiljön kommer även bli mer behaglig för de inblandade.

This project describes DRG (Dynamic Report Generator). This program can be used on the internet to summarize the content of a database based on user criteria. DRG allows the user to choose a database, input the data, and generate a report based on user input, and print out the results in a new format. This paper describes the design and analysis of the DRG program.

Model View Controller (MVC) software architecture is widely spread and commonly used in application’s development. Therefore generation of data layer for the database model is able to reduce cost and time. After research on current Object Relational Mapping (ORM) tools, it was discovered that there are generating tools like Data Access Object (DAO) and Hibernate, however their usage causes problems like inefficiency and slow performance due to many connections with database and set up time. Most of these tools are trying to solve specific problems rather than generating a data layer which is an important component and the bottom layer of database centred applications. The proposed solution to the problem is an engineering approach where we have designed a tool named Generated Intelligent Data Layer (GIDL). GIDL tool generates small models which create the main data layer of the system according to the Database Model. The goal of this tool is to enable and allow software developers to work only with object without deep knowledge in SQL. The problem of transaction and commit is solved by the tool. Also filter objects are constructed for filtering the database. GIDL tool reduced the number of connections and also have a cache where to store object lists and modify them. The tool is compared under the same environment with Hibernate and showed a better performance in terms of time evaluations for the same functions. GIDL tool is beneficial for software developers, because it generates the entire data layer.

Il lavoro è stato suddiviso in tre macro-aree. Una prima riguardante un'analisi teorica di come funzionano le intrusioni, di quali software vengono utilizzati per compierle, e di come proteggersi (usando i dispositivi che in termine generico si possono riconoscere come i firewall). Una seconda macro-area che analizza un'intrusione avvenuta dall'esterno verso dei server sensibili di una rete LAN. Questa analisi viene condotta sui file catturati dalle due interfacce di rete configurate in modalità promiscua su una sonda presente nella LAN. Le interfacce sono due per potersi interfacciare a due segmenti di LAN aventi due maschere di sotto-rete differenti. L'attacco viene analizzato mediante vari software. Si può infatti definire una terza parte del lavoro, la parte dove vengono analizzati i file catturati dalle due interfacce con i software che prima si occupano di analizzare i dati di contenuto completo, come Wireshark, poi dei software che si occupano di analizzare i dati di sessione che sono stati trattati con Argus, e infine i dati di tipo statistico che sono stati trattati con Ntop. Il penultimo capitolo, quello prima delle conclusioni, invece tratta l'installazione di Nagios, e la sua configurazione per il monitoraggio attraverso plugin dello spazio di disco rimanente su una macchina agent remota, e sui servizi MySql e DNS. Ovviamente Nagios può essere configurato per monitorare ogni tipo di servizio offerto sulla rete.

This research is concerned with the development of a framework for the analysis and design of interfaces found in a security environment. An example of such an interface is a firewall. The purpose of this research is to use the framework as a method to improve the usability of an interface, thus aiding the user to implement the correct security features. The purpose is also to use the framework to assist in the development of trust between a user and a computer system. In this research the framework comprises six criteria which are used to analyse interfaces found in the traditional software environment, Internet banking environment and e-commerce environment. In order to develop the framework an overview of the fields of information security and human computer interfaces (HCI) is given. The overview provides background information and also establishes the existing research which has been done in these fields. Due to its popularity, the Windows Internet Connection Firewall is analysed in this research. Based on the criteria a level of trust fostered between the user and interface is calculated for the firewall. It is then shown how this level of trust can be improved by modifying the interface. A proposed interface for the firewall is presented according to the criteria. Interfaces found in the online Internet environment are discussed. This is important in order to identify the similarities and differences between traditional software interfaces and web interfaces. Due to these differences the criteria are modified to be relevant in the analysis and design of security interfaces found on the Internet. Three South African online banking websites are analysed according to the modified framework. Each interface is broken down into a number of components which are then analysed individually. The results of the analysis are compared between the three banking sites to identify the elements which make up a successful interface in an online banking environment. Lastly, three interfaces of e-commerce websites are analysed. Recommendations are made on how the interfaces can be improved, thus leading to a higher level of trust.
Labuschagne, L., Prof.

This research looks at the use of PowerPoint as an instructional tool for teaching English language learners (ELL) who studied in a language program at a state university in the Pacific Northwest. The purpose of the research was to discover and to explore the perceptions of PowerPoint supported teaching and learning that were held by the students, the instructors, and the student researcher. PowerPoint is one of the most commonly used technologies in classrooms, and its projection on screens has become a fundamental part of many students' daily routine. The basic design of this research study is based on Stringer's (2004) action research model, which operates on a repeated circle of reflecting, planning, acting and observing. This action research was generated by all participants, guided by instructors, and monitored by the planned objectives of the study's outcomes. A constructivist approach was used to understand the process of teaching and learning with PowerPoint, and feedback (questionnaires, interviews, and personal communications) was collected from the students in order to help instructors and the student researcher to determine the students' needs. There are four main sets of data in this study—data from students' questionnaires, from students' interviews, from instructors' interviews, and from the student researcher's classroom observations. Students were given questionnaires at the ends of weeks two to ten, and two students from each class were selected to be interviewed. Instructors were interviewed both at the beginning and at the end of the term. The student researcher observed all classes starting week two, and wrote notes which were included as part of the data.
Graduation date: 2012