Matches in SemOpenAlex for { <https://semopenalex.org/work/W4319431246> ?p ?o ?g. }
Showing items 1 to 77 of
77
with 100 items per page.
- W4319431246 abstract "This paper presents the relevant aspects of server-side data pagination, together with the calculation of simple and matrix totals, from the perspective of the resources used (mainly the execution time), existing solutions but also variants, respectively new solutions proposed by the authors. Different scenarios were investigated: Oracle rownum pseudocolumn and ANSI SQL ROW_NUMBER analytical function in different query configurations, different ways of expressing the necessary joins and the place where the respective joins are used, different ways of calculating the total number of records, numerical fields totals (simple and matrix) and corroboration of this calculation with pagination. To our knowledge, the calculation of totals (especially matrix totals) simultaneously with the extraction of the data required for pagination represents a novel approach. The authors designed several experiments, and the processed results show that, on the pagination side, an improved version that uses the rownum pseudocolumn allows obtaining shorter execution times in most cases. The total number of lines as well as the simple totals are best obtained with distinct queries, combined with those from the pagination. For matrix calculation, the DENSE_RANK function used in a CTE (Common Table Expression) leads to the best results." @default.
- W4319431246 created "2023-02-09" @default.
- W4319431246 creator A5017426641 @default.
- W4319431246 creator A5017852741 @default.
- W4319431246 creator A5058341214 @default.
- W4319431246 creator A5069107185 @default.
- W4319431246 date "2022-10-01" @default.
- W4319431246 modified "2023-09-26" @default.
- W4319431246 title "Study and Experiments on Data Pagination and Calculation of Simple and Matrix Totals" @default.
- W4319431246 cites W1572972746 @default.
- W4319431246 doi "https://doi.org/10.1109/icebe55470.2022.00051" @default.
- W4319431246 hasPublicationYear "2022" @default.
- W4319431246 type Work @default.
- W4319431246 citedByCount "0" @default.
- W4319431246 crossrefType "proceedings-article" @default.
- W4319431246 hasAuthorship W4319431246A5017426641 @default.
- W4319431246 hasAuthorship W4319431246A5017852741 @default.
- W4319431246 hasAuthorship W4319431246A5058341214 @default.
- W4319431246 hasAuthorship W4319431246A5069107185 @default.
- W4319431246 hasConcept C106487976 @default.
- W4319431246 hasConcept C111472728 @default.
- W4319431246 hasConcept C11413529 @default.
- W4319431246 hasConcept C115903868 @default.
- W4319431246 hasConcept C121332964 @default.
- W4319431246 hasConcept C136764020 @default.
- W4319431246 hasConcept C138885662 @default.
- W4319431246 hasConcept C14036430 @default.
- W4319431246 hasConcept C159985019 @default.
- W4319431246 hasConcept C163716315 @default.
- W4319431246 hasConcept C192562407 @default.
- W4319431246 hasConcept C199360897 @default.
- W4319431246 hasConcept C2778692605 @default.
- W4319431246 hasConcept C2780586882 @default.
- W4319431246 hasConcept C2780644320 @default.
- W4319431246 hasConcept C41008148 @default.
- W4319431246 hasConcept C55166926 @default.
- W4319431246 hasConcept C56372850 @default.
- W4319431246 hasConcept C62520636 @default.
- W4319431246 hasConcept C78458016 @default.
- W4319431246 hasConcept C86803240 @default.
- W4319431246 hasConceptScore W4319431246C106487976 @default.
- W4319431246 hasConceptScore W4319431246C111472728 @default.
- W4319431246 hasConceptScore W4319431246C11413529 @default.
- W4319431246 hasConceptScore W4319431246C115903868 @default.
- W4319431246 hasConceptScore W4319431246C121332964 @default.
- W4319431246 hasConceptScore W4319431246C136764020 @default.
- W4319431246 hasConceptScore W4319431246C138885662 @default.
- W4319431246 hasConceptScore W4319431246C14036430 @default.
- W4319431246 hasConceptScore W4319431246C159985019 @default.
- W4319431246 hasConceptScore W4319431246C163716315 @default.
- W4319431246 hasConceptScore W4319431246C192562407 @default.
- W4319431246 hasConceptScore W4319431246C199360897 @default.
- W4319431246 hasConceptScore W4319431246C2778692605 @default.
- W4319431246 hasConceptScore W4319431246C2780586882 @default.
- W4319431246 hasConceptScore W4319431246C2780644320 @default.
- W4319431246 hasConceptScore W4319431246C41008148 @default.
- W4319431246 hasConceptScore W4319431246C55166926 @default.
- W4319431246 hasConceptScore W4319431246C56372850 @default.
- W4319431246 hasConceptScore W4319431246C62520636 @default.
- W4319431246 hasConceptScore W4319431246C78458016 @default.
- W4319431246 hasConceptScore W4319431246C86803240 @default.
- W4319431246 hasLocation W43194312461 @default.
- W4319431246 hasOpenAccess W4319431246 @default.
- W4319431246 hasPrimaryLocation W43194312461 @default.
- W4319431246 hasRelatedWork W1991971747 @default.
- W4319431246 hasRelatedWork W2018906356 @default.
- W4319431246 hasRelatedWork W2064237292 @default.
- W4319431246 hasRelatedWork W2096722880 @default.
- W4319431246 hasRelatedWork W2370217726 @default.
- W4319431246 hasRelatedWork W2385480689 @default.
- W4319431246 hasRelatedWork W2462574632 @default.
- W4319431246 hasRelatedWork W3201815179 @default.
- W4319431246 hasRelatedWork W4319431246 @default.
- W4319431246 hasRelatedWork W2091145045 @default.
- W4319431246 isParatext "false" @default.
- W4319431246 isRetracted "false" @default.
- W4319431246 workType "article" @default.