Customised Policies for Handling Partial Information in Relational Databases

SEEE DIGIBOOK ON ENGINEERING & TECHNOLOGY, VOL. 01 (2), JUN 2020 PP. (789-797)
Abstract– The overwhelming majority of databases that attempt to replicate the real world are missing at least some of the information that they claim to contain. Users of these kinds of databases are currently “on their own” when it comes to deciding how they will deal with the incompleteness of the data, as no standard protocol has been established in this regard. This paper presents the overarching concept of the partial information policy, also known as the PIP operator for short. The purpose of this paper is to manage incompleteness in relational databases, and the PIP operator will do this. PIP operators are able to accommodate a wide range of different kinds of incomplete information as they construct preference frameworks for use with incomplete data (e.g., a value exists but is not known; a value does not exist; a value may or may not exist). PIP operators give users the ability to specify a policy that corresponds to their perspective on risk, as well as their familiarity with the application and the process by which the data was gathered. This ability is combined with the user’s familiarity with the application and the process by which the data was gathered. In the real world, different users have various preferences regarding the manner in which they wish to deal with incompleteness. We propose index structures for effectively evaluating PIP operators, and we then experimentally evaluate the effectiveness of these index structures using data from a real-world airline data set. This allows us to conclude that our proposed index structures are effective in effectively evaluating PIP operators. In addition to this, we look into the PIP operators as well as the relational algebra operators.
Index Terms – Policies; handling partial information; database;
REFERENCE

Maier, D., 1983. The theory of relational databases (Vol. 11). Rockville: Computer science press.
Halpin, T. and Morgan, T., 2010. Information modeling and relational databases. Morgan Kaufmann.
Yang, X., Procopiuc, C.M. and Srivastava, D., 2009. Summarizing relational databases. Proceedings of the VLDB Endowment, 2(1), pp.634-645.
Li, F. and Jagadish, H.V., 2014. Constructing an interactive natural language interface for relationaldatabases. Proceedings of the VLDB Endowment, 8(1), pp.73-84.
Androutsopoulos, I., Ritchie, G. and Thanisch, P., 1993. Masque/sql–an efficient and portable natural language query interface for relational databases. In Proceedings of the 6th International Conference on Industrial & Engineering Applications of Artificial Intelligence and Expert Systems.
Stonebraker, M., Abadi, D.J., Batkin, A., Chen, X., Cherniack, M., Ferreira, M., Lau, E., Lin, A., Madden, S., O’Neil, E. and O’Neil, P., 2018. C-store: a column-oriented DBMS. In Making Databases Work: the Pragmatic Wisdom of Michael Stonebraker (pp. 491-518).
Seybold, D., Keppler, M., Gründler, D. and Domaschka, J., 2019, April. Mowgli: Finding your way in the dbms jungle. In Proceedings of the 2019 ACM/SPEC International Conference on Performance Engineering (pp. 321 332).
Lemahieu, W., vanden Broucke, S. and Baesens, B., 2018. Principles of database management: the practical guide to storing, managing and Analyzing big and small Data. Cambridge University Press.
Kandiri, J., 2018. Advanced Database Systems. 10.Ladeinde, F., Alabi, K. and Li, W., 2019. Optimization and Database Management in Smart Modeling of Aviation Heat Exchangers. Journal of Thermophysics and Heat Transfer, 33(4), pp.1142-1152.
Patil, N.S., Kiran, P., Kiran, N.P. and KM, N.P., 2018. A survey on graph database management techniques for huge unstructured data. International Journal of Electrical and Computer Engineering, 8(2), p.1140.
Goutam, S., Impact of Object Oriented Concepts on Database Management System.
Zeb, A., 2018. Security of Relational Database Management System: Threats and Security Techniques.

Bharathi S, Karthikeyan J, Manikandan M, Murugan A, Vijayabalan K
Department of Information Technology,
Rathinam Technical Campus,
Coimbatore, India

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top