Matches in SemOpenAlex for { <https://semopenalex.org/work/W4284969678> ?p ?o ?g. }
Showing items 1 to 70 of
70
with 100 items per page.
- W4284969678 abstract "Improved performance of database systems has enabled faster SQL querying and more complex data processing. However, as the data becomes more complex and larger, SQL data processing becomes more difficult and costly. Typical problems include changing SQL queries and data schema resolution in complex dependencies by hand. In addition, human errors can lead to complex cyclic dependency problems. To mitigate these problems, we developed AlphaSQL: an open-source software tool for SQL data processing. AlphaSQL mainly supports three techniques to automate data preparation by SQL: (1) extracting a directed acyclic graph (DAG) based on dependencies between SQL and data, (2) validating the schema included in the whole DAG, and (3) parallelizing the queries based on the DAG. We applied AlphaSQL to a real-world data analysis and machine learning project where we analyzed 1445 logs obtained from static validation for git commits and 3243 execution logs. Our analysis showed that AlphaSQL detected various errors with high precision and recall, part of which existing tools could not catch (e.g., missing resources and schema mismatches). AlphaSQL would enable more maintainable data management using SQL." @default.
- W4284969678 created "2022-07-10" @default.
- W4284969678 creator A5008903518 @default.
- W4284969678 creator A5012068346 @default.
- W4284969678 creator A5037878350 @default.
- W4284969678 creator A5090427874 @default.
- W4284969678 date "2022-05-01" @default.
- W4284969678 modified "2023-10-03" @default.
- W4284969678 title "AlphaSQL: Open Source Software Tool for Automatic Dependency Resolution, Parallelization and Validation for SQL and Data" @default.
- W4284969678 cites W1993786250 @default.
- W4284969678 cites W2020841721 @default.
- W4284969678 cites W2105315220 @default.
- W4284969678 cites W2612048434 @default.
- W4284969678 cites W2808642230 @default.
- W4284969678 cites W2889523940 @default.
- W4284969678 cites W2952851516 @default.
- W4284969678 cites W3020616315 @default.
- W4284969678 cites W3174439817 @default.
- W4284969678 doi "https://doi.org/10.1109/icdew55742.2022.00010" @default.
- W4284969678 hasPublicationYear "2022" @default.
- W4284969678 type Work @default.
- W4284969678 citedByCount "1" @default.
- W4284969678 countsByYear W42849696782023 @default.
- W4284969678 crossrefType "proceedings-article" @default.
- W4284969678 hasAuthorship W4284969678A5008903518 @default.
- W4284969678 hasAuthorship W4284969678A5012068346 @default.
- W4284969678 hasAuthorship W4284969678A5037878350 @default.
- W4284969678 hasAuthorship W4284969678A5090427874 @default.
- W4284969678 hasConcept C124101348 @default.
- W4284969678 hasConcept C141589383 @default.
- W4284969678 hasConcept C154420247 @default.
- W4284969678 hasConcept C164120249 @default.
- W4284969678 hasConcept C167544706 @default.
- W4284969678 hasConcept C194222762 @default.
- W4284969678 hasConcept C199360897 @default.
- W4284969678 hasConcept C23123220 @default.
- W4284969678 hasConcept C41008148 @default.
- W4284969678 hasConcept C510870499 @default.
- W4284969678 hasConcept C55596503 @default.
- W4284969678 hasConcept C77088390 @default.
- W4284969678 hasConcept C97854310 @default.
- W4284969678 hasConceptScore W4284969678C124101348 @default.
- W4284969678 hasConceptScore W4284969678C141589383 @default.
- W4284969678 hasConceptScore W4284969678C154420247 @default.
- W4284969678 hasConceptScore W4284969678C164120249 @default.
- W4284969678 hasConceptScore W4284969678C167544706 @default.
- W4284969678 hasConceptScore W4284969678C194222762 @default.
- W4284969678 hasConceptScore W4284969678C199360897 @default.
- W4284969678 hasConceptScore W4284969678C23123220 @default.
- W4284969678 hasConceptScore W4284969678C41008148 @default.
- W4284969678 hasConceptScore W4284969678C510870499 @default.
- W4284969678 hasConceptScore W4284969678C55596503 @default.
- W4284969678 hasConceptScore W4284969678C77088390 @default.
- W4284969678 hasConceptScore W4284969678C97854310 @default.
- W4284969678 hasLocation W42849696781 @default.
- W4284969678 hasOpenAccess W4284969678 @default.
- W4284969678 hasPrimaryLocation W42849696781 @default.
- W4284969678 hasRelatedWork W106036922 @default.
- W4284969678 hasRelatedWork W1505413869 @default.
- W4284969678 hasRelatedWork W1538798823 @default.
- W4284969678 hasRelatedWork W1725587203 @default.
- W4284969678 hasRelatedWork W2078380329 @default.
- W4284969678 hasRelatedWork W2282389522 @default.
- W4284969678 hasRelatedWork W2352765041 @default.
- W4284969678 hasRelatedWork W2356451189 @default.
- W4284969678 hasRelatedWork W2463360381 @default.
- W4284969678 hasRelatedWork W2738342198 @default.
- W4284969678 isParatext "false" @default.
- W4284969678 isRetracted "false" @default.
- W4284969678 workType "article" @default.