A Hybrid Relational Database Model for Uncertain and Imprecise Information


  • Hoa Nguyen Information Technology Faculty Saigon University, Vietnam




Fuzzy probabilistic triple, - equivalence, uncertain and imprecise information, relational algebraic operation


Recent years, many fuzzy or probabilistic database models have been built for representing and handling imprecise or uncertain information of objects in real-world applications. However, relational database models combining the relevance and strength of both fuzzy set and probability theories have rarely been proposed. This paper introduces a new relational database model, as a hybrid one combining consistently fuzzy set theory and probability theory for modeling and manipulating uncertain and imprecise information, where the uncertainty and imprecision of a relational attribute value are represented by a fuzzy probabilistic triple, the computation and combination of relational attribute values are implemented by using the probabilistic interpretation of binary relations on fuzzy sets, and the elimination of redundant data is dealt with by coalescing e-equivalent tuples. The basic concepts of the classical relational database model are extended in this new model. Then the relational algebraic operations are formally defined accordingly. A set of the properties of the relational algebraic operations is also formulated and proven.


J.F. Baldwin, J.M. Lawry, and T.P. Martin, “A mass assignment theory of the probability of fuzzy eventsâ€, Journal of Fuzzy Sets and Systems, vol. 83, pp. 353-367, 1996.

J.F. Baldwin, J.M. Lawry, and T.P. Martin, “A note on probability/possibility consistency for fuzzy eventsâ€, in Proceedings of the 6th International Conference on Information Processing and Management of Uncertainty in Knowledge-Based Systems, IPMU'96, Granada, Spain, pp. 521-525, 1996.

E.F. Codd, “A relational model of data for large shared data banksâ€, Communications of the ACM, vol. 13, pp. 377-387, 1970.

T. H. Cao, and H. Nguyen, “Uncertain and fuzzy object bases: a data model and algebraic operationsâ€, International Journal of Uncertainty Fuzziness and Knowledge-Based Systems, vol. 19, pp. 275−305, 2011.

C.J. Date, An introduction to database systems, the 8th Edition, Addison Wesley, 2008.

T. Cao, H. Nguyen, A. Inoue, and D. Zhou, "A Probabilistic Relational Database Model with Fuzzy Attribute Valuesâ€, in Proceedings of the 2019 IEEE International Conference on Fuzzy Systems (FUZZ-IEEE), New Orleans, Louisiana,USA, pp.338-343, 2019.

D. Dey and S. A. Sarkar, “A probabilistic relational model and algebraâ€, ACM Transactions on Database Systems, vol. 21, pp. 339-369, 1996.

T. Eiter, T. Lukasiewicz, and M. Walter, “A data model and algebra for probabilistic complex valuesâ€, Annals of Mathematics and Artificial Intelligence, vol. 33, pp. 205-252, 2001.

T. Eiter, J.J. Lu, T. Lukasiewicz, and V.S. Subrahmanian, “Probabilistic object basesâ€, ACM Transactions on Database Systems (TODS), vol. 26, pp. 264-312, 2001.

T. Ge, A. Dekhtyar, and J. Goldsmith, “Uncertain data: Representations, query processing, and applicationsâ€, in Studies in Fuzziness and Soft Computing, Springer-Verlag Berlin Heidelberg, pp. 67-108, 2013.

G.J. Klir, and B. Yuan, Fuzzy sets and fuzzy logic -Theory and applications, Prentice Hall PTR, 1994.

Z. Ma, and L. Yan, Advances in probabilistic databases for uncertain information management, Springer, 2013.

Z. Ma, and L. Yan, “Modeling fuzzy data with RDF and fuzzy relational database modelsâ€, International Journal of Intelligent Systems, vol. 33, pp. 1534-1554, 2018.

X. Meng, Z.M. Ma, and X. Zhu, “A Knowledge-based fuzzy query and results ranking approach for relational databasesâ€, Journal of Computational Information Systems, vol. 6, pp. 2037-2044, 2010.

J. Mishra, and S. Ghosh, “A new functional dependency in a vague relational database modelâ€, International Journal of Computer Applications, vol. 39, pp. 29-36, 2012.

H. Nguyen, and D.H. Tran, “A probabilistic relational data model for uncertain informationâ€, in Proceedings of the 3rd IEEE International Conference on Information Science and Technology (ICIST), Yangzhou, China, pp. 607-613, 2013.

H. Nguyen, “Towards a fuzzy probabilistic relational data base modelâ€, in Proceedings of the 7th IEEE International Conference on Knowledge and Systems Engineering (KSE), Ho Chi Minh City, Vietnam, pp. 298-301, 2015.

H. Nguyen, “A fuzzy probabilistic relational database model and algebraâ€, Journal of Computer Science and Cybernetics, vol. 32, pp. 189-207, 2016.

H. Nguyen, “Extending relational database model for uncertain informationâ€, Journal of Computer Science and Cybernetics, vol.35, pp.355-372, 2019.

K. Papaioannou, M. Theobald, and M. Boehlen, “Supporting set operations in temporal-probabilistic databasesâ€, in Proceedings of the 34th IEEE International Conference on Data Engineering (ICDE), Paris, France, pp. 1180 -1191, 2018.

F.E. Petry, Fuzzy databases: Principles and applications, Kluwer Academic Publishers, 1996.

R. Ross, and V.S. Subrahmanian, “Aggregate operators in probabilistic databasesâ€, Journal of the ACM, vol. 52, pp. 54-101, 2005.

A.A. Sabour, A.M. Gadallah, and H.A. Hefny, “Flexible querying of relational databases: fuzzy set based approachâ€, Advanced Machine Learning Technologies and Applications Communications in Computer and Information Science, vol. 488, pp. 446-455, 2014.

L. Yan, and Z.M. Ma, “A fuzzy probabilistic relational database model and algebraâ€, International Journal of Fuzzy Systems, vol. 15, pp. 244-253, 2013.

L. Yan, and Z.M. Ma, “A Probabilistic Nested Relational Database Model with Fuzzy Probability Measuresâ€, in Proceedings of the 2019 IEEE International Conference on Fuzzy Systems (FUZZ-IEEE), New Orleans, Louisiana,USA, pp.253-257, 2019.

L.A. Zadeh, “Fuzzy setsâ€, Journal of Information and Control, vol. 8, pp. 338-353, 1965.

S. Zhang, and C. Zhang, “A probabilistic data model and its semanticsâ€, Journal of Research and Practice in Information Technology, vol. 35, pp. 237-256, 2003.

W. Zhao, A. Dekhtyar, and J. Goldsmith, “Databases for interval probabilitiesâ€, International Journal of Intelligent Systems, vol. 19, pp. 789-815, 2004.



How to Cite

Nguyen, H. (2020). A Hybrid Relational Database Model for Uncertain and Imprecise Information. Asian Journal of Computer and Information Systems, 8(3). https://doi.org/10.24203/ajcis.v8i3.6178