Allophone database control systems synthesis for interaction organization between the aircraft automated control systems (ac acs) operator and automation complex means (acm)
Serhii Osiievskyi, Oleksii NesmiianThe article describes data warehouses implementation peculiarities and their limitations, as well as describing the sequence of data presentation in an abstract subject area, which allows us to propose some alternative approach to the organization of data warehouses, focused on containers usage. This approach combines the advantages of relational databases with their ability to ensure data consistency at any point in time, as well as features of unstructured data storage, typical of NoSQL systems in general. Also, the article proposes ways to solve the problem of synthesis of allophone database management system for organization of interaction between AC ACS operator and ACM. The method is based on a number of rules that allow to build a scheme of unstructured data, to organize the interaction of the NoSQL database with existing relational solutions, which is based on the provisions of the category theory. The developed rules provide the possibility of physical and logical modeling of NoSQL databases. Cardinality standards for NoSQL database modeling have also been developed and a classification has been introduced to prioritize classes and guidelines for NoSQL modeling. The verification of the proposed solutions was carried out by modeling and comparing the obtained results with theoretical positions. The SO-model was developed and its properties were substantiated. A feature of the SO-model is that each object has its own global unique identifier UunqID, which allows you to store objects of the same type on different computers, thereby increasing the scalability of the data store. Obtained results indicate a significant improvement of the data scheme of unstructured and poorly structured databases. The proposed model of data storage, due to its property of unifying the structure, which takes into account the dynamics of data and their connections, can be developed in various directions using NoSQL solutions.
References
[1] Garcia-Molina, H. et al. (2010). Database systems: a practical approach to design, implementation, and management. International Journal of Computer Applications in Technology, 49(4), 90-107.
[2] Chouder, M.L., Rizzi, S., & Chalal, R. (2017). Enabling self-service BI on document stores. In Workshop proceedings EDBT/ICDT 2017 joint conference. Venice: EDBT, Italy.
[3] Atzeni, P., Bugiotti, F., Rossi, L. (2014). Uniform access to NoSQL systems. Information Systems, 43, 117-133.
[4] Enriquez, J.G., Dominguez-Mayo, F.J., Escalona, M.J., Ross, M., & Staples, G. (2017). Entity reconciliation in big data sources: a systematic mapping study. Expert Systems with Applications, 80, 14-27.
[5] Imam, A.A., Basri, S., Ahmad, R., Aziz, N., & Gonzalez-Aparicio, M.T. (2017). New cardinality notations and styles for modeling NoSQL document-store databases. In TENCON 2017 - IEEE Region 10 Conference (pp. 2765-2770). Penang: IEEE. doi: 10.1109/TENCON.2017.8228332.
[6] Imam, A., Basri, S., Ahmad, R., Aziz, N., Gonzlez-Aparicio, M.T., Watada, J., & Member, S. (2018). Data modeling guidelines for NoSQL document-store databases. International Journal of Advanced Computer Science and Applications, 9(10), 544-555. doi: 10.14569/IJACSA.2018.091066.
[7] Sadalage, P.J., & Fowler, M. (2012). NoSQL distilled: A brief guide to the emerging world of polyglot persistence. Boston: Addison-Wesley.
[8] Date, C.J. (2012). Database design and relational theory: Normal forms and all that jazz. Sebastopol, CA: O'Reilly Media.
[9] Harrington, J.L. (2016). Relational database design and implementation. Burlington: Morgan Kaufmann.
[10] Davidson, L., & Moss, J. (2016). Pro SQL server relational database design and implementation. New York: Apress.
[11] Elmasri, R., & Navathe, S.B. (2015). Fundamentals of database systems (7th ed.). London: Pearson.
[12] Garcia-Molina, H., Ullman, J.D., & Widom, J. (2009). Database systems: The complete book (2nd ed.). New Jersey: Prentice Hall.