Engineering Journal: Science and InnovationELECTRONIC SCIENCE AND ENGINEERING PUBLICATION
Certificate of Registration Media number Эл #ФС77-53688 of 17 April 2013. ISSN 2308-6033. DOI 10.18698/2308-6033
  • Русский
  • Английский
Article

Query language to mivar representation of relational databases, containing information archive from previous human resources systems

Published: 19.11.2013

Authors: Baldin A.V., Tonoyan S.A., Eliseev D.V.

Published in issue: #11(23)/2013

DOI: 10.18698/2308-6033-2013-11-1053

Category: Information technology

The article analyzes the processing capabilities of relational databases, consolidated under mivar space, which showed the need to develop query language to such a representation archive of HR information. A scheme of work with mivar view of the relational database is proposed in the article, which allows the use of SQL statements of previous personnel systems. To implement this, the analysis of the SQL query language is performed to define additional operators to enable processing of information stored in a multidimensional mivar space. To interact with RDB multidimensional spaces the operators of processing of multidimensional spaces, special operations related to the definition of the desired state relations relational model, and operators to dynamically generate relations of RDB from mivar space are defined. Proposed mivar approach simplifies the solution of the problem of processing temporal data with variable structure in information systems.