No-FSQL

2016 ◽  
Vol 5 (2) ◽  
pp. 54-63 ◽  
Author(s):  
Ines BenAli-Sougui ◽  
Minyar Sassi Hidri ◽  
Amel Grissa-Touzi
Keyword(s):  
Query Language ◽  
Nosql Databases ◽  
Database Model ◽  
Precise Data ◽  
Hands On ◽  
Ambiguous Data

NoSQL (Not only SQL) is an efficient database model for storing and manipulating huge quantities of precise data. However, most NoSQL databases scale well as data grows and often are flexible enough to accommodate imprecise and ambiguous data. This comprehensive hands-on guide presents fundamental concepts and practical solutions for using fuzziness with NoSQL to deals with fuzzy databases (FDB). In this paper, the authors present a graph-based fuzzy NoSQL model to deal with large fuzzy databases while extending the NoSQL one. The authors consider the cypher declarative query language proposed for Neo4j which is the current leader on this market to querying fuzzy databases.

scholarly journals Performance Benchmarking of Key-Value Store NoSQL Databases

2018 ◽  
Vol 8 (6) ◽  
pp. 5333
Author(s):  
Omoruyi Osemwegie ◽  
Kennedy Okokpujie ◽  
Nsikan Nkordeh ◽  
Charles Ndujiuba ◽  
Samuel John ◽  
...  
Keyword(s):  
Data Storage ◽  
Web Applications ◽  
Query Language ◽  
Research Work ◽  
Database Systems ◽  
Nosql Databases ◽  
Performance Benchmarking ◽  
Nosql Database ◽  
Structured Query Language ◽  
Web Developers

<p>Increasing requirements for scalability and elasticity of data storage for web applications has made Not Structured Query Language NoSQL databases more invaluable to web developers. One of such NoSQL Database solutions is Redis. A budding alternative to Redis database is the SSDB database, which is also a key-value store but is disk-based. The aim of this research work is to benchmark both databases (Redis and SSDB) using the Yahoo Cloud Serving Benchmark (YCSB). YCSB is a platform that has been used to compare and benchmark similar NoSQL database systems. Both databases were given variable workloads to identify the throughput of all given operations. The results obtained shows that SSDB gives a better throughput for majority of operations to Redis’s performance.</p>

MonogDB

2017 ◽  
pp. 64-91
Author(s):  
Sonali Tidke
Keyword(s):  
Management System ◽  
Database Management ◽  
Query Language ◽  
Database Management System ◽  
Management Model ◽  
Nosql Databases ◽  
Performance Indexes ◽  
And Behavior ◽  
Relational Database Management ◽  
Partitioning Technique

MongoDB is a NoSQL type of database management system which does not adhere to the commonly used relational database management model. MongoDB is used for horizontal scaling across a large number of servers which may have tens, hundreds or even thousands of servers. This horizontal scaling is performed using sharding. Sharding is a database partitioning technique which partitions large database into smaller parts which are easy to manage and faster to access. There are hundreds of NoSQL databases available in the market. But each NoSQL product is different in terms of features, implementations and behavior. NoSQL and RDBMS solve different set of problems and have different requirements. MongoDB has a powerful query language which extends SQL to JSON enabling developers to take benefit of power of SQL and flexibility of JSON. Along with support for select/from/where type of queries, MongoDB supports aggregation, sorting, joins as well as nested array and collections. To improve query performance, indexes and many more features are also available.

scholarly journals A hands-on introduction to querying evolutionary relationships across multiple data sources using SPARQL

F1000Research ◽  
2019 ◽  
Vol 8 ◽  
pp. 1822 ◽  
Author(s):  
Ana Claudia Sima ◽  
Christophe Dessimoz ◽  
Kurt Stockinger ◽  
Monique Zahn-Zabal ◽  
Tarcisio Mendes de Farias
Keyword(s):  
Query Language ◽  
Data Sources ◽  
Multiple Sources ◽  
Semantic Web Technologies ◽  
Genome Database ◽  
Web Technologies ◽  
Multiple Data ◽  
Hands On ◽  
Description Framework ◽  
Different Sources

The increasing use of Semantic Web technologies in the life sciences, in particular the use of the Resource Description Framework (RDF) and the RDF query language SPARQL, opens the path for novel integrative analyses, combining information from multiple sources. However, analyzing evolutionary data in RDF is not trivial, due to the steep learning curve required to understand both the data models adopted by different RDF data sources, as well as the SPARQL query language. In this article, we provide a hands-on introduction to querying evolutionary data across multiple sources that publish orthology information in RDF, namely: The Orthologous MAtrix (OMA), the European Bioinformatics Institute (EBI) RDF platform, the Database of Orthologous Groups (OrthoDB) and the Microbial Genome Database (MBGD). We present four protocols in increasing order of complexity. In these protocols, we demonstrate through SPARQL queries how to retrieve pairwise orthologs, homologous groups, and hierarchical orthologous groups. Finally, we show how orthology information in different sources can be compared, through the use of federated SPARQL queries.

Query Languages for Graph Databases

