{"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}
{"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}
{"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}
{"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}
{"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}
{"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}
{"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}
{"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}
{"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}
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
{"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}