This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 1 C H A P T E R 1 Introduction to Database Applications for DB2 T he relational database of choice for modern distributed applications is IBMs widely popular DB2 Universal Database (UDB). DB2 UDB V7.1 provides high-performance data access, reliability, and an abundance of advanced features. Whether your application is an e-commerce site on the Web or a directory service such as a Lightweight Directory Access Pro- tocol (LDAP) server, the overall concepts for all database applications remain the same. Data- base applications mostly perform two major tasks, and are categorized as such. Applications that modify the contents of databases and perform transaction processing are known as Online Trans- action Processing (OLTP) applications. Applications that perform ad hoc queries to analyze the contents of databases are known as Decision Support Systems (DSS), or Online Analytical Pro- cessing (OLAP) applications. All applications communicate with DB2 in a client/server environment using the Struc- tured Query Language (SQL) within the context of one or more programming interfaces such as embedded SQL, JDBC, and the Perl DBI (Database Interface). Different interfaces also provide additional features that you may find useful. This is why it is important to understand the options available to you as an application developer. In this chapter, we introduce fundamental DB2 concepts and describe how applications connect to DB2 and use SQL statements to access and modify data in a DB2 UDB database. We assume that you already know about database objects such as tables and indexes, and that you are also familiar with SQL from the companion to this guide, The DB2 V7.1 Administration Cer- tification Guide . We still cover each of these topics briefly within this chapter to ensure you have an understanding of them for the purposes of the certification exam. You can find a complete reference for SQL and DB2 database objects in the SQL Refer- ence , which is included among the DB2 online books. The SQL Getting Started guide is another online book that includes a good tutorial on SQL. If you require information about installing 9136G-C.fm Page 1 Monday, November 6, 2000 11:22 AM 2 Chapter 1 Introduction to Database Applications for DB2 DB2, please refer to the DB2 Quick Beginnings books applicable to your environment, or read Chapter 2 of The DB2 V7.1 Administration Certification Guide . 1.1 Objectives In each chapter, we will begin with a set of goals for the reader. These goals will describe the concepts you should be familiar with after reading the chapter and completing the exercises. After reading the first chapter, you should have a general understanding of: The DB2 UDB client server environment....
View Full Document
- Spring '11
- Relational Database