Pub Date : 2017-09-30DOI: 10.5604/01.3001.0010.5210
Dominika Hodun, M. Skublewska-Paszkowska
. The article presents a discussion of the optimisation methods involving the modification of query syntax on the example of the use of indexes that served for the application of the methods in practice, and the presentation and analysis of the test results and their comparison. All the queries were made in a Microsoft SQL Server Management Studio 2014 environment, using the AdventureWorksDW2012 test database provided by Microsoft. The object of the research were SELECT queries, which consequently returned the desired set of output data.
． 本文以索引的使用为例，讨论了涉及修改查询语法的优化方法，为这些方法在实践中的应用提供了服务，并对测试结果进行了介绍和分析，并进行了比较。所有的查询都是在Microsoft SQL Server Management Studio 2014环境下进行的，使用的是Microsoft提供的AdventureWorksDW2012测试数据库。研究的对象是SELECT查询，因此返回所需的输出数据集。
{"title":"Optimisation analysis of Transact-SQL queries based on indexes","authors":"Dominika Hodun, M. Skublewska-Paszkowska","doi":"10.5604/01.3001.0010.5210","DOIUrl":"https://doi.org/10.5604/01.3001.0010.5210","url":null,"abstract":". The article presents a discussion of the optimisation methods involving the modification of query syntax on the example of the use of indexes that served for the application of the methods in practice, and the presentation and analysis of the test results and their comparison. All the queries were made in a Microsoft SQL Server Management Studio 2014 environment, using the AdventureWorksDW2012 test database provided by Microsoft. The object of the research were SELECT queries, which consequently returned the desired set of output data.","PeriodicalId":142227,"journal":{"name":"Informatics, Control, Measurement in Economy and Environment Protection","volume":"7 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2017-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"122445375","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Pub Date : 2017-09-30DOI: 10.5604/01.3001.0010.5204
V. Marasanov, A. Sharko
. The classification the functionality and the schemes of the acoustic emission sources localization is presented in the paper. Mathematical support of the coordinate searching of defects and means of their detection are stated.
． 介绍了声发射源定位的分类、功能和定位方案。给出了缺陷坐标搜索的数学支持和缺陷的检测方法。
{"title":"CLASSIFICATION OF THE FUNCTIONALITY AND THE SCHEMES OF THE ACOUSTIC EMISSION SOURCES LOCALIZATION","authors":"V. Marasanov, A. Sharko","doi":"10.5604/01.3001.0010.5204","DOIUrl":"https://doi.org/10.5604/01.3001.0010.5204","url":null,"abstract":". The classification the functionality and the schemes of the acoustic emission sources localization is presented in the paper. Mathematical support of the coordinate searching of defects and means of their detection are stated.","PeriodicalId":142227,"journal":{"name":"Informatics, Control, Measurement in Economy and Environment Protection","volume":"163 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2017-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"115713229","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Pub Date : 2017-09-30DOI: 10.5604/01.3001.0010.5214
Robert Susik
We consider the application of multiple pattern matching (Multi AOSO on q-Grams) algorithm for approximate pattern matching. We propose the on-line approach which translates the problem from approximate pattern matching into a multiple pattern one (called partitioning into exact search). Presented solution allows relatively fast search multiple patterns in text with given k-differences(or mismatches). This paper presents comparison of solution based on MAG algorithm, and [4]. Experiments on DNA, English, Proteins and XML texts with up to k errors show that the new proposed algorithm achieves relatively good results in practical use.
{"title":"APPLYING A Q-GRAM BASED MULTIPLE STRING MATCHING ALGORITHM FOR APPROXIMATE MATCHING","authors":"Robert Susik","doi":"10.5604/01.3001.0010.5214","DOIUrl":"https://doi.org/10.5604/01.3001.0010.5214","url":null,"abstract":"We consider the application of multiple pattern matching (Multi AOSO on q-Grams) algorithm for approximate pattern matching. We propose the on-line approach which translates the problem from approximate pattern matching into a multiple pattern one (called partitioning into exact search). Presented solution allows relatively fast search multiple patterns in text with given k-differences(or mismatches). This paper presents comparison of solution based on MAG algorithm, and [4]. Experiments on DNA, English, Proteins and XML texts with up to k errors show that the new proposed algorithm achieves relatively good results in practical use.","PeriodicalId":142227,"journal":{"name":"Informatics, Control, Measurement in Economy and Environment Protection","volume":"72 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2017-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"124069283","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Pub Date : 2017-09-30DOI: 10.5604/01.3001.0010.5216
V. Mosorov, T. Panskyi, S. Biedroń
In this paper the analysis of k-specified (namely k-means) crisp data partitioning pre-clustering algorithm’s termination criterion performance is described. The results have been analyzed using the clustering validity indices. Termination criterion allows analyzing data with any number of clusters. Moreover, introduced criterion in contrast to the known validity indices enables to analyze data that make up one cluster.
{"title":"ALTERNATIVE TERMINATION CRITERION FOR K-SPECIFIED CRISP DATA CLUSTERING ALGORITHMS","authors":"V. Mosorov, T. Panskyi, S. Biedroń","doi":"10.5604/01.3001.0010.5216","DOIUrl":"https://doi.org/10.5604/01.3001.0010.5216","url":null,"abstract":"In this paper the analysis of k-specified (namely k-means) crisp data partitioning pre-clustering algorithm’s termination criterion performance is described. The results have been analyzed using the clustering validity indices. Termination criterion allows analyzing data with any number of clusters. Moreover, introduced criterion in contrast to the known validity indices enables to analyze data that make up one cluster.","PeriodicalId":142227,"journal":{"name":"Informatics, Control, Measurement in Economy and Environment Protection","volume":"56 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2017-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"116673281","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Pub Date : 2017-09-30DOI: 10.5604/01.3001.0010.5221
Sławomir Sowa
{"title":"Natężenie światła dziennego w budynku szkoły","authors":"Sławomir Sowa","doi":"10.5604/01.3001.0010.5221","DOIUrl":"https://doi.org/10.5604/01.3001.0010.5221","url":null,"abstract":"","PeriodicalId":142227,"journal":{"name":"Informatics, Control, Measurement in Economy and Environment Protection","volume":"41 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2017-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"125264526","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Pub Date : 2017-09-30DOI: 10.5604/01.3001.0010.5225
M. Aftyka
{"title":"Wpływ doboru czynnika chłodniczego na możliwości magazynowania chłodu w zasobniku energii termicznej autobusu miejskiego","authors":"M. Aftyka","doi":"10.5604/01.3001.0010.5225","DOIUrl":"https://doi.org/10.5604/01.3001.0010.5225","url":null,"abstract":"","PeriodicalId":142227,"journal":{"name":"Informatics, Control, Measurement in Economy and Environment Protection","volume":"7 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2017-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"130404365","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Pub Date : 2017-09-30DOI: 10.5604/01.3001.0010.5220
P. Olszewski, W. Kamiński
{"title":"Sztuczne sieci neuronowe jako motoryczna pamięć asocjacyjna ręki robota humanoidalnego","authors":"P. Olszewski, W. Kamiński","doi":"10.5604/01.3001.0010.5220","DOIUrl":"https://doi.org/10.5604/01.3001.0010.5220","url":null,"abstract":"","PeriodicalId":142227,"journal":{"name":"Informatics, Control, Measurement in Economy and Environment Protection","volume":"50 Suppl 1 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2017-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"126133282","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Pub Date : 2017-09-30DOI: 10.5604/01.3001.0010.5224
Waldemar Nycz, R. Goleman
{"title":"Ekonomiczne i praktyczne aspekty wykorzystania pomp ciepła z odzyskiem z powietrza","authors":"Waldemar Nycz, R. Goleman","doi":"10.5604/01.3001.0010.5224","DOIUrl":"https://doi.org/10.5604/01.3001.0010.5224","url":null,"abstract":"","PeriodicalId":142227,"journal":{"name":"Informatics, Control, Measurement in Economy and Environment Protection","volume":"06 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2017-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"126502339","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Pub Date : 2017-09-30DOI: 10.5604/01.3001.0010.5208
M. Sowa
. The paper concerns a numerical method that deals with the computations of the fractional derivative in Caputo and Riemann-Liouville definitions. The method can be applied in time stepping processes of initial value problems. The name of the method is SubIval, which is an acronym of its previous name – the subinterval-based method. Its application in solving systems of fractional order state equations is presented. The method has been implemented into an ActiveX DLL. Exemplary MATLAB and Mathematica codes are given, which provide guidance on how the DLL can be used.
{"title":"Numerical computations of the fractional derivative in IVPS, examples in MATLAB and Mathematica","authors":"M. Sowa","doi":"10.5604/01.3001.0010.5208","DOIUrl":"https://doi.org/10.5604/01.3001.0010.5208","url":null,"abstract":". The paper concerns a numerical method that deals with the computations of the fractional derivative in Caputo and Riemann-Liouville definitions. The method can be applied in time stepping processes of initial value problems. The name of the method is SubIval, which is an acronym of its previous name – the subinterval-based method. Its application in solving systems of fractional order state equations is presented. The method has been implemented into an ActiveX DLL. Exemplary MATLAB and Mathematica codes are given, which provide guidance on how the DLL can be used.","PeriodicalId":142227,"journal":{"name":"Informatics, Control, Measurement in Economy and Environment Protection","volume":"769 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2017-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"133515689","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Pub Date : 2017-09-30DOI: 10.5604/01.3001.0010.5207
R. Krawczyk, P. Kolasiński, P. Linczuk, Wojciech Zabolotny, K. Poźniak, P. Zienkiewicz, Ryszard S. Romaniuk, A. Wojeński, G. Kasprowicz, T. Czarski, M. Chernyshova
The collaboration of authors led to implementing advanced and fast systems for diagnostics of plasma content in tokamaks. During the development of systems it is planned to add new functionalities, in particular, the algorithms of tomographic reconstruction to obtain information on three dimensional distribution of plasma impurities. In the article the idea of tomographic reconstruction is introduced and issues of performance and adequate hardware selection are presented.
{"title":"Into the fast tomographic postprocessing in tokamaks","authors":"R. Krawczyk, P. Kolasiński, P. Linczuk, Wojciech Zabolotny, K. Poźniak, P. Zienkiewicz, Ryszard S. Romaniuk, A. Wojeński, G. Kasprowicz, T. Czarski, M. Chernyshova","doi":"10.5604/01.3001.0010.5207","DOIUrl":"https://doi.org/10.5604/01.3001.0010.5207","url":null,"abstract":"The collaboration of authors led to implementing advanced and fast systems for diagnostics of plasma content in tokamaks. During the development of systems it is planned to add new functionalities, in particular, the algorithms of tomographic reconstruction to obtain information on three dimensional distribution of plasma impurities. In the article the idea of tomographic reconstruction is introduced and issues of performance and adequate hardware selection are presented.","PeriodicalId":142227,"journal":{"name":"Informatics, Control, Measurement in Economy and Environment Protection","volume":"186 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2017-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"127590127","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
京公网安备 11010802042870号
京ICP备2023020795号-1
扫码关注我们
求助内容：
应助结果提醒方式：