Figures

  1. Four Normalized Tables
  2. Read Process for Checking Seat Availability Before Optimization
  3. Altering the Tables to Improve Availability Checking
  4. Read Process for Displaying Passengers Booked on a Flight
  5. Duplicating Names to Display Passengers Booked on a Flight
  6. Duplicating Flights and Dates to Improve Flight Display
  7. Read Process for Canceling Passenger Bookings
  8. Four Revised Tables
  9. Adding Pointer Tables to Improve Access to the Passenger Table
  10. Adding a Pointer to Improve Access between the Flight and Seat Tables
  11. Adding a Pointer to Improve Access between the Seat and Passenger Tables
  12. Adding a Pointer to Improve Access between the Flight and Aircraft Tables
  13. Final Tables Showing the Database Structure
  14. Number of LRECs Required for Each File
  15. Spreading Data over Several LRECs
  16. TPFDF Files: DSECT Names, Algorithms, and Paths
  17. DSECT to Define the Passenger Name File
  18. Position of IR20DF in the File Structure
  19. DSECT to Define the Passenger Number File
  20. Position of IR21DF in the File Structure
  21. DSECT to Define the Flight File
  22. Position of IR22DF in the File Structure
  23. DSECT to Define the Seat File
  24. Position of IR23DF in the File Structure
  25. DSECT to Define the Passenger File
  26. Index Key Definitions for Path 0, IR20DF to IR24DF
  27. Index Key Definitions for Path 1, IR21DF to IR24DF
  28. Index Key Definitions for Path 2, IR23DF to IR24DF
  29. Position of IR24DF in the File Structure
  30. DSECT to Define the Aircraft File
  31. Position of IR25DF in the File Structure
  32. Syntax of a DSECT Macro File Name
  33. Instructions Always Required at the Start of a DSECT Macro Definition
  34. Instructions to Assign Values to Global Set Symbols
  35. Instructions Always Required after Setting the Global Symbols in a DSECT Macro
  36. Instructions in a DSECT macro to define the file header with 4-byte file addresses
  37. Instructions in a DSECT Macro to define the file header with 8-byte file addresses
  38. Instructions to Define the LREC Size and LREC ID Fields
  39. Defining Two Different LREC Types in a DSECT
  40. Defining User Fields in a DSECT
  41. DSECT Code to Define the Algorithm String Size
  42. Instructions Always Required at the End of a DSECT Macro
  43. C Structure for a File with Existing DSECT Definitions
  44. Read-Only Default Keys in the DBDEF
  45. QUE=NO Parameter
  46. Multi-level indexes
  47. Using the CDR Parameter to Override PIT Parameter Value
  48. Index File Pointing to Detail Subfiles
  49. Subfile Data Moved to Index File
  50. Index File Pointing to Different Subfiles
  51. Index File Pointing to Combined Subfiles
  52. Subfiles Accessed from an Index File
  53. Subfiles Accessed Using Algorithm #TPFDB05
  54. File Description for Simple Indexing
  55. File Description for Multiple Indexing to a Single Detail Subfile
  56. Algorithm String for the Update Path
  57. Reading the Detail File through Index File GRY1DF
  58. Reading the Detail File through Index File GRY2DF
  59. File Description for Multiple-Level Indexing
  60. Addressing Argument and Index Key for the Top-Level Index File
  61. Addressing Argument and Index Key for the Intermediate-Level Index File
  62. Separate Entries for One Passenger Name
  63. One Index File Pointing to Two Detail Files
  64. Index TLREC
  65. Block Indexing
  66. Sample B+Tree File
  67. B+Tree Data File DSECT and DBDEF
  68. B+Tree Index File DSECT and DBDEF
  69. DBDEF for Multiple ECB Chain Chasing
  70. Partitioning: &SW00xxx: PTN, BOR, EOR, and EO#
  71. Interleaving: &SW00xxx: ILV, BOR, EOR, and EO#
  72. Type-1 large logical record block structure
  73. Layout of the first block of a type-1 large logical record
  74. Type-2 large logical record file block structure
  75. Layout of the first block of a type-2 Large logical record
  76. NAB-Type File with Fixed-Length Items (CBV=1)
  77. NAB-Type File with Variable-Length Items (CBV=4)
  78. ADD/DEL-Type File with Fixed-Length Items (CBV=1)
  79. ADD/DEL-Type File with Variable-Length Items (CBV=4)
  80. CNT-Type File (CBV=2): Using the CNT Parameter
  81. CNT-Type File (CBV=2): Using the CPT Parameter
  82. File Containing Only Fixed-Position References (CBV=3)