Matches in SemOpenAlex for { <https://semopenalex.org/work/W113181503> ?p ?o ?g. }
Showing items 1 to 67 of
67
with 100 items per page.
- W113181503 abstract "On-Line Analytical Processing, OLAP, is a family of database algorithms and techniques used to compute multiple aggregation queries on an input fact table. Because it is generally accepted by OLAP queries are both slow and hard to optimize when evaluated within a DBMS, a significant portion of cube computations is often computed outside the database system, which requires an exporting of the data set, which is known to be very expensive for large data sets. In this dissertation, we contradict such traditional practice by providing three technical contributions, at three different levels. At the lowest level, we improve OLAP data cube pre-computation with innovative memory-only data structures that can be seamlessly integrated within a user-defined function, an extensibility mechanism provided by SQL. Second, we extend OLAP exploratory operations by introducing horizontal aggregations, a novel operation in SQL that combines pivoting and multi-dimensional aggregation of the data set into a single query. Such operation is essential as a pre-processing step for data mining algorithms, which do not generally accept a data set with a vertical layout. We show that horizontal aggregations are faster and more flexible than a built-in pivot operator. Finally, with OLAP as a data mining tool, we show it can synergistically work with statistics. By combining OLAP cubes with a parametric statistical test, we developed Cube Statistical Tests, a novel analytic algorithm that allows for the isolating of predictive attributes. This is accomplished with similarity comparisons between two cube subgroups based on a probabilistic function. In addition, we study the validity of discovered patterns by performing a reliability analysis against Association Rule Pairs, an extension of the standard pattern discovery algorithm. We show that Cube Statistical Test is superior in terms of the patterns." @default.
- W113181503 created "2016-06-24" @default.
- W113181503 creator A5079572598 @default.
- W113181503 date "2011-01-01" @default.
- W113181503 modified "2023-09-27" @default.
- W113181503 title "Optimization and gereralization of olap cube processing in relational database systems" @default.
- W113181503 hasPublicationYear "2011" @default.
- W113181503 type Work @default.
- W113181503 sameAs 113181503 @default.
- W113181503 citedByCount "0" @default.
- W113181503 crossrefType "journal-article" @default.
- W113181503 hasAuthorship W113181503A5079572598 @default.
- W113181503 hasConcept C11413529 @default.
- W113181503 hasConcept C114614502 @default.
- W113181503 hasConcept C124101348 @default.
- W113181503 hasConcept C135572916 @default.
- W113181503 hasConcept C177264268 @default.
- W113181503 hasConcept C199360897 @default.
- W113181503 hasConcept C201932085 @default.
- W113181503 hasConcept C33923547 @default.
- W113181503 hasConcept C41008148 @default.
- W113181503 hasConcept C510870499 @default.
- W113181503 hasConcept C53051483 @default.
- W113181503 hasConcept C5655090 @default.
- W113181503 hasConcept C77088390 @default.
- W113181503 hasConcept C78168278 @default.
- W113181503 hasConceptScore W113181503C11413529 @default.
- W113181503 hasConceptScore W113181503C114614502 @default.
- W113181503 hasConceptScore W113181503C124101348 @default.
- W113181503 hasConceptScore W113181503C135572916 @default.
- W113181503 hasConceptScore W113181503C177264268 @default.
- W113181503 hasConceptScore W113181503C199360897 @default.
- W113181503 hasConceptScore W113181503C201932085 @default.
- W113181503 hasConceptScore W113181503C33923547 @default.
- W113181503 hasConceptScore W113181503C41008148 @default.
- W113181503 hasConceptScore W113181503C510870499 @default.
- W113181503 hasConceptScore W113181503C53051483 @default.
- W113181503 hasConceptScore W113181503C5655090 @default.
- W113181503 hasConceptScore W113181503C77088390 @default.
- W113181503 hasConceptScore W113181503C78168278 @default.
- W113181503 hasLocation W1131815031 @default.
- W113181503 hasOpenAccess W113181503 @default.
- W113181503 hasPrimaryLocation W1131815031 @default.
- W113181503 hasRelatedWork W105366419 @default.
- W113181503 hasRelatedWork W1160301755 @default.
- W113181503 hasRelatedWork W1514498087 @default.
- W113181503 hasRelatedWork W1579933398 @default.
- W113181503 hasRelatedWork W1768579885 @default.
- W113181503 hasRelatedWork W1793564634 @default.
- W113181503 hasRelatedWork W1853932977 @default.
- W113181503 hasRelatedWork W2010676616 @default.
- W113181503 hasRelatedWork W2014339852 @default.
- W113181503 hasRelatedWork W2038607816 @default.
- W113181503 hasRelatedWork W2137370514 @default.
- W113181503 hasRelatedWork W2138759702 @default.
- W113181503 hasRelatedWork W2143972859 @default.
- W113181503 hasRelatedWork W2262376231 @default.
- W113181503 hasRelatedWork W2355987888 @default.
- W113181503 hasRelatedWork W2365640869 @default.
- W113181503 hasRelatedWork W2784252969 @default.
- W113181503 hasRelatedWork W2888906335 @default.
- W113181503 hasRelatedWork W2971751428 @default.
- W113181503 hasRelatedWork W575592017 @default.
- W113181503 isParatext "false" @default.
- W113181503 isRetracted "false" @default.
- W113181503 magId "113181503" @default.
- W113181503 workType "article" @default.