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 136
- Downloads 0
Heat Transfer of a Heat Generation MHD Fluid Flow Over a Vertical Porous Flat Plate in a Rotating System
Weinvestigated numerically onMHD Free Convection Fluid Flow over a Vertical Porous Flat Plate in a Rotating System is Presence of Radiation, Soret effect and Heat Transfer of a heat generation. In this study the governin...
Hand Written Circuit Schematic Recognition
Circuit drawing is an important task especially in undergraduate courses such as electronics and digital systems. To improve human computer interaction, we have developed recognition system for the hand written circuit a...
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 Fabrication of Quadrilateral Bubble Column Test Rig for Multiphase Flow Investigations
Bubble column reactor belongs to the general class of multiphase reactors in which gas come in contact with liquid. This reactor purposely used to mix the two phases or substances where the gas is dispersed into the colu...
A Design of Spherical Unmanned Aerial Vehicle Based on ARM
At present, the application of unmanned aerial vehicle (UAV) is widely used in daily life, but it can easily lead to destruction if the UAV once out of control. Based on ARM processor, we design a three-rotor rotorcraft...