Database schema invariant to subject domains and its distinctive features

Authors

  • V.I. Yesin

DOI:

https://doi.org/10.30837/rt.2018.2.193.13

Keywords:

database, relational database, database schema, data model with an universal basis of relations

Abstract

The desire to avoid unnecessary costs inherent in the traditional methodology of creating relational databases, not only at the stages of conceptual and logical design, but also at the stage of physical design, has actualized the task of developing a database schema that is invariant to subject domains. The main developed and distinguishing elements of this scheme are as follows: composition, structure of the basic relations; implementation of integrity constraints; means ensuring the database security.

References

Chaos Manifesto 2013: Think Big, Act Small online version. The Standish Group [Electronic resource]. Access mode : http://www.versionone.com/assets/img/files/ChaosManifesto2013.pdf.

Standish Group 2015 Chaos Report – Q&A with Jennifer Lynch [Electronic resource]. Access mode : https://www.infoq.com/articles/standish-chaos-2015.

Connolly T. M. Database systems: a practical approach to design, implementation, and management. Sixth edition / Thomas M. Connolly, Carolyn E. Begg. Harlow, Essex, England : Pearson Education Limited, 2015. 1329 p.

Security and noise immunity of telecommunication systems: new solutions to the codes and signals design problem. Collective monograph. Edited by Sergey G. Rassomakhin, Alexandr A. Kuznetsov. Minden, Nevada, USA : ASC Academic Publishing. 2017. 198 p., Chapter 8, Yesin V.I., Yesina M.V. Means for conceptual modeling of information system databases. P.160-196.

Есин В. И. Модель данных «объект-событие»: требования и синтез модели // Computer science and cyber security. International electronic scientific journal. 2017. Issue. 3 (7). P. 33-44. Access mode : http://periodicals.karazin.ua/cscs/article/view/10003/9527.

Есин В. И. Выразительные средства модели данных «объект-событие» / В. И. Есин // Радиотехника. 2017. Вып. 191. С. 99-112.

Есин В. И. Модель данных с универсальной фиксированной структурой / В. И. Есин // Теоретичні та прикладні аспекти побудови програмних систем : матеріали міжнародної наукової конференції, м. Київ, 15-17 грудня 2014 р. Кіровоград : ФО-П Александрова М. В., 2014. С. 112-116.

Есин В. И. Универсальная модель данных и ее математические основы / В. И. Есин // Системи обробки інформації. 2011. № 2(92). С.21-24.

Дейт К. Дж. Введение в системы баз данных. 8-е изд. ; пер. с англ. / К. Дейт. – Москва : Изд. дом "Вильямс", 2005. 1328 с.

Грофф Д. Р. SQL: полное руководство, 3-е изд. : Пер. с англ. / Грофф Д. Р., Вайнберг П. Н., Оппель Э. Дж. – Москва : ООО "И.Д. Вильямс", 2015. – 960 с.

Гарсиа-Молина Г. Системы баз данных // Г. Гарсиа-Молина, Д. Д. Ульман, Д. Уидом. Москва : Изд. дом "Вильямс", 2003. 1088 с.

Фиайли К. SQL ; пер. с англ. / К. Фиайли. Москва : ДМК Пресс, 2003. – 456 с.

Есин В. И. Язык для универсальной модели данных / В. И. Есин, М. В. Есина // Системи обробки ін-формації. 2011. № 5(95). С.193-197.

Есин В. И. Интерпретатор языка для универсальной модели данных / В. И. Есин, М. В. Есина // Наука і техніка Повітряних Сил Збройних Сил України. 2011. № 2(6). С. 140-143.

Downloads

Published

2018-05-15

How to Cite

Yesin, V. (2018). Database schema invariant to subject domains and its distinctive features. Radiotekhnika, 2(193), 133–142. https://doi.org/10.30837/rt.2018.2.193.13

Issue

No. 193 (2018): Radiotekhnika

Section

Articles

License

Authors who publish with this journal agree to the following terms:

1. 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.

2. 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.

3. 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 (See The Effect of Open Access).