Overview of DB2 database features

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.
DB2 core database features:
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 multimedia objects.
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 visual Query tools, visual izer Ultimedia Query visual multimedia Query tools, visual izer chart visual icon tools, and visual izer procedure visual process tools, 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.