bdfd1m03 | Database Administration |
- Four Normalized Tables
- Read Process for Checking Seat Availability Before Optimization
- Altering the Tables to Improve Availability Checking
- Read Process for Displaying Passengers Booked on a Flight
- Duplicating Names to Display Passengers Booked on a Flight
- Duplicating Flights and Dates to Improve Flight Display
- Read Process for Canceling Passenger Bookings
- Four Revised Tables
- Adding Pointer Tables to Improve Access to the Passenger Table
- Adding a Pointer to Improve Access between the Flight and Seat Tables
- Adding a Pointer to Improve Access between the Seat and Passenger Tables
- Adding a Pointer to Improve Access between the Flight and Aircraft Tables
- Final Tables Showing the Database Structure
- Number of LRECs Required for Each File
- Spreading Data over Several LRECs
- TPFDF Files: DSECT Names, Algorithms, and Paths
- DSECT to Define the Passenger Name File
- Position of IR20DF in the File Structure
- DSECT to Define the Passenger Number File
- Position of IR21DF in the File Structure
- DSECT to Define the Flight File
- Position of IR22DF in the File Structure
- DSECT to Define the Seat File
- Position of IR23DF in the File Structure
- DSECT to Define the Passenger File
- Index Key Definitions for Path 0, IR20DF to IR24DF
- Index Key Definitions for Path 1, IR21DF to IR24DF
- Index Key Definitions for Path 2, IR23DF to IR24DF
- Position of IR24DF in the File Structure
- DSECT to Define the Aircraft File
- Position of IR25DF in the File Structure
- Syntax of a DSECT Macro File Name
- Instructions Always Required at the Start of a DSECT Macro Definition
- Instructions to Assign Values to Global Set Symbols
- Instructions Always Required after Setting the Global Symbols in a DSECT Macro
- Instructions to Define the File Header in a DSECT Macro
- Instructions to Define the LREC Size and LREC ID Fields
- Defining Two Different LREC Types in a DSECT
- Defining User Fields in a DSECT
- DSECT Code to Define the Algorithm String Size
- Instructions Always Required at the End of a DSECT Macro
- C Structure for a File with Existing DSECT Definitions
- Read-Only Default Keys in the DBDEF
- QUE=NO Parameter
- Using the CDR Parameter to Override PIT Parameter Value
- Index File Pointing to Detail Subfiles
- Subfile Data Moved to Index File
- Index File Pointing to Different Subfiles
- Index File Pointing to Combined Subfiles
- Subfiles Accessed from an Index File
- Subfiles Accessed Using Algorithm #TPFDB05
- File Description for Simple Indexing
- File Description for Multiple Indexing to a Single Detail Subfile
- Algorithm String for the Update Path
- Reading the Detail File through Index File GRY1DF
- Reading the Detail File through Index File GRY2DF
- File Description for Multiple-Level Indexing
- Addressing Argument and Index Key for the Top-Level Index File
- Addressing Argument and Index Key for the Intermediate-Level Index File
- Separate Entries for One Passenger Name
- One Index File Pointing to Two Detail Files
- Index TLREC
- Block Indexing
- Sample B+Tree File
- B+Tree Data File DSECT and DBDEF
- B+Tree Index File DSECT and DBDEF
- DBDEF for Multiple ECB Chain Chasing
- Partitioning: &SW00xxx: PTN, BOR, EOR, and EO#
- Interleaving: &SW00xxx: ILV, BOR, EOR, and EO#
- NAB-Type File with Fixed-Length Items (CBV=1)
- NAB-Type File with Variable-Length Items (CBV=4)
- ADD/DEL-Type File with Fixed-Length Items (CBV=1)
- ADD/DEL-Type File with Variable-Length Items (CBV=4)
- CNT-Type File (CBV=2): Using the CNT Parameter
- CNT-Type File (CBV=2): Using the CPT Parameter
- File Containing Only Fixed-Position References (CBV=3)