Matches in SemOpenAlex for { <https://semopenalex.org/work/W3197267923> ?p ?o ?g. }
- W3197267923 endingPage "2431" @default.
- W3197267923 startingPage "2419" @default.
- W3197267923 abstract "Data analysis often involves comparing subsets of data across many dimensions for finding unusual trends and patterns. While the comparison between subsets of data can be expressed using SQL, they tend to be complex to write, and suffer from poor performance over large and high-dimensional datasets. In this paper, we propose a new logical operator COMPARE for relational databases that concisely captures the enumeration and comparison between subsets of data and greatly simplifies the expressing of a large class of comparative queries. We extend the database engine with optimization techniques that exploit the semantics of COMPARE to significantly improve the performance of such queries. We have implemented these extensions inside Microsoft SQL Server, a commercial DBMS engine. Our extensive evaluation on synthetic and real-world datasets shows that COMPARE results in a significant speedup over existing approaches, including physical plans generated by today's database systems, user-defined functions (UDFs), as well as middleware solutions that compare subsets outside the databases." @default.
- W3197267923 created "2021-09-13" @default.
- W3197267923 creator A5038037154 @default.
- W3197267923 creator A5063257827 @default.
- W3197267923 creator A5079891721 @default.
- W3197267923 date "2021-07-01" @default.
- W3197267923 modified "2023-09-24" @default.
- W3197267923 title "COMPARE" @default.
- W3197267923 cites W1515560342 @default.
- W3197267923 cites W1525397625 @default.
- W3197267923 cites W1964691382 @default.
- W3197267923 cites W2058458206 @default.
- W3197267923 cites W2075591954 @default.
- W3197267923 cites W2080582518 @default.
- W3197267923 cites W2096598900 @default.
- W3197267923 cites W2097267403 @default.
- W3197267923 cites W2103201239 @default.
- W3197267923 cites W2121516976 @default.
- W3197267923 cites W2123685385 @default.
- W3197267923 cites W2127675794 @default.
- W3197267923 cites W2129917572 @default.
- W3197267923 cites W2136046112 @default.
- W3197267923 cites W2245828441 @default.
- W3197267923 cites W2257756289 @default.
- W3197267923 cites W2610226709 @default.
- W3197267923 cites W2611990000 @default.
- W3197267923 cites W2888851078 @default.
- W3197267923 cites W2888965704 @default.
- W3197267923 cites W2917161856 @default.
- W3197267923 cites W2946535156 @default.
- W3197267923 cites W2948919184 @default.
- W3197267923 cites W2963114469 @default.
- W3197267923 cites W2963707382 @default.
- W3197267923 cites W3008323075 @default.
- W3197267923 cites W4235524867 @default.
- W3197267923 cites W4244600136 @default.
- W3197267923 cites W4247303118 @default.
- W3197267923 cites W4247980034 @default.
- W3197267923 doi "https://doi.org/10.14778/3476249.3476291" @default.
- W3197267923 hasPublicationYear "2021" @default.
- W3197267923 type Work @default.
- W3197267923 sameAs 3197267923 @default.
- W3197267923 citedByCount "2" @default.
- W3197267923 countsByYear W31972679232022 @default.
- W3197267923 crossrefType "journal-article" @default.
- W3197267923 hasAuthorship W3197267923A5038037154 @default.
- W3197267923 hasAuthorship W3197267923A5063257827 @default.
- W3197267923 hasAuthorship W3197267923A5079891721 @default.
- W3197267923 hasConcept C104317684 @default.
- W3197267923 hasConcept C118615104 @default.
- W3197267923 hasConcept C118930307 @default.
- W3197267923 hasConcept C124101348 @default.
- W3197267923 hasConcept C154945302 @default.
- W3197267923 hasConcept C158448853 @default.
- W3197267923 hasConcept C165696696 @default.
- W3197267923 hasConcept C17020691 @default.
- W3197267923 hasConcept C173608175 @default.
- W3197267923 hasConcept C184337299 @default.
- W3197267923 hasConcept C185592680 @default.
- W3197267923 hasConcept C199360897 @default.
- W3197267923 hasConcept C2777212361 @default.
- W3197267923 hasConcept C33923547 @default.
- W3197267923 hasConcept C38652104 @default.
- W3197267923 hasConcept C41008148 @default.
- W3197267923 hasConcept C510870499 @default.
- W3197267923 hasConcept C55493867 @default.
- W3197267923 hasConcept C5655090 @default.
- W3197267923 hasConcept C68339613 @default.
- W3197267923 hasConcept C77088390 @default.
- W3197267923 hasConcept C86339819 @default.
- W3197267923 hasConceptScore W3197267923C104317684 @default.
- W3197267923 hasConceptScore W3197267923C118615104 @default.
- W3197267923 hasConceptScore W3197267923C118930307 @default.
- W3197267923 hasConceptScore W3197267923C124101348 @default.
- W3197267923 hasConceptScore W3197267923C154945302 @default.
- W3197267923 hasConceptScore W3197267923C158448853 @default.
- W3197267923 hasConceptScore W3197267923C165696696 @default.
- W3197267923 hasConceptScore W3197267923C17020691 @default.
- W3197267923 hasConceptScore W3197267923C173608175 @default.
- W3197267923 hasConceptScore W3197267923C184337299 @default.
- W3197267923 hasConceptScore W3197267923C185592680 @default.
- W3197267923 hasConceptScore W3197267923C199360897 @default.
- W3197267923 hasConceptScore W3197267923C2777212361 @default.
- W3197267923 hasConceptScore W3197267923C33923547 @default.
- W3197267923 hasConceptScore W3197267923C38652104 @default.
- W3197267923 hasConceptScore W3197267923C41008148 @default.
- W3197267923 hasConceptScore W3197267923C510870499 @default.
- W3197267923 hasConceptScore W3197267923C55493867 @default.
- W3197267923 hasConceptScore W3197267923C5655090 @default.
- W3197267923 hasConceptScore W3197267923C68339613 @default.
- W3197267923 hasConceptScore W3197267923C77088390 @default.
- W3197267923 hasConceptScore W3197267923C86339819 @default.
- W3197267923 hasIssue "11" @default.
- W3197267923 hasLocation W31972679231 @default.
- W3197267923 hasOpenAccess W3197267923 @default.
- W3197267923 hasPrimaryLocation W31972679231 @default.
- W3197267923 hasRelatedWork W16380752 @default.
- W3197267923 hasRelatedWork W1825086818 @default.