A good overview of System-R:
http://www.cs.berkeley.edu/~brewer/cs262/SystemR.pdf
As to how the System-R design principal rippled through to Oracle and Sybase ( and later SQL Server), I'm afraid I don't have much insight. While a lot of the basic relational principals have remained, the various vendors have differentiated themselves by their optimization and indexing methodologies.