|
|
Do You Read On The Train?
I don't know about you, but I see more people with PDAs on trains reading things on there instead of reading paperbacks, or newspapers.
Is this the future we are looking at?
Will newspapers of a morning be unobtainable anymore?
Will...
Email Appending Erodes Privacy!
"Psssst! Hey buddy, check dis out over heeya. If ya give me yer database of customas' offline info, I'll give you email addresses to match! Waddaya say pal? $2 per name, awright?" That's how it might go down in a dark alley in privacy advocates'...
Small Business Q & A: Beware Of Spam Withdrawals
Q: I am so sick of all the spam that is sent to my business email address. I spend an hour every morning just trying to sort out the good email from the bad. I know I could just delete it all, but I'm afraid I'll accidentally delete email that...
Strategic Planning – Software design scenario
The most basic and pervasive management function is planning. All managers at all levels plan, and the success of the performance of the other management functions depends upon this activity. Planning is deciding in advance what has to be done,...
"You've Got Mail"
For the last 30 years, the most popular computer application on the Internet has been email. 30 Years? Yes. The first email application was built in 1971 and upgraded in 1972. With the upgrade, email became a widely used and really popular...
|
|
|
|
|
|
|
|
What Makes a Database Relational?
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".
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.
With more than 30 years in the IT industry, Mike Street is now director of FastComm (www.fastcomm.net) which 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 (www.zenergie.co.uk)
|
|
|
|
|
Tucows Downloads - Download Freeware and Shareware Software |
Download freeware, shareware, and demos. Maintains over 45000 software titles that are tested, rated, reviewed and ready to download. |
www.tucows.com |
  |
Free Software Downloads and Software Reviews - Download.com |
Download shareware, freeware and Demo software for PC, Mac, Linux, and Handhelds categorized into categories, plus software reviews. |
www.download.com |
  |
Computer software - Wikipedia, the free encyclopedia |
This includes application software such as a word processor, which enables a ... Application software is often purchased separately from computer hardware. ... |
en.wikipedia.org |
  |
Shareware.com - Search for shareware programs and free software ... |
Search for shareware programs from more than a dozen downloadable software directories. |
www.shareware.com |
  |
Jumbo: Free & Shareware MP3 files, Games, Screen Savers & Computer ... |
Source of free and shareware computer programs and utilities for PC and Mac. Evaluate software and read product reviews. Download games and screen savers. |
www.jumbo.com |
  |
Computer Software in the Yahoo! Directory |
Browse categories featuring sites devoted to computer software, including shareware and freeware download sites, operating systems, desktop customization, ... |
dir.yahoo.com |
  |
IEEE Software |
IEEE Computer Society's magazine covering all aspects of software, including software engineering. |
www.computer.org |
  |
Free Downloads on ZDNet | Shareware, Trialware, Evaluation Software |
ZDNet's Software Directory is the Web's largest library of software downloads. Covering software for Windows, Mac, and Mobile systems, ZDNet's Software ... |
downloads.zdnet.com |
  |
FSF - The Free Software Foundation |
Free software is a matter of liberty not price. Think of "free" as in "free speech". |
www.fsf.org |
  |
Apple - Software |
Software products for your digital life. ... The perfect addition for professional review. QuickTime Broadcaster. Encoding software for live events. ... |
www.apple.com |
  |
Open Directory - Computers: Software |
In Partnership with AOL Search. about dmoz | report abuse/spam | help. the entire directory, only in Computers/Software. Top: Computers: Software (38471) ... |
dmoz.org |
  |
freshmeat.net: Welcome to freshmeat.net |
About: The Web browser is probably the most frequently used software today, ... Web professionals can use the software for functional testing and regression ... |
freshmeat.net |
  |
Software - GNU Project - Free Software Foundation (FSF) |
Listing of the GNU software packages. |
www.gnu.org |
  |
Sun Software |
Get enterprise-class software--Solaris 10 OS, the Java Enterprise System, ... Sun Java StorageTek Software reduces cost and complexity with a single, ... |
www.sun.com |
  |
Internet Real Estate.com -- owns and operates a portfolio of the ... |
SOFTWARE.COM · SWEEPSTAKES.COM · PHONE.COM PODCAST.COM ... Software.com | Sweepstakes.com | Phone.com | Podcast.com | Shop.com | Safety.com ... |
www.internetrealestate.com |
  |
Joel on Software |
A weblog by Joel Spolsky, a programmer working in New York City, about software and software companies. |
www.joelonsoftware.com |
  |
Amazon.com Software: Computer & video games, business, accounting ... |
Online shopping for computer & video games, business & office productivity software, software from Microsoft, Apple, Adobe & more; accounting, antivirus, ... |
www.amazon.com |
  |
IBM Software - Home Page |
IBM home page for all of its software products, including Lotus and Tivoli, with keyword search, category browse and AZ product names. |
www.ibm.com |
  |
Opera web browser: Homepage |
Copyright © 2006 Opera Software ASA. All rights reserved. Skip navigation. Opera Software ... Copyright Opera Software ASA . All rights reserved. ... |
www.opera.com |
  |
Google Directory - Computers > Software |
Search only in Software Search the Web ... Software Categorized by Letter: A B C D E F G H I J K L M N O P Q R S T U V W X Y Z ... |
www.google.com |
  |
|