Abstract: A computer-implemented method comprising receiving a user request. The method analyzes the data in a plurality of data sets to find inconsistent mappings. Data of data sets, such as columns formed by a join condition, are compared to determine matching or non-matching distinct characteristic values. A composite data set is generated based on the comparison. Another data set is compared with the composite data set, and the composite data set is enhanced. Each data set is compared in sequence, if the composite data set is not empty, until all data sets are analyzed. A result set is generated based on the matching or non-matching distinct characteristic values. The method may also determine if a join operates as a data filter. The operations that are used for analysis may include ‘count distinct’, ‘intersection’ and ‘Boolean operators’.

Abstract: A central data warehouse includes embedded data marts. These embedded data marts, referred to as workspaces, are assigned centrally manage data by reference only but rely directly on the centrally managed data and the underlying infrastructure. Workspaces still allow departments in an enterprise to perform certain actions on their own (like adding new data and building new models) without having to instantiate copies of the centrally managed data in a locally managed data mart.

Abstract: In one embodiment, a computer-implemented method comprising receiving a user request. The method analyzes the data in a plurality of data sets to find inconsistent mappings. Data of data sets, such as columns formed by a join condition, are compared to determine matching or non-matching distinct characteristic values. A composite data set is generated based on the comparison. Another data set is compared with the composite data set, and the composite data set is enhanced. Each data set is compared in sequence, if the composite data set is not empty, until all data sets are analyzed. A result set is generated based on the matching or non-matching distinct characteristic values. The method may also determine if a join operates as a data filter. The operations that are used for analysis may include ‘count distinct’, ‘intersection’ and ‘Boolean operators’.

Abstract: A central data warehouse includes embedded data marts. These embedded data marts, referred to as workspaces, are assigned centrally manage data by reference only but rely directly on the centrally managed data and the underlying infrastructure. Workspaces still allow departments in an enterprise to perform certain actions on their own (like adding new data and building new models) without having to instantiate copies of the centrally managed data in a locally managed data mart.