FRINK Linked Data Fragments server

Matches in SemOpenAlex for { <https://semopenalex.org/work/W2753109262> ?p ?o ?g. }

• W2753109262 endingPage "1405" @default.
• W2753109262 startingPage "1394" @default.
• W2753109262 abstract "Query reverse engineering seeks to re-generate the SQL query that produced a given query output table from a given database. In this paper, we solve this problem for OLAP queries with group-by and aggregation. We develop a novel three-phase algorithm named REGAL 1 for this problem. First, based on a lattice graph structure, we identify a set of group-by candidates for the desired query. Second, we apply a set of aggregation constraints that are derived from the properties of aggregate operators at both the table-level and the group-level to discover candidate combinations of group-by columns and aggregations that are consistent with the given query output table. Finally, we find a multi-dimensional filter, i.e., a conjunction of selection predicates over the base table attributes, that is needed to generate the exact query output table. We conduct an extensive experimental study over the TPC-H dataset to demonstrate the effectiveness and efficiency of our proposal." @default.
• W2753109262 created "2017-09-15" @default.
• W2753109262 creator A5026021699 @default.
• W2753109262 creator A5032263010 @default.
• W2753109262 creator A5074464488 @default.
• W2753109262 creator A5088315797 @default.
• W2753109262 date "2017-08-01" @default.
• W2753109262 modified "2023-09-24" @default.
• W2753109262 title "Reverse engineering aggregation queries" @default.
• W2753109262 cites W1911540707 @default.
• W2753109262 cites W1971684273 @default.
• W2753109262 cites W2013167115 @default.
• W2753109262 cites W2023878327 @default.
• W2753109262 cites W2024958874 @default.
• W2753109262 cites W2057513751 @default.
• W2753109262 cites W2077207253 @default.
• W2753109262 cites W2094806969 @default.
• W2753109262 cites W2096454106 @default.
• W2753109262 cites W2099239777 @default.
• W2753109262 cites W2275996142 @default.
• W2753109262 cites W2430277509 @default.
• W2753109262 cites W760598031 @default.
• W2753109262 doi "https://doi.org/10.14778/3137628.3137648" @default.
• W2753109262 hasPublicationYear "2017" @default.
• W2753109262 type Work @default.
• W2753109262 sameAs 2753109262 @default.
• W2753109262 citedByCount "20" @default.
• W2753109262 countsByYear W27531092622018 @default.
• W2753109262 countsByYear W27531092622019 @default.
• W2753109262 countsByYear W27531092622020 @default.
• W2753109262 countsByYear W27531092622021 @default.
• W2753109262 countsByYear W27531092622022 @default.
• W2753109262 countsByYear W27531092622023 @default.
• W2753109262 crossrefType "journal-article" @default.
• W2753109262 hasAuthorship W2753109262A5026021699 @default.
• W2753109262 hasAuthorship W2753109262A5032263010 @default.
• W2753109262 hasAuthorship W2753109262A5074464488 @default.
• W2753109262 hasAuthorship W2753109262A5088315797 @default.
• W2753109262 hasConcept C124101348 @default.
• W2753109262 hasConcept C132525143 @default.
• W2753109262 hasConcept C134306372 @default.
• W2753109262 hasConcept C135572916 @default.
• W2753109262 hasConcept C157692150 @default.
• W2753109262 hasConcept C159985019 @default.
• W2753109262 hasConcept C164120249 @default.
• W2753109262 hasConcept C177264268 @default.
• W2753109262 hasConcept C192028432 @default.
• W2753109262 hasConcept C192562407 @default.
• W2753109262 hasConcept C192939062 @default.
• W2753109262 hasConcept C199360897 @default.
• W2753109262 hasConcept C201932085 @default.
• W2753109262 hasConcept C23123220 @default.
• W2753109262 hasConcept C24028149 @default.
• W2753109262 hasConcept C33923547 @default.
• W2753109262 hasConcept C41008148 @default.
• W2753109262 hasConcept C42058472 @default.
• W2753109262 hasConcept C45235069 @default.
• W2753109262 hasConcept C4679612 @default.
• W2753109262 hasConcept C4969071 @default.
• W2753109262 hasConcept C510870499 @default.
• W2753109262 hasConcept C77088390 @default.
• W2753109262 hasConcept C80444323 @default.
• W2753109262 hasConcept C97854310 @default.
• W2753109262 hasConceptScore W2753109262C124101348 @default.
• W2753109262 hasConceptScore W2753109262C132525143 @default.
• W2753109262 hasConceptScore W2753109262C134306372 @default.
• W2753109262 hasConceptScore W2753109262C135572916 @default.
• W2753109262 hasConceptScore W2753109262C157692150 @default.
• W2753109262 hasConceptScore W2753109262C159985019 @default.
• W2753109262 hasConceptScore W2753109262C164120249 @default.
• W2753109262 hasConceptScore W2753109262C177264268 @default.
• W2753109262 hasConceptScore W2753109262C192028432 @default.
• W2753109262 hasConceptScore W2753109262C192562407 @default.
• W2753109262 hasConceptScore W2753109262C192939062 @default.
• W2753109262 hasConceptScore W2753109262C199360897 @default.
• W2753109262 hasConceptScore W2753109262C201932085 @default.
• W2753109262 hasConceptScore W2753109262C23123220 @default.
• W2753109262 hasConceptScore W2753109262C24028149 @default.
• W2753109262 hasConceptScore W2753109262C33923547 @default.
• W2753109262 hasConceptScore W2753109262C41008148 @default.
• W2753109262 hasConceptScore W2753109262C42058472 @default.
• W2753109262 hasConceptScore W2753109262C45235069 @default.
• W2753109262 hasConceptScore W2753109262C4679612 @default.
• W2753109262 hasConceptScore W2753109262C4969071 @default.
• W2753109262 hasConceptScore W2753109262C510870499 @default.
• W2753109262 hasConceptScore W2753109262C77088390 @default.
• W2753109262 hasConceptScore W2753109262C80444323 @default.
• W2753109262 hasConceptScore W2753109262C97854310 @default.
• W2753109262 hasIssue "11" @default.
• W2753109262 hasLocation W27531092621 @default.
• W2753109262 hasOpenAccess W2753109262 @default.
• W2753109262 hasPrimaryLocation W27531092621 @default.
• W2753109262 hasRelatedWork W1488870204 @default.
• W2753109262 hasRelatedWork W2090529051 @default.
• W2753109262 hasRelatedWork W2146477719 @default.
• W2753109262 hasRelatedWork W2164636932 @default.
• W2753109262 hasRelatedWork W2350026801 @default.
• W2753109262 hasRelatedWork W2604963418 @default.

• next