tags:

views:

66

answers:

1
+1  Q: 

Relational Algebra instead of SQL

I am studying relational algebra these days and I was wondering...

Don't you thing it would be better if a compiler was existed which could compile relational algebra than compiling SQL?

In which case a database programmer would be more productive?

Is there any research on relational algebra compilers?

Thanks in advance

A: 

See Tutorial D by C J Date, he also has a good rant somewhere on the evils of SQL.

Also see datalog, although not exactly relational algebra, is similar.

deinst  2010-08-08 13:14:04
It was a typo. Fixed.
relet  2010-08-08 13:18:50
I'm not at all sure what is going on. There appears to be a //tp being inserted. Look up Tutorial D on wikipedia. There is also an implementation of Tutorial D called rel. C J Date's rant is entitled "A critique of the SQL database language", but it is behind a paywall. If you are a student you should be able to get it.
deinst  2010-08-08 13:24:10
@relet Thanks. Sorry about my typing skills.
deinst  2010-08-08 13:26:02
I am not a student, I was refreshing relational algebra, I have written maany lines of SQL but reconsidered relational algebra as better than SQL.
Novemberland  2010-08-08 13:27:57

related questions

What language do you use for Postgresql triggers and stored procedures?
Are Multiple DataContext classes ever appropriate?
Which tools do people use to create Data Dictionaries?
Any experiences with Protocol Buffers?
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
How do I index a database field
How does database indexing work?
How do I connect to a database and loop over a recordset in C#?
Editing database records by multiple users
Object Oriented vs Relational Databases
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
Embedded Database for .net that can run off a network
Connect PHP to an AS/400
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
.NET Migrations Engine
Is there a version control system for database structure changes?
SQLite and XSD
How do I version my MS SQL database in SVN?
XSD DataSets and ignoring foreign keys
Flat File Databases in PHP
Throw Error In MySQL Trigger
Binary Data in MySQL