{"title":"类型2缓慢变化的维度:使用co>操作系统的案例研究","authors":"C. Stanfill","doi":"10.1145/2390045.2390059","DOIUrl":null,"url":null,"abstract":"The Co>Operating System - a parallel and distributed enterprise computing platform based on dataflow - is applied to the management of Type 2 slowly changing dimensions. Five different solutions, using merge join, hybrid hash join, lookup files, SQL, and stored procedures are implemented and evaluated. Solutions to important but often neglected aspects of such systems, such as auditing and error handling are also described. The solutions are evaluated based on scalability and performance and are found to scale up to the limits of the platform.","PeriodicalId":335396,"journal":{"name":"International Workshop on Data Warehousing and OLAP","volume":"2 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2012-11-02","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"6","resultStr":"{\"title\":\"Type 2 slowly changing dimensions: a case study using the co>operating system\",\"authors\":\"C. Stanfill\",\"doi\":\"10.1145/2390045.2390059\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"The Co>Operating System - a parallel and distributed enterprise computing platform based on dataflow - is applied to the management of Type 2 slowly changing dimensions. Five different solutions, using merge join, hybrid hash join, lookup files, SQL, and stored procedures are implemented and evaluated. Solutions to important but often neglected aspects of such systems, such as auditing and error handling are also described. The solutions are evaluated based on scalability and performance and are found to scale up to the limits of the platform.\",\"PeriodicalId\":335396,\"journal\":{\"name\":\"International Workshop on Data Warehousing and OLAP\",\"volume\":\"2 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2012-11-02\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"6\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"International Workshop on Data Warehousing and OLAP\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1145/2390045.2390059\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"International Workshop on Data Warehousing and OLAP","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1145/2390045.2390059","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Type 2 slowly changing dimensions: a case study using the co>operating system
The Co>Operating System - a parallel and distributed enterprise computing platform based on dataflow - is applied to the management of Type 2 slowly changing dimensions. Five different solutions, using merge join, hybrid hash join, lookup files, SQL, and stored procedures are implemented and evaluated. Solutions to important but often neglected aspects of such systems, such as auditing and error handling are also described. The solutions are evaluated based on scalability and performance and are found to scale up to the limits of the platform.