S.N. Kuznetsov – Ph. D. (Eng.), Associate Professor, Department «Конструирование и технология РЭС», Moscow Aviation Institute (National Research University). E-mail: firstname.lastname@example.org
A.S. Kuznetsov – Head of Department of Information Technologies, Pushkin State Museum. E-mail: email@example.com
In article the methods of increase of performance of information support of the radio technical system\'s CAD, based on a modular principle are analyzed.
The databases providing both storage and selection of all the modules, included in a hierarchical tree of system, and the operations connected with removal or addition of modules at any hierarchical level of system are the basis of information support of such CAD.
The performance of database, at the solution of the tasks stated above, in many respects depends on its structure, number of hierarchical levels and number of stored modules radio technical system.
In paper comparison of performance of two options of creation of DB providing to carry out hierarchical queries are given: by using method a «parent–child» or method, which uses the type of data of HierarchyID.
Also in article three options of creation of DB, which can carry out procedure of queries like «generation of modules», are analyzed: by using method a «parent–child», by using method, which uses the type of data of HierarchyID and by using method, which uses the type of data of HierarchyID with breath-first index.
The analysis of the considered methods shows that at a small number of the modules, included in a hierarchical tree, the performance of database is almost identical to all options of creation of DB. Therefore it makes sense to apply a «parent–child» method, as the simplest at realization. This is true both for hierarchical queries, and for queries like «generation of modules». If the number of modules is rather great (more than 1000), to increase performance of database, when hierarchical queries carry out it is expedient to apply a method in which the type of data of HierarchyID is used, and when queries like «generation of modules» carry out – a method in which the type of data of HierarchyID with breath-first index.
The main result of paper are practical recommendations of using in CAD of the considered options of creation of DB depending on complexity of the developed radio technical system. A scope of the received results are CAD of radio technical, information, electronic and other systems the construction of which is based on a modular principle.
- Ushkar M.N. Avtomatizacija sistemnogo proektirovanija
informacionnykh radiosistem // Trudy MAI. Dekabr 2014. № 78.
- JAn Liberman.ORDPATH – novyjj podkhod k rabote s ierarkhijami (derevjami) v SQLServer 2008 // RSDNMagazine. 2007. № 4. [EHlektronnyjj
resurs]. URL: http://rsdn.ru/article/db/ordpath.xml (data obrashhenija: 12.03.2015).
- Kent Tegels. Model Your Data Hierarchies With SQL
Server 2008 // MSDN Magazine > Issues and Downloads. September2008. [EHlektronnyjj resurs]. URL: https://msdn.microsoft.com/en-us/magazine/cc794278.aspx (data obrashhenija: 18.02.2015).
- GOST R
52003-2003. Urovni razukrupnenija radioehlektronnykh sredstv. Data vvedenija:
- Paresh Prajapati. Breath First and Depth First Strategy
– HierarchyId Data Type in SQL Server 2008 // Jul 6, 2014. [EHlektronnyjj
resurs]. URL: http://beyondrelational.com/modules/2/blogs/88/Posts/19945/breath-first-and-depth-first-strategy-hierarchyid-data-type-in-sql-server-2008.aspx (data obrashhenija: 15.02.2015).