Knowledge Base about the database industry: database software, database management systems, database application development, data warehouse, data mining, business intelligence, OLAP, database design, data modeling, data integration, database security.
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 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 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 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-relational database 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-relational database.
Even though DB2 started out on the mainframe it migrated down through UNIX and Windows servers and finally became available on Linux and on PDAs. This process was mainly undertaken through the 1990's. DB2's precursors are IBM DL/1 and IBM IMS, both initially hierarchical and then network (or codasyl) databases. DB2 is also embedded in the operating system of IBM iSeries (formerly the AS/400).
SQL editor or query tool for Oracle, DB2, SQL Server, Sybase that featured intellisense-like code completion and parameter hinting.
.com Solutions Inc. is making its Perl CGI generating software CGIScripter available Free with TrialPay in order to facilitate its use by students, non-profit organizations and small businesses who might not otherwise be able to afford to pay for software at retail prices.
EMS SQL Manager for DB2 has plenty of powerful tools such as Visual Database Designer, Visual Query Builder, powerful BLOB editor to satisfy all needs of experienced users…
EMS Database Management Solutions are pleased to announce a new version of EMS Data Export. Unicode support added, performance highly increased, new formats supported and much more…
Universal SQL Editor is a powerful, yet easy-to-use graphical tool for all database developers. It allows you to connect any ODBC compliant databases, such as Oracle, DB2, SQL Server, etc., and edit SQL scripts and queries with code completion, syntax highlighting, SQL formatting, plus other useful features that allow you to work more efficiently.
FmPro Migrator quickly and accurately migrates FileMaker databases to MySQL, Oracle, Access, SQL Server, Sybase, DB2, OpenBase,PostgreSQL and FrontBase. Microsoft Access and SQL Server to FileMaker 9, FileMaker Table Consolidation conversions are included.
SQL editor or query tool for Oracle, DB2, SQL Server, Sybase that featured intellisense-like code completion and parameter hinting.
.com Solutions Inc. is making its Perl CGI generating software CGIScripter available Free with TrialPay in order to facilitate its use by students, non-profit organizations and small businesses who might not otherwise be able to afford to pay for software at retail prices.
Universal SQL Editor is a powerful, yet easy-to-use graphical query tool for all database developers. It allows you connect any ODBC compliant databases, such as Oracle, DB2, SQL Server, Sybase, etc., and edit SQL queries and scripts with code completion, syntax highlighting, SQL formatting, plus other useful features that allow you to work more efficiently.
DeZign for Databases is a data modeling tool that delivers dramatic increases in productivity for database developers with a complete toolset to model, maintain, generate and capture the design and requirements of databases.
EMS SQL Manager for DB2 has plenty of powerful tools such as Visual Database Designer, Visual Query Builder, powerful BLOB editor to satisfy all needs of experienced users…
EMS Database Management Solutions are pleased to announce a new version of EMS Data Export. Unicode support added, performance highly increased, new formats supported and much more…
Universal SQL Editor is a powerful, yet easy-to-use graphical tool for all database developers. It allows you to connect any ODBC compliant databases, such as Oracle, DB2, SQL Server, etc., and edit SQL scripts and queries with code completion, syntax highlighting, SQL formatting, plus other useful features that allow you to work more efficiently.
SLA driven Remote Support services utilizing a team of experts, state of the art technologies and best of breed solutions. The Right Solution, the Right Resources, at the Right Time!
EMS Database Management Solutions released EMS Data Import version 3.0. Changes: Increased speed, improved objects extraction algorithm, extraction of BLOBs and Arrays, Oracle and DB2 versions added, and much more…
