Open Access Open Access  Restricted Access Subscription Access

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

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

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.

Keywords


data model; database.

Full Text:

PDF

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.


Refbacks

  • There are currently no refbacks.
hgs yükleme