Hybrid Database Model For Efficient Performance

Vyawahare, Harsha R.; Karde, Pravin; Thakare, V. M.

doi:10.1016/j.procs.2019.05.040

Cited by 4 publications

(5 citation statements)

References 3 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Speeding up the response time of the relational database by combining other database models was conducted by Vyawahare et al [17], which is to do a hybrid database approach between relational databases integrated with graph databases to improve the performance of analytical queries. In this experiment, the researchers did not change the database that had been used and did not add hardware but ran a relational DBMS (MySQL) and column-oriented database (ClickHouse) on the same server.…”

Section: Methodsmentioning

confidence: 99%

Query Execution Performance Analysis of Column-Oriented Database in Dashboard

Triaji¹,

Andriyani²,

Suprawoto³

et al. 2022

Jour. Int. Intl. Sys. Soft

View full text Add to dashboard Cite

In making reports or dashboards from operational data, problems often occur in the query process with low speed in responding to an output, causing the server to experience overload. This condition often occurs in companies or higher education organizations in managing academic data. This condition can be improved by optimizing the database server by integrating relational databases with column-oriented databases to speed up query responses and save development costs. Based on the experiments that had been carried out, column-oriented has succeeded in optimizing with a significant difference in query execution time and the server does not crash.

show abstract

Section: Methodsmentioning

confidence: 99%

Query Execution Performance Analysis of Column-Oriented Database in Dashboard

Triaji¹,

Andriyani²,

Suprawoto³

et al. 2022

Jour. Int. Intl. Sys. Soft

View full text Add to dashboard Cite

show abstract

“…Refer to table 1 for more information. Figures 6,7,8,and 9 show that the refreshing operations time increased as the amount data contained in the views increased; this fact has to be taken into consideration if prompt and consistent availability of data is required.…”

Section: Refresh Materialized View Test Casesmentioning

confidence: 99%

“…A hybrid database model is a database system that uses two or more different database models in a system [6] and functions as an abstraction layer that sits on top of databases, for example in the paradigms SQL and NoSQL [7]. Some benefits in using multiple database models in a system are flexibility [8], increased performance [9,10,11], logical distribution [12], their design conceived for the web [6,13].…”

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

Hybrid storage engine for geospatial data using NoSQL and SQL paradigms

Herrera-Ramírez¹,

Treviño-Villalobos²,

Víquez-Acuña³

2021

View full text Add to dashboard Cite

The design and implementation of services to handle geospatial data involves thinking about storage engine performance and optimization for the desired use. NoSQL and relational databases bring their own advantages; therefore, it is necessary to choose one of these options according to the requirements of the solution. These requirements can change, or some operations may be performed in a more efficient way on another database engine, so using just one engine means being tied to its features and work model. This paper presents a hybrid approach (NoSQL-SQL) to store geospatial data on MongoDB, which are replicated and mapped on a PostgreSQL database, using an open source tool called ToroDB Stampede; solutions then can take advantage from either NoSQL or SQL features, to satisfy most of the requirements associated to the storage engine performance. A descriptive analysis to explain the workflow of the replication and synchronization in both engines precedes the quantitative analysis by which it was possible to determine that a normal database in PostgreSQL has a shorter response time than to perform the query in PostgreSQL with the hybrid database. In addition, the type of geometry increases the update response time of a materialized view.

show abstract

“…After execution of entire test suite if the desired results need to be stored in the original database with tester's login for future referencing it is possible only after approval. All the unapproved request(s) will be rolled back automatically [26,27,28].…”

Section: ) Request Initiated By End User / Customer / Online Ordermentioning

confidence: 99%

Efficient Software Testing Technique based on Hybrid Database Approach

Aleem¹,

Mahmood²,

Mubashir³

2019

IJACSA

View full text Add to dashboard Cite

In the field of computer science, software testing is referred as a critical process which is executed in order to assess and analyze the performance and risks existing in software applications. There is an emphasis on integrating specific approaches to carry out testing activities in an effective mode; the efficient strategy being explored recently is adopting hybrid database approach. For this purpose, a hybrid algorithm will be proposed to ensure the functionality and outcomes of testing procedure. The technical processes and its impact on current methodology would help to evaluate its effectiveness in software testing through which specific conclusions could be drawn. The findings of the research will elaborate effectiveness of the proposed algorithm that would be used in software testing. It would be suggested that new technology is easier and simple to assess and analyze the reliability of the software. Basically, hybrid database approach comprises of traditional and modern techniques that are deployed in order to achieve testing outcomes. It is explored from various testing methods that challenges have been identified related to focusing on traditional techniques due to which hybrid approach is now being developed in most of the areas. In the light of addressing these concepts, the paper aims to investigate the complexity and efficiency of hybrid database approach in software testing, as well as its scope in the IT industry.

show abstract

Hybrid Database Model For Efficient Performance

Cited by 4 publications

References 3 publications

Query Execution Performance Analysis of Column-Oriented Database in Dashboard

Query Execution Performance Analysis of Column-Oriented Database in Dashboard

Hybrid storage engine for geospatial data using NoSQL and SQL paradigms

Efficient Software Testing Technique based on Hybrid Database Approach

Contact Info

Product

Resources

About