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

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.

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.

Sign in / Sign up

Export Citation Format

Share Document