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 166
- Downloads 0
A Review On Compressive And Flexural Strength Of Concrete Containing Fly Ash In Normal And Acidic Environment
Concrete has become an indispensable construction material and it is now used in greater quantities than any other material. In the present context durability, strength, economy and stainable development are key issues f...
Mathematical Modeling of Infra-red Drying of Mango-Sweetpotato Leathers
Infra-red drying has in recent times been of use due to the potential for obtaining quality dried foodstuffs. To reduce losses associated with mangoes and sweet potatoes, infra-red dryer was employed in drying mango-swee...
Diagnostics of Motor Oil Quality by Using the Device Based on Surface Plasmon Resonance Phenomenon
We demonstrate the possibility to examine quality of motor oil by using the method of surface plasmon resonance (SPR) for comparing values of refractive indexes inherent to initial and used oil. It was experimentally sho...
Integer Points on the Hyperbola
The binary quadratic equation representing hyperbola is considered. Different patterns of solutions are obtained. A few interesting relations satisfied by x and y are exhibited. Keywords: binary quadratic, hyperbola...
A Study on Resource Allocation in Cloud
Cloud computing ia a type of internet based computing that is relies on sharing of computer resource from anywhere and anytime. It is similar to utility computing. In this paper a review of various policies for dynamic...