Superstore Sales Reporting: A Comparative Analysis of Relational and Non-relational Databases

2018 ◽  
pp. 98-102
Author(s):  
Gheorghe Coșofreț ◽  
Ioana Ciuciu
Keyword(s):  
Comparative Analysis ◽  
Relational Databases

scholarly journals When Relational-Based Applications Go to NoSQL Databases: A Survey

Information ◽  
2019 ◽  
Vol 10 (7) ◽  
pp. 241
Author(s):  
Geomar A. Schreiner ◽  
Denio Duarte ◽  
Ronaldo dos S. Melo
Keyword(s):  
Big Data ◽  
Comparative Analysis ◽  
Relational Databases ◽  
Research Area ◽  
Relational Data ◽  
Data Sets ◽  
System Architectures ◽  
Nosql Databases ◽  
State Of Art ◽  
Open Issues

Several data-centric applications today produce and manipulate a large volume of data, the so-called Big Data. Traditional databases, in particular, relational databases, are not suitable for Big Data management. As a consequence, some approaches that allow the definition and manipulation of large relational data sets stored in NoSQL databases through an SQL interface have been proposed, focusing on scalability and availability. This paper presents a comparative analysis of these approaches based on an architectural classification that organizes them according to their system architectures. Our motivation is that wrapping is a relevant strategy for relational-based applications that intend to move relational data to NoSQL databases (usually maintained in the cloud). We also claim that this research area has some open issues, given that most approaches deal with only a subset of SQL operations or give support to specific target NoSQL databases. Our intention with this survey is, therefore, to contribute to the state-of-art in this research area and also provide a basis for choosing or even designing a relational-to-NoSQL data wrapping solution.

Data Types Diversity Quantitative Indicators in Relational Databases Physical Models

TEM Journal ◽  
2020 ◽  
pp. 862-867
Author(s):  
Alexander Aleksandrovich Rybanov ◽  
Makushkina Lidiya Aleksandrovna
Keyword(s):  
Comparative Analysis ◽  
Relational Databases ◽  
Diversity Index ◽  
Diversity Indices ◽  
Physical Models ◽  
Qualitative Assessment ◽  
Data Types ◽  
New Models ◽  
Evenness Index ◽  
Quantitative Indicators

The article compares diversity indices applicability used in ecology to assess data types distribution for physical database schemes. The following dominance measures are used to assess the data type's diversity in the physical database scheme: Simpson's diversity index, Shannon diversity index, Simpson's evenness index, Pielu evenness index. A comparative analysis of the data type's diversity indicators for physical database schemes showed that the values of some indices obey certain rules. It is proposed to use diversity indices for physical database schemes' qualitative assessment. The indices considered in this work can also be used to build new models for assessing database complexity.

Comparative Analysis of Nosql Specimen with Relational Data Store for Big Data in Cloud

2015 ◽  
Vol 3 (1) ◽  
Author(s):  
Sangeeta Gupta
Keyword(s):  
Comparative Analysis ◽  
Data Storage ◽  
Relational Databases ◽  
Traditional Approach ◽  
Modern World ◽  
Nosql Databases ◽  
Complex Queries ◽  
Data Formats ◽  
Data Store ◽  
Storage Technologies

The massive amount of data collected by various fields is a challenging aspect for analysis using the available storage technologies. Relational databases are a traditional approach of data storage more suitable for structured data formats and are constrained by ACID properties. As the modern world data in the form of word documents, pdf files, audio and video formats is unstructured, where tables and schema definition is not a major concern. Relational databases such as Mysql may not be suitable to serve such Bigdata. An alternate approach is to use the emerging Nosql databases. This paper presents a comparative analysis of Nosql types such as Hbase, Mongodb, Simple DB and Big Table with relational database like Mysql and specifies their limitations when applied to real world problems. It also proposes solution to overcome these limitations using an integrated data store which serve to be beneficial over the mentioned Nosql and Mysql stores in terms of efficiently implementing simple and complex queries yielding better performance.

scholarly journals Comparative analysis of connection performance with databases via JDBC interface and ORM programming frameworks

2021 ◽  
Vol 21 ◽  
pp. 309-315
Author(s):  
Mateusz Żuchnik ◽  
Piotr Kopniak
Keyword(s):  
Comparative Analysis ◽  
Computer Science ◽  
Programming Language ◽  
Relational Databases ◽  
Research Subject ◽  
Science Students ◽  
Java Programming ◽  
Relational Mapping ◽  
Object Relational ◽  
Communication Methods

The research subject of this paper was the comparative analysis of efficiency of connections with databases using different communication methods based on Java programming language. The tools investigated included JDBC drivers and Object-relational mapping (ORM) frameworks. A survey based on 8 different criteria was conducted to determine the most effective method and tool for working with relational databases when developing Java applications. The weights of the criteria were determined through a survey of Java programmers and computer science students.

Sign in / Sign up

Export Citation Format

Share Document