bdfd1m03Database Administration


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 to Define the File Header in a DSECT Macro
  37. Instructions to Define the LREC Size and LREC ID Fields
  38. Defining Two Different LREC Types in a DSECT
  39. Defining User Fields in a DSECT
  40. DSECT Code to Define the Algorithm String Size
  41. Instructions Always Required at the End of a DSECT Macro
  42. C Structure for a File with Existing DSECT Definitions
  43. Read-Only Default Keys in the DBDEF
  44. QUE=NO Parameter
  45. Using the CDR Parameter to Override PIT Parameter Value
  46. Index File Pointing to Detail Subfiles
  47. Subfile Data Moved to Index File
  48. Index File Pointing to Different Subfiles
  49. Index File Pointing to Combined Subfiles
  50. Subfiles Accessed from an Index File
  51. Subfiles Accessed Using Algorithm #TPFDB05
  52. File Description for Simple Indexing
  53. File Description for Multiple Indexing to a Single Detail Subfile
  54. Algorithm String for the Update Path
  55. Reading the Detail File through Index File GRY1DF
  56. Reading the Detail File through Index File GRY2DF
  57. File Description for Multiple-Level Indexing
  58. Addressing Argument and Index Key for the Top-Level Index File
  59. Addressing Argument and Index Key for the Intermediate-Level Index File
  60. Separate Entries for One Passenger Name
  61. One Index File Pointing to Two Detail Files
  62. Index TLREC
  63. Block Indexing
  64. Sample B+Tree File
  65. B+Tree Data File DSECT and DBDEF
  66. B+Tree Index File DSECT and DBDEF
  67. DBDEF for Multiple ECB Chain Chasing
  68. Partitioning: &SW00xxx: PTN, BOR, EOR, and EO#
  69. Interleaving: &SW00xxx: ILV, BOR, EOR, and EO#
  70. NAB-Type File with Fixed-Length Items (CBV=1)
  71. NAB-Type File with Variable-Length Items (CBV=4)
  72. ADD/DEL-Type File with Fixed-Length Items (CBV=1)
  73. ADD/DEL-Type File with Variable-Length Items (CBV=4)
  74. CNT-Type File (CBV=2): Using the CNT Parameter
  75. CNT-Type File (CBV=2): Using the CPT Parameter
  76. File Containing Only Fixed-Position References (CBV=3)