Big data of type spatial is growing exponentially with the highest rate due to extensive growth in usage of sensors, IoT and mobile devices’ spatial data generation, therefore maintaining, processing and using such data efficiently, effectively with high performance has become one of the top priorities for Database management system providers, hence spatial database features and datatypes have become serious criteria in evaluating database management systems that are supposed to work as the back-end for spatial applications and services. With exponential growth of data and introducing of new types of data, “Big Data” has become strongly focused area that has gained the attention of different sectors e.g. academia, industries and governments to other organizations and studies. The rising trend in high resolution and large-scale geographical information systems have resulted in more companies providing location-based applications and services, therefore finding a proper database management system solution that can support spatial big data features, with multi-model big data support that is reliable and affordable has become a business need for many companies. Concerning the fact that choosing proper solution for any software project can be crucial due to the total cost and desired functionalities that any product could possibly bring into the solution. Migration is also a very complicated and costly procedure that many companies should avoid, which justifies the criticality of choosing the right solution based on the specific needs of any organization. Companies providing spatial applications and services are growing with the common concern of providing successful solutions and robust services. One of the most significant elements that ensures services’ and hence the providers’ reputation and positive depiction is services’ high availability. The possible future work for the thesis could be to develop the framework into a decision support solution for IT businesses with emphasize on spatial features. Another possibility for the future works would be to evaluate the framework by testing the evaluation framework on many other different DBMSs.

Knowing which database management system to use for a project is difficult to know in advance. Luckily, there are tools that can help the developer apply the same database design on multiple different database management systems without having to change the code. In this thesis, we investigate the strengths of SQLAlchemy, which is an SQL toolkit for Python. We compared SQLite, PostgreSQL and MySQL using SQLAlchemy as well as compared a pure MySQL implementation against the results from SQLAlchemy. We conclude that, for our database design, PostgreSQL was the best database management system and that for the average SQL-user, SQLAlchemy is an excellent substitution to writing regular SQL.

Foi estruturado um modelo de servidor de mapas, na plataforma MapGuide, capaz de disseminar eletrônicamente os dados geoespaciais gerados pela Prefeitura de Taboão da Serra SP. O projeto de servidor visou duas finalidades principais: implementar este tipo de tecnologia ao analista responsável pelo projeto, no âmbito da Prefeitura, e; tornar a dissertação um guia teóricometodológico introdutório a profissionais da Cartografia e Geociências, não especializados com este ramo das geotecnologias. O serviço de disseminação foi configurado para servir dados geoespaciais diretamente a navegadores de rede, servidores FTP e Sistemas de Informação Geográfica (SIG). Para estes últimos, foram utilizados recursos de acesso a dados localizados em servidores de mapas remotos, por meio dos serviços de Web Mapping Service (WMS) e Web Feature Service (WFS). Enquanto a disseminação em navegador de rede pode alcançar usuários não especializados com este campo das geotecnologias, a utilização de servidores FTP, serviços WMS e WFS remotos, favorece usuários técnicos das Geociências e Cartografia. Comparou-se as funcionalidades do MapGuide, a SIG de primeira e segunda geração, com funções topológicas completas. Concluiu-se que o servidor de mapas não possuía a mesma capacidade de análise espacial dos SIG topológicos. / A Web Mapping application built on MapGuide was designed to digitally serve the municipal government of Taboão da Serra SP geospatial data. There were two aims related to the application project: to implement the technology to the analyst responsible for the project, and; to develop the project content as an introdutory theoretical-methodological guide to geoscientists and cartographers not specialized in the internet mapping field. The geospatial data dissemination services were configured to web browsers, FTP servers and Geographic Information Systems (GIS). For these lasts, data access resources to remote spatial servers were used, via Web Mapping Services (WMS) and Web Feature Services (WFS). While the web browser data dissemination is suitable for non-technicians, the FTP server, WMS and WFS resources, are best suitable for GIS analysts. A comparison between MapGuide functionalities with other first and second generation topological GIS softwares was performed. The conclusion revealed the web mapping application didn\'t have the same spatial analysis capabilities as the topological GIS.

3D GIS is the key point of the development in the area in geospatial information domain. 3D visualization techniques, including 3D terrain data processing, the 3D objects modelling , satellite or air photo image texture, model material, level-of-detail terrain, is already gradually mature and had the outstanding performance in the existing 3D GIS software. But 3D spatial analysis function was still lacking in the field of the 3D spatial data processing. The goal of this research is to develop a 3D spatial analysis function for sun shadow in horizontal and vertical direction and to construct a system for 3D geographic objects visualization by using MFC and OpenGL as the development kit. It has some fundamental functions including: camera control, selecting a single face of a object, linking to a database, level-of-detail terrain. The shadow volume algorithm was used for 3D shadow visualization, and light tracing algorithm was used to compute a single face¡¦s culling area, finally sunshine formula of four seasons was utilitized to realize the shadow analysis function.

<p>This thesis paper introduces you about the process of how to build an inventory tracking system in a local Swedish company. The related project is to support the thesis paper, and is also for the company’ using. The software product of this project is an application that works for managing various types’ instruments in the company of SWECO-Vaxjo. It will play an important role in the further management work of the company.</p><p>In this thesis paper, the candidate techniques and theories for implementing this system are discussed. And in the end a good solution for this problem will be presented in the paper.</p>

