FORMALIZED REPRESENTATION FOR THE DATA MODEL WITH THE UNIVERSAL BASIS OF RELATIONS

Authors

  • Vitalii I. Yesin
  • Mikolaj Karpinski
  • Maryna V. Yesina
  • Vladyslav V. Vilihura

DOI:

https://doi.org/10.47839/ijc.18.4.1615

Keywords:

data model, database.

Abstract

The goal of the article is to develop a universal (standard) data model that allows you to get rid of the need for a costly policy of doing extra work when developing new ones or transforming existing relational databases (RDBs) caused by dynamic changes in the subject domain (SD). The requirements for the developed data model were formulated. In accordance with the formulated requirements, the data model was synthesized. To simplify the process of creating relational database schemas an algorithm for transforming the description of the subject domain into the relations of the universal basis of the developed model was proposed. The scientific novelty of the obtained results is: a data model that, unlike known ones, allows us to simplify the creation of RDB schemas at the stage of logical design of relational databases, under the conditions of dynamic changes in subject domains, due to the introduced universal basis of relations, as a means of describing structures and the presentation of data for various SDs has been developed.

References

T. M. Connolly, C. E. Begg, Database Systems: A Practical Approach to Design, Implementation, and Management, sixth edition, Harlow, Essex, England, Pearson Education Limited, 2015, 1329 p.

E. Z. Zinder, “Database design: new requirements, new approaches,” DBMS, vol. 3, pp. 10-22, 1996. (in Russian).

V. V. Pasichnyk, V. A. Reznichenko, Organization of Databases and Knowledge, BHV Publishing Group, Kyiv, 2006, 384 p. (in Ukrainian).

D. C. Tsichritzis, F. H. Lochovsky, Data Models, Finance and Statistics, Moscow, 1985, 344 p. (in Russian).

S. D. Kuznetsov, Database Basics, Internet University of Information Technologies, BINOM, Laboratory of Knowledge, Moscow, 2007, 484 p. (in Russian).

DB-Engines Ranking, 2018 [Online]. Available at: https://db-engines.com/en/ranking.

M. Adrian, D. Feinberg, N. Heudecker, Magic Quadrant for Operational Database Management Systems, 22 October 2018, ID G00346575, 2018. [Online]. Available at: https://www.gartner.com/doc/reprints?id=1-5LPN68I&ct=181015&st=sb.

D. Feinberg, M. Adrian, N. Heudecker, Critical Capabilities for Operational Database Management Systems, 23 October 2018, ID G00353669, 2018. [Online]. Available at: https://www.gartner.com/doc/reprints?id=1-5LPN68L&ct=181015&st=sb.

P. A. Bernstein, U. Dayal, D. J. DeWitt, et al., “Future directions in DBMS research – The Laguna Beach Participants,” ACM SIGMOD Record, vol. 18, issue 1, pp. 17-26, 1989.

P. A. Bernstein, M. L. Brodie, S. Ceri, et al., “The asilomar report on database research,” ACM SIGMOD Record, vol. 27, issue 4, pp. 74-80, 1998.

Yu. A. Pergamentsev, “Database design based on the universal data model,” Proceedings of the conference on Corporate Databases 2002, Moscow, Russia, April 16-17, 2002, [Online]. Available at: http://citforum.ru/seminars/cbd2002/111.shtml. (in Russian).

E. D. Vyazilov, A. A. Fedortsov, “Universal data storage model taking into account the life cycle of objects,” Proceedings of the Sixth All-Russian Open Annual Conference “Modern Problems of Remote Sensing of the Earth from Space”, Moscow, Russia, November 10-14, 2008, [Online]. Available at: http://d902.iki.rssi.ru/theses-cgi/thesis.pl?id=1197. (in Russian).

E. D. Vyazilov, A. A. Fedortsov, A. E. Kobelev, “Unification of data structure for field research, exploration and resources using of World Ocean,” Proceedings of the 10-th All-Russian Scientific Conference “Electronic libraries: promising methods and technologies, electronic collections”, RCDL’2008, Dubna, Russia, October 7-11, 2008, pp. 293-298. (in Russian).

V. Filatov, V. Radchenko, “Reengineering relational database on analysis functional dependent attribute”, Proceedings of the X Intern. Scient. and Techn. Conf. «Computer Science & Information Technologies» (CSIT’2015), Lviv, Ukraine, September 14-17, 2015, pp. 85-88.

D. Abadi, R. Agrawal, A. Ailamaki, M. Balazinska, P. A. Bernstein, M. J. Carey, S. Chaudhuri, J. Dean, A. Doan, M. J. Franklin, J. Gehrke, L. M. Haas, A. Y. Halevy, J. M. Hellerstein, Y. E. Ioannidis, H. V. Jagadish, D. Kossmann, S. Madden, S. Mehrotra, T. Milo, J. F. Naughton, R. Ramakrishnan, V.r Markl, C. Olston, B. C. Ooi, C. Re, D. Suciu, M. Stonebraker, T. Walter, J. Widom, “The Beckman report on database research,” ACM SIGMOD Record, vol. 43, issue 3, pp. 61-70, 2014.

H. Garcia-Molina, J. D. Ullman, J. Widom, Database Systems. The Complete Book, 2th ed., Pearson Prentice Hall, 2009, 1203 p.

O. O. Varlamov, Evolutionary Databases and Knowledge for Adaptive Synthesis of Intelligent Systems. Mivar Information Space, Radio and Communication, Moscow, 2002, 282 p. (in Russian).

V. I. Yesin, M. V. Yesina, S. G. Rassomakhin, M. Karpinski, “Ensuring database security with the universal basis of relations,” in: K. Saeed, W. Homenda (Eds.) Computer Information Systems and Industrial Management. CISIM 2018. Lecture Notes in Computer Science, vol. 11127, Springer, Cham, 2018, pp. 510-522.

V. I. Yesin, M. V. Yesina, “Means for conceptual modeling of information system databases,” in: S. G. Rassomakhin, A. A. Kuznetsov (Eds.), Security and noise immunity of telecommunication systems: new solutions to the codes and signals design problem, ASC Academic Publishing, Minden, Nevada, 2017, pp. 160-196.

M. Sh. Tsalenko, Modeling Semantics in Databases, Moscow, Russia, Science, Main Edition of the Physical and Mathematical Literature, 1989, 288 p. (in Russian).

C. J. Date, An Introduction to Database Systems, 8th Edition, Pearson, Addison-Wesley, 2004, 983 p.

Downloads

Published

2019-12-31

How to Cite

Yesin, V. I., Karpinski, M., Yesina, M. V., & Vilihura, V. V. (2019). FORMALIZED REPRESENTATION FOR THE DATA MODEL WITH THE UNIVERSAL BASIS OF RELATIONS. International Journal of Computing, 18(4), 453-460. https://doi.org/10.47839/ijc.18.4.1615

Issue

2019, Volume 18, Issue 4

Section

Articles

License

International Journal of Computing is an open access journal. Authors who publish with this journal agree to the following terms:
•    Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
•    Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
•    Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.