03439nam a2200433 4500 20260818171509.0 280898 th eng .b10494649 AIT Thesis no. CS-87-16 Orachorn Punyajaray Performance and transaction cost variations of SQL/DS data base against selected parameters Bangkok : Asian Institute of Technology, 1987 122 p. Thesis ; no. CS-87-16 A thesis submitter in partial fulfillment of the requirements for the degree of Master of Science, School of Engineering and Technology Thesis (M.Sc.) - Asian Institute of Technology, 1987 Buffer sizes, the storage and access methods used, cardinality of target tables, and some VM/SP system load indicators were shown to affect the performance of SQL/DS data base and their effects were quantified. Use of appropriate page buffer size and clustering index drastically reduced the CPU time and I/O requirements in retrieval transactions. Regular setting of appropriate page buffer size in order to conserve computer resources and the use the page hit ratio as the parameter to be monitored in order to determine proper page buffer size is recommended. In data base operations involving heavy retrieval transactions from DBSPACEs containing multiple tables, the use of clustering index is re commended to realize savings in computer resources even with the extra DASD space required for the indexes and the inconvenience in creating them. For certain storage/ access cases transaction cost models based on number of pages referenced and cardinality are shown to be in agreement with SQL/DS cost estimate. SQL/DS cost estimate is shown to be a linear function of cardinality in certain storage/access cases. Indexing has minimal effect in reducing transaction cost when the table accessed resides in single-table DBSPACE. Cost reduction is effected when tables have clustering index in multiple-table DBSPACE Data base management Niem, Lechi, Chairperson Huynh, Ngoc Phien, Examination Committee Venkatachalam, Paruvachi A., Examination Committee Gonzales, Jr. R. L., Examination Committee Asian Institute of Technology. Thesis ; no. CS-87-16 Full-Text http://203.159.5.9/ait-thesis/detail.php?q=B19174 .b10494649 mnait x 250325 2 951012 m a x 0 mnait mnait mnarc mnarc 20 40 Barcode : 30050003148243 CREATED : 1994-05-18 RECORD # : i10620394 LPATRON : 0 LCHKIN : - # RENEWALS : 0 # OVERDUE : 0 IUSE3 : 0 TOT CHKOUT : 0 TOT RENEW : 0 Barcode : 30050002588035 CREATED : 1994-05-18 RECORD # : i10620400 LPATRON : 0 LCHKIN : - # RENEWALS : 0 # OVERDUE : 0 IUSE3 : 0 TOT CHKOUT : 0 TOT RENEW : 0 Barcode : 30050003148235 CREATED : 1994-12-21 RECORD # : i11755751 LPATRON : 0 LCHKIN : - # RENEWALS : 0 # OVERDUE : 0 IUSE3 : 0 TOT CHKOUT : 0 TOT RENEW : 0 Barcode : 30050120373617 CREATED : 2016-08-06 RECORD # : i13023226 LPATRON : 0 LCHKIN : - # RENEWALS : 0 # OVERDUE : 0 IUSE3 : 0 TOT CHKOUT : 0 TOT RENEW : 0 86515 86515 0 0 0 0 MAIN MAIN mnait 2026-08-18 0 AIT Thesis no. CS-87-16 30050003148243 2026-08-18 17:15:09 1 2026-08-18 20 0 0 0 0 MAIN MAIN mnait 2026-08-18 0 AIT Thesis no. CS-87-16 30050002588035 2026-08-18 17:15:09 2 2026-08-18 20 0 0 0 0 MAIN MAIN mnarc 2026-08-18 0 AIT Thesis no. CS-87-16 30050003148235 2026-08-18 17:15:09 3 2026-08-18 20 0 0 0 0 MAIN MAIN mnarc 2026-08-18 0 AIT Thesis no. CS-87-16 30050120373617 2026-08-18 17:15:09 2026-08-18 40