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.

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.

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.

A Framework for Cost-Based Query Optimization in Native XML Database Management Systems

2010 ◽  
pp. 160-183 ◽  
Author(s):  
Andreas M. Weiner ◽  
Theo Härder
Keyword(s):  
Query Optimization ◽  
Database Management ◽  
Cost Model ◽  
Database Systems ◽  
Database Management Systems ◽  
Management Systems ◽  
Xml Database ◽  
Xml Documents ◽  
Native Xml Database ◽  
Query Optimizers

Since the very beginning of query processing in database systems, cost-based query optimization has been the essential strategy for effectively answering complex queries on large documents. XML documents can be efficiently stored and processed using native XML database management systems. Even though such systems can choose from a huge repertoire of join operators (e. g., Structural Joins and Holistic Twig Joins) and various index access operators to efficiently evaluate queries on XML documents, the development of full-fledged XML query optimizers is still in its infancy. Especially the evaluation of complex XQuery expressions using these operators is not well understood and needs further research. The extensible, rule-based, and cost-based XML query optimization framework proposed in this chapter, serves as a testbed for exploring how and whether well-known concepts from relational query optimization (e. g., join reordering) can be reused and which new techniques can make a significant contribution to speed-up query execution. Using the best practices and an appropriate cost model that will be developed using this framework, it can be turned into a robust cost-based XML query optimizer in the future.

Object Oriented Databases and their Application to Historical Data

1994 ◽  
Vol 6 (1) ◽  
pp. 44-51 ◽  
Author(s):  
Gwyn Price ◽  
Alec Gray
Keyword(s):  
Database Management ◽  
Historical Data ◽  
Historical Context ◽  
Object Oriented ◽  
Database Systems ◽  
Historical Research ◽  
Management Systems ◽  
Relational Database Systems ◽  
Analytical Power ◽  
Object Oriented Databases

Relational Database Systems currently dominate the marketplace and thus the use of Database Management Systems by historians. This technology can constrain the thinking ofits users and limit the representational and analytical power of the applications built using it. This has led to research into other models of Database Management which are less restricting. An introduction toone ofthese approaches, Object OrientedDatabase Systems, ispresentedhere in a historical context with the purpose ofillustrating its power for historical research. An example of this power is given with a description of the authors research into the development of a workbench system utilising Object Orientedprinciples for Nominal Record Linkage.

Null Queries with Compound Fuzzy Attributes

1999 ◽  
Vol 3 (6) ◽  
pp. 509-514
Author(s):  
Shyue-Liang Wang ◽  
◽  
Yu-Jane Tsai ◽  
Keyword(s):  
Database Management ◽  
Database Management Systems ◽  
Management Systems ◽  
Database Schema ◽  
Data Types ◽  
User Friendly

We present a generalized approach for handling null queries that contain compound fuzzy attributes. Null queries elicit a null answer from the database. Compound fuzzy attributes are ambiguous attributes not defined in the original database schema but derived from multiple rigid attributes in a schema. Compound fuzzy attributes derived from simple numbers were studied by Nomura11). We extend compound fuzzy attributes so they can be derived from numbers, interval values, scalars, and sets of all these data types. Database management systems that handle this type of ambiguous attributes in null queries both reduce occurrences of null answers and provide an improved user-friendly query environment.

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"

scholarly journals Comparative analysis of databases working under the control of Windows system

2019 ◽  
Vol 13 ◽  
pp. 298-301
Author(s):  
Serhii Stets ◽  
Grzegorz Kozieł
Keyword(s):  
Comparative Analysis ◽  
Database Management ◽  
Database Management Systems ◽  
Management Systems ◽  
Query Performance ◽  
Second Stage ◽  
The Third ◽  
Third Stage ◽  
Analysis Of Results

The aim of this paper is to conduct research on the most popular database management systems such as MySQL, PostgreSQL and Firebird in terms of query performance, CPU load and disk usage. At the first stage, the analysis of the popularity of databases was carried out. In the second stage an application was created that allows for communication with selected databases. At the third stage, tests were carried out using a written application and analysis of results.

Open Source Database Management Systems

2005 ◽  
pp. 457-462 ◽  
Author(s):  
Sulayman K. Sowe ◽  
Ioannis Samoladas ◽  
Ioannis Stamelos
Keyword(s):  
Software Development ◽  
Open Source ◽  
Open Source Software ◽  
Database Management ◽  
Database Management Systems ◽  
Management Systems ◽  
Free Open Source Software ◽  
Source Database ◽  
1960S And 1970S ◽  
Free Open Source

This article discusses open source database management systems (OSDBMS) trends from two broad perspectives. First, the software engineering discipline platform on which databases are built has recently witnessed a new form of software development—Free/Open Source Software Development (F/OSSD). Methodically, the F/OSSD paradigm has changed the way relational databases, initiated in the 1960s and 1970s, are developed, distributed, supported, and maintained. Second, commercial relational database management systems (RDBMS) still dominate the database market because, on one hand, vendors and users are skeptical of the boon of applications developed and distributed under the F/OSSD paradigm, and on the other hand, it has been argued that OSDBMS are not likely to follow the successful trend of other robust Free/Open Source Software (F/OSS) systems (Linux, Apache, etc.). This article presents trends in OSDBMS by looking at the morphology and landscape of the type of applications developed by the F/OSS community. Implementation of F/OSS strategies and factors mitigating the adoption and utilization of OSDBMS are explored by looking at the interactions between the F/OSSD process and database firms, vendors, and users.

Sign in / Sign up

Export Citation Format

Share Document