IBM DB2 Application Development Guide

Author: Yang Jian
Publisher:
Publish Date: 2004-01-01
Features: DB2UDBV8 is a powerful relational database management system (RDBMS) launched by IBM, allowing terminal users and programmers to access and manipulate data through Structured Query Language (SQL). IBM first proposed the relational database model in 1970, marking an important milestone in the history of database technology. Over the years, IBM has been committed to the research and development of relational database technology and was among the first to introduce relational database products into practical applications. Due to IBM's continuous investment in database products, DB2 has maintained a leading position in the highly competitive database market. Currently, DB2 has evolved into a comprehensive database management system that helps users establish unified or distributed enterprise-level database systems and applications across various platforms or environments. It offers excellent scalability, supporting hardware systems ranging from single processors to multi-processors and large-scale parallel processing. It can store and retrieve multimedia information such as text, images, and audio, enabling users to develop rich, visually appealing applications. With its robust web connectivity and full support for Java, DB2 provides a solid foundation for users to develop a wide range of e-commerce solutions. This book introduces the latest version of DB2—DB2V8. Through specific examples, it provides a detailed overview of IBM's comprehensive support for enterprise application development, including: an overview of DB2 application development, SQL, database objects, logical database design, physical database design, application development center, information catalog center, creating a DB2 database, large objects, user-defined types, SQL procedures, embedded SQL, web application development, Java application development, DB2XML application development, DB2 connectivity, distributed databases, and general development techniques and tips for building data warehouses. The IBM DB2 database environment is renowned for its use in large companies, government agencies, telecommunications, and postal services that require massive data processing. Since the launch of multiple products for users of different levels in October 2002, DB2V8 has seen increasingly widespread application. This book introduces the latest version of DB2—DB2V8. Through specific examples, it provides a detailed overview of IBM's comprehensive support for enterprise application development, including: an overview of DB2 application development, SQL, database objects, logical database design, physical database design, application development center, information catalog center, creating a DB2 database, large objects, user-defined types, SQL procedures, embedded SQL, web application development, Java application development, DB2XML application development, DB2 connectivity, distributed databases, and general development techniques and tips for building data warehouses. This book is suitable for database administrators or programmers with some experience in database management or programming, as well as enterprise data analysts engaged in data warehouse application development and data mining.