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 169
- Downloads 0
Application of Simulation Softwares for Analysing the Solidification Pattern of Aluminium Alloy (LM6) Casting
Casting simulation is a virtual casting process that ensures the production of defect less castings in the shortest possible time. It involves computer-aided modeling, pattern design, methoding, simulation and optimizati...
Research on the network transmission of cooperative work in the logging platform of large data environment
Currently advanced methods of logging interpretation method such as acoustic-electric imaging, MRI, array acoustic have been widely applied. Data needed handling are large two-dimensional and even three-dimensional data....
Handling Unstructured Data for Semantic Web – A Natural Language Processing Approach
World Wide Web is a large repository of structured data and un-structured data. Structured data has a well-fixed structure thus is easy to analyze and use with computational machinery. On the other side handling of unstr...
Exact solutions to the regularized Burgers-BBM equation
The trial equation method is applied to the regularized Burgers-BBM equation, when the parameter p takes the different values, we have obtained all of its corresponding exact traveling wave solutions. Keywords: traveling...
Improved approximation of PERT activity parameters and validation
In Project Evaluation and Review Technique (PERT) , the activity mean and variance are very useful to find the expected project duration and variance of the critical path. Project duration makes a large difference in the...