Database NewSQL performance evaluation for big data in the public cloud

For very years, relational databases have been the leading model for data storage, retrieval and management. However, due to increasing needs for scalability and performance, alternative systems have emerged, namely NewSQL technology. NewSQL is a class of modern relational database management systems (RDBMS) that provide the same scalable performance of NoSQL systems for online transaction processing (OLTP) read-write workloads, while still maintaining the ACID guarantees of a traditional database system. In this research paper, the performance of a NewSQL database is evaluated, compared to a MySQL database, both running in the cloud, in order to measure the response time against different configurations of workloads.Instituto de Investigación en Informátic

Database NewSQL performance evaluation for big data in the public cloud

For very years, relational databases have been the leading model for data storage, retrieval and management. However, due to increasing needs for scalability and performance, alternative systems have emerged, namely NewSQL technology. NewSQL is a class of modern relational database management systems (RDBMS) that provide the same scalable performance of NoSQL systems for online transaction processing (OLTP) read-write workloads, while still maintaining the ACID guarantees of a traditional database system. In this research paper, the performance of a NewSQL database is evaluated, compared to a MySQL database, both running in the cloud, in order to measure the response time against different configurations of workloads.Instituto de Investigación en Informátic

Database NewSQL performance evaluation for big data in the public cloud

For very years, relational databases have been the leading model for data storage, retrieval and management. However, due to increasing needs for scalability and performance, alternative systems have emerged, namely NewSQL technology. NewSQL is a class of modern relational database management systems (RDBMS) that provide the same scalable performance of NoSQL systems for online transaction processing (OLTP) read-write workloads, while still maintaining the ACID guarantees of a traditional database system. In this research paper, the performance of a NewSQL database is evaluated, compared to a MySQL database, both running in the cloud, in order to measure the response time against different configurations of workloads.Instituto de Investigación en Informátic

Listat ja aggregaatio NoSQL-dokumenttivarastossa : tapaus Taitorakennerekisteri

Tässä tutkimuksessa tarkastellaan NoSQL-tietokantojen ja niitä muistuttavien hakukoneiden ilmaisuvoimaa erityisesti alidokumentteihin kohdistuvissa hauissa. NoSQL-tietokannoilla tarkoitetaan relaatiomallista poikkeavia tietokantoja. Dokumentilla tarkoitetaan avain-arvo-pareista koostuvaa tietorakennetta. Dokumentilla voi olla myös dokumenttityyppisiä arvoja tai listatyyppisiä arvoja, jotka sisältävät dokumentteja, joita kutsutaan tässä yhteydessä alidokumenteiksi. Tutkimuksen menetelminä ovat tapaustutkimus ja konstruktiivinen tutkimus. Tarkasteltavana tapauksena tutkimuksessa on Liikenneviraston Taitorakennerekisteri-tietojärjestelmän hakutoiminnallisuus, joka pohjautuu Elasticsearch-hakukoneeseen. Tutkimuksessa halutaan vastata siihen, miten yleisesti NoSQL-tietokannoilla ja erityisesti Elasticsearchilla voi toteuttaa alidokumentteja koskevia hakuja ja toisaalta miten ilmaisuvoimainen haku toteutuu tarkastellun tapauksen tietojärjestelmässä. Tutkimuksessa kartoitetaan, miten kirjallisuudessa on käsitelty NoSQL-tietokantoja ja niiden ilmaisuvoimaa alidokumentteihin kohdistuvissa ja aggregaatiota hyödyntävissä hauissa. Tutkimuksen konstruktiivisessa osuudessa toteutettiin hakutoiminnallisuuden laajennus Taitorakennerekisteri-järjestelmään, jolla on tarkoitus parantaa haun ilmaisuvoimaa

A real time urban sustainability assessment framework for the smart city paradigm

Cities have proven to be a great source of concerns on their impact on the world environment and ecosystem. The objective, in a context where environmental concerns are growing rapidly, is no longer to develop liveable cities but to develop sustainable and responsive cities. This study investigates the currently available urban sustainability assessment (USA) schemes and outlines the main issues that the field is facing. After an extensive literature review, the author advocates for a scheme that would dynamically capture urban areas sustainability insights during their operation, a more user-centred and transparent scheme. The methodological approach has enabled the construction of a solid expertise on urban sustainability indicators, the essential role of the smart city and the Internet of Thing for a real-time key performance indicators determination and assessment, and technical and organisational challenges that such solution would encounter. Key domains such as sensing networks, remote sensing and GIS technologies, BIM technologies, Statistical databases and Open Governmental data platform, crowdsourcing and data mining that could support a real-time urban sustainability assessment have been studied. Additionally, the use of semantic web technologies has been investigated as a mean to deal with sources heterogeneity from diverse data structures and their interoperability. An USA ontology has been designed, integrating existing ontologies such as SSN, ifcOWL, cityGML and geoSPARQL. A web application back-end has then been built around this ontology. The application backbone is an Ontology-Based Data Access where a Relational Database is mapped to the USA ontology, enabling to link sensors data to pieces of information on the urban environment. Overall, this study has contributed to the body of knowledge by introducing an Ontology-Based Data Access (OBDA) approach to support real-time urban sustainability assessment leveraging sensors networks. It addresses both technical and organisational challenges that the smart systems domain is facing and is believed to be a valuable approach in the upcoming smart city paradigm. The solution proposed to tackle the research questions still faces some limitations such as a limited validation of the USA scheme, the OBDA limited intelligence, an improvable BIM and cityGML models conversion to RDF or the lack of user interface. Future work should be carried out to overcome those limitations and to provide stakeholders a high-hand service