An Empirical Data Cleaning Technique for CFDs
Journal Title: INTERNATIONAL JOURNAL OF ENGINEERING TRENDS AND TECHNOLOGY - Year 2013, Vol 4, Issue 9
Abstract
Data cleaning is a basic data preprocessing technique for before forwarding the data to data mining approach ,but it leads to an intresting research area in the field of data mining. Data cleaning is the process of finding and deleting noisy data/records from the database. The simplest technique used for data cleaning is based on Functional Dependencies. As FDs works on entire instance of a table we introduced a new technique called Conditional Functional Dependencies. CFDs are like if then rules. The dependence between the columns of a table are represented as conditions using functions.. For example if we consider a employee table which maintains the employee name,id,city,pincode and etc. In this table the employees who are belongs to the same city, are all may have the same pincode, So that we can generate a FD that city--->pincode. CFD means using specific condition for the FD. ex:city=vizag---->pincode=531005. The main agend of our project is to find the CFD violated rows in a table using the created CFDs. These CFDs violated rows are deleted to correct data.
Authors and Affiliations
Satyanarayana Mummana1 , Ravi kiran Rompella
Keywords
Related Articles
- EP ID EP151779
- DOI -
- Views 96
- Downloads 0
BER Performance of MC-CDMA Using Walsh Code with MSK Modulation on AWGN and Rayleigh Channel
Multi-carrier code division multiple access (MCCDMA) is method for high speed data rate communication. It skip the problem of inter symbol interference.MC-CDMA too provide spatial diversity, which mitigate the fa...
Improvement of Rotor Angle Stability and Dynamic Performance of AC/DC Interconnected Transmission System
his paper illustrates a study on improvement of rotor angle and dynamic performance of AC/DC interconnected system. High voltage direct current transmission is an economic way for long distance power delivery and/o...
Mechanical Behaviour of Friction Stir Welding Joints of Aluminium alloy of AA6351 with AA6351 and AA6351 with AA5083
Modern structural application demands reduction in both the weight and as well as cost of the fabrication and production of materials. Aluminium alloys are the best choice for the reduction of weight, cost and replacing...
Intelligent Traffic System Which Respond To Emergencies
Congested roads and heavy traffic are major challenges these days. Traffic lights are the heart to prevent traffic jams. Making them intelligent makes time spent in traffic jams minimized for whom time is critica...
Performance Transaction’s Assessment Of Real Time Database System In Distributed Environment
Database performance is a very important aspect of database usability. The objective of this paper is to proposed policy to forecast the performance of transaction under real time database system in distributed env...