2019 ◽  
pp. 645-659
Author(s):  
Kornelije Rabuzin
Keyword(s):  
Relational Databases ◽  
Query Language ◽  
Main Idea ◽  
Query Languages ◽  
End Users ◽  
The Other ◽  
Graph Database ◽  
Graph Databases ◽  
Nosql Databases ◽  
The Past

In the past few years, many NoSQL databases have emerged, including graph databases. NoSQL databases have certain advantages and they can be used in certain domains as an alternative to relational databases. In order to use graph databases, one needs to be familiar with specific languages like Cypher Query Language (CQL) or Gremlin. However, some statements in CQL can be considered too complex for end users as it is shown later on. Because of that, the main idea of this chapter is to explore two other languages for graph databases. One of them is new and it is used to pose queries visually. Since CQL does not support recursion, views, etc., the other language is used to show how to use recursion and views on a graph database.

Query Languages in NoSQL Databases

2015 ◽  
pp. 415-437 ◽  
Author(s):  
Maristela Holanda ◽  
Jane Adriana Souza
Keyword(s):  
Query Language ◽  
Data Retrieval ◽  
Query Languages ◽  
Nosql Databases ◽  
Different Types ◽  
Application Codes

This chapter aims to investigate how NoSQL (Not Only SQL) databases provide query language and data retrieval mechanisms. Users attest to many advantages in using the NoSQL databases for specific applications, however, they also report that querying and retrieving data easily continues to be a problem. The NoSQL operations require that, during the project, the queries must be thought of as built-in application codes. The authors intend to contribute to the investigation of querying, considering different types of NoSQL databases.

scholarly journals Benchmarking geospatial database on Kubernetes cluster

2021 ◽  
Vol 2021 (1) ◽  
Author(s):  
Bharti Sharma ◽  
Poonam Bansal ◽  
Mohak Chugh ◽  
Adisakshya Chauhan ◽  
Prateek Anand ◽  
...  
Keyword(s):  
Spatial Data ◽  
Query Language ◽  
Research Work ◽  
Nosql Databases ◽  
Geospatial Database ◽  
Computationally Expensive ◽  
Execution Times ◽  
Container Orchestration ◽  
Geospatial Databases ◽  
Geo Database

AbstractKubernetes is an open-source container orchestration system for automating container application operations and has been considered to deploy various kinds of container workloads. Traditional geo-databases face frequent scalability issues while dealing with dense and complex spatial data. Despite plenty of research work in the comparison of relational and NoSQL databases in handling geospatial data, there is a shortage of existing knowledge about the performance of geo-database in a clustered environment like Kubernetes. This paper presents benchmarking of PostgreSQL/PostGIS geospatial databases operating on a clustered environment against non-clustered environments. The benchmarking process considers the average execution times of geospatial structured query language (SQL) queries on multiple hardware configurations to compare the environments based on handling computationally expensive queries involving SQL operations and PostGIS functions. The geospatial queries operate on data imported from OpenStreetMap into PostgreSQL/PostGIS. The clustered environment powered by Kubernetes demonstrated promising improvements in the average execution times of computationally expensive geospatial SQL queries on all considered hardware configurations compared to their average execution times in non-clustered environments.

Query Languages for Graph Databases

2018 ◽  
pp. 2031-2042
Author(s):  
Kornelije Rabuzin
Keyword(s):  
Relational Databases ◽  
Query Language ◽  
Main Idea ◽  
Query Languages ◽  
End Users ◽  
The Other ◽  
Graph Database ◽  
Graph Databases ◽  
Nosql Databases ◽  
The Past

In the past few years many NoSQL databases have emerged, including graph databases. NoSQL databases have certain advantages and they can be used in certain domains as an alternative to relational databases. In order to use graph databases, one needs to be familiar with specific languages like Cypher Query Language (CQL) or Gremlin. However, some statements in CQL can be considered too complex for end users as it is shown later on. Because of that the main idea of this paper is to explore two other languages for graph databases. One of them is new and it is used to pose queries visually. Since CQL does not support recursion, views, etc., the other language is used to show how to use recursion and views on a graph database.

Data Analytics: Introduction to Using Analytics in Auditing

2016 ◽  
Vol 13 (1) ◽  
pp. 121-140 ◽  
Author(s):  
David Y. Chan ◽  
Alexander Kogan
Keyword(s):  
Open Source ◽  
Open Source Software ◽  
Data Analytics ◽  
Query Language ◽  
Class Discussion ◽  
Teaching Case ◽  
Hands On ◽  
Structured Query Language ◽  
Class Assignment ◽  
Attributes Data

ABSTRACT This is a hands-on introductory practical data analytics teaching case that can be used in an auditing or related course. Students will learn about data attributes, data creation, structured query language (SQL), basic statistics, and performing basic audit procedures using analytics by utilizing the open source software R. Instructors can use this case for an in-class discussion or an independent out-of-class assignment. A solutions guide is available in the Teaching Notes. Multimedia files are available for download, see Appendix B.

Sign in / Sign up

Export Citation Format

Share Document