The db2 tutorial I am watching is: Comparison of common database systems DB2 databases. DB2 is a product of IBM and originated from System R and System R*. It supports from PC to UNIX, from small and medium-sized machines to mainframes; from IBM to non-IBM (HP and
SUN UNIX system, etc.) various operating platforms. It can be run independently on the host in a master/slave mode or in a client/server environment. Among them the services
The platform can be OS/400, AIX, OS/2, HP-UNIX, SUN-Solaris and other operating systems, and the client platform can be OS/2 or Windows, Dos, AIX, HP-
UX, SUN Solaris and other operating systems.
Database Server
The DB2 database core is also called DB2 public server. It adopts a multi-process and multi-cue architecture and can run on multiple operating systems and according to the corresponding
The platform environment has been adjusted and optimized to achieve better performance.
The features of DB2 core database are:
(1) Support object-oriented programming
DB2 supports complex data structures, such as structureless text objects, which can search for Boolean matching, closest matching and arbitrary matching on structureless text objects.
User data types and user-defined functions can be created.
(2) Support multimedia applications
DB2 supports sophomore binary objects (BLOB), allowing access to binary large objects and text large objects in the database. Among them, large binary objects can be used to store multiple
Media Object.
(3) Backup and recovery capabilities
(4) Support stored procedures and triggers, and users can display complex definition integrity rules when creating tables
(5) Supported silicon SQL query
(6) Support heterogeneous distributed database access
(7) Support data replication
Development Tools
IBM provides many development tools, mainly including Visualizer Query, VisualAge, and VisualGen.
Visualizer is an integrated tool software in the client/server environment, mainly including Visualizer Query visual query tool, Visualizer
Ultimmedia Query visual multimedia query tool, Visualizer chart visual icon tool, Visualizer procedure visualization process tool,
Visualizer statistics visual statistics tool, Visualizer Plans visual planning tool, Visualizer Development visual development worker
Tool.
VisualAge is a highly functional visual object-oriented application development tool that can greatly improve software development efficiency. Its main characteristics are:
(1) Visual programming tool.
(2) Part library. Includes prefab missing that supports graphical user interfaces, and common components that contain database queries, transactions, and local, remote functions.
(3) Relational database support.
(4) Group programming.
(5) Supports enhanced dynamic connection library.
(6) Support multimedia.
(7) Support data sharing.
VisualGen is an important part of the efficient development solutions provided by IBM. It integrates the fourth generation language, client/server and object-oriented technology to use
The household provides a complete and efficient development environment.
SUN UNIX system, etc.) various operating platforms. It can be run independently on the host in a master/slave mode or in a client/server environment. Among them the services
The platform can be OS/400, AIX, OS/2, HP-UNIX, SUN-Solaris and other operating systems, and the client platform can be OS/2 or Windows, Dos, AIX, HP-
UX, SUN Solaris and other operating systems.
Database Server
The DB2 database core is also called DB2 public server. It adopts a multi-process and multi-cue architecture and can run on multiple operating systems and according to the corresponding
The platform environment has been adjusted and optimized to achieve better performance.
The features of DB2 core database are:
(1) Support object-oriented programming
DB2 supports complex data structures, such as structureless text objects, which can search for Boolean matching, closest matching and arbitrary matching on structureless text objects.
User data types and user-defined functions can be created.
(2) Support multimedia applications
DB2 supports sophomore binary objects (BLOB), allowing access to binary large objects and text large objects in the database. Among them, large binary objects can be used to store multiple
Media Object.
(3) Backup and recovery capabilities
(4) Support stored procedures and triggers, and users can display complex definition integrity rules when creating tables
(5) Supported silicon SQL query
(6) Support heterogeneous distributed database access
(7) Support data replication
Development Tools
IBM provides many development tools, mainly including Visualizer Query, VisualAge, and VisualGen.
Visualizer is an integrated tool software in the client/server environment, mainly including Visualizer Query visual query tool, Visualizer
Ultimmedia Query visual multimedia query tool, Visualizer chart visual icon tool, Visualizer procedure visualization process tool,
Visualizer statistics visual statistics tool, Visualizer Plans visual planning tool, Visualizer Development visual development worker
Tool.
VisualAge is a highly functional visual object-oriented application development tool that can greatly improve software development efficiency. Its main characteristics are:
(1) Visual programming tool.
(2) Part library. Includes prefab missing that supports graphical user interfaces, and common components that contain database queries, transactions, and local, remote functions.
(3) Relational database support.
(4) Group programming.
(5) Supports enhanced dynamic connection library.
(6) Support multimedia.
(7) Support data sharing.
VisualGen is an important part of the efficient development solutions provided by IBM. It integrates the fourth generation language, client/server and object-oriented technology to use
The household provides a complete and efficient development environment.