Journal of applied mathematics & informatics

The Korean Society for Computational and Applied Mathematics (한국전산응용수학회)
권호 표지
DOI QR코드

DOI QR Code

ON THE PROPERTIES OF POSITIVE BOOLEAN DEPENDENCIES BY GROUPS IN THE DATABASE MODEL OF BLOCK FORM

  • TRUC, TRINH NGOC (Infomation Technology Institute, Vietnam Women's Academy) ;
  • THANG, TRINH DINH (Infomation Technology Institute, Hanoi Pedagogical University 2 of Vietnam) ;
  • TUYEN, TRAN MINH (Department of Infomation Technology, University union Vietnam)
  • Received : 2021.06.19
  • Accepted : 2022.01.05
  • Published : 2022.05.30
Download PDF
⟨ Previous Next ⟩

Abstract

The article proposed a new type of data relationship: Positive Boolean dependencies by groups on block and slice in the database model of block form, where instead of considering value pairs, we consider a group of p values (p ≥ 2). From this new concept, the article stated and demonstrated the equivalence of the three types of deduction, namely: deduction by logic, deduction by block with groups, deduction by block has no more than p elements with groups. Operations on blocks or slices performed for index attributes on blocks, the properties related to this new concept as theorem the equivalen of the three types of deduction, closure of set positive Boolean dependencies by groups and representation and tight representation set of positive Boolean dependencies by groups when the block degenerated into relation are true in the relational database model and also stated and proven in this paper.

Keywords

Acknowledgement

This work was supported by the research grant of the Vietnam Women's Academy and University Hanoi Pedagogical University 2 of Vietnam.

References

  1. D. Maier, The Theory of Relational Databases, Computer Science Press, Rockville, 1983.
  2. Apostolos Benisis, Business Process Management: A Data Cube To Analyze Business Process Simulation Data For Decision Making Paperback, VDM Verlag Dr. Muller, 2010.
  3. Maurizio Rafanelli, M.Rafanelli, Multidimensional Databases: Problems and Solutions Hardcover, Idea Group Publishing, 2003.
  4. Omar Boussaid and Doulkifli Boukraa. Multidimensional Modeling of Complex Data, Encyclopedia of Data Warehousing and Mining, Second Edition, edited by John Wang, IGI Global, 2009.
  5. Haiping Lu, Konstantinos N. Plataniotis, Anastasios Venetsanopoulos, Multilinear Subspace Learning: Dimensionality Reduction of Multidimensional Data (Chapman & Hall/Crc Machine Learning & Pattern Recognition) 1 edition, 2013.
  6. R. Agrawal, A. Gupta, and S. Sarawagi, Modeling Multidimensional Databases, In Proc. of 13 th, Int. Conf. on Data Engineering (ICDE) IEEE press, 1997, 232-243.
  7. R. Kimball and M. Ross, The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling. 2ed. J. Wiley and Sons, Canada, 2002.
  8. Ralph Kimball, Margy Ross, Warren Thornthwaite, Joy Mundy, Bob Becker, The Data Warehouse Lifecycle Toolkit Paperback, J. Wiley and Sons, Canada, 2008.
  9. G. Garani, G.K. Adam and D. Ventzas, Temporal data warehouse logical modelling, Int. J. Data Mining, Modelling and Management 8 (2016), 144-159. https://doi.org/10.1504/IJDMMM.2016.077156
  10. Krish Krishnan, Data Warehousing in the Age of Big Data, The Morgan Kaufmann Series on Business Intelligence, Morgan Kaufmann; 1 edition, USA, 2013.
  11. Nguyen Xuan Huy, Trinh Dinh Thang, The database model of blocks form, Journal of Informatics and Cybernetics, 14 (1998), 52-60.
  12. Nguyen Xuan Huy, Logical dependencies in the database, Statistical Publisher, HaNoi, 2006.
  13. Trinh Dinh Thang, Tran Minh Tuyen, Logic dependencies in the database model of block forms, Scientific and Technical publishing House, HaNoi, 2020.
  14. Trinh Dinh Thang, Tran Minh Tuyen, The translation of block scheme and the present problem of the closure, key in the database model of block forms, Proceedings of the National Conference XIII "Some the selected issues of Information Technology and Communication", 2010, 276-286.
  15. Trinh Dinh Thang, Tran Minh Tuyen, Closed mapping and translation of block schemes,. Proceedings of the National Conference on the VI for Fundamental and Applied Information Technology Research, 2013, 677-683.
  16. Trinh Dinh Thang, Tran Minh Tuyen, Trinh Ngoc Truc, Deductive formula in the database model of block forms, Proceedings of the National Conference on the VIII for Fundamental and Applied Information Technology Research, 2015, 103-110, DOI: 10.15625/vap.2015.000143.