Part II Oracle Data Structures

This part describes the basic data structures of a database, including data integrity rules, and the structures that store metadata.

• Tables and Table Clusters
  This chapter provides an introduction to schema objects and discusses tables, which are the most common types of schema objects.
• Indexes and Index-Organized Tables
  Indexes are schema objects that can speed access to table rows. Index-organized tables are tables stored in an index structure.
• Partitions, Views, and Other Schema Objects
  Although tables and indexes are the most important and commonly used schema objects, the database supports many other types of schema objects, the most common of which are discussed in this chapter.
• Data Integrity
  This chapter explains how integrity constraints enforce the business rules associated with a database and prevent the entry of invalid information into tables.
• Application Data Usage
  This chapter explains what data use case domains and schema annotations are.
• Data Dictionary and Dynamic Performance Views
  The central set of read-only reference tables and views of each Oracle database is known collectively as the data dictionary. The dynamic performance views are special views that are continuously updated while a database is open and in use.