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.

scholarly journals Performance Comparison of Asymmetric Cryptography (Case study- Mail message)

2019 ◽  
Vol 4 (3) ◽  
pp. 105-111
Author(s):  
Zarni Sann ◽  
Thi thi Soe ◽  
Kaythi Wyut Mhone Knin ◽  
Zin May Win
Keyword(s):  
Computation Time ◽  
Performance Comparison ◽  
Sql Server ◽  
Sensitive Data ◽  
Rsa Algorithm ◽  
Mail Server ◽  
C Programming ◽  
Elgamal Encryption ◽  
Server System

Encryption is a well known technology for protecting sensitive data. ElGamal encryption and RSA algorithm is made before storing mails to mail server. ElGamal decryption and RSA decryption is made after retrieving mails from mail server. This system is implemented to secure mail server system for local government’s important mail messages. These algorithms consume a considerable amount of time and resources such as memory, CPU time, and computation time to encrypt and decrypt data. In this paper, the results are comparison of these algorithms in term of encryption time, decryption time, and memory usage over variable file sizes. After processing, it is proven that RSA performs a faster encryption process than ElGamal. However, ElGamal decryption process is faster than RSA. This system is also expressed comparison of storage Size between RSA and ElGamal. Both of these algorithms are cryptographic public-key algorithms but have functions in different ways. This system is using C# programming language and SQL Server to store mail messages.

Digital Bookstore

2021 ◽  
Vol 9 (VII) ◽  
pp. 1326-1337
Author(s):  
Amey Thakur
Keyword(s):  
Programming Languages ◽  
Web Application ◽  
Credit Card ◽  
Sql Server ◽  
Data Sets ◽  
Frequent User ◽  
Web Browser ◽  
Book Store ◽  
Different Types ◽  
Online Book

The project's main goal is to build an online book store where users can search for and buy books based on title, author, and subject. The chosen books are shown in a tabular style and the customer may buy them online using a credit card. Using this Website, the user may buy a book online rather than going to a bookshop and spending time. Many online bookstores, such as Powell's and Amazon, were created using HTML. We suggest creating a comparable website with .NET and SQL Server. An online book store is a web application that allows customers to purchase ebooks. Through a web browser the customers can search for a book by its title or author, later can add it to the shopping cart and finally purchase using a credit card transaction. The client may sign in using his login credentials, or new clients can simply open an account. Customers must submit their full name, contact details, and shipping address. The user may also provide a review of a book by rating it on a scale of one to five. The books are classified into different types depending on their subject matter, such as software, databases, English, and architecture. Customers can shop online at the Online Book Store Website using a web browser. A client may create an account, sign in, add things to his shopping basket, and buy the product using his credit card information. As opposed to a frequent user, the Administrator has more abilities. He has the ability to add, delete, and edit book details, book categories, and member information, as well as confirm a placed order. This application was created with PHP and web programming languages. The Online Book Store is built using the Master page, data sets, data grids, and user controls.

GuessXQ

2013 ◽  
pp. 57-76
Author(s):  
Daniela Morais Fonte ◽  
Daniela da Cruz ◽  
Pedro Rangel Henriques ◽  
Alda Lopes Gancarski
Keyword(s):  
Information Retrieval ◽  
Learning Process ◽  
Web Application ◽  
Relational Databases ◽  
Query Language ◽  
General Purpose ◽  
Considerable Effort ◽  
Document Structure ◽  
Query By Example ◽  
Xml Documents

XML is a widely used general-purpose annotation formalism for creating custom markup languages. XML annotations give structure to plain documents to interpret their content. To extract information from XML documents XPath and XQuery languages can be used. However, the learning of these dialects requires a considerable effort. In this context, the traditional Query-By-Example methodology (for Relational Databases) can be an important contribution to leverage this learning process, freeing the user from knowing the specific query language details or even the document structure. This chapter describes how to apply the Query-By-Example concept in a Web-application for information retrieval from XML documents, the GuessXQ system. This engine is capable of deducing, from an example, the respective XQuery statement. The example consists of marking the desired components directly on a sample document, picked-up from a collection. After inferring the corresponding query, GuessXQ applies it to the collection to obtain the desired result.

The Design of Web User Interface Based on Dynamic Re-Components

2014 ◽  
Vol 539 ◽  
pp. 424-428
Author(s):  
Shi Liu ◽  
Jia Lin Gang ◽  
He Ma
Keyword(s):  
User Interface ◽  
Interface Design ◽  
Web Application ◽  
Relational Databases ◽  
Structural Changes ◽  
Web Application System ◽  
Display Function ◽  
Web Interface Design ◽  
Table Data ◽  
Flexible Component

