scholarly journals Analysis of the possibilities of optimizing SQL queries

2021 ◽  
Vol 19 ◽  
pp. 151-158
Author(s):  
Piotr Rymarski ◽  
Grzegorz Kozieł
Keyword(s):  
Relational Database ◽  
Web Applications ◽  
Query Language ◽  
Database Systems ◽  
Sql Server ◽  
Management Systems ◽  
Relational Database Systems ◽  
The Impact ◽  
Relational Database Management ◽  
Test Scenarios

Most of today's web applications run on relational database systems. Communication with them is possible through statements written in Structured Query Language (SQL). This paper presents the most popular relational database management systems and describes common ways to optimize SQL queries. Using the research environment based on fragment of the imdb.com database, implementing OracleDb, MySQL, Microsoft SQL Server and PostgreSQL engines, a number of test scenarios were performed. The aim was to check the performance changes of SQL queries resulting from syntax modication while maintaining the result, the impact of database organization, indexing and advanced mechanisms aimed at increasing the eciency of operations performed, delivered in the systems used. The tests were carried out using a proprietary application written in Java using the Hibernate framework.

scholarly journals Oracle 19c, SQL Server 2019, Postgresql 12 and MySQL 8 database systems comparison

2020 ◽  
Vol 17 ◽  
pp. 373-378
Author(s):  
Arkadiusz Solarz ◽  
Tomasz Szymczyk
Keyword(s):  
Comparative Analysis ◽  
Open Source ◽  
Database Management ◽  
Database Systems ◽  
Sql Server ◽  
Management Systems ◽  
Database Schema ◽  
Oracle Database ◽  
Server Systems ◽  
Test Scenarios

This article presents a comparative analysis of four popular database technologies. Commercial Oracle Database and SQL Server systems are compared with open source database management systems: PostgreSQL and MySQL. These systems have been available on the market for over a dozen years. Versions released in 2019 were selected for testing and comparasion. For the purposes of the comparative analysis, a database schema was developed and instantiated. Then, test scenarios were developed. They were prepared on the basis of the most popular operations performed with the use of database systems.

Access path query language for relational database systems

1983 ◽  
Vol 13 (8) ◽  
pp. 661-670
Author(s):  
L. M. Patnaik ◽  
Phule Shailendra ◽  
K. Venkateswara Rao
Keyword(s):  
Relational Database ◽  
Query Language ◽  
Database Systems ◽  
Access Path ◽  
Relational Database Systems

Database Queries, Data Mining, and OLAP

2011 ◽  
pp. 598-603
Author(s):  
Lutz Hamel
Keyword(s):  
Data Mining ◽  
Relational Database ◽  
Query Language ◽  
Data Retrieval ◽  
Database Systems ◽  
Database Queries ◽  
On Line ◽  
Analytical Processing ◽  
Relational Database Systems ◽  
Complementary Value

Modern, commercially available relational database systems now routinely include a cadre of data retrieval and analysis tools. Here we shed some light on the interrelationships between the most common tools and components included in today’s database systems: query language engines, data mining components, and on-line analytical processing (OLAP) tools. We do so by pair-wise juxtaposition which will underscore their differences and highlight their complementary value.

Database Queries, Data Mining, and OLAP

2011 ◽  
pp. 339-343
Author(s):  
Lutz Hamel
Keyword(s):  
Data Mining ◽  
Relational Database ◽  
Query Language ◽  
Data Retrieval ◽  
Database Systems ◽  
Database Queries ◽  
Analytical Processing ◽  
Relational Database Systems ◽  
Complementary Value ◽  
Do So

Modern, commercially available relational database systems now routinely include a cadre of data retrieval and analysis tools. Here we shed some light on the interrelationships between the most common tools and components included in today’s database systems: query language engines, data mining components, and online analytical processing (OLAP) tools. We do so by pair-wise juxtaposition, which will underscore their differences and highlight their complementary value.

scholarly journals Seasonality and Software Vulnerabilities in Major Database Management Systems

2020 ◽  
Vol 5 (12) ◽  
pp. 76-81
Author(s):  
HyunChul Joh
Keyword(s):  
Database Management ◽  
Database Systems ◽  
Database Management Systems ◽  
Sql Server ◽  
Management Systems ◽  
Security Risks ◽  
Oracle Database ◽  
Software Vulnerabilities ◽  
Security Effectiveness ◽  
Relational Database Management

Popularity and marketshare are very important index for software users and vendors since more popular systems tend to engage better user experience and environments. periodical fluctuations in the popularity and marketshare could be vital factors when we estimate the potential risk analysis in target systems. Meanwhile, software vulnerabilities, in major relational database management systems, are detected every now and then. Today, all most every organizations depend on those database systems for store and retrieve their any kinds of informations for the reasons of security, effectiveness, etc. They have to manage and evaluate the level of risks created by the software vulnerabilities so that they could avoid potential losses before the security defects damage their reputations. Here, we examine the seasonal fluctuations with respect to the view of software security risks in the four major database systems, namely MySQL, MariaDB, Oracle Database and Microsoft SQL Server.

Set Valued Attributes

2005 ◽  
pp. 632-637 ◽  
Author(s):  
Karthikeyan Ramasamy ◽  
Prasad M. Deshpande
Keyword(s):  
Relational Database ◽  
Data Model ◽  
Relational Databases ◽  
Database Systems ◽  
Sql Server ◽  
Relational Model ◽  
Database Model ◽  
Competitive Edge ◽  
The Past ◽  
Relational Database Systems

About three decades ago, when Codd (1970) invented the relational database model, it took the database world by storm. The enterprises that adapted it early won a large competitive edge. The past two decades have witnessed tremendous growth of relational database systems, and today the relational model is by far the dominant data model and is the foundation for leading DBMS products, including IBM DB2, Informix, Oracle, Sybase, and Microsoft SQL server. Relational databases have become a multibillion-dollar industry.

Sign in / Sign up

Export Citation Format

Share Document