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 81
- Downloads 0
Finite Element Analysis and optimization of Automotive Composite Drive Shaft
Almost all automobiles (at least those which correspond to design with rear wheel drive and front engine installation) have transmission shafts. The weight reduction of the drive shaft can have a certain role in the gene...
Telematics and its Applications in Automobile Industry
This paper introduces Telematics and applications of Telematics in automobiles and discuss how the Telematics communication will happen. This paper also discuss the role of Vehicle Telematics in Automobile Industry...
Optimization Speed Control of DC Separately Excited Motor Using Tuning Controller of Linear Quadratic Regulator (LQR) Technique
The tuning of Linear Quadratic regulator (LQR) controllers is a challenge for researchers and plant operators. This paper presents a optimization and comparison of time response specification between Traditional ZN Tunin...
Steps Involved in Heart Sound Analysis- A Review of Existing Trends
This paper reviews the heart sounds thought to be extremely important to access the condition of heart and covers the stages involved in Phonocardiograph (PCG) signal analysis which includes signal acquisition, m...
Concept of Green Concrete Using Construction Demolished Waste As Recycled Coarse Aggregate
The use of Recycle product is increasing with innovation in present scenario. The utilization of waste product in the manufacturing of new product is a challenging job. The Natural Resource decreases in a...