Jump to content

Db2 Database

Add links
From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Angoca (talk | contribs) at 13:40, 16 December 2018. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
Db2 (Formerly Db2 for LUW)
Developer(s)IBM
Initial release1987; 38 years ago (1987)
Written inC, C++, assembly, Java
Operating systemLinux, Unix-like, Windows
Platformx86-64, x86, Sparc, IBM POWER microprocessors, IA-32
Size1.6 GB
Available inEnglish, Spanish, French, German, Russian, Japanese
TypeRDBMS
LicenseProprietary commercial software, Proprietary EULA
Websitewww.ibm.com/analytics/db2/

Db2 for Linux, UNIX and Windows is a database server product developed by IBM. Sometimes called Db2 LUW for brevity, it is part of the Db2 family of database products. Db2 LUW is the "Common Server" product member of the Db2 family, designed to run on most popular operating systems. By contrast, all other Db2 products are specific to a single platform.

Db2 LUW was initially called Db2 Universal Database (UDB), but over time IBM marketing started to use the same term for other database products, notably mainframe (z-Series) Db2. Thus the Db2 for Linux, UNIX and Windows moniker became necessary to distinguish the common server Db2 LUW product from single-platform Db2 products.

The current Db2 LUW product runs on multiple Linux and UNIX distributions, such as Red Hat Linux, SUSE Linux, IBM AIX, HP-UX, and Solaris, and most Windows systems. Earlier versions also ran on OS/2. Multiple editions are marketed for different sizes of organisation and uses. The same code base is also marketed without the Db2 name as IBM InfoSphere Warehouse edition.

In 2017, the "Db2 UDB" name became just "Db2".

History

The first release of Advanced Db2 LUW was as Db2 Universal Database version 5, available on UNIX, Windows and OS/2 platforms. This new product stemmed from two earlier products, Db2 Common Server version 2 and Db2 Parallel Edition. Db2 Universal Database version 5 continued IBM's new direction of using a common code base to support Db2 on different platforms, while incorporating the shared nothing features of Db2 Parallel Edition to support large data warehousing databases.

Key features

In addition to standard ACID-compliant row-organized relational database functionality, some of its key features are:

  • IBM BLU Acceleration: OLAP oriented column-organized tables,[1] compressed with order-preserving "approximate Huffman encoding",[2] exploiting SIMD vector processing of compressed data. Because the compression is order preserving, a greater range of operations can be performed on compressed data.
  • pureScale: A data-sharing clustering of the database over multiple servers for scalability and resilience. This technology was taken from the mainframe (z-Series) Db2 product. This form of clustering suits OLTP workloads well.
  • Database partitioning feature: A shared-nothing approach to clustering, with data hashed across multiple partitions on the same server or different processors. With the right database design, this approach allows near-linear scaling. This form of clustering is generally employed for large data warehouses rather than OLTP workloads.
  • XML support: XML-specific storage and indexing, accessible by both SQL and also XQuery.
  • NoSQL support: Currently graph triple stores[3] and JSON support[4]

References

  1. ^ "Column-organized tables". IBM. Retrieved September 13, 2017.
  2. ^ Eaton, Chris. "Actionable Compression in Db2 10.5 with BLU Acceleration". Toolbox. Retrieved September 13, 2017.
  3. ^ "RDF application development for IBM data servers". IBM. Retrieved September 13, 2017.
  4. ^ "JSON application development for IBM data servers". IBM. Retrieved September 13, 2017.
Retrieved from "https://en.wikipedia.org/w/index.php?title=Db2_Database&oldid=874000868"