Skip to Main Content
DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition
book

DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition

by Raul F. Chong, Clara Liu
October 2013
Beginner to intermediate content levelBeginner to intermediate
784 pages
20h 55m
English
IBM Press
Content preview from DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition

Chapter 7. Working with Database Objects

In this chapter, we discuss how to create and work with databases. First, we explain how DB2 stores database objects on disk and memory with an introduction to different concepts such as automatic storage, storage groups, table spaces, and buffer pools. Then we describe the various database objects that can be created in the database, such as tables, indexes, and views. The chapter assumes you have basic knowledge of the Structure Query Language (SQL); if not, refer to Appendix B, “Introduction to SQL.”

In this chapter, you learn about

The big picture of DB2 databases and database objects

Database creation and structure

The definitions of database partitions, partition groups, table spaces, buffer ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL for Data Analysis

SQL for Data Analysis

Cathy Tanimura
Oracle DBA Fundamentals

Oracle DBA Fundamentals

Robert G. Freeman

Publisher Resources

ISBN: 9780133461930Purchase book