Relational database is a collection of relations. Duplicate tuple existence is common in many real time relational\ud databases. There is no known, simple and direct technique for finding duplicated records in relational database.\ud In a relational database, if the same real-world entity is represented by more than one tuple, then such tuples are\ud called duplicate tuples. Finding duplicate tuples and then replacing them by one best tuple is called a fusion\ud operation. Whenever duplicate tuples are found in the relations of any database, those tuples must be replaced\ud with one special best approximate tuple that represents the joint information of all the duplicate tuples. Present\ud study proposes new techniques to find duplicate tuples and then remove those duplicate tuples with the correct\ud real world tuples. In the first step duplicate tuples in the relation are classified based on the class label and in the\ud second step then for each set of duplicate tuples functional dependency method or union method is applied to\ud replace duplicate tuples with the corresponding correct real world single tuple. One possibility is to replace one\ud set of duplicate tuples with one correct real world tuple. Another possibility is to replace two or more sets of\ud duplicate tuples in the relation by one set of correct real world tuples. Sometimes the removal of duplicate tuples\ud in the relations of any relational database can create referential integrity violations. All such violations must be\ud controlled and coordinated syntactically as well as semantically in relation
To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.