By Kato Mivule Database Systems During a database development process, often database developers will engage with their clients and users to solicit the requirements that the new database is supposed to accomplish. One of the best ways to communicate with clients and users is with the use of ER diagrams to check if the developers [...]
Archive for March, 2011
The Need to Map ER-diagrams to the Relational Model
Posted in Tutorials and Papers on March 22, 2011 | Leave a Comment »
SQL, Relational Algebra, and Relational Calculus, the Differences
Posted in Tutorials and Papers on March 22, 2011 | Leave a Comment »
By Kato Mivule Database Systems Outline In this article we take a look at the differences between SQL, Relational Algebra, and Relational Calculus. I this article, we focus on the main differences between Relational Algebra and Relational Calculus. Since SQL is mainly an implementation language, we take note of some major differences between Relational Algebra [...]
An Overview of Relational Algebra Operators and Their SQL Translations
Posted in Tutorials and Papers on March 22, 2011 | Leave a Comment »
By Kato Mivule Database Systems Outline Relational Algebra Operators are indispensable mathematical tools that can be used to retrieve queries by describing a sequence operations on relations and schemas. In this discussion, we take a look at various Relational Algebra operations and the SQL implementation of assorted Relational Algebraic operators. Introduction Relational Algebra Operators are [...]
Oracle 11g SQL Performance Analyzer Overview
Posted in Tutorials and Papers on March 22, 2011 | Leave a Comment »
By Kato Mivule Database Systems Oracle 11g’s SQL Performance Analyzer (SPA) also referred to as the “Fully Automatic SQL Tuning” is a technological feature provided in Oracle 11g that analyzes queries and checks the queries so as to better optimize them for better efficiency. The SPA will then rewrite the query for better, faster, and [...]
A Discussion on Amazon’s SimpleDB and Relational Databases
Posted in Tutorials and Papers on March 22, 2011 | Leave a Comment »
By Kato Mivule Database Systems Online retailer Amazon sent shock waves into the Database tech community in 2007 with the launching of the Amazon SimpleDB [1] that led some to question the future of Relational Databases and in particular the future of SQL. [2] Microsoft also launched launched a service similar to Amazon’s SimpleDB in [...]
