Matches in SemOpenAlex for { <https://semopenalex.org/work/W3168770866> ?p ?o ?g. }
Showing items 1 to 85 of
85
with 100 items per page.
- W3168770866 endingPage "115226" @default.
- W3168770866 startingPage "115226" @default.
- W3168770866 abstract "Most data-warehouse construction processes are performed manually by experts, which is laborious, time-consuming, and prone to error. Furthermore, special knowledge is required to design complex multidimensional models, such as a star schema. This predicament has motivated computer scientists to propose automation techniques to generate such models. For this reason, we present a new strategy that incorporates knowledge-based models into a framework, named the Semantic-based Star-schema Designer, that assists the automation of star schema construction. Our models provide reasoning capabilities needed by star schema designs, including those that can disambiguate heterogeneous terms, detect appropriate data types and attribute sizes, and organize data hierarchies to support online analytical processes. We also propose strategies to overcome the uncertainty arising when attribute names are not available in the data source. The names of unknown attributes are thus predicted using an arithmetic coding technique to infer column names. Our system also generates star schema from semi-structured data (e.g., comma-separated-value files and spreadsheets), which do not provide primary keys, foreign keys, or relationship cardinalities between tables. Our framework facilitates star schema construction and their relationship information without human intervention using homegrown algorithms. Experiments demonstrate that our technique predicts column names and data types that enable the effective generation of star schema better than baseline approaches." @default.
- W3168770866 created "2021-06-22" @default.
- W3168770866 creator A5000659850 @default.
- W3168770866 creator A5040426688 @default.
- W3168770866 creator A5041972005 @default.
- W3168770866 creator A5074524268 @default.
- W3168770866 date "2021-11-01" @default.
- W3168770866 modified "2023-10-03" @default.
- W3168770866 title "Intelligent approach to automated star-schema construction using a knowledge base" @default.
- W3168770866 cites W1522784375 @default.
- W3168770866 cites W1568351876 @default.
- W3168770866 cites W1976507515 @default.
- W3168770866 cites W2036619835 @default.
- W3168770866 cites W2059102521 @default.
- W3168770866 cites W2081580037 @default.
- W3168770866 cites W2083012399 @default.
- W3168770866 cites W2090669483 @default.
- W3168770866 cites W2092090410 @default.
- W3168770866 cites W2129652681 @default.
- W3168770866 cites W2143814287 @default.
- W3168770866 cites W2164508904 @default.
- W3168770866 cites W2165905239 @default.
- W3168770866 cites W2890689990 @default.
- W3168770866 cites W2909761977 @default.
- W3168770866 cites W2954175085 @default.
- W3168770866 cites W3010624202 @default.
- W3168770866 cites W3012988874 @default.
- W3168770866 cites W3017265497 @default.
- W3168770866 doi "https://doi.org/10.1016/j.eswa.2021.115226" @default.
- W3168770866 hasPublicationYear "2021" @default.
- W3168770866 type Work @default.
- W3168770866 sameAs 3168770866 @default.
- W3168770866 citedByCount "4" @default.
- W3168770866 countsByYear W31687708662022 @default.
- W3168770866 countsByYear W31687708662023 @default.
- W3168770866 crossrefType "journal-article" @default.
- W3168770866 hasAuthorship W3168770866A5000659850 @default.
- W3168770866 hasAuthorship W3168770866A5040426688 @default.
- W3168770866 hasAuthorship W3168770866A5041972005 @default.
- W3168770866 hasAuthorship W3168770866A5074524268 @default.
- W3168770866 hasConcept C115901376 @default.
- W3168770866 hasConcept C124101348 @default.
- W3168770866 hasConcept C127413603 @default.
- W3168770866 hasConcept C148840519 @default.
- W3168770866 hasConcept C154945302 @default.
- W3168770866 hasConcept C190703929 @default.
- W3168770866 hasConcept C23123220 @default.
- W3168770866 hasConcept C30775581 @default.
- W3168770866 hasConcept C41008148 @default.
- W3168770866 hasConcept C4554734 @default.
- W3168770866 hasConcept C52146309 @default.
- W3168770866 hasConcept C78519656 @default.
- W3168770866 hasConceptScore W3168770866C115901376 @default.
- W3168770866 hasConceptScore W3168770866C124101348 @default.
- W3168770866 hasConceptScore W3168770866C127413603 @default.
- W3168770866 hasConceptScore W3168770866C148840519 @default.
- W3168770866 hasConceptScore W3168770866C154945302 @default.
- W3168770866 hasConceptScore W3168770866C190703929 @default.
- W3168770866 hasConceptScore W3168770866C23123220 @default.
- W3168770866 hasConceptScore W3168770866C30775581 @default.
- W3168770866 hasConceptScore W3168770866C41008148 @default.
- W3168770866 hasConceptScore W3168770866C4554734 @default.
- W3168770866 hasConceptScore W3168770866C52146309 @default.
- W3168770866 hasConceptScore W3168770866C78519656 @default.
- W3168770866 hasFunder F4320323020 @default.
- W3168770866 hasLocation W31687708661 @default.
- W3168770866 hasOpenAccess W3168770866 @default.
- W3168770866 hasPrimaryLocation W31687708661 @default.
- W3168770866 hasRelatedWork W1521130755 @default.
- W3168770866 hasRelatedWork W1522717081 @default.
- W3168770866 hasRelatedWork W1829475407 @default.
- W3168770866 hasRelatedWork W1992271858 @default.
- W3168770866 hasRelatedWork W2087376388 @default.
- W3168770866 hasRelatedWork W2092058806 @default.
- W3168770866 hasRelatedWork W2585924647 @default.
- W3168770866 hasRelatedWork W2736988155 @default.
- W3168770866 hasRelatedWork W73343063 @default.
- W3168770866 hasRelatedWork W2585344821 @default.
- W3168770866 hasVolume "182" @default.
- W3168770866 isParatext "false" @default.
- W3168770866 isRetracted "false" @default.
- W3168770866 magId "3168770866" @default.
- W3168770866 workType "article" @default.