There has been a surge of new databases in recent years. Applications today create a higher demand on database performance than ever before. Main-memory databases have come into the market quite recently and they are just now catching a lot of interest from many different directions. Main-memory databases are a type of database that stores all of its data in the primary memory. They provide a big increase in performance to a lot of different applications. This work evaluates the difference in performance between two chosen candidates. To represent main memory databases we chose VoltDB and to represent traditional databases we chose MySQL. We have performed several tests on those two databases. We point out differences in functionality, performance and design choices. We want to create a reference where anyone that considers changing from a traditional database to a main memory database, can find support for their decision. What are the advantages and what are the disadvantages of using a main-memory database, and when should we switch from our old database to a newer technology.

This is the end report of my final exam at Medieteknik. It covers the planning, work process and review of a Flash based web application that I set out to do. The goal was to create a user friendly, interactive e-shop with embedded functionality for playing music, displaying rich media content and researching possible payment solutions, to enable buying music files online. The project involved creating the user interface, the programmatic functionality of a Flash client (an SWF file). Also, setting up an Apache HTTP Server and establishing a working “bridge” between the Flash client and the web server with Flash Remoting components and AMFPHP. Furthermore, a web interface for adding music files and data to the server was created, built in HTML, CSS, JavaScript, PHP and MySQL. The project consisted of researching and implementing the technologies and techniques involved by iteratively collecting information, reading, testing, programming and evaluating the end results. Also, object oriented design and programming principles was applied in the development process. The software development methodologies – Agile development and extreme programming was practiced. The purpose was to gain experience in developing large scale client/server web applications dealing with creative processes, project planning, project management and problem solving. And in the longer perspective make use of the experience and knowledge in future projects. / Jag hade en idé om att skapa en e-shop med fokus på användarvänlighet och interaktivitet. Detta ledde till en klient/server-applikation med funktioner för att lyssna på musik och söka efter- och ta del av musikinformation. Syftet var att ge användare möjlighet att köpa musik i form av nedladdningsbara MP3-filer. Applikationen är huvudsakligen indelad i tre sektioner, en meny överst; en musikspelare placerad på vänster sida; och en s.k. content-del, ett slags fönster där all text och bildbaserat innehåll presenteras. Gränssnittets utformning är rent och enkelt med tydliga knappar och menyer för enkel navigation. Musik kan förhandslyssnas, och spelas upp med hjälp av en inbyggd musikspelare. Tanken är att ljudet ska kunna spelas upp i realtid från servern, dvs. strömmas. Detta medför att data inte lagras hos klienten och syftet är alltså att användaren ska kunna förhandslyssna på den musik han eller hon är intresserad av att köpa, men till sämre ljudkvalitet än den köpta MP3-filen. En display visar artistens eller gruppens namn, låtnamn, spelad tid, och total tid. Vidare finns knappar för att spela upp, stoppa, pausa och spela nästa respektive föregående låt. Slutligen finns ett reglage för att kunna styra spelposition. Som ett led i att förenkla köp av musik kan en spellista fyllas med valda låtar. Låtarna i denna lista kan man sedan köpa i ett svep eller var för sig. Detta innebär att användaren slipper leta upp en låt i taget, och lyssna på dem vart efter varandra. Ett webbformulär byggdes för att kunna tillhandahålla uppladdning och lagring av musikfiler och musikinformation. Webbformuläret är byggt i teknikerna HTML, CSS, PHP och JavaScript. Den innehåller en dynamiskt genererad tabell för att underlätta insättning av låtar. Webbformuläret kan med fördel utnyttjas av godkända parter (skivbolag, artister…), för att ladda upp och lagra musikfiler på servern. Detta resulterar i en arbetsbesparande process eftersom arbetsbördan fördelas till extern part. All musikinformation, så som artistnamn, låtnamn, utgivningsdatum, etc. lagras och hämtas från en MySQL-databas. Musikfiler lagras och spelas upp från filsystemet i en Apache HTTP Server. Applikationen utgörs av flera skikt. Det innebär att den är uppdelad i flera separata delar. En del består av gränssnittet, en SWF-fil som användaren kommer åt genom sin webbläsare. Gränssnittet opererar gentemot data som ligger lagrat på en webbserver. Vidare finns speciell programkod på servern för att ta emot-, skicka respektive manipulera data. Två typer av datalager används för att möjliggöra kommunikation av data mellan Flashklient (gränssnitt) och server – Flash Remoting och AMFPHP. Flash Remoting är ett slags kommunikationsprotokoll som Flashklienten använder för att kommunicera med server. AMFPHP används för att ”tolka” Flashkod som sänds via HTTP till server. AMFPHP omvandlar denna till, för servern, läsbar server-sidekod – PHP, som i sin tur kan manipulera data på servern, t.ex. lagra data i databasen. När data skickas till Flashklienten, omvandlar AMFPHP data till, för Flashfilen, läsbar kod. En stor del av projektet har varit av undersökande natur. Målet var att erhålla tekniska kunskaper i Flashmiljön för att kunna utveckla interaktiva webbapplikationer. Kunskap har inhämtats via litteratur i bokform, det inbyggda hjälpbiblioteket i Adobe Flash 8 Professional mjukvara, samt från internet, bland en mängd olika forum och webbsidor. Utvecklingsarbetet har bestått av en kombination av rörlig utveckling och extrem programmering. / +46 (0)708 38 08 03 guild2000@hotmail.com

