3 ms·
Good recommendations in this thread, but seems a bit thin on the data side - both in terms of abstract datatypes, and in terms of database theory. I don't have
by e12e 7y ago
Good recommendations in this thread, but seems a bit thin on the data side - both in terms of abstract datatypes, and in terms of database theory.
I don't have a concrete recommendation off-hand - but certainly something by Codd on databases/normalization should be on such a list?
A lack of understanding data normalization can hurt even "simple" code that uses structs and procedures.
- Tomte 7y agoFor database theory probably something from C.J. Date.
- e12e 7y agoOh certainly. Maybe Codd and Todd for papers, Date for books? Somewhat related, this interview with Date on the relational model: https://www.red-gate.com/simple-talk/opinion/opinion-pieces/chris-date-and-the-relational-model/ https://www.red-gate.com/simple-talk/opinion/opinion-pieces/...
- e12e 7y agoRelevant (to TFA) quote from the interview: > A related piece of advice is: Learn the relational model first, SQL second (doing it the other way around is hard). Finally, read either or both of Ted Codd’s first two papers every year. (Those papers are “Derivability, Redundancy, and Consistency of Relations Stored in Large Data Banks”, IBM Research Report RJ599, August 19th, 1969, reprinted in ACM SIGMOD Record 38, No. 1 (March 2009), and “A Relational Model of Data for Large Shared Data Banks”, CACM 13, No. 6, June 1970, which you can find online.) Ed: DERIVABILITY, REDUNDANCY CONSISTENCY OF RELATIONS STORED IN LARGE DATA BANKS E. F. Codd: http://domino.research.ibm.com/library/cyberdig.nsf/papers/B7765CC7C03E358D85257593005B42EF/$File/RJ599.pdf http://domino.research.ibm.com/library/cyberdig.nsf/papers/B... A relational model of data for large shared data banks: http://www.seas.upenn.edu/~zives/03f/cis550/codd.pdf http://www.seas.upenn.edu/~zives/03f/cis550/codd.pdf