The Wayback Machine - https://web.archive.org/all/20060616012049/http://www.gmhealthlinks.com:80/healthlinks-insight-What+Makes+A+Database+Relational-section-1-id-175.html

Health Links

Health Links

Our Network Websites
real estate links
insurance guide
software links
health links
travel links
Health Directory
Computer Hardware Directory
What Makes A Database Relational?
Publish Date : 1/11/2006 6:28:37 PM   Source : Mike Street

There is a calumny being spread across the Internet. It is so deeply entrenched that many intelligent people think they understand it. It makes perfect sense. It is logical. It is understandable. But it is wrong, wrong, wrong.

Let me explain...

Back in the 1960's computers were big, noisy and very, very expensive. Information was kept in more-or-less random places and accessed by programs which were hand-coded to fetch & send the data to the right place. It was a little like writing the names of all your friends together with their phone numbers randomly on a piece of paper. How do you know which phone number belongs to which friend? Back in those early days, programmers had to know whcih item belonged with which when they wrote the programs to get the data out of the system. In the system itself, it was pretty much all over the place. A customer's phone number had to be linked to the customer's name by the programmer, every time the information was used.

Then, in 1970, along came Ted Codd with his seminal paper: "A Relational Model of Data for Large Shared Data Banks" (www.acm.org/classics/nov95/toc.html).

Dr Edgar Codd was born in 1923 in Dorset, England, was educated at Oxford and flew in the RAF during the war. In 1949 he joined IBM in the USA, became an IBM Fellow in 1976 and in 1981 was presented with the Turing Award, the highest industry accolade possible. Yet few people now understand his 'Relational Model'.

Most people know that relational databases store information in tables. These are just like the ordinary tables we use everyday - telephone books, TV programme listings, train timetables, league tables in sports etc.

Many people think that a database is relational if it allows you to relate information in one table to matching information in another.

Consider an order system. Customers are in one table, together with their contact details, credit limit, phone numbers etc. Orders are in another table, with the first column being the Customer Number, so you can relate the Customer to the Orders for that Customer, held in another table. Many people think this is called a 'relation'. Actually, in the Structured Query Language (SQL) which is used to manipulate relational databases, its called a 'join'.

Ted Codd showed that the table IS the relation. What he said was that if you put all this data in a table, you can see how one piece of data (Customer Name) relates to all the others (Customer Phone Number) without having to program it every time.

(Actually, what he said was something like:

"The term relation is used here in its accepted mathematical sense. Given sets S1, S1, ···, Sn, (not necessarily distinct), R is a relation on these n sets if it is a set of n-tuples each of which has its first element from S1, its second element from S1, and so on."

but he was a mathematician and a genius and I'm neither.)

In a table, for example a phone book, you can read a name in one column and you know the phone number in the next column relates to the name you just read, and not some other name on a different page. In any (vertical) column all the information is of the same type (name or phone number but not both). In each row, all the the information is related (the phone number belongs to the name in the 'name' column, and not some other name somewhere else).

So a relational database stores its data in tables. Its as simple as that. These tables may or may not join to other tables for complex queries, but if they don't, it doesn't stop it being relational.

In 1985 Ted Codd defines rules for relational databases, 12 in all, but only one of them (Rule 7: High-level Insert, Update, and Delete) talks, in passing, about joining tables. Some of the rules are still not supported by present day relational databases. Ted Codd passed away in 2003, but technology still hasn't caught up with all of his remarkable insights.


About the Author: fter more than 30 years in the IT industry, Mike Street is a director of FastComm (http://www.fastcomm.net) w hich specialises in information and tools to help increase sales, including Airlook Mobile Email software, the Eye Catcher Video Phone and the online Contact Management system, FastCRM. He is also webmaster of his wife's Health and Beauty site Zenergie (http://www.zenergie.co.uk)

Source: www.isnare.com
Premium Link Partners




Become a Premium Link Partner
Premium Link Partners




Become a Premium Link Partner

More Real Estate Guides


Top Cookie Flavors For Baby Showers And Other Parties        
Cookies are a very popular treat at any party event and as a snack in general. There are now hundreds of different types of cookies that can be served to your guests and at parties. In case you are having difficulty choosing which flavors to serve,...

Top Ten Ways To Stay Sane As A Work At Home Mom        
The other day, someone asked me what it's like to be a work at home mom. I just blinked back at him, my mind blank. How could I possibly describe life as a work at home mom? Only someone who's lived it can understand the juggling act it requires....

Viagra Facts: What’s Good And What’s Bad        
Men around the world vote Viagra as the most preferred drug for treating erectile dysfunction. Women, especially older ones, have shown more interest in sexual health after men took to Viagra. When in doubt, ask Does Viagra treat medical problems...

Vitamin C -- The Most Famous Of Vitamins!        
We call Vitamin C, also known as ascorbic acid, "the most famous of vitamins" because it really is the best known. It is the first one schoolchildren learn. It is the most cited cure for the common cold. Most people can rhyme off at least a few...

Vitamins And Minerals        
Life Giving Vitamins Have you ever thought to yourself, what vitamin is good for which aiment? Well here you go. A complete listing of vitamins, their food source, and their main role. Vitamin A For the maintenance of skin, mucous membranes,...

Vitamins And Their Role In Our Lives        
Vitamins, like minerals, are an essential part of the function and health of the body system. While many vitamins serve individual purposes, the more common way for vitamins to function properly is as cofactors to or in partnership with other...

Wedding Loans In The Uk – Saving Future From The Present Wedding Expenses        
It is wrong if you thought that typical British weddings are starving of novel ideas. In fact, there is a glut of ideas, and each idea sounds as enthralling as the previous ones. The only glitch then is of finance. Had weddings been the be-all and...

Weight Loss: Customize, Personalize, Spice Up!        
You know you have weighted, err, waited more than enough. So you decide to get yourself started on some weight loss programs and regimens. In all likelihood you would draft yourself with the ones that promise you sure-hit quick weight loss tips. So...

What Else You Don't Know About Supplements?        
COMPANIES do not KNOW HOW TO MAKE HERBAL FORMULAS without BULK VITAMINS and MINERALS! There is a trend on the market mixing herbs with different ingredients also called the 'fillers'. Seriously, just look on the label – most Supplements are mixed...

What Is A Healthy Eating Plan?        
Healthy eating is important for everyone, from babies to the elderly. Learning to eat well is more than just eating a variety of foods so that your body gets the proper nutrients. It is also about enjoyment of foods and maintaining a healthy weight....

Total Results : 183  
More News (Opens in New Window) :    [1]   2   3   4   5   6   7   8   9   10   11   12   13   14   15   16   17   18   19      Next Page
Our Network Websites >>> real estate links | insurance guide | software links | health links | travel links mens clothing | bargain cruises | hotel reviews | used cars | wedding favors | extended stay hotels | condos buying tips | laptop guide | bargain holidays | best mortgage deals | dental insurance | auto insurance quotes | cheap life insurance | car insurance quotes | life insurance quotes | ireland golf vacation packages | golf vacations | ireland vacations | hawaii vacation packages | vacation packages | digital camera review | digital video camera | security camera | home security cameras | disposable cameras | digital printing | digital photo software | digital projectors | digital photo processing | surveillance cameras | electronic stores | home electronics | diet supplements | zone diet | eating disorders guide | fsbo | learn spanish | learn italian | business brokers | commercial real estate |

:: SiteWide Links :: Hotel Reviews :: discount hotel :: vacation packages : wedding favors :: mens clothing ::