CFP last date
20 December 2024
Reseach Article

A Simple Approach to SQL Joins in a Relational Algebraic Notation

by C.bhanuprakash, Y.s. Nijagunarya, M.a. Jayaram
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 104 - Number 4
Year of Publication: 2014
Authors: C.bhanuprakash, Y.s. Nijagunarya, M.a. Jayaram
10.5120/18190-9099

C.bhanuprakash, Y.s. Nijagunarya, M.a. Jayaram . A Simple Approach to SQL Joins in a Relational Algebraic Notation. International Journal of Computer Applications. 104, 4 ( October 2014), 18-26. DOI=10.5120/18190-9099

@article{ 10.5120/18190-9099,
author = { C.bhanuprakash, Y.s. Nijagunarya, M.a. Jayaram },
title = { A Simple Approach to SQL Joins in a Relational Algebraic Notation },
journal = { International Journal of Computer Applications },
issue_date = { October 2014 },
volume = { 104 },
number = { 4 },
month = { October },
year = { 2014 },
issn = { 0975-8887 },
pages = { 18-26 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume104/number4/18190-9099/ },
doi = { 10.5120/18190-9099 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T22:36:28.059430+05:30
%A C.bhanuprakash
%A Y.s. Nijagunarya
%A M.a. Jayaram
%T A Simple Approach to SQL Joins in a Relational Algebraic Notation
%J International Journal of Computer Applications
%@ 0975-8887
%V 104
%N 4
%P 18-26
%D 2014
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Join is an operation in accessing the data from table if number of tables exceeds one. Whenever we need the data which is not available from a single table, then it needs to necessitate using join operation. Sometimes join is required even if there is a single table. It all depends on the format in which we need to display the data in the user environment. In join processes, the accessing of the data depends on the joining conditions with different operators. Here, join condition is a must. For this purpose, generally we are using relational operators along with logical operators. The problem presently we are facing is many of them are not knowing exactly all types of joins, their proper syntaxes and their proper usage. Sometimes it is vey difficult for the teacher or trainer to convince the trainees, students, research scholars in giving right practical examples while we teach SQL joins to them. Even if we use some conventional operators, the performance of the query may results in delayed accessing time in retrieving the data from N number of tables. This is due to lack of knowledge of the programmers on evaluation criteria of the joined queries. Since the present tables are dealing with millions of records, if we take these tables as example tables, then it is very difficult to give the exact demonstration regarding the number of records to be accessed, because, many joining concepts dealing with exact number of records which are working based on Cartesian Product. To avoid all these uncertainties, confusion, ambiguities, in this paper, it has been used with only three simple tables which are given from Oracle Corporation in user schema scott/tiger. The number of records used in these tables is very minimum and are meaningful records. After understanding the basics of all SQL joins, then it is necessary to represent the same queries in relational algebraic notations, because, those are the standard and uniform syntaxes which will be applicable in any of the database software. But the present problem is many of the software developers, specialists, programmers, and researchers are not aware of how to represent queries exactly in that syntax. In order to overcome this, the main focus is to make a familiarity in writing the SQL queries in relational algebraic format along with different types of joins. The main focus of this paper is to learn the basic fundamentals of all types of SQL joins along with algebraic notations in a very easiest, convinced and simple approach. On many stages, it is given with live examples along with SQL code and its result set by using SQLPLUS interface.

References
  1. Oracle® Database SQL Reference 10g Release 1 (10. 1), Documentation.
  2. Fundamentals of Database Systems, Fifth Edition, by Ramez Elmasri, Shamkant B. Navathe, Pearson Publications, 2009.
  3. Database Management Systems, By –Raghuramakrishnan, Gehrke, Third Edition, McGraw-Hill Publications, 2003.
  4. Pratt, Phillip J (2005), A Guide To SQL, Seventh Edition, Thomson Course Technology, ISBN 978-0-619-21674-0
  5. Shah, Nilesh (2005)
  6. , Database Systems Using Oracle – A Simplified Guide to SQL and PL/SQL Second Edition (International ed. ), Pearson Education International, ISBN 0-13-191180-5
  7. Yu, Clement T. ; Meng, Weiyi (1998), Principles of Database Query Processing for Advanced Applications, Morgan Kaufmann, ISBN 978-1-55860-434-6, retrieved 2009-03-03
  8. M. Tamer Özsu; Patrick Valduriez (2011). Principles of Distributed Database Systems (3rd ed. ). Springer. p. 46. ISBN 978-1-4419-8833-1.
  9. C. J. Date (2011). SQL and Relational Theory: How to Write Accurate SQL Code. O'Reilly Media, Inc. pp. 133–135. ISBN 978-1-4493-1974-8.
Index Terms

Computer Science
Information Sciences

Keywords

SQL Joins Relational operators Relational Algebraic expressions Query evaluation Access time matching records Result set.