Matches in SemOpenAlex for { <https://semopenalex.org/work/W2532060087> ?p ?o ?g. }
Showing items 1 to 89 of
89
with 100 items per page.
- W2532060087 abstract "Online Analytical Processing aims at gaining useful information quickly from large amounts of data residing in a Data warehouse. To reduce the time of executing aggregate queries in a data warehousing environment, frequently used aggregates are often pre-computed and materialized in the form of summary views so that future queries can use them directly. Undoubtedly, materializing these summary views can minimize query response time but as the number of views increases exponentially with the number of dimensions, all the views cannot be materialized. However under storage constraint, we must be able to select an optimal number of views to be materialized. To determine the views to be materialized, a Data warehouse administrator may not be able to afford the necessary time to determine the number of rows(size) in each view. Counting actual number of rows present in each view takes considerable time. We explore the use of sampling to estimate the size of views. In this paper we propose a hybrid estimator that takes into account the degree of skew in the data and combines Jacknife estimator with the Schlosser estimator to estimate the size of the view more accurately. The proposed hybrid estimator has been used to estimate the view size in tpc-h benchmark and the results show better estimation results as compared to individual estimators." @default.
- W2532060087 created "2016-10-28" @default.
- W2532060087 creator A5002008018 @default.
- W2532060087 creator A5017407803 @default.
- W2532060087 creator A5019718836 @default.
- W2532060087 date "2013-12-01" @default.
- W2532060087 modified "2023-09-27" @default.
- W2532060087 title "Materialized view size estimation using sampling" @default.
- W2532060087 cites W2047061289 @default.
- W2532060087 cites W2058991275 @default.
- W2532060087 cites W2072764742 @default.
- W2532060087 cites W2101684971 @default.
- W2532060087 doi "https://doi.org/10.1109/iccic.2013.6724143" @default.
- W2532060087 hasPublicationYear "2013" @default.
- W2532060087 type Work @default.
- W2532060087 sameAs 2532060087 @default.
- W2532060087 citedByCount "4" @default.
- W2532060087 countsByYear W25320600872015 @default.
- W2532060087 countsByYear W25320600872017 @default.
- W2532060087 countsByYear W25320600872020 @default.
- W2532060087 crossrefType "proceedings-article" @default.
- W2532060087 hasAuthorship W2532060087A5002008018 @default.
- W2532060087 hasAuthorship W2532060087A5017407803 @default.
- W2532060087 hasAuthorship W2532060087A5019718836 @default.
- W2532060087 hasConcept C105795698 @default.
- W2532060087 hasConcept C106131492 @default.
- W2532060087 hasConcept C124101348 @default.
- W2532060087 hasConcept C13280743 @default.
- W2532060087 hasConcept C135572916 @default.
- W2532060087 hasConcept C135598885 @default.
- W2532060087 hasConcept C140779682 @default.
- W2532060087 hasConcept C148840519 @default.
- W2532060087 hasConcept C159985019 @default.
- W2532060087 hasConcept C185429906 @default.
- W2532060087 hasConcept C185798385 @default.
- W2532060087 hasConcept C192562407 @default.
- W2532060087 hasConcept C205649164 @default.
- W2532060087 hasConcept C2524010 @default.
- W2532060087 hasConcept C2776036281 @default.
- W2532060087 hasConcept C31972630 @default.
- W2532060087 hasConcept C33923547 @default.
- W2532060087 hasConcept C41008148 @default.
- W2532060087 hasConcept C43711488 @default.
- W2532060087 hasConcept C4679612 @default.
- W2532060087 hasConcept C54239708 @default.
- W2532060087 hasConcept C76155785 @default.
- W2532060087 hasConcept C77088390 @default.
- W2532060087 hasConcept C98199447 @default.
- W2532060087 hasConceptScore W2532060087C105795698 @default.
- W2532060087 hasConceptScore W2532060087C106131492 @default.
- W2532060087 hasConceptScore W2532060087C124101348 @default.
- W2532060087 hasConceptScore W2532060087C13280743 @default.
- W2532060087 hasConceptScore W2532060087C135572916 @default.
- W2532060087 hasConceptScore W2532060087C135598885 @default.
- W2532060087 hasConceptScore W2532060087C140779682 @default.
- W2532060087 hasConceptScore W2532060087C148840519 @default.
- W2532060087 hasConceptScore W2532060087C159985019 @default.
- W2532060087 hasConceptScore W2532060087C185429906 @default.
- W2532060087 hasConceptScore W2532060087C185798385 @default.
- W2532060087 hasConceptScore W2532060087C192562407 @default.
- W2532060087 hasConceptScore W2532060087C205649164 @default.
- W2532060087 hasConceptScore W2532060087C2524010 @default.
- W2532060087 hasConceptScore W2532060087C2776036281 @default.
- W2532060087 hasConceptScore W2532060087C31972630 @default.
- W2532060087 hasConceptScore W2532060087C33923547 @default.
- W2532060087 hasConceptScore W2532060087C41008148 @default.
- W2532060087 hasConceptScore W2532060087C43711488 @default.
- W2532060087 hasConceptScore W2532060087C4679612 @default.
- W2532060087 hasConceptScore W2532060087C54239708 @default.
- W2532060087 hasConceptScore W2532060087C76155785 @default.
- W2532060087 hasConceptScore W2532060087C77088390 @default.
- W2532060087 hasConceptScore W2532060087C98199447 @default.
- W2532060087 hasLocation W25320600871 @default.
- W2532060087 hasOpenAccess W2532060087 @default.
- W2532060087 hasPrimaryLocation W25320600871 @default.
- W2532060087 hasRelatedWork W1494049834 @default.
- W2532060087 hasRelatedWork W1591045846 @default.
- W2532060087 hasRelatedWork W1980161931 @default.
- W2532060087 hasRelatedWork W2408609218 @default.
- W2532060087 hasRelatedWork W2532060087 @default.
- W2532060087 hasRelatedWork W2792920932 @default.
- W2532060087 hasRelatedWork W4238268284 @default.
- W2532060087 hasRelatedWork W2751504412 @default.
- W2532060087 hasRelatedWork W2770044876 @default.
- W2532060087 hasRelatedWork W3088491908 @default.
- W2532060087 isParatext "false" @default.
- W2532060087 isRetracted "false" @default.
- W2532060087 magId "2532060087" @default.
- W2532060087 workType "article" @default.