AI SearchDuplicate record detection for database cleansing (Record no. 31836)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 03084nas|a2200409 a 4500 |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20260818094227.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 091112s2009 th uu|m rtt 0| a1eng d |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | .b12070385 |
| 099 #9 - LOCAL FREE-TEXT CALL NUMBER (OCLC) | |
| Classification number | AIT RSPR no.IM-09-01 |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Rehman, Mariam |
| 245 10 - TITLE STATEMENT | |
| Title | Duplicate record detection for database cleansing |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. | |
| Place of publication, distribution, etc. | Pathum Thani, Thailand : |
| Name of publisher, distributor, etc. | Asian Institute of Technology, |
| Date of publication, distribution, etc. | 2009 |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 45 p. : |
| Other physical details | ill. |
| 490 1# - SERIES STATEMENT | |
| Series statement | Research studies project report ; |
| Volume/sequential designation | no. IM-09-01 |
| 500 ## - GENERAL NOTE | |
| General note | A research study submitted in partial fulfillment of the requirements for the degree of Master of Engineering Information Management, School of Engineering and Technology |
| 502 ## - DISSERTATION NOTE | |
| Dissertation note | Research Studies Project Report (M.Eng.) - Asian Institute of Technology, 2009 |
| 520 ## - SUMMARY, ETC. | |
| Summary, etc. | Many organizations collect large amounts of data to support their business and decision making processes. The data collected from various sources may have data quality problems in it. These kinds of issues become prominent when various databases are integrated. The integrated databases inherit the data quality problems that were present in the source database. The data in the integrated systems need to be cleaned for proper decision making. Cleansing of data is one of the most crucial steps. In this research, focus is on one of the major issue of data cleansing i.e. "duplicate record detection" which arises when the data is collected from various sources. As a result of this research study, comparison among standard duplicate detection algorithm, sorted neighborhood algorithm, duplicate elimination sorted neighborhood algorithm, and adaptive duplicate detection algorithm is provided. A prototype is also developed which shows that adaptive duplicate detection algorithm is the optimal solution for the problem of duplicate record detection |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Database management |
| 700 0# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Vatcharaporn Esichaikul, |
| Relator term | Chairperson |
| 700 0# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Vilas Wuwongse, |
| Relator term | Examination Committee |
| 700 1# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Jenecek, Paul, |
| Relator term | Examination committee |
| 710 2# - ADDED ENTRY--CORPORATE NAME | |
| Corporate name or jurisdiction name as entry element | Higher Education Commission ( HEC), Pakistan, |
| Relator term | Scholarship donor |
| 810 2# - SERIES ADDED ENTRY--CORPORATE NAME | |
| Corporate name or jurisdiction name as entry element | Asian Institute of Technology. |
| Title of a work | Research studies project report ; |
| Volume/sequential designation | no. IM-09-01 |
| 856 ## - ELECTRONIC LOCATION AND ACCESS | |
| Materials specified | Full-Text |
| Uniform Resource Identifier | <a href="http://203.159.5.9/ait-thesis/detail.php?q=B01412">http://203.159.5.9/ait-thesis/detail.php?q=B01412</a> |
| 907 ## - LOCAL DATA ELEMENT G, LDG (RLIN) | |
| a | .b12070385 |
| b | mnait |
| c | u |
| 902 ## - LOCAL DATA ELEMENT B, LDB (RLIN) | |
| a | 240329 |
| 998 ## - LOCAL CONTROL INFORMATION (RLIN) | |
| Operator's initials, OID (RLIN) | 0 |
| Cataloger's initials, CIN (RLIN) | 091112 |
| First date, FD (RLIN) | m |
| -- | a |
| -- | u |
| -- | 0 |
| 945 ## - LOCAL PROCESSING INFORMATION (OCLC) | |
| l | mnait |
| 945 ## - LOCAL PROCESSING INFORMATION (OCLC) | |
| l | mnait |
| 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 : 30050120722557 |
| CREATED | CREATED : 2009-12-11 |
| RECORD Id | RECORD # : i12623507 |
| LPATRON | LPATRON : 1025685 |
| LCHKIN | LCHKIN : 2015-01-30 |
| RENEWALS | # RENEWALS : 0 |
| -- | # OVERDUE : 0 |
| -- | IUSE3 : 0 |
| -- | TOT CHKOUT : 3 |
| -- | TOT RENEW : 0 |
| 909 ## - LOCAL ITEMS USED | |
| Barcode | Barcode : 30050120722565 |
| CREATED | CREATED : 2009-12-11 |
| RECORD Id | RECORD # : i12623519 |
| LPATRON | LPATRON : 0 |
| LCHKIN | LCHKIN : - |
| RENEWALS | # RENEWALS : 0 |
| -- | # OVERDUE : 0 |
| -- | IUSE3 : 0 |
| -- | TOT CHKOUT : 0 |
| -- | TOT RENEW : 0 |
| 909 ## - LOCAL ITEMS USED | |
| Barcode | Barcode : 30050160108683 |
| CREATED | CREATED : 2016-08-04 |
| RECORD Id | RECORD # : i12934343 |
| 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 | Cost, normal purchase price | 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 | 50.00 | AIT RSPR no.IM-09-01 | 30050120722557 | 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 | 50.00 | AIT RSPR no.IM-09-01 | 30050120722565 | 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 RSPR no.IM-09-01 | 30050160108683 | 18/08/2026 | 1 | 18/08/2026 | 40-Archives |