Magister Scientiae - MSc / Many Single Nucleotide Polymorphisms (SNPs) found in coding or regulatory regions within the human genome lead to phenotypic differences that make prediction of physical appearance, based on genetic analysis, potentially useful in forensic investigations. Complex traits such as pigmentation can be predicted from the genome sequence, provided that genes with strong effects on the trait exist and are known. Phenotypic traits may also be associated with variations in gene expression due to the presence of SNPs in promoter regions. In this project, the identification of genes associated with these physical traits of potential forensic relevance have been collated from the literature using a text mining platform and hand curation. The SNPs associated with these genes have been acquired from public SNP repositories such as the International HapMap project, dbSNP and Ensembl. Characterization of different population groups based on the SNPs has been performed and the results and data stored in a MySQL database. This database contains SNP genotyping data with respect to physical phenotypic differences of forensic interest. The potential forensicrelevance of the SNP information contained in this database has been verified through in silico SNP analysis aimed at establishing possible relationships between SNP occurrence and phenotype. The software used for this analysis is MATCH™. Data management and access has been enhanced by the use of a functional web-based front-end which enables the users to extract and display SNP information without running complex Structured Query Language (SQL) statements from the command line. This Forensic SNP Phenotype resource can be accessed at http://forensic.sanbi.ac.za/alecia_forensics/Index.html / South Africa

This Diploma thesis deals with the analysis and proposal of the pilot BI solution for the company Svoboda & Partner CZ s.r.o., engaged in the automechanic expertise. Fundamental objectives of this work focus particularly on the above mentioned pilot BI solutions and partial objectives deal with an analysis of the company and its needs, arising from business strategy and market analysis applications available to support the visualization of transaction reporting. These objectives have been achieved by analyzing the company's business model in chapter seven, further analysis of needs and problems within the company in chapter eight. Before the analysis, the diploma thesis deals with a survey of available applications that offer functionality of dynamically generated graphs to aid visualization of transaction reporting in chapter six and finally a major analysis and preparation of pilot BI and transaction reporting for this business which you can find from chapter 9 to chapter eleven. Contribution of this work for the company will be a complete analysis and delivery of all necessary documents in order to decide whether the above BI solutions to the company implement or not. In the case of a positive decision of the company, it is expected that thanks to BI solutions the ways of looking at corporate data can be more expanded, more precise and more operational management of the company, achieving better performance, higher profits and more efficient decision-making based on better data for decision making.

This paper focuses on NoSQL database systems. These systems currently serve rather as supplement than replacement of relational database systems. The aim of this paper is to compare 4 selected NoSQL database systems (MongoDB, Apache Cassandra, Apache HBase and Redis) with a main focus on performance and scalability. Performance comparison is done using simulated workload in a 4 nodes cluster environment. One relational SQL database is also benchmarked to provide comparison between classic and modern way of maintaining structured data. As the result of comparison I found out that none of these database systems can be labeled as "the best" as each of the compared systems is suitable for different production deployment.

This thesis discusses the design of API interface for applications for IT STUDIO s.r.o. and of the e-commerce calendar, using the API. In the introduction, there is described the system of the World Wide Web and its most important parts, including the possible protocols for implementing interfaces. The next part deals with the specifcation, analysis, interface design and application design. The implementation section describes used libraries and chosen solutions, including the description of possible alternatives.

The master's thesis deals with the design of a universal web portal, which will allow any information system of a selected company to be interconnected with any information system of suppliers and customers. The web portal will contain information about availability, product pricing, and offers modules such as managing business partners accounts, creating special offers and ordering pre-selected products. Implementation is performed in PHP with MySQL database support. The partial aim of this master's thesis is to deploy the designed portal in the chosen company and for its business partners.

This diploma thesis deals with the research of existing solutions of electronic information systems. The purpose of this survey is to inspire what is offered to users of these professional systems, or what users expect from these systems. Based on the acquired knowledge, the thesis also deals with the design of its own system, which can serve as another alternative to professional solutions of companies on the market, in the sense of the concept of solution of the given task. After the design of the system, the thesis deals chronologically with the selected "tools" used for the actual implementation of the assigned task Electronic Information Boards. Both hardware and software parts of the task, which form the majority of this thesis. At the end of the work are presented practical results.

This thesis handles about informative technologiesthat the find exercise in health sector. Below conception electronic health service we can introduce systemsthat the expressive in a way castigate and largely oversimplify work doctors with reference to legislature in Czech republic. On this account are pick out only such sizes compatibility use it electronic health documentation (so - called datal standards), which guarantee the quality technical protection and safeguard personal data before pertinent misuse. Part those diploma work work handles about proposal Internet health system realized by the help of web interface, making use programmatic languages HTML, CSS, PHP and database system MySQL. Information system makes it possible to distant repair and administration patients' data. For example browsing anamneses, diagnosis, medicines, survey doctors, medical arrangement and laboratory values. Next his feature is compatibility with informative system IZIPthat the will prove send round news in language XML.

The thesis contains complete design of complex system for acquisition of data from bus of a vehicle. It resolves problems of connection of a new node to CAN bus of a vehicle, communication protocol NMEA 0183 of GPS receivers, logging of caught CAN frames into database system MySQL, and proposes algorithms of application for operation of the system. It includes also process of complete installation based on established concept and test results of the system in real situations.