Skip to main content
Article thumbnail
Location of Repository

Confiscation of Duplicate Tuples in The Relational Databases

By Dr.K.VenkataRamana* and Dr.G.V.Ramesh Babu

Abstract

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

Topics: Relational Database, Duplicate Tuples, Joins, Union, Engineering (General). Civil engineering (General), TA1-2040, Technology, T
Publisher: International Journal of Engineering Research and Applications
Year: 2016
OAI identifier: oai:doaj.org/article:33b767773f8d43d79f7ae9537343ae9d
Journal:
Download PDF:
Sorry, we are unable to provide the full text but you may find it at the following location(s):
  • https://doaj.org/toc/2248-9622 (external link)
  • https://doaj.org/toc/2248-9622 (external link)
  • http://www.ijera.com/papers/Vo... (external link)
  • https://doaj.org/article/33b76... (external link)
  • Suggested articles


    To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.