|

Development and implementation of operators for handling archive personnel information in the form of multidimensional spaces, using 1C

Authors: Baldin A.V., Tonoyan S.A., Eliseev D.V. Published: 03.09.2015
Published in issue: #4(103)/2015  
DOI: 10.18698/0236-3933-2015-4-113-126

 
Category: Informatics, Computer Engineering and Control | Chapter: Theoretical Computer Science, Cybernetics  
Keywords: relational database, mivar space, temporal, SQL query, multidimensional space, relations, operators, set, database structure, data structure, interpreter

The paper describes the possibilities of processing the archive personnel information through the relational database (RDB), consolidated in a multidimensional space. Processing of such personnel information requires special operators. The paper represents the workflow with multidimensional mivar representation of the relational databases, allowing the application of SQL-queries from the previous personnel systems. The authors propose the way of performing this task by extending the SQL query language functional and developing additional operators, allowing processing the information stored in a multidimensional mivar space. To ensure the interactions between the relational databases and multidimensional spaces. They also determine some additional operators, which process the multidimensional spaces. The authors define special operations associated with the process of finding the required state of relational model relations, as well as operators for dynamically forming relationships of relational databases from a mivar space. Both a mivar space and operators processing information are implemented on the basis of the technological platform "1C: Enterprise 8". The proposed mivar approach simplifies the solution to the problem of processing temporal data with variable structure in the information systems.

References

[1] Tonoyan S.A., Saraev D.V. Temporal database models and their properties. Jelektr. Nauchno-Tehn. Izd. "Inzhenernyy zhurnal: nauka i innovacii"[El. Sc.-Techn. Publ. "Eng. J.: Science and Innovation"], 2014, no. 12 (36). http://engjournal.ru/search/word/page1.html (accessed 04.02.2015).

[2] Eliseev D.V. Metodika obrabotki temporal’noy relyatsionnoy bazy dannykh v mivarnom prostranstve [Techniques of Temporal Relational Database Treatment in Mivar Space]. Diss. kand. tekhn. nauk [Cand. tech. sci. diss.]. Moscow, MGTU im. N.E. Baumana, 2011. 149 p.

[3] Tonoyan S.A., Baldin A.V., Eliseev D.V. Techniques of Upgrading Standard Modules of Typical Configuration Based on the Technological Platform "1C: Enterprise 8" with Minimal Modifications. Jelektr. Nauchno-Tehn. Izd. "Nauka i obrazovanie" [El. Sc.-Tech. Publ. "Science and Education"], 2012, no. 8. DOI: 10.7463/0812.0450231 URL: http://technomag.edu.ru (accessed 04.02.2015).

[4] Eliseev D.V., Baldin A.V., Tonoyan S.A. Analysis of the Application of the Standard Configuration "1C: Salary and Staff in a Budget-Funded Entity 8" in Russian Higher Education Institutions. Novye informatsionnye tekhnologii v obrazovanii. Sb. Tr. 12 Mezhdunar. Nauch.-Praktich. Konf "Formirovanie novoy informatsionnoy sredy obrazovatel’nogo uchrezhdeniya s ispol’zovanie tekhnologiy 1S" [New Information Technologies in Education. Proc. Int. Sci. Conf. Formation of the New Information Environment of Educational Institutions Using the Technology 1C], Moscow, 1S-Pablishing, 2012, vol. 2, pp. 54-59 (in Russ.).

[5] Tonoyan S.A., Timofeev V.B., Chernen’kiy S.V. Analysis and Selection of Network Configuration for BMSTU Financial-Economic Activity Based on 1C: Enterprise 8 Platform. Vestn. Mosk. Gos. Tekh. Univ. im. N.E. Baumana, Priborostr, Spetsvyp "Informatika i sistemy upravleniya" [Herald of the Bauman Moscow State Tech. Univ., Instrum. Eng., Spec. Issue Informatics and Control Systems], 2012, pp. 101108 (in Russ.).

[6] Baldin A.V., Eliseev D.V., Agayan K.G. Review of the Methods of Constructing Temporal Systems Based on Relational Databases. Jelektr. Nauchno-Tehn. Izd. "Nauka i obrazovanie" [El. Sc.-Tech. Publ. "Science and Education"], 2012, no. 8. DOI: 10.7463/0812.0441884. URL: http://technomag.edu.ru/en/doc/441884.html (accessed 04.02.2015).

[7] Varlamov O.O. Evolyutsionnye bazy dannykh i znaniy dlya adaptivnogo sinteza intellektual’nykh sistem. Mivarnoe informatsionnoe prostranstvo [Evolutionary Data and Knowledge Bases for Intelligent System Adaptive Synthesis. Mivar Information Space.]. Moscow, Radio i svyaz’ Publ., 2002. 286 p.

[8] Chernen’kiy V.M., Baldin A.V, Tonoyan S.A. Informatsionnaya upravlyayushchaya sistema MGTU im. N.E. Baumana "Elektronnyy Universitet": kontseptsiya i realizatsiya [BMSTU Information Management System "Electronic University": the Concept and Implmentation]. Moscow, MGTU im. N.E. Baumana Publ., 2009. 376 p.

[9] Grigor’ev Yu.A. The Algorithm of Synthesis of Relational Database Partially Optimal Schema. Jelektr. Nauchno-Tehn. Izd. "Nauka i obrazovanie" [El. Sc.-Tech. Publ. "Science and Education"], 2012, no. 1. DOI: 77-30569/294486 URL: http://technomag.bmstu.ru/doc/294486.html/ (accessed 04.02.2015).

[10] Vinogradova M.V., Igushev E.G. Designer of Databases Based on Entities and Their Properties with the Possibility of Normalization. Jelektr. Nauchno-Tehn. Izd. "Nauka i obrazovanie" [El. Sc.-Tech. Publ. "Science and Education" ], 2012, no. 1. DOI: 77-30569/242645 URL: http://technomag.edu.ru/ (accessed 04.02.2015).

[11] Chernen’kiy V.M., Gapanyuk Yu.E., Mavzyutov A.A. Development of Complex Biomedical Information Systems Based on Adaptive Objects. Vestn. Mosk. Gos. Tekh. Univ. im. N.E. Baumana, Priborostr., Spetsvyp no. 3 "Biometricheskie tekhnologii" [Herald of the Bauman Moscow State Tech. Univ., Instrum. Eng., Spec. Issue no. 3 "Biometric Technologies"], 2011, pp. 105-112 (in Russ.).

[12] Radchenko M.G., Khrustaleva E.Yu. 1S: Predpriyatie 8.2 Prakticheskoe posobie razrabotchika [1C: Enterprise 8.2 Developer Practical Guide]. Moscow, 1S-Pablishing; St. Petersburg, Piter Publ., 2009. 613 p.

[13] Steiner A. A generalisation approach to temporal data models and their implementations, 1998. Availlable at: http://www.timeconsult.com/Publicati-ons/diss.pdf (accessed 04.02.2015).