7 Week Syllabus for ERM
- Codd and Date
In the sciences, Galileo can end a conversation, or be the beginning of one. Even when he is not the subject, he often notes something interesting, which other people later exploit. Sometimes much later. It might seem that he is rather remote from relational database management, but Galileo observed three important things: that the heartbeat is the major way of designing databases, that orbits and heartbeats are the same, and that there is a deep relationship between infinities and continua that is only solved by Cantor.
These three improvements are only a glimpse of what Galileo did, and yet most people would be proud to do just one of these things. We will explore how he did this, from 1604 when he discovered heartbeats, to 1638 when he elucidated that there was a relationship between whole and fractional parts of a series.
Pascal is remembered for many things, but in this role he started work on calculation machines and why this was important to digital computers.He was also involved in cycloid, and that led the way to the physics of solids. It may not seem that this has much to do with relational databases, but in fact that years how we computer whether we are dealing with random numbers or a set which is whole and integral.
He also formulated the Pascals triangle, which was the way Cantor used to formulate the idea that something could be countable and yet unlimited.
if Galileo was to find the outlines of the problem, Newton found the answers, though he was secretive about how he got them. He got answers by formalism, that is a general solution to a problem, and informally based on different proves which did not solve the problem, but worked there way around them. This combined method of theoretical and practical solutions meant that the problems which may had to be able to solve, good be done.
Cantors great achievement was realizing what had actually been proven. First he discovered that Pascal's triangle meant that real numbers were countable, while transcendental numbers were uncountable. This is the result of showing that all whole numbers fit on pascals triangle, but transcendental numbers are more numerous, which he proved, though often to vigorous debate.
It Cantor had made a distinction between finite and infinite, and with different kinds of infinite; Godel erased the distinction between symbols - and numbers etc. he published a proof in his late 20s, and showed how addition traction and so on could be in the same field as numbers.This means all systems, that are infinite are 3 value, not 2 (true,false,no value).
First Turing simplified dels complex number language with a simple device - well simple to computer scientists - which was close to buildable, and that it would be possible to represent an algorithm. But even when on to prove that it would not be possible to know whether it would halt, answering David Hilbert's question on the decision problem (Entsheidungsprolem).
Codd and Date
Codd and Date formulated rules made the relational database specific and portable among all computer architectures. currently there is only one which completely adopts ther rules, but many of them have adopted most of them. this includes IBM System R, Oracle, postgres, Sybase, and MySQL. including micro DBMS produced at MIT.