The problems associated with the effective design and uses of databases are increasing. The information contained in a database is becoming more complex and the size of the data is causing space problems. Technology must continually develop to accommodate this growing need. An inquiry was conducted in order to find effective guidelines that could support queries in general in terms of performance and productivity. Two database management systems were researched to compare die theoretical aspects with the techniques implemented in practice. Microsoft SQL Sewer and MySQL were chosen as the candidates and both were put under close scrutiny. The systems were researched to uncover the methods employed by each to manage queries. The query optimizer forms the basis for each of these systems and manages the parsing and execution of any query. The methods employed by each system for storing data were researched. The way that each system manages table joins, uses indices and chooses optimal execution plans were researched. Adjusted algorithms were introduced for various index processes like B+ trees and hash indexes. Guidelines were compiled that are independent of the database management systems and help to optimize relational databases. Practical implementations of queries were used to acquire and analyse the execution plan for both MySQL and SQL Sewer. This plan along with a few other variables such as execution time is discussed for each system. A model is used for both database management systems in this experiment. / Thesis (M.Sc. (Computer Science))--North-West University, Potchefstroom Campus, 2007.

Δημιουργία του ιστότοπου της κυτταρολογικής Βάσης Δεδομένων Φυτών PhytoKaryon, η οποία περιέχει καρυολογικά δεδομένα των φυτών της Μεσογείου και της Ευρώπης. Υλοποιήθηκε σε περιβάλλον PHP, MySQL και Apache Server. Παρουσιάζει τα αποτελέσματα της αξιοποίησης της Βάσης Δεδομένων από την πλευρά του διαχειριστή του Ιστότοπου. / The creation of the site of the cytologic Plants' Data Base PhytoKaryon, which contains karyological data of plants of Mediterranean and Europe. It was implemented in PHP, MySQL and Apache Server environment. It presents the results of exploitation of Data Base from the side of site's administrator.

Η παρούσα διπλωματική εργασία πραγματεύεται τον σχεδιασμό και την υλοποίηση συστήματος για ηλεκτρονικές προμήθειες. Ως ηλεκτρονική προμήθεια ορίζεται η διαδικασία με την οποία ένας φορέας προμηθεύεται τις υπηρεσίες και τα αγαθά που τον ενδιαφέρουν με την χρήση σύγχρονων διαδικτυακών και υπολογιστικών υπηρεσιών. Ο φορέας που μελετάται εδώ είναι ένα νοσοκομείο. Οι ηλεκτρονικές προμήθειες είναι ένα είδος ηλεκτρονικού εμπορίου, συνεπώς πρώτα γίνεται μία θεωρητική ανάλυση του ηλεκτρονικού εμπορίου και έπειτα των ηλεκτρονικών προμηθειών. Εν συνεχεία παρατίθεται η υλοποίηση ενός συστήματος ηλεκτρονικών προμηθειών, δηλαδή η σύσταση ενός ιστότοπου, ο οποίος περιέχει όλες τις απαραίτητες λειτουργίες για τη δημιουργία και διεξαγωγή ηλεκτρονικών διαγωνισμών. Στο σύστημα αυτό που δημιουργήθηκε υπάρχουν δύο κύρια είδη χρηστών, οι απλοί χρήστες και οι διαχειριστές. Οι απλοί χρήστες μπορούν να δουν τους ενεργούς διαγωνισμούς και να υποβάλουν προσφορά σε όσους διαγωνισμούς τους ενδιαφέρουν. Οι διαχειριστές διευθύνουν τον ιστότοπο και είναι υπεύθυνοι για την προκήρυξη και διεξαγωγή των διαγωνισμών. Επίσης, ευθύνη των διαχειριστών είναι η αξιολόγηση των προσφορών που έχουν γίνει στους διαγωνισμούς και με βάση κριτήρια όπως το ποσό προσφοράς και η ημερομηνία παράδοσης των προϊόντων συνυπολογίζεται η προτιμότερη προσφορά. Για την δημιουργία του ιστότοπου χρησιμοποιήθηκαν μόνο Open Source εργαλεία. Συγκεκριμένα για τη δημιουργία δυναμικών ιστοσελίδων χρησιμοποιήθηκαν οι γλώσσες HTML, PHP και JavaScript, για την δημιουργία και διαχείριση της βάσης δεδομένων η γλώσσα MySQL και για το στήσιμο ενός εικονικού διακομιστή στον οποίο θα τρέχει ο ιστότοπος χρησιμοποιήθηκε ο εξυπηρετητής παγκόσμιου ιστού Apache. / This thesis discusses the design and implementation of an e-procurement system. E-procurement is defined as the process by which an entity procures services and goods that are of interest by using modern computing and internet services. The organization studied here is a hospital. Electronic procurement is a type of electronic commerce, thus a theoretical analysis of e-commerce and e-procurement is made. The implementation of an electronic procurement system is then presented specifically about the establishment of a website that contains all the necessary functions for creating and conducting electronic contests. The created system has mainly two kinds of users, ordinary users and administrators. Ordinary users can see the active contests and bid to those who are interested in. Administrators manage the site and are responsible for creating and conducting contests. Also, they have the responsibility of evaluating the offers made, and based on criteria such as the bid amount and the delivery date of products they conclude to the preferred bid. To create the site only Open Source tools were used. Specifically for creating dynamic web pages, HTML, PHP and JavaScript languages were used. In order to create and manage the database, MySQL language was used and setting up a virtual server that will run the site was implemented by the web server Apache.

