000 03439nam a2200433 4500
005 20260818171509.0
008 280898 th eng
035 _a.b10494649
099 9 _aAIT Thesis no. CS-87-16
100 0 _aOrachorn Punyajaray
245 1 0 _aPerformance and transaction cost variations of SQL/DS data base against selected parameters
260 _aBangkok :
_bAsian Institute of Technology,
_c1987
300 _a122 p.
490 1 _aThesis ;
_vno. CS-87-16
500 _aA thesis submitter in partial fulfillment of the requirements for the degree of Master of Science, School of Engineering and Technology
502 _aThesis (M.Sc.) - Asian Institute of Technology, 1987
520 _aBuffer 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
650 0 _aData base management
700 1 _aNiem, Lechi,
_eChairperson
700 1 _aHuynh, Ngoc Phien,
_eExamination Committee
700 1 _aVenkatachalam, Paruvachi A.,
_eExamination Committee
700 1 _aGonzales, Jr. R. L.,
_eExamination Committee
810 2 _aAsian Institute of Technology.
_tThesis ;
_vno. CS-87-16
856 _3Full-Text
_uhttp://203.159.5.9/ait-thesis/detail.php?q=B19174
907 _a.b10494649
_bmnait
_cx
902 _a250325
998 _b2
_c951012
_dm
_ea
_fx
_g0
945 _lmnait
945 _lmnait
945 _lmnarc
945 _lmnarc
942 _c20
942 _c40
909 _aBarcode : 30050003148243
_bCREATED : 1994-05-18
_cRECORD # : i10620394
_dLPATRON : 0
_eLCHKIN : -
_f# RENEWALS : 0
_g# OVERDUE : 0
_hIUSE3 : 0
_iTOT CHKOUT : 0
_jTOT RENEW : 0
909 _aBarcode : 30050002588035
_bCREATED : 1994-05-18
_cRECORD # : i10620400
_dLPATRON : 0
_eLCHKIN : -
_f# RENEWALS : 0
_g# OVERDUE : 0
_hIUSE3 : 0
_iTOT CHKOUT : 0
_jTOT RENEW : 0
909 _aBarcode : 30050003148235
_bCREATED : 1994-12-21
_cRECORD # : i11755751
_dLPATRON : 0
_eLCHKIN : -
_f# RENEWALS : 0
_g# OVERDUE : 0
_hIUSE3 : 0
_iTOT CHKOUT : 0
_jTOT RENEW : 0
909 _aBarcode : 30050120373617
_bCREATED : 2016-08-06
_cRECORD # : i13023226
_dLPATRON : 0
_eLCHKIN : -
_f# RENEWALS : 0
_g# OVERDUE : 0
_hIUSE3 : 0
_iTOT CHKOUT : 0
_jTOT RENEW : 0
999 _c86515
_d86515