Join Operations in Relational Databases with Automatic Attributes Renaming
Journal Title: Scholars Journal of Engineering and Technology - Year 2017, Vol 5, Issue 6
Abstract
The paper considers inner and outer join of relation operations, as well as set-theoretical operations on relations. Unlike join operations in Codd’s relational algebra the join operations under consideration are based on Kleene and Priest three-valued logic used in SQL, that allows to give the semantics of join operations more precisely. In relational algebra, any relation that does not contain tuples is represented as an empty set. It is impossible to define outer joins for such relations provided we do not know what columns contain an empty relation. In the paper relations with schemas are introduced. That allows the operations to be defined even if one or both operands are empty relations unlike classical relational algebra. Keywords: relational algebra, relational databases, program theory, programming language semantics, SQL, table join operations.
Authors and Affiliations
Poliakov S, Buy D, Mohmmed Karam, Israa Jasim AL. kalafa
Keywords
Related Articles
- EP ID EP386599
- DOI -
- Views 172
- Downloads 0
Design of a University Portal with Biometric Lecture Attendance Monitoring System
Management of information is a herculean task for most institutions. The advent of web portal technology proved promising as it provided ways to curb the difficulties in effectively managing data and information transfer...
Effect of Concrete Strength on the Size Effect of Reinforced Concrete Circular Column Confined By GFRP Sheet
Abstract:The finite element analysis by ANSYS finite element software is carried out on the three kinds of concrete strength specimens to explore the influence of concrete strength on the size effect of reinforced concre...
Design and FPGA Implementation of UART Using Microprogrammed Controller
This paper presents an implementation of Universal Asynchronous Receiver-Transmitter (UART) controller based on Microprogrammed Controller on Field Programmable Gate Array (FPGA. Our design of UART is fully functional an...
Existence results for a coupled system of fourth-order differential equations with two-point boundary conditions
This paper studies a coupled system of fourth-order differential equations with two-point boundary conditions. Applying the Schauder's fixed point theorem, an existence result is proved. Keywords: Coupled systems; Differ...
Reform and Practice of Curriculum System of Math Education in Local Undergraduate Colleges
Curriculum system is the important partin the program of cultivating talents. This paper explores the curriculum system reform of mathematics education in our school. We not only pay great attention to professional educa...