Matches in SemOpenAlex for { <https://semopenalex.org/work/W2146753709> ?p ?o ?g. }
- W2146753709 abstract "With hundreds of millions of users, spreadsheets are one of the most important end-user applications. Spreadsheets are easy to use and allow users great flexibility in storing data. This flexibility comes at a price: users often treat spreadsheets as a poor man's database, leading to creative solutions for storing high-dimensional data. The trouble arises when users need to answer queries with their data. Data manipulation tools make strong assumptions about data layouts and cannot read these ad-hoc databases. Converting data into the appropriate layout requires programming skills or a major investment in manual reformatting. The effect is that a vast amount of real-world data is locked-in to a proliferation of one-off formats. We introduce FlashRelate, a synthesis engine that lets ordinary users extract structured relational data from spreadsheets without programming. Instead, users extract data by supplying examples of output relational tuples. FlashRelate uses these examples to synthesize a program in Flare. Flare is a novel extraction language that extends regular expressions with geometric constructs. An interactive user interface on top of FlashRelate lets end users extract data by point-and-click. We demonstrate that correct Flare programs can be synthesized in seconds from a small set of examples for 43 real-world scenarios. Finally, our case study demonstrates FlashRelate's usefulness addressing the widespread problem of data trapped in corporate and government formats." @default.
- W2146753709 created "2016-06-24" @default.
- W2146753709 creator A5011543162 @default.
- W2146753709 creator A5032195792 @default.
- W2146753709 creator A5037163132 @default.
- W2146753709 creator A5052667625 @default.
- W2146753709 date "2015-06-03" @default.
- W2146753709 modified "2023-09-25" @default.
- W2146753709 title "FlashRelate: extracting relational data from semi-structured spreadsheets using examples" @default.
- W2146753709 cites W1679901020 @default.
- W2146753709 cites W1958332869 @default.
- W2146753709 cites W1965680834 @default.
- W2146753709 cites W1974942389 @default.
- W2146753709 cites W1989445634 @default.
- W2146753709 cites W2006426998 @default.
- W2146753709 cites W2044468887 @default.
- W2146753709 cites W2044515729 @default.
- W2146753709 cites W2048282669 @default.
- W2146753709 cites W2054974985 @default.
- W2146753709 cites W2064682298 @default.
- W2146753709 cites W2064766209 @default.
- W2146753709 cites W2065394549 @default.
- W2146753709 cites W2098516643 @default.
- W2146753709 cites W2144951274 @default.
- W2146753709 cites W2153072229 @default.
- W2146753709 cites W2160196229 @default.
- W2146753709 cites W4230945824 @default.
- W2146753709 cites W4233189519 @default.
- W2146753709 cites W4237412827 @default.
- W2146753709 doi "https://doi.org/10.1145/2737924.2737952" @default.
- W2146753709 hasPublicationYear "2015" @default.
- W2146753709 type Work @default.
- W2146753709 sameAs 2146753709 @default.
- W2146753709 citedByCount "75" @default.
- W2146753709 countsByYear W21467537092014 @default.
- W2146753709 countsByYear W21467537092015 @default.
- W2146753709 countsByYear W21467537092016 @default.
- W2146753709 countsByYear W21467537092017 @default.
- W2146753709 countsByYear W21467537092018 @default.
- W2146753709 countsByYear W21467537092019 @default.
- W2146753709 countsByYear W21467537092020 @default.
- W2146753709 countsByYear W21467537092021 @default.
- W2146753709 countsByYear W21467537092022 @default.
- W2146753709 countsByYear W21467537092023 @default.
- W2146753709 crossrefType "proceedings-article" @default.
- W2146753709 hasAuthorship W2146753709A5011543162 @default.
- W2146753709 hasAuthorship W2146753709A5032195792 @default.
- W2146753709 hasAuthorship W2146753709A5037163132 @default.
- W2146753709 hasAuthorship W2146753709A5052667625 @default.
- W2146753709 hasBestOaLocation W21467537092 @default.
- W2146753709 hasConcept C105795698 @default.
- W2146753709 hasConcept C111919701 @default.
- W2146753709 hasConcept C113843644 @default.
- W2146753709 hasConcept C118615104 @default.
- W2146753709 hasConcept C118930307 @default.
- W2146753709 hasConcept C129307140 @default.
- W2146753709 hasConcept C157915830 @default.
- W2146753709 hasConcept C177264268 @default.
- W2146753709 hasConcept C199360897 @default.
- W2146753709 hasConcept C23123220 @default.
- W2146753709 hasConcept C2524010 @default.
- W2146753709 hasConcept C2780598303 @default.
- W2146753709 hasConcept C28719098 @default.
- W2146753709 hasConcept C33923547 @default.
- W2146753709 hasConcept C41008148 @default.
- W2146753709 hasConcept C5655090 @default.
- W2146753709 hasConcept C77088390 @default.
- W2146753709 hasConceptScore W2146753709C105795698 @default.
- W2146753709 hasConceptScore W2146753709C111919701 @default.
- W2146753709 hasConceptScore W2146753709C113843644 @default.
- W2146753709 hasConceptScore W2146753709C118615104 @default.
- W2146753709 hasConceptScore W2146753709C118930307 @default.
- W2146753709 hasConceptScore W2146753709C129307140 @default.
- W2146753709 hasConceptScore W2146753709C157915830 @default.
- W2146753709 hasConceptScore W2146753709C177264268 @default.
- W2146753709 hasConceptScore W2146753709C199360897 @default.
- W2146753709 hasConceptScore W2146753709C23123220 @default.
- W2146753709 hasConceptScore W2146753709C2524010 @default.
- W2146753709 hasConceptScore W2146753709C2780598303 @default.
- W2146753709 hasConceptScore W2146753709C28719098 @default.
- W2146753709 hasConceptScore W2146753709C33923547 @default.
- W2146753709 hasConceptScore W2146753709C41008148 @default.
- W2146753709 hasConceptScore W2146753709C5655090 @default.
- W2146753709 hasConceptScore W2146753709C77088390 @default.
- W2146753709 hasLocation W21467537091 @default.
- W2146753709 hasLocation W21467537092 @default.
- W2146753709 hasOpenAccess W2146753709 @default.
- W2146753709 hasPrimaryLocation W21467537091 @default.
- W2146753709 hasRelatedWork W1577346958 @default.
- W2146753709 hasRelatedWork W2106319245 @default.
- W2146753709 hasRelatedWork W2347608685 @default.
- W2146753709 hasRelatedWork W2740990710 @default.
- W2146753709 hasRelatedWork W2755712538 @default.
- W2146753709 hasRelatedWork W3003553552 @default.
- W2146753709 hasRelatedWork W3201834830 @default.
- W2146753709 hasRelatedWork W4312445213 @default.
- W2146753709 hasRelatedWork W4324387396 @default.
- W2146753709 hasRelatedWork W2093148164 @default.
- W2146753709 isParatext "false" @default.
- W2146753709 isRetracted "false" @default.