 |
What advantages does SQL have over relational algebra? |
[Edit] |
Generally relational models are queried using relational algebras. SQL and XQuery are examples of relational algebras, with XQuery actually being a purer form of a relational algebra.
- XQuery
- + Already exists and supports this extended relational model
- + Supports XPath
- + Supported by Oracle, IBM and Microsoft databases
- + Existing open source implementations for those who don't have it
- - Not yet a standard (but probably will be)
- - Not very easy to formulate
- - Immature development bindings usually resulting in DOM manipulation (not very efficient)
- - Difficult language to optimize which may result in poor performance
- - No developer community
- - No developer tools
- - It's currently a read-only language and the update additions are not focused on transactional systems
- SQL
- + Millions of developers know (and love) it
- + Most repositories already support it
- + Supports PROJECTION, JOIN and UNION
- + Long established standard
- + Efficient language bindings with JDBC and ODBC
- + Lots of development tools
- - Need to specify and implement HIERARCHY ENUMERATION
- - Need to work around the multi-value problem with PROJECTION and SELECTION functions
First answer by Alisha ny. Last edit by Alisha ny. Contributor trust: 0 [recommend contributor]. Question popularity: 0 [recommend question]
|
Research your answer: |
Can you answer other
questions about computing terms?
Answers.com > Wiki Answers > Categories > Technology > Computers > Computer Terminology > What advantages does SQL have over relational algebra?
Our contributors said this page should be displayed for the questions below. (Where do these come from ) |
| If any of these are not a genuine rephrasing of the question, please help out and edit these alternates. |
The advantages and disadvantages of SQL? Difference between sql and relational algebra?
