AI SearchPerformance and transaction cost variations of SQL/DS data base against selected parameters (Record no. 86515)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 03439nam a2200433 4500 |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20260818171509.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 280898 th eng |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | .b10494649 |
| 099 #9 - LOCAL FREE-TEXT CALL NUMBER (OCLC) | |
| Classification number | AIT Thesis no. CS-87-16 |
| 100 0# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Orachorn Punyajaray |
| 245 10 - TITLE STATEMENT | |
| Title | Performance and transaction cost variations of SQL/DS data base against selected parameters |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. | |
| Place of publication, distribution, etc. | Bangkok : |
| Name of publisher, distributor, etc. | Asian Institute of Technology, |
| Date of publication, distribution, etc. | 1987 |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 122 p. |
| 490 1# - SERIES STATEMENT | |
| Series statement | Thesis ; |
| Volume/sequential designation | no. CS-87-16 |
| 500 ## - GENERAL NOTE | |
| General note | A thesis submitter in partial fulfillment of the requirements for the degree of Master of Science, School of Engineering and Technology |
| 502 ## - DISSERTATION NOTE | |
| Dissertation note | Thesis (M.Sc.) - Asian Institute of Technology, 1987 |
| 520 ## - SUMMARY, ETC. | |
| Summary, etc. | 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 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Data base management |
| 700 1# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Niem, Lechi, |
| Relator term | Chairperson |
| 700 1# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Huynh, Ngoc Phien, |
| Relator term | Examination Committee |
| 700 1# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Venkatachalam, Paruvachi A., |
| Relator term | Examination Committee |
| 700 1# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Gonzales, Jr. R. L., |
| Relator term | Examination Committee |
| 810 2# - SERIES ADDED ENTRY--CORPORATE NAME | |
| Corporate name or jurisdiction name as entry element | Asian Institute of Technology. |
| Title of a work | Thesis ; |
| Volume/sequential designation | no. CS-87-16 |
| 856 ## - ELECTRONIC LOCATION AND ACCESS | |
| Materials specified | Full-Text |
| Uniform Resource Identifier | <a href="http://203.159.5.9/ait-thesis/detail.php?q=B19174">http://203.159.5.9/ait-thesis/detail.php?q=B19174</a> |
| 907 ## - LOCAL DATA ELEMENT G, LDG (RLIN) | |
| a | .b10494649 |
| b | mnait |
| c | x |
| 902 ## - LOCAL DATA ELEMENT B, LDB (RLIN) | |
| a | 250325 |
| 998 ## - LOCAL CONTROL INFORMATION (RLIN) | |
| Operator's initials, OID (RLIN) | 2 |
| Cataloger's initials, CIN (RLIN) | 951012 |
| First date, FD (RLIN) | m |
| -- | a |
| -- | x |
| -- | 0 |
| 945 ## - LOCAL PROCESSING INFORMATION (OCLC) | |
| l | mnait |
| 945 ## - LOCAL PROCESSING INFORMATION (OCLC) | |
| l | mnait |
| 945 ## - LOCAL PROCESSING INFORMATION (OCLC) | |
| l | mnarc |
| 945 ## - LOCAL PROCESSING INFORMATION (OCLC) | |
| l | mnarc |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Koha item type | 20-AIT Publication |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Koha item type | 40-Archives |
| 909 ## - LOCAL ITEMS USED | |
| Barcode | Barcode : 30050003148243 |
| CREATED | CREATED : 1994-05-18 |
| RECORD Id | RECORD # : i10620394 |
| LPATRON | LPATRON : 0 |
| LCHKIN | LCHKIN : - |
| RENEWALS | # RENEWALS : 0 |
| -- | # OVERDUE : 0 |
| -- | IUSE3 : 0 |
| -- | TOT CHKOUT : 0 |
| -- | TOT RENEW : 0 |
| 909 ## - LOCAL ITEMS USED | |
| Barcode | Barcode : 30050002588035 |
| CREATED | CREATED : 1994-05-18 |
| RECORD Id | RECORD # : i10620400 |
| LPATRON | LPATRON : 0 |
| LCHKIN | LCHKIN : - |
| RENEWALS | # RENEWALS : 0 |
| -- | # OVERDUE : 0 |
| -- | IUSE3 : 0 |
| -- | TOT CHKOUT : 0 |
| -- | TOT RENEW : 0 |
| 909 ## - LOCAL ITEMS USED | |
| Barcode | Barcode : 30050003148235 |
| CREATED | CREATED : 1994-12-21 |
| RECORD Id | RECORD # : i11755751 |
| LPATRON | LPATRON : 0 |
| LCHKIN | LCHKIN : - |
| RENEWALS | # RENEWALS : 0 |
| -- | # OVERDUE : 0 |
| -- | IUSE3 : 0 |
| -- | TOT CHKOUT : 0 |
| -- | TOT RENEW : 0 |
| 909 ## - LOCAL ITEMS USED | |
| Barcode | Barcode : 30050120373617 |
| CREATED | CREATED : 2016-08-06 |
| RECORD Id | RECORD # : i13023226 |
| LPATRON | LPATRON : 0 |
| LCHKIN | LCHKIN : - |
| RENEWALS | # RENEWALS : 0 |
| -- | # OVERDUE : 0 |
| -- | IUSE3 : 0 |
| -- | TOT CHKOUT : 0 |
| -- | TOT RENEW : 0 |
| Withdrawn status | Lost status | Damaged status | Not for loan | Home library | Current library | Shelving location | Date acquired | Total checkouts | Full call number | Barcode | Date last seen | Copy number | Price effective from | Koha item type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Available for Loans | Asian Institute of Technology Library | Asian Institute of Technology Library | AIT Publications | 18/08/2026 | AIT Thesis no. CS-87-16 | 30050003148243 | 18/08/2026 | 1 | 18/08/2026 | 20-AIT Publication | ||||
| Available for Loans | Asian Institute of Technology Library | Asian Institute of Technology Library | AIT Publications | 18/08/2026 | AIT Thesis no. CS-87-16 | 30050002588035 | 18/08/2026 | 2 | 18/08/2026 | 20-AIT Publication | ||||
| Available for Loans | Asian Institute of Technology Library | Asian Institute of Technology Library | Archives | 18/08/2026 | AIT Thesis no. CS-87-16 | 30050003148235 | 18/08/2026 | 3 | 18/08/2026 | 20-AIT Publication | ||||
| Available for Loans | Asian Institute of Technology Library | Asian Institute of Technology Library | Archives | 18/08/2026 | AIT Thesis no. CS-87-16 | 30050120373617 | 18/08/2026 | 18/08/2026 | 40-Archives |