Search
Exact matches only
Search in title
Search in content
Search in excerpt
Search in comments
Filter by Custom Post Type
8 08, 2018

Databases and Database Management System

By Dr. Joseph H Volker | 2018-08-30T10:19:16+00:00 August 8th, 2018|Computer Science, DBMS|0 Comments

Databases and database systems are an essential component of life in modern society. Every day most of us perform several activities that involve some interaction with a database. If we go to the bank to deposit or withdraw funds, if we make a hotel or airline company booking, if we access a digital library directory [...]

8 08, 2018

Relational Algebra and RDBMS

By Dr. Joseph H Volker | 2018-08-30T10:21:34+00:00 August 8th, 2018|Computer Science, DBMS|0 Comments

The relational algebra is essential for several reasons. First, it offers a formal structure for relational model operations. Second, and perhaps more important, it is used as a basis for implementing and optimizing queries in the query processing and optimization modules that are important parts of relational database management systems (RDBMSs). Third, some of its [...]

8 08, 2018

SQL – Structured/Standardized Query Language

By Dr. Joseph H Volker | 2018-08-30T10:24:37+00:00 August 8th, 2018|Computer Science, DBMS|0 Comments

The SQL language could be considered among the significant reasons for the commercial success of relational databases. Due to the fact that it ended up being a standard for relational databases, users were less concerned about moving their database applications from various other types of database systems-- for example, older network or hierarchical systems-- to [...]

8 08, 2018

Tuple Relational Calculus

By Dr. Joseph H Volker | 2018-08-30T10:27:03+00:00 August 8th, 2018|Computer Science, DBMS|0 Comments

This article introduces the language called tuple relational calculus, and another article will feature a variation called domain relational calculus. In both variations of relational calculus, we create one declarative expression to specify a retrieval request; hence, there is no description of how, or in what order, to examine a query. A calculus expression defines [...]