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 104
- Downloads 0
Enhancement of the Performance of Ring Laser Gyro using Silane Compound
Ring Laser Gyro ( RLG ), in its original form is insensitive to small rotation rates. This insensitivity occurs because of the coupling between the two counter propagating travelling waves, having a very low frequency di...
Modelling and Analysis of Suspension System of TATA SUMO by using Composite Material under the Static Load Condition by using FEA
In order to conserve natural resources and economize energy, weight reduction has been the main focus of automobile manufacturer in the present scenario. Weight reduction can be achieved primarily by the introduction of...
Parametric Studies of Standard 2-D Roof Truss Configuration
Now a day, our observation about the steel structures, Industrial trusses form one of the major structural systems, which require accurate and economic design. Their span and corresponding weight plays an important role...
Performance And Emissions Characteristics Of Diesel Engine Fuelled With Rice Bran Oil
Due to the scarcity of conventional fuels and the crude oil, the price was going up day to day and there will be no more conventional fuels in future and also increasing the environmental pollution by the usage of crude...
Effect of Reinforcement on Abrasive wear of Different Aluminium based Metal Matrix Composite-A Review
Aluminium alloys are the most widely used nonferrous materials in engineering applications owing to their attractive properties such as high strength to weight ratio, good ductility, excellent corrosion resistance, avail...