Modern DBMSes are designed to support many transactions running simultaneously. DBMS thrashing is indicated by the existence of a sharp drop in transaction throughput. The thrashing behavior in DBMSes is a serious concern to DBAs engaged in on-line transaction processing (OLTP) and on-line analytical processing (OLAP) systems, as well as to DBMS implementors developing technologies related to concurrency control. If thrashing is prevalent in a DBMS, thousands of transactions may be aborted, resulting in little progress in transaction throughput over time. From an engineering perspective, therefore, it is of critical importance to understand the factors of DBMS thrashing. However, understanding the origin of modern DBMSes' thrashing is challenging, due to many factors that may interact. The existing literature on thrashing exhibits the following weaknesses: (i) methodologies have been based on simulation and analytical studies, rather than on empirical analysis on real DBMSes, (ii) scant attention has been paid to the associations between factors, and (iii) studies have been restricted to one specific DBMS rather than across multiple DBMSes. This dissertation aims at better understanding the thrashing phenomenon across multiple DBMSes. We identify the underlying causes and propose a novel structural causal model to explicate the relationships between various factors contributing to DBMS thrashing. Our model derives a number of specific hypotheses to be subsequently tested across DBMSes, providing empirical support for this model as well as engineering implications for fundamental improvements in transaction processing. Our model also guides database researchers to refine this causal model, by looking into other unknown factors.

Veiklos analizavimas bei sprendimų priėmimas labai svarbus šiandieninėje įmonių veikloje. Norėdamos atlikti veiklos statistinę analizę, įmonės perka brangius ir sudėtingus produktus nesigilindamos apie tų produktų nauda įmonės veikloje. Vienas iš sprendimo būdų kaip efektyviai atlikti statistinę duomenų analizę neinvestuojant didelių resursų – naudoti standartines DBVS statistines priemones. Šiomis priemonėmis įmonės gali atlikti įvairią statistinę analizę kasdienėje veikloje naudojant statistinės analizės metodus: linijinę regresiją, koreliacijos analizę, nuspėjamąją duomenų analitika, Pareto analitika, Chi kvadrato analitika, ANOVA. / This work reviews advantages and disadvantages of existing statistical analysis tools usage for small and mid sized enterprises, explores usage of statistical analysis of enterprise data in data warehouse, reviews integrated statistical analysis functions in existing database management systems and integrated graphical software for graphical statistical analysis usage. In this work were analyzed Oracle, Microsoft SQL Server and DB2 DBMS. The new statistical analysis solution was offered. This solution allows statistical analysis of existing data using integrated statistical functions of the database management systems and integrated graphical tool. Proposed solution has been designed and realized for the statistical analysis of insurance company‘s data. Oracle DBMS was selected for statistical analysis, because this DBMS is used by insurance company. Oracle has a large number of integrated statistical analysis functions; it ensures more diverse and rapid analysis. Graphic depiction of the selected Oracle Discoverer tool to optimally exploit data analysis potential of Oracle DBMS. The proposed statistical analysis process is versatile and suitable for different business areas and can be applied to other DBMS, which has an integrated analytical functions and graphical tools for the results display.

Most of the common DBMS (ORACLE, Microsoft SQL Server, MySQL, DB2, etc.) use disk storage as run time memory. When data becomes necessary from database, DBMS reads them from disk and loads it to RAM (Random Access Memory). This approach uses small amount of RAM, but DBMS efficiency is relative poor. In this work was created prototype of DBMS. This prototype is read-only DBMS and holds all database data in RAM. The purpose of this work is to compare efficiency of common DBMS against created prototype. For this prototype was developed and optimized bunch of data searching, sorting, grouping, joining algorithms. All of these algorithms are based on the main prototype data model idea: database table stores all data into table tree. Prototype and other DBMS were tested with TPCH test, which consists of very different 22 SQL queries to test DBMS efficiency. The test result produced good results for prototype: prototype was 30-40 times faster against ORACLE on complex joining queries and 100-200 times faster against ORACLE on simple joining and searching queries.

Šiame darbe yra sukurtas ir pasiūlyta architektūra duomenų mainams tarp atviro kodo DBVS ir XML dokumento. Ši sistema leidžia vartotojui XML dokumente aprašyti SQL užklausas.Po to kai bus vykdomas kreipimasis į šį XML dokumentą iš naršyklės, sistema sugeneruos naują XML dokumentą, kuriame bus atvaizduotas XML struktūros dokumentas su duomenim išgautais iš DBVS pagal anksčiau pateiktame XML dokuemnte SQL užklausą (-oms). Ši sistema buvo sukurta, pasinaudojus Microsoft SQLXML programinės įrangos pagrindu, tačiau mūsų sistema turi privalūmą tame, kad saveikauja nesvarbu su kokiom DBVS, t.y. MySQL, Oracle ir t.t. / In this study, has been created software, that support XML documents interfacing with open source data base management systems. This system enables in XML document write SQL query or queries. When this XML document (file) will be requested from internet browser, this system generate a new XML document in which instead placed SQL query or queries, would be inserted generated query answer from data base written in XML format. This system has been created similar as Microsoft product SQLXML. Only our system has a feature, that it interfacing with open source data base management systems, such as MySQL.

Sukurti MySQL duomenų bazių valdymo sistemos duomenų bazių duomenų valdymo sistemą, kuri duomenų perdavimui naudotų REST architektūros principus. REST architektūra gali būti naudojama padidinti įvairių sistemų integravimo galimybes, nes suteikia patogiai prieinamą sąsają prie sistemos funkcionalumo ir duomenų. Tad sukūrus sistemą MySQL DBVS valdymui REST architektūros pagalba, būtų galima kurti sistemas, kurios naudojasi kitų tiekėjų duomenimis. / REST architecture allows easier collaboration between two systems, as provided an easy way to call necessary functions in remote system and to get desired results. Such systems as Amazon, eBay, Twitter have their own API with support of REST architecture. However the REST architecture is not provided by default in MySQL, therefore additional tools have to be used. The purpose of this work is to design and implement a system, which could be used as a database management tool in REST architecture. Therefore in this thesis a requirement and architecture specifications are provided for such a system. The implemented system is tested and install and configuration manuals are provided.