Marie Fischer, Paul Roessler, Paul Sieben, Janina Adamcic, Christoph Kirchherr, Tobias Straeubig, Youri Kaminsky, Felix Naumann
{"title":"BCNF* -从规范化到星型模式再回来","authors":"Marie Fischer, Paul Roessler, Paul Sieben, Janina Adamcic, Christoph Kirchherr, Tobias Straeubig, Youri Kaminsky, Felix Naumann","doi":"10.1145/3555041.3589712","DOIUrl":null,"url":null,"abstract":"Data warehouses are the core of many data analysis processes. They contain various database schemas, which are designed and created through schema transformation and integration. These processes are complex and require technical knowledge, which makes them costly and prevents business teams to start new analyses independently. BCNF* is a web application that enables users to safely explore valid schema transformations and generate transformation scripts automatically. It can be used for any schema transformation, but is optimized for semi-automatic data warehouse creation through means like a dedicated star schema mode.","PeriodicalId":161812,"journal":{"name":"Companion of the 2023 International Conference on Management of Data","volume":"71 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2023-06-04","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"BCNF* - From Normalized- to Star-Schemas and Back Again\",\"authors\":\"Marie Fischer, Paul Roessler, Paul Sieben, Janina Adamcic, Christoph Kirchherr, Tobias Straeubig, Youri Kaminsky, Felix Naumann\",\"doi\":\"10.1145/3555041.3589712\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Data warehouses are the core of many data analysis processes. They contain various database schemas, which are designed and created through schema transformation and integration. These processes are complex and require technical knowledge, which makes them costly and prevents business teams to start new analyses independently. BCNF* is a web application that enables users to safely explore valid schema transformations and generate transformation scripts automatically. It can be used for any schema transformation, but is optimized for semi-automatic data warehouse creation through means like a dedicated star schema mode.\",\"PeriodicalId\":161812,\"journal\":{\"name\":\"Companion of the 2023 International Conference on Management of Data\",\"volume\":\"71 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2023-06-04\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Companion of the 2023 International Conference on Management of Data\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1145/3555041.3589712\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Companion of the 2023 International Conference on Management of Data","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1145/3555041.3589712","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
BCNF* - From Normalized- to Star-Schemas and Back Again
Data warehouses are the core of many data analysis processes. They contain various database schemas, which are designed and created through schema transformation and integration. These processes are complex and require technical knowledge, which makes them costly and prevents business teams to start new analyses independently. BCNF* is a web application that enables users to safely explore valid schema transformations and generate transformation scripts automatically. It can be used for any schema transformation, but is optimized for semi-automatic data warehouse creation through means like a dedicated star schema mode.