Abstract
An experiment in optimizing the physical storage structures of a DBTG-like database w.r.t. a given transaction load is described. It was carried out during a practical course on database administration. Logical data structures and transaction programs were kept fixed while the underlying storage structures could be varied according to a rich set of options and parameters. The preferences for certain search key and set mode options leading to surprising time differences are discussed. Properties of good optimization solutions are presented. A number of recommendations for the use of the set modes POINTER-ARRAY and CHAIN are given. Finally, some general observations concerning the learning pattern of the students are summarized.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
