DB2 database Introduction

DB2 is a product of IBM, originated from System R and System R *. He supports various operating platforms from PC to UNIX, from minicomputers to mainframes, from IBM to non-IBMHP and sun unix systems. It can run independently on the host in Master/Slave Mode or in the client/server environment. The service platform can be OS/400, AIX, OS/2, HP-UNIX, SUN-Solaris and other operating systems, the client platform can be OS/2 or Windows, Dos, AIX, HP-UX, SUN Solaris and other operating systems.
Database Server
The core of the DB2 database is also known as the DB2 public server. It adopts a multi-process, multi-clue architecture and runs on multiple operating systems. It is adjusted and optimized according to the corresponding platform environment, in order to achieve better performance.
Features of the DB2 core database
1) Support for Object-Oriented Programming
DB2 supports complex data structures, such as unstructured text objects, which can be searched by Boolean match, closest match, and arbitrary match.
You can create user data types and user-defined functions.
2) support for Multimedia Applications
DB2 supports BLOB (a binary object), allowing access to Binary large objects and text large objects in the database. Binary large objects can be used to store multiple
Media object.
3) backup and recovery capabilities
4) supports stored procedures and triggers. You can define complex integrity rules displayed during table creation.
5) support for silicon SQL queries
6) supports access to Heterogeneous Distributed Databases
7) supports data replication
Development Tools
IBM provides many development tools, including Visualizer Query, VisualAge, and VisualGen.
Visualizer is an integrated tool software in the customer/server environment. It mainly includes the Visualizer Query Visual Query Tool and Visualizer
Ultimedia Query visual multimedia Query tool, Visualizer chart visual icon tool, Visualizer procedure visual process tool,
Visualizer statistics visual statistics Tool, Visualizer Plans visual planning tool, Visualizer Development Visual Development Engineer
.
VisualAge is a highly functional and visualized object-oriented application development tool that can greatly improve the efficiency of software development. Its main features include:
1) visual programming tools.
2) Component Library. This includes prefabricated components that support graphical user interfaces and common components that include database queries, transactions, and local and remote functions.
3) relational database support.
4) group program design.
5) supports enhanced dynamic connection libraries.
6) supports multimedia.
7) data sharing is supported.
VisualGen is an important part of IBM's efficient development solutions. It integrates the fourth generation language, Client/Server, and object-oriented technology, providing users with a complete and efficient development environment.