Relational Algebra in databases

[Chromium]

so in my intro to databases class, so far we have only learned about the various relational algebra operators. So far, relational algebra just seems like this purely theoretical concept that has no practical purpose. So, I was wondering: is relational algebra used commercially as a query language? Is it utilized at all in industry?

--Jonathan

 

[Math Is Hard]

SQL is based on relational algebra. Have you written any queries yet? When you do, you'll do things like selection, projection, joins, unions, etc all the time. (I assume that's the sort of operations you're learning about, anyway.)

 

[Chromium]

No, I haven't written any queries yet. But if SQL is based on relational algebra, does that mean that most, if not all, relational database management systems have relational algebra operations somewhere in their implementation? For example, if I call a SELECT operation on a table, am I really calling a SELECT function that has the relational algebra project operation somewhere in its definition?