Article

Article title RESEARCH OF THE DATA MANIPULATION METHODS CONTRUCTION IN STRUCTURE-INDEPENDENT DATABASES
Authors A.S. Grishchenko
Section SECTION III. INFORMATION TECHNOLOGY, APPLIED INFORMATION SYSTEMS AND NETWORKS
Month, Year 11, 2015 @en
Index UDC 004.62
DOI
Abstract The paper reviewed the work on assessing the performance of existing data manipulation procedures in structure-independent databases. The main problem of them called the low efficiency of procedures. The reasons for this low performance could be called structure-independent database two-tier structure, converting at data input / output from the horizontal to the vertical view and back, as well as more of the operations of insertion. The paper deals with the reasons affecting their performance. We consider optimization approach to the problem of low efficiency of data manipulation procedures in structure-independent databases but its use makes difficult in a flexible configurable information systems, therefore, requires the development of a methodological basis. The objective of this research is the development of requirements for the method allows building effective data manipulation procedures in structure-independent databases. The structure of the process of creating existing data manipulation procedures in databases is given and an overview of existing creating methods is produced. To ensure uniformity of the process are required the use the identical form of representation for the purpose, the result and process of procedure creating in the form of action. The conclusion is that they are constructed empirically and construction process is inhomogeneous now, whereby the relevance of developing a method for constructing data manipulation procedures increases. The result is requirements for the method of creating existing data manipulation procedures in structure-independent databases that made during the research.

Download PDF

Keywords Structure-independent database; data manipulation procedure; performance; efficiency; review; research.
References 1. Degtyarev A.A. Razrabotka i issledovanie metoda postroeniya gidroakusticheskikh informatsionnykh sistem na osnove konfigurirovaniya funktsional'nosti: avtoref. dis. … kand. tekhn. Nauk [Research and development of the hydroacoustic method for constructing information systems based on the configuration of functionality. Cand. of eng. sc. diss]. 05.25.05.
2. Magento™ creates huge success with enterprise e-commerce platform & community built on Zend Framework. Available at: https://www.zend.com/topics/Magento-CS.pdf.
3. Microsoft Dynamics. Available at: http://www.microsoft.com/ru-u/dynamics/crm.aspx.
4. McDonald C. The Regenstrief Medical Records, MD Computing, 1982, No. 5 (5), pp. 34-47.
5. Nadkarni P. An Introduction to Entity-Attribute-Value Design for Generic Clinical Study Data Management Systems, Center for Medical Informatics, Yale University Medical School. Available at: http://med.yale.edu/.
6. Brandt C., Morse R., Matthews K., Sun K., Deshpande A., Gadagkar R., Cohen D., Miller P., Nadkarni P. Metadata-driven creation of data marts from an EAV-modeled clinical research database, International journal of medical informatics, 2002, No. 65, pp. 225-241.
7. Boncz P., Zukowski M., Nes N. MonetDB/X100: Hyper-pipelining query execution, CIDR, 2005.
8. Boncz P.A., Kersten M.L. MIL primitives for querying a fragmented world, VLDB Journal, 1999, No. 8 (2), pp. 101-119.
9. Stonebraker M., Abadi D. J., Batkin A. (и др.). C-Store: A Column-Oriented DBMS, VLDB Journal, 2005, pp. 553-564.
10. Rogozov Yu.I., Grishchenko A.S. Otsenka proizvoditel'nosti mekhanizmov manipulirovaniya dannymi v strukturno-nezavisimykh baz dannykh [Performance evaluation of mechanisms for manipulating data in a structurally independent database], Informatizatsiya i svyaz' [Informatization and Communication], 2013, No. 2, pp. 41-43.
11. Grishchenko A.S., Sviridov A.S., Belousova S.A. Performance estimation of selecting and inserting procedures in the structure-independent database, Proceedings of «8th International Conference on Application of Information and Communication Technologies» (AICT-2014). Astana, Kazakhstan, 2014, pp. 202-207.
12. Zmeev O., Moiseev A. Sravnitel'nyy analiz nekotorykh metodov O-R-preobrazovaniya [Comparative analysis of some methods O-R transformation], Vestnik Tomskogo gosudarstvennogo universiteta [Tomsk State University Journal of Control and Computer Science], 2003, No. 280, pp. 263-271.
13. Tentser A. Baza dannykh – khranilishche ob"ektov [Database – object store], Komp'yuter Press [Computer Press], 2001, No. 8.
14. EAV vs Row Modeling. Тест производительности на PostgreSQL. Available at: http://valv.ru/eav-vs-row-modeling-test-proizvoditelnosti-na-postgresql.html.
15. Rogozov Y.I., Bodrow W., Kucherov S.А., Sviridov А.S. Purpose-Driven Approach For Flexible Structure-Independent Database Design, Proceedings of 5th International Conference on Software and Data Technologies. ICSOFT 2010, Vol. 1, pp. 356-362
16. Chernykh, T.A. Sovershenstvovanie ASU gazokondensatnogo mestorozhdeniya za schet primeneniya podsistemy obrabotki kvazistrukturirovannoy informatsii: avtoref. dis. … kand. tekhn. nauk [Improving ACS gas condensate field at the expense of application processing subsystems, quasi-structured information. Cand. of eng. sc. diss]. 05.13.06. Orenburg, 2011, 19.
17. Gmar' D.V., Ignatova Yu.A., Tsuranov E.V., Shakhgel'dyan K.I. Metody raboty s vertikal'noy model'yu dannykh [Methods of work with vertical data model], Informatsionnye tekhnologii i vychislitel'nye sistemy [Information Technologies and Computing Systems], 2015, No. 2, pp. 1-28.
18. Grishchenko A.S. Podkhod k povysheniyu proizvoditel'nosti strukturno-nezavisimoy bazy dannykh [Approach to improving structure-independent database performance], Izvestiya YuFU. Tekhnicheskie nauki [Izvestiya SFedU. Engineering Sciences], 2014, No. 6 (155), pp. 185-192.
19. PostgreSQL. Dokumentatsiya na russkom yazyke [Documentation in Russian language]. Available at: https://wiki.postgresql.org/wiki/Russian.
20. Elektronnaya dokumentatsiya po Microsoft SQL Server 2014 [Books online for Microsoft SQL Server 2014]. Available at: https://msdn.microsoft.com/ru-ru/library/ms130214(v=sql.120).aspx.

Comments are closed.