A PERSONALIZED SCHEME FOR INCOMPLETE AND DUPLICATE INFORMATION HANDLING IN RELATIONAL DATABASES
Journal Title: International Journal of Engineering Sciences & Research Technology - Year 30, Vol 5, Issue 9
Abstract
Missing data replacement is a crucial process in most real world databases. Due to the tremendous improvement of data management, users of such database can effectively manage the incompleteness using their customized policies. This work proposes the renovated concept of partial information handling with complete prediction model, which handle incompleteness in relational databases. The incomplete data management brings a new challenge which is the data duplication. The Customized Information Prediction Policies with effective index method has been proposed in this work for handling missing data. Different users in the real world have different ways in which they want to handle incompleteness. The CIP operators suggest the best match to replace the null value, and this operator also allows them to state a strategy that matches their attitude to risk and their knowledge of the application. Using the same strategy DIP operators has been introduced to handle duplicate data’s in the relational database. Using the Autoregressive HMM the system improves the prediction method. The CIP manages all data and policies using PQ_ Index structures, which is known as Priority Queue based Index. The present work also analyze how relational algebra operators and PIP operators interact with one another. This also handles the COALESCE function using the CIP operator.
Authors and Affiliations
Dr. K. Sathesh Kumar*
Keywords
Related Articles
- EP ID EP90918
- DOI 10.5281/zenodo.154206
- Views 91
- Downloads 0
Investigation of Structural Properties of Gradient -Porosity Porous Silicon Layer Produced by Laser- Assisted Etching
Laser-assisted etching process with a step-gradient illumination intensity of 630nm laser wavelength was conducted to produce high porosity and minimum thickness of gradient – porosity porous silicon layer (GPSi)....
SOLUTION FOR RUBIK’S CUBE BY USING GENETIC ALGORITHM
Solutions calculated by Genetic Algorithms have come to surpass exact methods for solving various problems. The Rubik’s Cube optimization problem is one such area. In this work we present a different approach to s...
DESIGN AND ANALYSIS OF ROLLER CONVEYOR FOR WEIGHT OPTIMIZATION BY USING COMPOSITE MATERIAL
In the present work, an attempt is made to reduction in weight of existing roller conveyor by optimizing the critical parts of (e.g. Roller,) conveyor without hampering its structural strength. The existing Roller...
STRUCTURAL AND MODEL ANALYSIS OF A COMPOSITE MATERIAL DIFFERENTIAL GEARBOX ASSEMBLY
The main aim of the this project is to study the structural and dynamic behaviour of the gears in the differential gearbox assembly made up of the different composite material as compared to the conventional metallic ma...
Performance of a 3.3kV Resistive type Superconducting Fault Current Limiter
In today’s technological world, electrical energy is one of the most important forms of energy and is needed directly or indirectly in almost every field. Increase in the demand and consumption of electrical energ...