Matches in SemOpenAlex for { <https://semopenalex.org/work/W2038607816> ?p ?o ?g. }
Showing items 1 to 94 of
94
with 100 items per page.
- W2038607816 abstract "Since the early 1990s, On-Line Analytical Processing (OLAP) has been a well studied research topic that has focused on implementation outside the database, either with OLAP servers or entirely within the client computers. Our approach involves the computation and storage of OLAP cubes using User-Defined Functions (UDF) with a database management system. UDFs offer users a chance to write their own code that can then called like any other standard SQL function. By generating OLAP cubes within a UDF, we are able to create the entire lattice in main memory. The UDF also allows the user to assert more control over the actual generation process than when using standard OLAP functions such as the CUBE operator. We introduce a data structure that can not only efficiently create an OLAP lattice in main memory, but also be adapted to generate association rule itemsets with minimal change. We experimentally show that the UDF approach is more efficient than SQL using one real dataset and a synthetic dataset. Also, we present several experiments showing that generating association rule itemsets using the UDF approach is comparable to a SQL approach. In this paper, we show that techniques such as OLAP and association rules can be efficiently pushed into the UDF, and has better performance, in most cases, compared to standard SQL functions." @default.
- W2038607816 created "2016-06-24" @default.
- W2038607816 creator A5031610238 @default.
- W2038607816 creator A5079572598 @default.
- W2038607816 date "2008-10-30" @default.
- W2038607816 modified "2023-10-18" @default.
- W2038607816 title "Efficient OLAP with UDFs" @default.
- W2038607816 cites W1993626269 @default.
- W2038607816 cites W2014339852 @default.
- W2038607816 cites W2045466225 @default.
- W2038607816 cites W2049859567 @default.
- W2038607816 cites W2058494157 @default.
- W2038607816 cites W2063680791 @default.
- W2038607816 cites W2064803206 @default.
- W2038607816 cites W2072764742 @default.
- W2038607816 cites W2118324373 @default.
- W2038607816 cites W2166559705 @default.
- W2038607816 cites W4249047728 @default.
- W2038607816 cites W4252403066 @default.
- W2038607816 doi "https://doi.org/10.1145/1458432.1458440" @default.
- W2038607816 hasPublicationYear "2008" @default.
- W2038607816 type Work @default.
- W2038607816 sameAs 2038607816 @default.
- W2038607816 citedByCount "19" @default.
- W2038607816 countsByYear W20386078162012 @default.
- W2038607816 countsByYear W20386078162013 @default.
- W2038607816 countsByYear W20386078162014 @default.
- W2038607816 countsByYear W20386078162015 @default.
- W2038607816 countsByYear W20386078162016 @default.
- W2038607816 countsByYear W20386078162019 @default.
- W2038607816 countsByYear W20386078162020 @default.
- W2038607816 countsByYear W20386078162021 @default.
- W2038607816 crossrefType "proceedings-article" @default.
- W2038607816 hasAuthorship W2038607816A5031610238 @default.
- W2038607816 hasAuthorship W2038607816A5079572598 @default.
- W2038607816 hasConcept C111919701 @default.
- W2038607816 hasConcept C11413529 @default.
- W2038607816 hasConcept C114614502 @default.
- W2038607816 hasConcept C123593499 @default.
- W2038607816 hasConcept C124101348 @default.
- W2038607816 hasConcept C135572916 @default.
- W2038607816 hasConcept C164120249 @default.
- W2038607816 hasConcept C194222762 @default.
- W2038607816 hasConcept C201932085 @default.
- W2038607816 hasConcept C206384180 @default.
- W2038607816 hasConcept C23123220 @default.
- W2038607816 hasConcept C2984286706 @default.
- W2038607816 hasConcept C33923547 @default.
- W2038607816 hasConcept C41008148 @default.
- W2038607816 hasConcept C45374587 @default.
- W2038607816 hasConcept C510870499 @default.
- W2038607816 hasConcept C53051483 @default.
- W2038607816 hasConcept C77088390 @default.
- W2038607816 hasConcept C78168278 @default.
- W2038607816 hasConcept C93996380 @default.
- W2038607816 hasConcept C97854310 @default.
- W2038607816 hasConceptScore W2038607816C111919701 @default.
- W2038607816 hasConceptScore W2038607816C11413529 @default.
- W2038607816 hasConceptScore W2038607816C114614502 @default.
- W2038607816 hasConceptScore W2038607816C123593499 @default.
- W2038607816 hasConceptScore W2038607816C124101348 @default.
- W2038607816 hasConceptScore W2038607816C135572916 @default.
- W2038607816 hasConceptScore W2038607816C164120249 @default.
- W2038607816 hasConceptScore W2038607816C194222762 @default.
- W2038607816 hasConceptScore W2038607816C201932085 @default.
- W2038607816 hasConceptScore W2038607816C206384180 @default.
- W2038607816 hasConceptScore W2038607816C23123220 @default.
- W2038607816 hasConceptScore W2038607816C2984286706 @default.
- W2038607816 hasConceptScore W2038607816C33923547 @default.
- W2038607816 hasConceptScore W2038607816C41008148 @default.
- W2038607816 hasConceptScore W2038607816C45374587 @default.
- W2038607816 hasConceptScore W2038607816C510870499 @default.
- W2038607816 hasConceptScore W2038607816C53051483 @default.
- W2038607816 hasConceptScore W2038607816C77088390 @default.
- W2038607816 hasConceptScore W2038607816C78168278 @default.
- W2038607816 hasConceptScore W2038607816C93996380 @default.
- W2038607816 hasConceptScore W2038607816C97854310 @default.
- W2038607816 hasLocation W20386078161 @default.
- W2038607816 hasOpenAccess W2038607816 @default.
- W2038607816 hasPrimaryLocation W20386078161 @default.
- W2038607816 hasRelatedWork W2060220453 @default.
- W2038607816 hasRelatedWork W2092428805 @default.
- W2038607816 hasRelatedWork W2234182594 @default.
- W2038607816 hasRelatedWork W2351600626 @default.
- W2038607816 hasRelatedWork W2356805518 @default.
- W2038607816 hasRelatedWork W2377040749 @default.
- W2038607816 hasRelatedWork W2381928906 @default.
- W2038607816 hasRelatedWork W2405318132 @default.
- W2038607816 hasRelatedWork W626841726 @default.
- W2038607816 hasRelatedWork W633303806 @default.
- W2038607816 isParatext "false" @default.
- W2038607816 isRetracted "false" @default.
- W2038607816 magId "2038607816" @default.
- W2038607816 workType "article" @default.