submit urlsubmit rss feedadd directory

article

DB2 is IBM's family of information management software products. Most often, though, when people say DB2 they are referring to IBM's flagship relational database management system, DB2 Universal Database (DB2 UDB).

History


DB2 has a long history and was what some consider to be the first database product to use SQL.

The name DB2 was first given to the Database Management System or DBMS in 1982 where IBM released SQL/DS and DB2 on its mainframe platform. Prior to this the product was named System Relational, or System R, which launched in 1978. DB2 has its roots back to the beginning of the seventies where Dr. E.F. Codd, working for IBM, described the theory of relational databases and in June of 1970 published the model for data manipulation. To apply the model Codd needed a relational database language which he named Alpha. IBM didn't believe in Codd's idea's potential, leaving its implementation to a group of programmers who weren't under Codd's supervision, violating several fundamentals of the relational model; the result was Structured English QUEry Language or SEQUEL. SEQUEL was already a trademarked name, so IBM renamed the acronym to SQL, short for Structured Query Language. The acronym SQL still stands to this day.

Historically, it is interesting to note that when Informix acquired Illustra and made their database engine an object-SQL DBMS by introducing their Universal Server, both Oracle and IBM followed suit by changing their database engines to be capable of object-relational extensions. Moreover, in 2001, IBM bought Informix and in the following years incorporated Informix technology into the DB2 product suite. Technically, today, DB2 can be considered to be an object-SQL DBMS.

More on [ IBM DB2 ]


directory of related categories

 

 
directory of related topics

Mainframe :: IBM
370 :: Assembly
Cobol :: Languages
Data Warehousing :: Databases
z OS :: IBM

 
IBM_DB2 RSS feed
Business Applications - RSS Sponsorship

HP's first 13.3-inch Pavilion vs. the competition
Wed, 01 Oct 2008 12:34:18 -0700
HP is shipping its first laptop with a 13.3-inch widescreen display. The HP Pavilion dv3500t series is already available on HP's site starting at $1,000, and a slightly higher-end configuration, the dv3520nr, is available for pre-order at Best Buy for $1,200. Other sites have reported that this model will be...
A new mystery: What's Microsoft got up its Office Live sleeve?
Wed, 01 Oct 2008 12:22:06 -0700
It sounds like Microsoft has yet another Professional Developers Conference PDC announcement percolating -- beyond the Windows 7, Oslo, cloud OS (Red Dog/Zurich) and Mesh Platform stuff about which the company already has been dropping hints. by Mary Jo Foley
Google talks efficient data centers
Wed, 01 Oct 2008 12:18:32 -0700
Google is known as a search titan, but its real business is running data centers. On Wednesday, Google handed out a few key tips as it touted its data center efficiency and sustainability efforts. In a blog post, Google's senior vice president of operations Urs Hölzle outlined...
Apple strikes back against Psystar, asks for counterclaim to be dismissed
Wed, 01 Oct 2008 12:17:23 -0700
Apple has hit back against claims made by Mac-clone maker Psystar that the company is operating in violation of the Sherman Antitrust Act and the Clayton Antitrust Act and will be asking the U.S. District Court judge to dismiss to dismiss the counterclaim. by Adrian Kingsley-Hughes
Microsoft HealthVault offers the nickel tour
Wed, 01 Oct 2008 12:08:55 -0700
Nolan insists that "third party applications" will be what get HealthVault over the top, and it's in making those available that he hopes the system will prove its value. by Dana Blankenhorn
Student Technology Day: "Windows Cloud" revealed
Wed, 01 Oct 2008 11:47:18 -0700
Steve Ballmer was next door in the Queen Elizabeth Hall talking to the TechNet/TechEd people about Office Live, and mentioning that there would be a major announcement at the PDC on the 27th October. Once he finished there, he popped next door and told us a similar thing. ...

 
Subscribe to Software RSS feed

directory of related sites

IBM DB2 Universal Database - Official IBM homepage of DB2 Universal Database for all platforms, including support, ordering, downloads, and technical libraries.
Meta Description: [ This is the home page for the DB2 Universal Database for UNIX, Windows and Linux. From here you can link to any platform specific product page or investigate the details of the various product editions such as ESE, WSE, PE, etc. ]

About.com on DB2 - Provides original feature articles, a collection of links, forum discussions and a chat room.
Meta Description: [ The Net’s best collection of IBM DB2 links from your About.com Guide to Databases. ]

Bonnie Baker Corporation - Consulting and training for DB2, including the popular Things I Wish They Had Told Me series

DB2 Magazine - Articles about DB2 covering both management and technicalities.
Meta Description: [ DB2 Magazine is devoted to DB2 and targeted at database administrators, analysts, programmers, designers, consultants, and MIS/DP managers. DB2 Magazine covers a range of topics for all DB2 platforms (including IBM AIX, Hewlett-Packard HP-UX, Sun Solaris, SCO UnixWare, Linux, Microsoft Windows NT... ]

DB2 UDB Cookbook Downloads - Graeme Birchall, a DB2 UDB authority, puts out free PDF-format SQL cookbooks with sample code, tricks and hints.
Meta Description: [ DB2/V2 Cookbook Downloads ]

404 DB2usa: DB2 by a Frenchman in the United States - Collected links about DB2: technical papers, redbooks, conferences, newsgroups, and FAQ.

GSE UK DB2 Working Group -

IBM DB2 Online Resource Center - IBM and Fatbrain.com have teamed up to bring you a collection of the most useful titles on DB2 and related topics for database programmers, administrators, and users.

IDUG: International DB2 Users - IDUG is the International DB2 Users Group. IDUG provides information and support to DB2 Users and Vendors about DB2 database products, DB2 conferences, other DB2 user groups, and other DB2 vendors.

Search DB2 Frequently Asked Questions Database of Raul L. Gonzalez - Search the DB2 Frequently Asked Questions Database of Raul L. Gonzalez, a DB2 Systems Programmer and Database Administrator in Dallas, Texas
Meta Description: [ DB2 FAQ (Frequently Asked Questions) for DBAs and System Programmers ]

SHARE Inc - International user group for broad-based users of IBM systems. Our user group; designed, built and managed by volunteers; has a goal to SHARE the latest technical information with you. For over 40 years, SHARE has brought together top industry representatives for learning, networking, and advocacy purposes. The foundation of SHARE's existence and the vision of its future is to provide its members with technology, connections, and results.

SQL Books - Descriptions and ordering information on books about SQL for DB2.

IBM_DB2 related videos
My High Definition Mac Mini Media Center using EyeTV Elgato Hybrid. ...
Next Video

 

HOMEADVERTISINGABOUT US

articlesartsbusinesscomputersgameshealthhospitalshomekids & teensnewsmobilephysiciansrecreationreferenceregionalscienceshoppingsocietysportsworld


Submit a Site About Become an Editor