Performance Comparison of Relational Databases and Columnar Databases Using Bitmap Index for Fast Search of 10Gbps Network Flows

2015 ◽  
pp. 171-175 ◽  
Author(s):  
Sunoh Choi ◽  
Hyun-Wook Park ◽  
Joo-Young Lee ◽  
Jong-Hyun Kim ◽  
Ik-Kyun Kim
Keyword(s):  
Relational Databases ◽  
Network Flows ◽  
Performance Comparison ◽  
Bitmap Index ◽  
Fast Search

scholarly journals PERBANDINGAN PERFORMANSI DATABASE MONGODB DAN MYSQL DALAM APLIKASI FILE MULTIMEDIA BERBASIS WEB

2018 ◽  
Vol 6 (1) ◽  
pp. 63
Author(s):  
Mesri Silalahi
Keyword(s):  
Data Storage ◽  
Information Needs ◽  
Relational Databases ◽  
Performance Comparison ◽  
Web Based ◽  
File Storage ◽  
Nosql Database ◽  
Computer Resources ◽  
Important Building Block ◽  
Multimedia File

Database appeared and began to develop in line with the needs of processing and data storage to meet the information needs. Database is part of an important building block in an information system. In addition to a relational database (SQL), which stores structured datas in tables with defined schemes, there is a non-relational databases (NoSQL) with a dynamic scheme or unstructured. This study will compare the performance between NoSQL database (MongoDB) and SQL database (MySQL) for a web-based multimedia file storage application that stores files as BLOBs. Performance comparison is based on the speed of execution and the computer resources usage (CPU, memory, and virtual memory).

A performance comparison of object and relational databases using the Sun Benchmark

1988 ◽  
Vol 23 (11) ◽  
pp. 153-163
Author(s):  
Joshua Duhl ◽  
Craig Damon
Keyword(s):  
Relational Databases ◽  
Performance Comparison ◽  
The Sun ◽  
A Performance

scholarly journals Relational Databases versus Search Engines: A Performance Comparison for Storing and Querying DICOM Metadata

2020 ◽  
Author(s):  
Alexandre Savaris ◽  
Gabriela Colonetti ◽  
Rodrigo De Melo ◽  
Aldo Von Wangenheim
Keyword(s):  
Search Engine ◽  
Relational Database ◽  
Search Engines ◽  
Communication Systems ◽  
Relational Databases ◽  
Search Time ◽  
Performance Comparison ◽  
Alternative Approach ◽  
Picture Archiving And Communication ◽  
Individual Self

The Digital Imaging and Communications in Medicine (DICOM) standard adopts files as individual, self-contained repositories for the storage of a mixed of alphanumerical and binary content regarding radiological images. Usually, groups of DICOM files are hierarchically organized in studies and series, physically disposed into filesystem directory trees. Despite its simplicity in storing content, ordinary filesystems do not provide index capabilities allowing searches by content – restricting access by directory names and file names. To surpass such limitation, Picture Archiving and Communication Systems (PACSs) often adopt Relational Database Management Systems (RDBMSs) as metadata repositories, benefiting from its general-purposed index structures. An alternative approach, not quite explored, considers the adoption of search engines as metadata catalogs, aiming to minimize the search time by exploring the engine’s index optimizations. In order to evaluate the performance on managing DICOM metadata, this work compares relational database instances to a search engine in terms of storage space, storage time, and query time. Results show that, in the best case, the search engine is slightly slower in storing content; however, it requires 69% less disk space for the same dataset. For queries, in turn, the search engine performs up to 8.3 times faster in retrieving groups of tags.

scholarly journals Performance comparison of relational databases SQL Server, MySQL and PostgreSQL using a web application and the Laravel framework

2020 ◽  
Vol 17 ◽  
pp. 358-364
Author(s):  
Rafał Wodyk ◽  
Maria Skublewska-Paszkowska
Keyword(s):  
Web Application ◽  
Relational Databases ◽  
Performance Comparison ◽  
Sql Server ◽  
Technical Parameters

Many database implementations are supported by application frameworks that can affect their performance. The paper presents a comparison of the performance of SQL Server, MySQL and PostgreSQL relational databases based on an application written in PHP using the Laravel framework. The time of performance for various types of queries, both simple and using column and table concatenation was evaluated. The obtained results for the same database structures differed depending on the operations performed on the databases. Looking at the entirety of the research conducted, it can be concluded that in the case of databases in which the number of records is not too large (up to 1000 records) and the technical parameters of the device on which the database is running are of low or medium class, MySQL performs very well.

Direct ammonia fueled solid oxide fuel cells: A comprehensive review on challenges, opportunities and future outlooks

2020 ◽  
pp. 70-91 ◽  
Author(s):  
Molla Asmare ◽  
Mustafa Ilbas
Keyword(s):  
Electric Power ◽  
Energy Demand ◽  
Renewable Energy Sources ◽  
Clean Energy ◽  
Performance Comparison ◽  
Optimum Operating ◽  
Practical Implementation ◽  
Human Society ◽  
Energy Access ◽  
Green Fuel

Nowadays, the most decisive challenges we are fronting are perfectly clean energy making for equitable and sustainable modern energy access, and battling the emerging alteration of the climate. This is because, carbon-rich fuels are the fundamental supply of utilized energy for strengthening human society, and it will be sustained in the near future. In connection with this, electrochemical technologies are an emerging and domineering tool for efficiently transforming the existing scarce fossil fuels and renewable energy sources into electric power with a trivial environmental impact. Compared with conventional power generation technologies, SOFC that operate at high temperature is emerging as a frontrunner to convert the fuels chemical energy into electric power and permits the deployment of varieties of fuels with negligible ecological destructions. According to this critical review, direct ammonia is obtained as a primary possible choice and price-effective green fuel for T-SOFCs. This is because T-SOFCs have higher volumetric power density, mechanically stable, and high thermal shocking resistance. Also, there is no sealing issue problem which is the chronic issues of the planar one. As a result, the toxicity of ammonia to use as a fuel is minimized if there may be a leakage during operation. It is portable and manageable that can be work everywhere when there is energy demand. Besides, manufacturing, onboard hydrogen deposition, and transportation infrastructure connected snags of hydrogen will be solved using ammonia. Ammonia is a low-priced carbon-neutral source of energy and has more stored volumetric energy compared with hydrogen. Yet, to utilize direct NH3 as a means of hydrogen carrier and an alternative green fuel in T-SOFCs practically determining the optimum operating temperatures, reactant flow rates, electrode porosities, pressure, the position of the anode, thickness and diameters of the tube are still requiring further improvement. Therefore, mathematical modeling ought to be developed to determine these parameters before planning for experimental work. Also, a performance comparison of AS, ES, and CS- T-SOFC powered with direct NH3 will be investigated and best-performed support will be carefully chosen for practical implementation and an experimental study will be conducted for verification based on optimum parameter values obtained from numerical modeling.

Sign in / Sign up

Export Citation Format

Share Document