For environment and user needs easy-to-change issues in the Web application system application, the ideology of flexible software and Web interface design combining in the paper, we proposed a dynamic reconfiguration capability flexible component-based Web user interface model. The model displays the description of component style templates and adapts to the structural changes of business data component rules stored in the XML documents and relational databases, so as to solve the adaptability and reusability of Web user interface. Finally, a flexible Web user interface of the table data display function to illustrate the effectiveness and availability of the model.

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).

scholarly journals Performance analysis of relational databases Oracle and MS SQL based on desktop application

2018 ◽  
Vol 8 ◽  
pp. 263-269
Author(s):  
Grzegorz Dziewit ◽  
Jakub Korczyński ◽  
Maria Skublewska-Paszkowska
Keyword(s):  
Binary Data ◽  
Relational Databases ◽  
Database Systems ◽  
Database System ◽  
Sql Server ◽  
External Application ◽  
Oracle Database ◽  
Sql Server Database ◽  
Relational Database Systems ◽  
Mean Time

Comparison of efficiency is not a trivial phenomenon because of disparities between different database systems. This paper presents a methodology of comparing relational database systems in respect of mean time of execution individual DML queries containing subqueries and conjunction of tables. The presented methodology can be additionally accommodated to studies of efficiency in a range of database system itself (study of queries executed directly in database engine). The described methodology allows to receive statement telling which database system is better in comparison to another in dependency of functionalities fulfilled by external application. In the article the analysis of mean time of execution individual DML queries was performed.Two research hypotheses have been put forward: "Microsoft SQL Server database system needs less time to execute INSERT and UPDATE queries than Oracle database" and "Oracle database system needs less time to execute DML queries with binary data than SQL Server"

State of the Art Technology

2013 ◽  
pp. 201-218
Author(s):  
Ibrahim Dweib ◽  
Joan Lu
Keyword(s):  
Database Management ◽  
Relational Databases ◽  
State Of The Art ◽  
Database Management Systems ◽  
The State ◽  
Sql Server ◽  
Management Systems ◽  
Advantages And Disadvantages ◽  
Xml Documents

This chapter presents the state of the art approaches for storing and retrieving the XML documents from relational databases. Approaches are classified into schema-based mapping and schemaless-based mapping. It also discusses the solutions which are included in Database Management Systems such as SQL Server, Oracle, and DB2. The discussion addresses the issues of: rebuilding XML from RDBMS approaches, comparison of mapping approaches, and their advantages and disadvantages. The chapter concludes with the issues addressed.

scholarly journals Decision making based on data analyses using data warehouses

2018 ◽  
Vol 6 (3) ◽  
pp. 1-6
Author(s):  
Valdrin Haxhiu
Keyword(s):  
Decision Making ◽  
Data Warehouse ◽  
Relational Databases ◽  
Daily Basis ◽  
Transformation Process ◽  
Sql Server ◽  
Data Warehouses ◽  
Data Analyses ◽  
Weak Points ◽  
Using Data

Data warehouses are a collection of several databases, whose goal is to help different companies and corporations make important decisions about their activities. These decisions are taken from the analyses that are made to the data within the data warehouse. These data are taken from data that companies and corporations collect on daily basis from their branches that may be located in different cities, regions, states and continents. Data that are entered to data warehouses are historical data and they represent that part of data that is important for making decisions. These data go under a transformation process in order to accommodate with the structure of the objects within the databases in the data warehouse. This is done because the structure of the relational databases is not similar with the structure of the databases (multidimensional databases) within the data warehouse. The first ones are optimized for transactions on daily basis like: entering, changing, deleting and retrieving data through simple queries, the second ones are optimized for retrieving data through multidimensional queries, which enable us to extract important information. This information helps to make important decisions by learning which are the weak points and the strong points of the company, in order to invest more on the weak points and to strengthen the strong points, increasing the profits of the company. The goal of this paper is to treat data analyses for decision making from a data warehouse by using OLAP (online analytical processing) analysis. For this treatment we used the Analysis Services of Microsoft SQL Server 2016 platform. We analyzed the data of an IT Store with branches in different cities in Kosovo and came to a conclusion for some sales trends. This paper emphasizes the role of data warehouses in decision making.

Sign in / Sign up

Export Citation Format

Share Document