|
Authors
Submit your research Submission Guidelines Editorial Board Review Process Publication Fee Scirj Indexing Publications Research Journal Special Issue Thesis Monograph Research Library RSS & Feeds Subscribe |
Scirj Volume V, Issue IX, September 2017 Edition ISSN: 2201-2796 The Power of Relational Algebra in Database Management System Ebole Alpha F , Illuno Christiana Abstract: The fundamental set of operations for the relational model is known as the relational algebra. These operations permit a user to specify basic retrieval requirements. The result of retrieval is a new relation, which may have been formed from one or more relations. The algebra operations thus produce new relations, which can be further manipulated using operations of the same algebra. A sequence of relational algebra operations forms a relational algebra expression, whose result will also be a relation that represents the result of a database query (or retrieval request). A language based on operators and a domain of values operators map values taken from the domain into other domain values hence, an expression involving operators and arguments produces a value in the field when the domain is a set of all relations. The operators are project, union, set difference, Cartesian product, select, rename, set intersection, natural join, and assignment, to generate and get the relational algebra. We refer to the expression as a query and the value produced as the query result. Reference this Paper: The Power of Relational Algebra in Database Management System by Ebole Alpha F , Illuno Christiana published at: "Scientific Research Journal (Scirj), Volume V, Issue IX, September 2017 Edition, Page 14-22 ". Search Terms: Language, expression, operators and argument [Read Research Paper] [Full Screen] |
© 2012-2023 Scientific Research Journal, US . Malaysia . Australia Scirj is "refereed" or "peer reviewed" international journal. Open Access research journal licensed under Creative Commons Attribution CC BY. All rights reserved. |