Matches in SemOpenAlex for { <https://semopenalex.org/work/W1876756839> ?p ?o ?g. }
Showing items 1 to 84 of
84
with 100 items per page.
- W1876756839 endingPage "64" @default.
- W1876756839 startingPage "64" @default.
- W1876756839 abstract "One of the urgent tasks in the DBMS optimization by the materialized views (MV) - the saved query evaluation results - is selecting queries, the result of which can be materialized. The problem is characterized by high computational complexity since it requires an analysis of the DBMS transaction log over a long period of time. The choice of the MV should be based on the cost of their future support, as well as the execution frequency and cost of queries, optimized by the MV data. It is effective to create the MP not for individual queries, but to form groups of similar queries and create views for them. When searching for the same type of queries, the SQL syntax should be taken into account. The paper considers the technology for automated creation of MV. Query evaluation was proposed, which takes into account the statistical and time indicators of query execution, as well as update frequency of the base tables. The query tokenization algorithm, which takes into account various syntactic structures of SQL was developed. The model of presenting queries in the form of numeric vectors was described. The pre-clustering stage was introduced to reduce the volume of the data processed. The improved clustering algorithm has allowed to form groups around the most resource-intensive and often executed queries. An algorithm for grouping and forming the central query, specifying the results of the preliminary clustering was developed. The described technology allows to automate the full creation cycle of MV. Experimental data showed that technology improvement has allowed to increase performance and reduce the resource intensity of the MV generation process, as well as enhance the quality of the developed MV compared to previous solutions." @default.
- W1876756839 created "2016-06-24" @default.
- W1876756839 creator A5031104857 @default.
- W1876756839 creator A5044420824 @default.
- W1876756839 date "2015-10-23" @default.
- W1876756839 modified "2023-09-26" @default.
- W1876756839 title "Development of technology for automated creation of materialized views" @default.
- W1876756839 doi "https://doi.org/10.15587/1729-4061.2015.50892" @default.
- W1876756839 hasPublicationYear "2015" @default.
- W1876756839 type Work @default.
- W1876756839 sameAs 1876756839 @default.
- W1876756839 citedByCount "1" @default.
- W1876756839 countsByYear W18767568392016 @default.
- W1876756839 crossrefType "journal-article" @default.
- W1876756839 hasAuthorship W1876756839A5031104857 @default.
- W1876756839 hasAuthorship W1876756839A5044420824 @default.
- W1876756839 hasBestOaLocation W18767568391 @default.
- W1876756839 hasConcept C121332964 @default.
- W1876756839 hasConcept C124101348 @default.
- W1876756839 hasConcept C148840519 @default.
- W1876756839 hasConcept C154945302 @default.
- W1876756839 hasConcept C157692150 @default.
- W1876756839 hasConcept C164120249 @default.
- W1876756839 hasConcept C192028432 @default.
- W1876756839 hasConcept C194222762 @default.
- W1876756839 hasConcept C20556612 @default.
- W1876756839 hasConcept C23123220 @default.
- W1876756839 hasConcept C41008148 @default.
- W1876756839 hasConcept C510870499 @default.
- W1876756839 hasConcept C54239708 @default.
- W1876756839 hasConcept C62520636 @default.
- W1876756839 hasConcept C73555534 @default.
- W1876756839 hasConcept C77088390 @default.
- W1876756839 hasConcept C97854310 @default.
- W1876756839 hasConcept C98199447 @default.
- W1876756839 hasConceptScore W1876756839C121332964 @default.
- W1876756839 hasConceptScore W1876756839C124101348 @default.
- W1876756839 hasConceptScore W1876756839C148840519 @default.
- W1876756839 hasConceptScore W1876756839C154945302 @default.
- W1876756839 hasConceptScore W1876756839C157692150 @default.
- W1876756839 hasConceptScore W1876756839C164120249 @default.
- W1876756839 hasConceptScore W1876756839C192028432 @default.
- W1876756839 hasConceptScore W1876756839C194222762 @default.
- W1876756839 hasConceptScore W1876756839C20556612 @default.
- W1876756839 hasConceptScore W1876756839C23123220 @default.
- W1876756839 hasConceptScore W1876756839C41008148 @default.
- W1876756839 hasConceptScore W1876756839C510870499 @default.
- W1876756839 hasConceptScore W1876756839C54239708 @default.
- W1876756839 hasConceptScore W1876756839C62520636 @default.
- W1876756839 hasConceptScore W1876756839C73555534 @default.
- W1876756839 hasConceptScore W1876756839C77088390 @default.
- W1876756839 hasConceptScore W1876756839C97854310 @default.
- W1876756839 hasConceptScore W1876756839C98199447 @default.
- W1876756839 hasIssue "4(77)" @default.
- W1876756839 hasLocation W18767568391 @default.
- W1876756839 hasOpenAccess W1876756839 @default.
- W1876756839 hasPrimaryLocation W18767568391 @default.
- W1876756839 hasRelatedWork W1882050836 @default.
- W1876756839 hasRelatedWork W2011795509 @default.
- W1876756839 hasRelatedWork W2030156974 @default.
- W1876756839 hasRelatedWork W2032053783 @default.
- W1876756839 hasRelatedWork W2170476109 @default.
- W1876756839 hasRelatedWork W2171492933 @default.
- W1876756839 hasRelatedWork W2248831950 @default.
- W1876756839 hasRelatedWork W2250332863 @default.
- W1876756839 hasRelatedWork W2276956334 @default.
- W1876756839 hasRelatedWork W2337762748 @default.
- W1876756839 hasRelatedWork W2343166297 @default.
- W1876756839 hasRelatedWork W2609283634 @default.
- W1876756839 hasRelatedWork W2778076530 @default.
- W1876756839 hasRelatedWork W2800798464 @default.
- W1876756839 hasRelatedWork W2919225789 @default.
- W1876756839 hasRelatedWork W2955368753 @default.
- W1876756839 hasRelatedWork W2986626966 @default.
- W1876756839 hasRelatedWork W3016499880 @default.
- W1876756839 hasRelatedWork W3120225099 @default.
- W1876756839 hasRelatedWork W2825443991 @default.
- W1876756839 hasVolume "5" @default.
- W1876756839 isParatext "false" @default.
- W1876756839 isRetracted "false" @default.
- W1876756839 magId "1876756839" @default.
- W1876756839 workType "article" @default.