{"id":"https://openalex.org/W4379382824","doi":"https://doi.org/10.1145/3555041.3589712","title":"BCNF* - From Normalized- to Star-Schemas and Back Again","display_name":"BCNF* - From Normalized- to Star-Schemas and Back Again","publication_year":2023,"publication_date":"2023-06-04","ids":{"openalex":"https://openalex.org/W4379382824","doi":"https://doi.org/10.1145/3555041.3589712"},"language":"en","primary_location":{"id":"doi:10.1145/3555041.3589712","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3555041.3589712","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3555041.3589712","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the 2023 International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3555041.3589712","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5003877931","display_name":"Marie A. Fischer","orcid":"https://orcid.org/0009-0007-7798-4561"},"institutions":[{"id":"https://openalex.org/I143288331","display_name":"Hasso Plattner Institute","ror":"https://ror.org/058rn5r42","country_code":"DE","type":"facility","lineage":["https://openalex.org/I143288331","https://openalex.org/I176453806"]},{"id":"https://openalex.org/I176453806","display_name":"University of Potsdam","ror":"https://ror.org/03bnmw459","country_code":"DE","type":"education","lineage":["https://openalex.org/I176453806"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Marie Fischer","raw_affiliation_strings":["Hasso Plattner Institute, University of Potsdam, Potsdam, Germany"],"raw_orcid":"https://orcid.org/0009-0007-7798-4561","affiliations":[{"raw_affiliation_string":"Hasso Plattner Institute, University of Potsdam, Potsdam, Germany","institution_ids":["https://openalex.org/I143288331","https://openalex.org/I176453806"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5072236855","display_name":"Paul G. Roessler","orcid":null},"institutions":[{"id":"https://openalex.org/I143288331","display_name":"Hasso Plattner Institute","ror":"https://ror.org/058rn5r42","country_code":"DE","type":"facility","lineage":["https://openalex.org/I143288331","https://openalex.org/I176453806"]},{"id":"https://openalex.org/I176453806","display_name":"University of Potsdam","ror":"https://ror.org/03bnmw459","country_code":"DE","type":"education","lineage":["https://openalex.org/I176453806"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Paul Roessler","raw_affiliation_strings":["Hasso Plattner Institute, University of Potsdam, Potsdam, Germany"],"raw_orcid":"https://orcid.org/0009-0003-4645-2408","affiliations":[{"raw_affiliation_string":"Hasso Plattner Institute, University of Potsdam, Potsdam, Germany","institution_ids":["https://openalex.org/I143288331","https://openalex.org/I176453806"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5091676699","display_name":"Paul Sieben","orcid":"https://orcid.org/0000-0002-4365-9484"},"institutions":[{"id":"https://openalex.org/I143288331","display_name":"Hasso Plattner Institute","ror":"https://ror.org/058rn5r42","country_code":"DE","type":"facility","lineage":["https://openalex.org/I143288331","https://openalex.org/I176453806"]},{"id":"https://openalex.org/I176453806","display_name":"University of Potsdam","ror":"https://ror.org/03bnmw459","country_code":"DE","type":"education","lineage":["https://openalex.org/I176453806"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Paul Sieben","raw_affiliation_strings":["Hasso Plattner Institute, University of Potsdam, Potsdam, Germany"],"raw_orcid":"https://orcid.org/0000-0002-4365-9484","affiliations":[{"raw_affiliation_string":"Hasso Plattner Institute, University of Potsdam, Potsdam, Germany","institution_ids":["https://openalex.org/I143288331","https://openalex.org/I176453806"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5092088733","display_name":"Janina Adamcic","orcid":"https://orcid.org/0009-0005-8885-2535"},"institutions":[{"id":"https://openalex.org/I143288331","display_name":"Hasso Plattner Institute","ror":"https://ror.org/058rn5r42","country_code":"DE","type":"facility","lineage":["https://openalex.org/I143288331","https://openalex.org/I176453806"]},{"id":"https://openalex.org/I176453806","display_name":"University of Potsdam","ror":"https://ror.org/03bnmw459","country_code":"DE","type":"education","lineage":["https://openalex.org/I176453806"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Janina Adamcic","raw_affiliation_strings":["Hasso Plattner Institute, University of Potsdam, Potsdam, Germany"],"raw_orcid":"https://orcid.org/0009-0005-8885-2535","affiliations":[{"raw_affiliation_string":"Hasso Plattner Institute, University of Potsdam, Potsdam, Germany","institution_ids":["https://openalex.org/I143288331","https://openalex.org/I176453806"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5092088734","display_name":"Christoph Kirchherr","orcid":null},"institutions":[{"id":"https://openalex.org/I143288331","display_name":"Hasso Plattner Institute","ror":"https://ror.org/058rn5r42","country_code":"DE","type":"facility","lineage":["https://openalex.org/I143288331","https://openalex.org/I176453806"]},{"id":"https://openalex.org/I176453806","display_name":"University of Potsdam","ror":"https://ror.org/03bnmw459","country_code":"DE","type":"education","lineage":["https://openalex.org/I176453806"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Christoph Kirchherr","raw_affiliation_strings":["Hasso Plattner Institute, University of Potsdam, Potsdam, Germany"],"raw_orcid":"https://orcid.org/0009-0003-4289-8664","affiliations":[{"raw_affiliation_string":"Hasso Plattner Institute, University of Potsdam, Potsdam, Germany","institution_ids":["https://openalex.org/I143288331","https://openalex.org/I176453806"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5092088735","display_name":"Tobias Straeubig","orcid":null},"institutions":[{"id":"https://openalex.org/I143288331","display_name":"Hasso Plattner Institute","ror":"https://ror.org/058rn5r42","country_code":"DE","type":"facility","lineage":["https://openalex.org/I143288331","https://openalex.org/I176453806"]},{"id":"https://openalex.org/I176453806","display_name":"University of Potsdam","ror":"https://ror.org/03bnmw459","country_code":"DE","type":"education","lineage":["https://openalex.org/I176453806"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Tobias Straeubig","raw_affiliation_strings":["Hasso Plattner Institute, University of Potsdam, Potsdam, Germany"],"raw_orcid":"https://orcid.org/0009-0001-2362-5201","affiliations":[{"raw_affiliation_string":"Hasso Plattner Institute, University of Potsdam, Potsdam, Germany","institution_ids":["https://openalex.org/I143288331","https://openalex.org/I176453806"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5001444081","display_name":"Youri Kaminsky","orcid":"https://orcid.org/0009-0007-6547-592X"},"institutions":[{"id":"https://openalex.org/I143288331","display_name":"Hasso Plattner Institute","ror":"https://ror.org/058rn5r42","country_code":"DE","type":"facility","lineage":["https://openalex.org/I143288331","https://openalex.org/I176453806"]},{"id":"https://openalex.org/I176453806","display_name":"University of Potsdam","ror":"https://ror.org/03bnmw459","country_code":"DE","type":"education","lineage":["https://openalex.org/I176453806"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Youri Kaminsky","raw_affiliation_strings":["Hasso Plattner Institute, University of Potsdam, Potsdam, Germany"],"raw_orcid":"https://orcid.org/0009-0007-6547-592X","affiliations":[{"raw_affiliation_string":"Hasso Plattner Institute, University of Potsdam, Potsdam, Germany","institution_ids":["https://openalex.org/I143288331","https://openalex.org/I176453806"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5053028480","display_name":"Felix Naumann","orcid":"https://orcid.org/0000-0002-4483-1389"},"institutions":[{"id":"https://openalex.org/I143288331","display_name":"Hasso Plattner Institute","ror":"https://ror.org/058rn5r42","country_code":"DE","type":"facility","lineage":["https://openalex.org/I143288331","https://openalex.org/I176453806"]},{"id":"https://openalex.org/I176453806","display_name":"University of Potsdam","ror":"https://ror.org/03bnmw459","country_code":"DE","type":"education","lineage":["https://openalex.org/I176453806"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Felix Naumann","raw_affiliation_strings":["Hasso Plattner Institute, University of Potsdam, Potsdam, Germany"],"raw_orcid":"https://orcid.org/0000-0002-4483-1389","affiliations":[{"raw_affiliation_string":"Hasso Plattner Institute, University of Potsdam, Potsdam, Germany","institution_ids":["https://openalex.org/I143288331","https://openalex.org/I176453806"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":8,"corresponding_author_ids":["https://openalex.org/A5003877931"],"corresponding_institution_ids":["https://openalex.org/I143288331","https://openalex.org/I176453806"],"apc_list":null,"apc_paid":null,"fwci":0.4931,"has_fulltext":true,"cited_by_count":2,"citation_normalized_percentile":{"value":0.66999065,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":95,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"103","last_page":"106"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9997000098228455,"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"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9997000098228455,"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"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9991000294685364,"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.9990000128746033,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.9239678382873535},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7843403220176697},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.7693088054656982},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.7629934549331665},{"id":"https://openalex.org/keywords/scripting-language","display_name":"Scripting language","score":0.7383193373680115},{"id":"https://openalex.org/keywords/schema-migration","display_name":"Schema migration","score":0.5102488994598389},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.49304744601249695},{"id":"https://openalex.org/keywords/schema-evolution","display_name":"Schema evolution","score":0.4460436701774597},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.4191802740097046},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.41441184282302856},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.38638532161712646},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3831523060798645},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.32886362075805664},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.321224182844162},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.3044945001602173},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.1285344362258911}],"concepts":[{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.9239678382873535},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7843403220176697},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7693088054656982},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.7629934549331665},{"id":"https://openalex.org/C61423126","wikidata":"https://www.wikidata.org/wiki/Q187432","display_name":"Scripting language","level":2,"score":0.7383193373680115},{"id":"https://openalex.org/C153440673","wikidata":"https://www.wikidata.org/wiki/Q7431119","display_name":"Schema migration","level":5,"score":0.5102488994598389},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.49304744601249695},{"id":"https://openalex.org/C2780660560","wikidata":"https://www.wikidata.org/wiki/Q3951893","display_name":"Schema evolution","level":4,"score":0.4460436701774597},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.4191802740097046},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.41441184282302856},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.38638532161712646},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3831523060798645},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.32886362075805664},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.321224182844162},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.3044945001602173},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.1285344362258911}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3555041.3589712","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3555041.3589712","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3555041.3589712","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the 2023 International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3555041.3589712","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3555041.3589712","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3555041.3589712","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the 2023 International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4379382824.pdf","grobid_xml":"https://content.openalex.org/works/W4379382824.grobid-xml"},"referenced_works_count":11,"referenced_works":["https://openalex.org/W1495859460","https://openalex.org/W2072044535","https://openalex.org/W2090300806","https://openalex.org/W2157060173","https://openalex.org/W2182148130","https://openalex.org/W2232417456","https://openalex.org/W2439326083","https://openalex.org/W2521016955","https://openalex.org/W2952207484","https://openalex.org/W3013082216","https://openalex.org/W3030383065"],"related_works":["https://openalex.org/W2103472145","https://openalex.org/W166845585","https://openalex.org/W2153512431","https://openalex.org/W1591654213","https://openalex.org/W49842380","https://openalex.org/W2561775104","https://openalex.org/W1512552654","https://openalex.org/W2148067883","https://openalex.org/W1513459549","https://openalex.org/W2031254074"],"abstract_inverted_index":{"Data":[0],"warehouses":[1],"are":[2,16,27],"the":[3],"core":[4],"of":[5],"many":[6],"data":[7,78],"analysis":[8],"processes.":[9],"They":[10],"contain":[11],"various":[12],"database":[13],"schemas,":[14],"which":[15,33],"designed":[17],"and":[18,23,29,37,60],"created":[19],"through":[20,81],"schema":[21,58,71,87],"transformation":[22,62],"integration.":[24],"These":[25],"processes":[26],"complex":[28],"require":[30],"technical":[31],"knowledge,":[32],"makes":[34],"them":[35],"costly":[36],"prevents":[38],"business":[39],"teams":[40],"to":[41,54],"start":[42],"new":[43],"analyses":[44],"independently.":[45],"BCNF*":[46],"is":[47,74],"a":[48,84],"web":[49],"application":[50],"that":[51],"enables":[52],"users":[53],"safely":[55],"explore":[56],"valid":[57],"transformations":[59],"generate":[61],"scripts":[63],"automatically.":[64],"It":[65],"can":[66],"be":[67],"used":[68],"for":[69,76],"any":[70],"transformation,":[72],"but":[73],"optimized":[75],"semi-automatic":[77],"warehouse":[79],"creation":[80],"means":[82],"like":[83],"dedicated":[85],"star":[86],"mode.":[88]},"counts_by_year":[{"year":2025,"cited_by_count":2}],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2025-10-10T00:00:00"}