New Perspectives for NoSQL Database Design: A Systematic Review

The use of NoSQL databases has increasingly become a trend in software development, mainly due to the expansion of Web 2.0 systems. However, there is not yet a standard to be used for the design of this type of database even with the growing number of studies related to this subject. This paper presents a systematic review looking for new trends regarding strategies used in this context. The result of this process demonstrates that there are still few methodologies for the NoSQL database design and there are no design methodologies capable of working with polyglot persistence

An Access Control Model for NoSQL Databases

Current development platforms are web scale, unlike recent platforms which were just network scale. There has been a rapid evolution in computing paradigm that has created the need for data storage as agile and scalable as the applications they support. Relational databases with their joins and locks influence performance in web scale systems negatively. Thus, various types of non-relational databases have emerged in recent years, commonly referred to as NoSQL databases. To fulfill the gaps created by their relational counter-part, they trade consistency and security for performance and scalability. With NoSQL databases being adopted by an increasing number of organizations, the provision of security for them has become a growing concern. This research presents a context based abstract model by extending traditional role based access control for access control in NoSQL databases. The said model evaluates and executes security policies which contain versatile access conditions against the dynamic nature of data. The goal is to devise a mechanism for a forward looking, assertive yet flexible security feature to regulate access to data in the database system that is devoid of rigid structures and consistency, namely a document based database such as MongoDB

Semantic Support for Log Analysis of Safety-Critical Embedded Systems

Testing is a relevant activity for the development life-cycle of Safety Critical Embedded systems. In particular, much effort is spent for analysis and classification of test logs from SCADA subsystems, especially when failures occur. The human expertise is needful to understand the reasons of failures, for tracing back the errors, as well as to understand which requirements are affected by errors and which ones will be affected by eventual changes in the system design. Semantic techniques and full text search are used to support human experts for the analysis and classification of test logs, in order to speedup and improve the diagnosis phase. Moreover, retrieval of tests and requirements, which can be related to the current failure, is supported in order to allow the discovery of available alternatives and solutions for a better and faster investigation of the problem.Comment: EDCC-2014, BIG4CIP-2014, Embedded systems, testing, semantic discovery, ontology, big dat

A New Model for Testing CRUD Operations in a NoSQL Database

NoSQL databases provide high availability and efficiency in data processing but at the expense of weaker consistency. In this paper, we propose a new approach in order to test NoSQL key/value databases in general and their CRUD operations in particular. We design a new context-aware model that takes into account the contextual requirements of clients (users) and the NoSQL database system. Accordingly, we develop a transaction model and testing criteria in order to test NoSQL databases by taking into account transactional and nontransactional CRUD operations. Results from testing criteria are used to analyse the trade-off between availability and consistency of NoSQL databases. In addition, these are used to help NoSQL database users and developers to choose between transactional and non-transactional CRUD operations.

Teaching Tip: Teaching NoSQL Databases in a Database Course for Business Students

NoSQL databases have been used in organizations for decades. Few database textbooks on the market, however, have suitable materials about NoSQL beyond general introductions for typical business students. In fact, users of the typical NoSQL systems on the software market need to have certain computer programming skills. This teaching tip introduces a small unit on NoSQL databases in a traditional database course for students in all business majors. The unit uses a Microsoft Excel-based NoSQL database example to explain the basis of NoSQL, describes the four essential types of NoSQL databases, and discusses representative NoSQL database management systems on the software market. As this unit does not require computer programming skills, it can be easily integrated into an existing relational database course for business students. The unit was tested twice. Students have demonstrated positive first-hand practice experiences of NoSQL beyond general concepts of NoSQL

Database management system performance comparisons: A systematic literature review

Efficiency has been a pivotal aspect of the software industry since its inception, as a system that serves the end-user fast, and the service provider cost-efficiently benefits all parties. A database management system (DBMS) is an integral part of effectively all software systems, and therefore it is logical that different studies have compared the performance of different DBMSs in hopes of finding the most efficient one. This study systematically synthesizes the results and approaches of studies that compare DBMS performance and provides recommendations for industry and research. The results show that performance is usually tested in a way that does not reflect real-world use cases, and that tests are typically reported in insufficient detail for replication or for drawing conclusions from the stated results.Comment: 36 page

Revisión bibliográfica sobre la factibilidad de la base de datos Neo4j orientado a grafos como alternativa de reemplazo de RDBMS

Neo4 is a NoSQL graph database that has been emerging in the fields of social networks and web applications with high concurrency. The characteristics of supporting technological transactions and a high scalability have been attracting the attention of the academic world. Therefore, this literature review focuses in analyse four research papers developed in USA, Spain, India and Germany. The authors show the results of benchmarking between Neo4j and other models, including relational databases. The aim of this paper is to illustrate the features of Neo4j, the architecture and advantages. Also, the purpose is to identify if Neo4 is a reliable alternative for replacing the RDBMS (Relational Database Management System) and offer suggestions for carrying out better experiments.Neo4j es una base de datos gráfica NoSQL que viene emergiendo en los campos de las redes sociales y las aplicaciones web de alta concurrencia. Las características tecnológicas de soportas transacciones y una alta escalabilidad están atrayendo la atención del mundo académico. Por tanto, esta revisión bibliográfica se enfoca en el análisis de cuatro investigaciones recientes realizadas en Estados Unidos, España, India y Alemania. Los autores muestran los resultados de experimentos de comparaciones entre Neo4j y otros modelos, incluyendo las bases de datos relacionales. El objetivo de este artículo es ilustrar las características de Neo4j, su arquitectura y ventajas. Además, el propósito es identificar si Neo4j es una alternativa confiable para reemplazar a las RDBMS (Sistema de Gestión de Bases de Datos Relacionales). Finalmente, se ofrecen recomendaciones para llevar a cabo experimentos comparativos más precisos