Performance Evaluation of SQL and NoSQL Database Management Systems in a Cluster

Niyizamwiyitira, Christine; Lundberg, Lars

doi:10.5121/ijdms.2017.9601

Cited by 9 publications

(8 citation statements)

References 15 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…SQL is the only program language supported by procedures, but there are plans to introduce a framework to support other languages in the future. According to [15], Process Data (SQL) is an automatic information process that processes continuous data flows. There are several servers that can input data into a database, including MYSQL (My Structured Query Language).…”

Section: Introductionmentioning

confidence: 99%

E-Assessment Motivation in Physics Subjects for Senior High School

et al. 2019

View full text Add to dashboard Cite

<strong>Abstract – </strong>The use of technology in education can be utilized in the assessment, namely in the form of e-assessment. E-assessment is an assessment with an online system (e-assessment). Can make assessment more efficient in terms of time, funding, and achievement of assessment objectives. This study adopted Thiagarajan's research with the stages of development and evaluate. The number of samples used was 168 students and 14 teachers from senior high school 10 in Batanghari and senior high school in 5 Batanghari. The findings of this study are the system description, this motivational e-assessment is made from MySQL software, because of the ease of installation and use and small hard drives and memory traces. And this application can be used simultaneously. Exploration results show that effective assessment using motivational e-assessment has a good category of 72.6% with a total of 122 students from 168 students. Then the response of teachers using motivational e-assessment is in a good category 50.0% with a total of 7 teachers from 14 teachers, which means the teacher's response to student motivation is very good in assessment or evaluation. This is that e-assessment is important to use because it can make it easier for teachers to make an assessment of themselves because it is in line with the Industrial Revolution 4.0.

show abstract

Section: Introductionmentioning

confidence: 99%

E-Assessment Motivation in Physics Subjects for Senior High School

et al. 2019

View full text Add to dashboard Cite

show abstract

“…We measure the efficiency of the implemented NoSQL-DocW with two metrics: Write-Request-Latency (WRL) and Read-Request-Latency (RRL) (Niyizamwiyitira et al, 2017). WRL measures the loading time for a single write, and RRL measures the response time of a query.…”

Section: Evaluation and Discussionmentioning

confidence: 99%

Building a Document-Oriented Warehouse Using NoSQL

Messaoud

Alshdadi

Feki

2021

International Journal of Operations Research and Information Systems

View full text Add to dashboard Cite

The traditional data warehousing approaches should adapt to take into consideration novel needs and data structures. In this context, NoSQL technology is progressively gaining a place in the research and industry domains. This paper proposes an approach for building a NoSQL document-oriented warehouse (DocW). This approach has two methods, namely 1) document warehouse builder and 2) NoSQL-Converter. The first method generates the DocW schema as a galaxy model whereas the second one translates the generated galaxy into a document-oriented NoSQL model. This relies on two types of rules: structure and hierarchical rules. Furthermore, in order to help understanding the textual results of analytical queries on the NoSQL-DocW, the authors define two semantic operators S-Drill-Up and S-Drill-Down to aggregate/expand the terms of query. The implementation of our proposals uses MangoDB and Talend. The experiment uses the medical collection Clef-2007 and two metrics called write request latency and read request latency to evaluate respectively the loading time and the response time to queries.

show abstract

“…Two such latencies in the database are (i) write latency is the number of milliseconds required to fulfill a single write request. (ii) read latency is the number of milliseconds required to fulfill a read request [108]. In parallel databases, every lock operation in a processor introduces a lot of latency.…”

Section: Performance Factorsmentioning

confidence: 99%

Growth of relational model: Interdependence and complementary to big data

Shetty

Rao

Prabhu

2021

IJECE

View full text Add to dashboard Cite

A database management system is a constant application of science that provides a platform for the creation, movement, and use of voluminous data. The area has witnessed a series of developments and technological advancements from its conventional structured database to the recent buzzword, bigdata. This paper aims to provide a complete model of a relational database that is still being widely used because of its well known ACID properties namely, atomicity, consistency, integrity and durability. Specifically, the objective of this paper is to highlight the adoption of relational model approaches by bigdata techniques. Towards addressing the reason for this in corporation, this paper qualitatively studied the advancements done over a while on the relational data model. First, the variations in the data storage layout are illustrated based on the needs of the application. Second, quick data retrieval techniques like indexing, query processing and concurrency control methods are revealed. The paper provides vital insights to appraise the efficiency of the structured database in the unstructured environment, particularly when both consistency and scalability become an issue in the working of the hybrid transactional and analytical database management system.

show abstract

Performance Evaluation of SQL and NoSQL Database Management Systems in a Cluster

Abstract: ABSTRACT

Cited by 9 publications

References 15 publications

E-Assessment Motivation in Physics Subjects for Senior High School

E-Assessment Motivation in Physics Subjects for Senior High School

Building a Document-Oriented Warehouse Using NoSQL

Growth of relational model: Interdependence and complementary to big data

Contact Info

Product

Resources

About