{"id":"https://openalex.org/W2090300806","doi":"https://doi.org/10.1145/1317331.1317334","title":"SAMSTAR","display_name":"SAMSTAR","publication_year":2007,"publication_date":"2007-11-09","ids":{"openalex":"https://openalex.org/W2090300806","doi":"https://doi.org/10.1145/1317331.1317334","mag":"2090300806"},"language":"en","primary_location":{"id":"doi:10.1145/1317331.1317334","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1317331.1317334","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM tenth international workshop on Data warehousing and OLAP","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5111861086","display_name":"Il Yeol Song","orcid":null},"institutions":[{"id":"https://openalex.org/I72816309","display_name":"Drexel University","ror":"https://ror.org/04bdffz58","country_code":"US","type":"education","lineage":["https://openalex.org/I72816309"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Il Yeol Song","raw_affiliation_strings":["Drexel University, Philadelphia, PA"],"affiliations":[{"raw_affiliation_string":"Drexel University, Philadelphia, PA","institution_ids":["https://openalex.org/I72816309"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5112061816","display_name":"Ritu Khare","orcid":null},"institutions":[{"id":"https://openalex.org/I72816309","display_name":"Drexel University","ror":"https://ror.org/04bdffz58","country_code":"US","type":"education","lineage":["https://openalex.org/I72816309"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ritu Khare","raw_affiliation_strings":["Drexel University, Philadelphia, PA"],"affiliations":[{"raw_affiliation_string":"Drexel University, Philadelphia, PA","institution_ids":["https://openalex.org/I72816309"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5081863278","display_name":"Bing Tian Dai","orcid":"https://orcid.org/0000-0002-7245-7021"},"institutions":[{"id":"https://openalex.org/I72816309","display_name":"Drexel University","ror":"https://ror.org/04bdffz58","country_code":"US","type":"education","lineage":["https://openalex.org/I72816309"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Bing Dai","raw_affiliation_strings":["Drexel University, Philadelphia, PA"],"affiliations":[{"raw_affiliation_string":"Drexel University, Philadelphia, PA","institution_ids":["https://openalex.org/I72816309"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5111861086"],"corresponding_institution_ids":["https://openalex.org/I72816309"],"apc_list":null,"apc_paid":null,"fwci":6.1002,"has_fulltext":false,"cited_by_count":50,"citation_normalized_percentile":{"value":0.96114094,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"9","last_page":"16"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9986000061035156,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9986000061035156,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9983999729156494,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9973000288009644,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8285191655158997},{"id":"https://openalex.org/keywords/wordnet","display_name":"WordNet","score":0.7304194569587708},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.684078574180603},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.6350878477096558},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.4955974817276001},{"id":"https://openalex.org/keywords/de-facto","display_name":"De facto","score":0.47274836897850037},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4447837769985199},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.4324350655078888},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4023224115371704},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.36974966526031494},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.3408776521682739},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2564712166786194},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.17062026262283325}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8285191655158997},{"id":"https://openalex.org/C157659113","wikidata":"https://www.wikidata.org/wiki/Q533822","display_name":"WordNet","level":2,"score":0.7304194569587708},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.684078574180603},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6350878477096558},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.4955974817276001},{"id":"https://openalex.org/C2992317946","wikidata":"https://www.wikidata.org/wiki/Q712144","display_name":"De facto","level":2,"score":0.47274836897850037},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4447837769985199},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.4324350655078888},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4023224115371704},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.36974966526031494},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.3408776521682739},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2564712166786194},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.17062026262283325},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1317331.1317334","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1317331.1317334","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM tenth international workshop on Data warehousing and OLAP","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":25,"referenced_works":["https://openalex.org/W56165858","https://openalex.org/W87057539","https://openalex.org/W104265064","https://openalex.org/W1495859460","https://openalex.org/W1522784375","https://openalex.org/W1530537858","https://openalex.org/W1546237735","https://openalex.org/W1588882338","https://openalex.org/W1612832955","https://openalex.org/W1988156201","https://openalex.org/W2007757916","https://openalex.org/W2008120802","https://openalex.org/W2017012227","https://openalex.org/W2017097583","https://openalex.org/W2072044535","https://openalex.org/W2074999403","https://openalex.org/W2103818918","https://openalex.org/W2123588622","https://openalex.org/W2134835128","https://openalex.org/W2135203905","https://openalex.org/W2163009032","https://openalex.org/W2170235279","https://openalex.org/W4213254507","https://openalex.org/W4232157087","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2034415381","https://openalex.org/W2087376388","https://openalex.org/W2103472145","https://openalex.org/W2092058806","https://openalex.org/W1561927997","https://openalex.org/W1992271858","https://openalex.org/W160336554","https://openalex.org/W2389917040","https://openalex.org/W166845585","https://openalex.org/W2042840812"],"abstract_inverted_index":{"The":[0,75,150],"star":[1,22,49,62],"schema":[2,23],"is":[3,24],"widely":[4],"accepted":[5],"as":[6,71,73,110,112],"the":[7,37,41,56,82,85,94,102,116,128,136,147,154],"de":[8],"facto":[9],"data":[10,13],"model":[11],"for":[12,19],"warehouse":[14],"design.":[15],"A":[16],"popular":[17],"approach":[18],"developing":[20],"a":[21,48,142,161],"to":[25,46,114,127,164],"develop":[26],"it":[27,126],"from":[28,64,130],"an":[29,44,65],"entity-relationship":[30],"diagram":[31],"with":[32],"some":[33],"heuristics.":[34],"Most":[35],"of":[36,43,78,84,87,96,104,118,138,144,146,156],"existing":[38,131,148],"approaches":[39],"analyze":[40],"semantics":[42,70],"ERD":[45,66],"generate":[47],"schema.":[50],"In":[51],"this":[52],"paper,":[53],"we":[54],"present":[55],"SAMSTAR":[57,79,151],"method,":[58],"which":[59],"semi-automatically":[60],"generates":[61],"schemas":[63],"by":[67,124],"analyzing":[68],"its":[69],"well":[72,111],"structure.":[74],"novel":[76],"features":[77],"are":[80,141],"(1)":[81],"use":[83,103],"notion":[86],"Connection":[88],"Topology":[89],"Value":[90],"(CTV)":[91],"in":[92],"identifying":[93],"candidates":[95],"facts":[97],"and":[98,100,159],"dimensions":[99],"(2)":[101],"Annotated":[105],"Dimensional":[106],"Design":[107],"Patterns":[108],"(A_DDP)":[109],"WordNet":[113],"extend":[115],"list":[117],"dimensions.":[119],"We":[120,133],"illustrate":[121],"our":[122,139],"method":[123,140,152],"applying":[125],"examples":[129],"literature.":[132],"prove":[134],"that":[135],"outputs":[137],"superset":[143],"those":[145],"methods.":[149],"simplifies":[153],"work":[155],"experienced":[157],"designers":[158],"gives":[160],"smooth":[162],"head-start":[163],"novices.":[165]},"counts_by_year":[{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":5},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":2},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":5}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2016-06-24T00:00:00"}