Web development is a challenging task and it’s easy to neglect feedback from users in development stages. That’s why the aim is to create a tool which would help the communication between developers and users by using A/B-testing. The idea is to let developers release two choices containing images, which would be the intended design changes. By letting the users vote for the preferred option, they will be able to provide some feedback for the developers. Response times becomes a critical factor for the tool’s overall success. Therefore, this study compares MySQL and PostgreSQL through a technical experiment to see which database would be the better option regarding the image processing. The experiment indicated that PostgreSQL would the better alternative regarding the subject, as it had the most responsive processing of images. This prototype provides a good foundation for a potentially useful system that could be implemented in future work.

Subject of this thesis is creation of a Web application aiming to offer an alternative to desktop and mobile applications testing possibilities. In the theoretical part we acquire a basic overview of the principles of software testing and its possible use in crowdsourcing test projects. In the practical part the functionality of the web application and its data structure is designed. On the basis of the created design and gained knowledge of software testing the application is then implemented.

The master´s thesis pays attention to the information system dealing with the procession of insolvency proposals. This requirement originated in the terms and conditions of the prepared amendment to the act on insolvency. The first part analyses the existing system of procession. The demands for the information system are formulated based on the foundout facts. The second part describes the proposed solution by means of charts depicting examples of use, and a process and checking chart processed in the Enterprise Architect programme. The third part includes a description of the information system implementation. The information system has been programmed by means of the PHP scripting language using the Nette framework and the MySQL database. The FPDF and FPDL libraries were used to generate the insolvency proposal in PDF. This system respects the valid legislation, facilitating the work and saving the costs related to the procession of insolvency proposals.

The diploma thesis is focused on the design and implementation of application for business trips's administration. The aim of this thesis is to familiarize the readers with the issue of business trips from the economic and financial point of view, with the basics of information systems and with the designing of diagrams in UML's notation. From the practical point of view this thesis deals with the design of database and application which should be helpful for automation of the creation and approval business trip's process and also deals with the administration of all created business trips. The outcome of this thesis is the design of UML's diagrams and implementation of application for business trips's administration in C# programming language.

The theoretical part of this thesis is devoted to familiarization with the technology of cloud computing, virtualization technology, data storage problems and Petri nets. Followed by the practical part, the first part discusses the various technologies which are VMware ESX, Citrix Xen, Hyper -V, KVM and oVirt. The following part is a summary of the characteristics of each technology and an output of this summary is a decision tree which is intended to help to select the appropriate virtualization technology. The second part is dedicated to the implementation of an application used for storing data in the database depending on the sensitivity of data. The thesis includes the final economic evaluation and discussion as well.

Syftet med arbetet som beskrivs i denna rapport var att undersöka om den Oracle-baserade laborationsmiljö som användes hos ADIT gick att överföra till MySQL. Oracle är ett komplext system som är krävande att administrera, något som ADIT ansvarat för med egen personal och egen hårdvara och detta var inte idealiskt. I kombination med ett stort intresse från studenter att använda just MySQL vid laborationer hos ADIT beslutades det att man skulle undersöka om MySQL nu var moget att axla den roll som Oracle tidigare haft. Utifrån detta går rapporten igenom vad som behövde göras med det befintliga laborationsmaterialet. En introduktion till relations¬modellen och SQL samt förklaringar av skillnader i features mellan Oracle och MySQL som hade betydelse för laborationerna återfinns också. Det visade sig att överföringen var enkel att göra och sist i rapporten sammanställs våra erfarenheter.

Denna rapport återspeglar framtagandet av ett företags webbplats. Då själva utvecklandet av webbplatsen har varit en praktisk tillämpning så tar rapporten snarare upp utvecklingen på ett mer teoretiskt plan i form av en fallstudie. Vilka tekniker och metoder som har använts i det praktiska arbetet, såsom användbarhet, semantisk uppmärkning och agila utvecklingsmetoder, har förklarats samtidigt som dess funktionalitet vävts in i arbetets olika implementeringsfaser. Då också ett specialanpassat CMS (innehållshanteringssystem för redigering av webbplatsens innehåll) har utvecklats för webbplatsen så beskriver rapporten också arbetet kring detta.