USER DRIVEN BUSINESS DATA AGGREGATION AND CROSS MAPPING FRAMEWORK

• US 20160117362A1
• Filed: 10/24/2014
• Published: 04/28/2016
• Est. Priority Date: 10/24/2014
• Status: Active Grant

• Current Assignee: Kyndryl Incorporated
• Original Assignee: International Business Machines Corporation
• Inventors: Bauer, Daniel N., Jobson, Thomas A. Jr., Bagehorn, Frank, Qureshi, Adeel
• Granted Patent: US 9,720,958 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/221 Column-oriented storage; Management thereof
• CPC Class Codes: G06F 16/244 Grouping and aggregation

Abstract

An approach is provided for aggregating business data. Based on received columns, attributes, and keys of a dataset, the dataset is registered in a central hub of datasets which include data that is independently and locally maintained. Initial or updated data is loaded into the dataset in the central hub. Other datasets in the central hub that include columns, attributes, or keys that match the received columns, attributes, or keys, respectively, are determined and displayed. In response to receiving a user selection of one or more of the displayed datasets, cross-links between the dataset and each of the one or more selected datasets are automatically generated. The cross-links are based on the columns, attributes, or keys of the displayed datasets that match the received columns, attributes or keys. The cross-links provide an aggregation of business data in the dataset and the one or more selected datasets.

Claims

1. A method of aggregating business data, the method comprising the steps of:

a computer receiving, from a user, columns, attributes of the columns, and keys of a dataset of a database, the keys being unique identifiers of records in the dataset, and the dataset not being initially cross-linked to any dataset included in a central hub of a plurality of datasets, each dataset including data that is independently and locally maintained;

based on the received columns, attributes, and keys of the dataset, the computer registering the dataset so that the dataset is included in the central hub;

the computer loading initial data or updated data into the dataset in the central hub;

the computer determining and displaying other datasets included in the central hub that include columns, attributes, or keys that match the received columns, attributes, or keys, respectively;

the computer receiving from the user a selection of one or more of the displayed datasets; and

in response to the step of receiving the selection, the computer automatically generating cross-links between the dataset and each of the one or more datasets selected from the displayed datasets, the cross-links based at least in part on the columns, attributes, or keys of the displayed datasets that match the received columns, attributes or keys, and the cross-links providing an aggregation of business data in the dataset and the one or more datasets.

2. The method of claim 1, further comprising the step of the computer receiving a selection of visibility of the dataset, which indicates that the dataset has (1) public visibility to all users of the central hub or (2) private visibility to a predetermined group of users that is a proper subset of all users of the central hub.

3. The method of claim 2, further comprising the steps of:

the computer determining the selected visibility of the dataset indicates the dataset has private visibility;

the computer determining a second user is attempting to access the dataset via the central hub;

the computer determining the second user is included in the predetermined group of users;

based on the second user being included in the predetermined group of users, the computer providing the second user with access to the dataset and to the cross-links between the dataset and each of the one or more datasets selected from the displayed datasets; and

responsive to a request by the second user, the computer generating an analysis of data in the dataset by utilizing the access of the second user to the dataset and to the cross-links.

4. The method of claim 1, further comprising the step of the computer receiving from the user a selection of foreign key(s) of the one or more datasets selected from the displayed datasets, wherein the step of automatically generating the cross-links is based in part on the received selection of the foreign key(s).

5. The method of claim 1, further comprising the steps of:

the computer displaying the plurality of datasets which are preconfigured and included in the central hub and in response, receiving from the user or another user a selection of the dataset from the displayed plurality of datasets;

the computer receiving from the user or the other user a modification of the records in the dataset, the modification of the records including at least one of (1) an addition of a record to the dataset, (2) a deletion of a record from the dataset, and (3) a change of a value of an attribute included in a record in the dataset;

based on the modification of the records, the computer generating an alternate version of the dataset that includes the modification of the records;

the computer storing the alternate version of the dataset in association with the dataset;

based on the alternate version being stored in association with the dataset and in response to an interaction with the central hub by a second user, the computer initiating a sharing of the alternate version with the second user by displaying the dataset and the alternate version of the dataset as a potential selection by the second user, the second user being different from the user;

the computer receiving from the second user a selection of the displayed dataset or the displayed alternate version of the dataset; and

based on the selection received from the second user, the computer performing an analysis of data in the dataset or the alternate version of the dataset.

6. The method of claim 1, further comprising the steps of:

the computer displaying the cross-links between the dataset and each of the one or more datasets, and in response, receiving from the user or another user a selection of one of the displayed cross-links;

the computer receiving from the user or the other user a modification of the cross-link whose selection was received;

the computer storing the modification of the cross-link in association with the cross-link;

based on the modification of the cross-link being stored in association with the cross-link and in response to an interaction with the central hub by a second user, the computer displaying (1) the modification of the cross-link instead of the cross-link and (2) cross-link(s) other than the cross-link whose selection was received as a potential selection by the second user, the second user being different from the user;

the computer receiving from the second user a selection of the displayed modification of the cross-link or one of the other cross-link(s); and

based on the selection received from the second user, the computer performing an analysis of data in the dataset.

7. The method of claim 6, wherein the step of the computer receiving the modification of the cross-link includes receiving an additional record or a pruned record to modify the cross-link.

8. The method of claim 1, further comprising:

providing at least one support service for at least one of creating, integrating, hosting, maintaining, and deploying computer-readable program code in the computer, the program code being executed by a processor of the computer to implement the steps of receiving the columns, attributes, and keys, registering the dataset, loading the initial or updated data, determining and displaying the other datasets, receiving the selection, and generating the cross-links.

9. A computer program product, comprising:

a computer-readable storage device; and

a computer-readable program code stored in the computer-readable storage device, the computer-readable program code containing instructions that are executed by a central processing unit (CPU) of a computer system to implement a method of aggregating business data, the method comprising the steps of;

the computer system receiving from a user columns, attributes of the columns, and keys of a dataset of a database, the keys being unique identifiers of records in the dataset, and the dataset not being initially cross-linked to any dataset included in a central hub of a plurality of datasets, each dataset including data that is independently and locally maintained;

based on the received columns, attributes, and keys of the dataset, the computer system registering the dataset so that the dataset is included in the central hub;

the computer system loading initial data or updated data into the dataset in the central hub;

the computer system determining and displaying other datasets included in the central hub that include columns, attributes, or keys that match the received columns, attributes, or keys, respectively;

the computer system receiving from the user a selection of one or more of the displayed datasets; and

in response to the step of receiving the selection, the computer system automatically generating cross-links between the dataset and each of the one or more datasets selected from the displayed datasets, the cross-links based at least in part on the columns, attributes, or keys of the displayed datasets that match the received columns, attributes or keys, and the cross-links providing an aggregation of business data in the dataset and the one or more datasets.

10. The computer program product of claim 9, wherein the method further comprises the step of the computer system receiving a selection of visibility of the dataset, which indicates that the dataset has (1) public visibility to all users of the central hub or (2) private visibility to a predetermined group of users that is a proper subset of all users of the central hub.

11. The computer program product of claim 10, wherein the method further comprises the steps of:

the computer system determining the selected visibility of the dataset indicates the dataset has private visibility;

the computer system determining a second user is attempting to access the dataset via the central hub;

the computer system determining the second user is included in the predetermined group of users;

based on the second user being included in the predetermined group of users, the computer system providing the second user with access to the dataset and to the cross-links between the dataset and each of the one or more datasets selected from the displayed datasets; and

responsive to a request by the second user, the computer system generating an analysis of data in the dataset by utilizing the access of the second user to the dataset and to the cross-links.

12. The computer program product of claim 9, wherein the method further comprises the step of the computer system receiving from the user a selection of foreign key(s) of the one or more datasets selected from the displayed datasets, wherein the step of automatically generating the cross-links is based in part on the received selection of the foreign key(s).

13. The computer program product of claim 9, wherein the method further comprises the steps of:

the computer system displaying the plurality of datasets which are preconfigured and included in the central hub and in response, receiving from the user or another user a selection of the dataset from the displayed plurality of datasets;

the computer system receiving from the user or the other user a modification of the records in the dataset, the modification of the records including at least one of (1) an addition of a record to the dataset, (2) a deletion of a record from the dataset, and (3) a change of a value of an attribute included in a record in the dataset;

based on the modification of the records, the computer system generating an alternate version of the dataset that includes the modification of the records;

the computer system storing the alternate version of the dataset in association with the dataset;

based on the alternate version being stored in association with the dataset and in response to an interaction with the central hub by a second user, the computer system initiating a sharing of the alternate version with the second user by displaying the dataset and the alternate version of the dataset as a potential selection by the second user, the second user being different from the user;

the computer system receiving from the second user a selection of the displayed dataset or the displayed alternate version of the dataset; and

based on the selection received from the second user, the computer system performing an analysis of data in the dataset or the alternate version of the dataset.

14. The computer program product of claim 9, wherein the method further comprises the steps of:

the computer system displaying the cross-links between the dataset and each of the one or more datasets, and in response, receiving from the user or another user a selection of one of the displayed cross-links;

the computer system receiving from the user or the other user a modification of the cross-link whose selection was received;

the computer system storing the modification of the cross-link in association with the cross-link;

based on the modification of the cross-link being stored in association with the cross-link and in response to an interaction with the central hub by a second user, the computer system displaying (1) the modification of the cross-link instead of the cross-link and (2) cross-link(s) other than the cross-link whose selection was received as a potential selection by the second user, the second user being different from the user;

the computer system receiving from the second user a selection of the displayed modification of the cross-link or one of the other cross-link(s); and

based on the selection received from the second user, the computer system performing an analysis of data in the dataset.

15. A computer system comprising:

a central processing unit (CPU);

a memory coupled to the CPU; and

a computer-readable storage device coupled to the CPU, the storage device containing instructions that are executed by the CPU via the memory to implement a method of aggregating business data, the method comprising the steps of;

the computer system receiving from a user columns, attributes of the columns, and keys of a dataset of a database, the keys being unique identifiers of records in the dataset, and the dataset not being initially cross-linked to any dataset included in a central hub of a plurality of datasets, each dataset including data that is independently and locally maintained;

based on the received columns, attributes, and keys of the dataset, the computer system registering the dataset so that the dataset is included in the central hub;

the computer system loading initial data or updated data into the dataset in the central hub;

the computer system determining and displaying other datasets included in the central hub that include columns, attributes, or keys that match the received columns, attributes, or keys, respectively;

the computer system receiving from the user a selection of one or more of the displayed datasets; and

in response to the step of receiving the selection, the computer system automatically generating cross-links between the dataset and each of the one or more datasets selected from the displayed datasets, the cross-links based at least in part on the columns, attributes, or keys of the displayed datasets that match the received columns, attributes or keys, and the cross-links providing an aggregation of business data in the dataset and the one or more datasets.

16. The computer system of claim 15, wherein the method further comprises the step of the computer system receiving a selection of visibility of the dataset, which indicates that the dataset has (1) public visibility to all users of the central hub or (2) private visibility to a predetermined group of users that is a proper subset of all users of the central hub.

17. The computer system of claim 16, wherein the method further comprises the steps of:

the computer system determining the selected visibility of the dataset indicates the dataset has private visibility;

the computer system determining a second user is attempting to access the dataset via the central hub;

the computer system determining the second user is included in the predetermined group of users;

based on the second user being included in the predetermined group of users, the computer system providing the second user with access to the dataset and to the cross-links between the dataset and each of the one or more datasets selected from the displayed datasets; and

responsive to a request by the second user, the computer system generating an analysis of data in the dataset by utilizing the access of the second user to the dataset and to the cross-links.

18. The computer system of claim 15, wherein the method further comprises the step of the computer system receiving from the user a selection of foreign key(s) of the one or more datasets selected from the displayed datasets, wherein the step of automatically generating the cross-links is based in part on the received selection of the foreign key(s).

19. The computer system of claim 15, wherein the method further comprises the steps of:

the computer system displaying the plurality of datasets which are preconfigured and included in the central hub and in response, receiving from the user or another user a selection of the dataset from the displayed plurality of datasets;

the computer system receiving from the user or the other user a modification of the records in the dataset, the modification of the records including at least one of (1) an addition of a record to the dataset, (2) a deletion of a record from the dataset, and (3) a change of a value of an attribute included in a record in the dataset;

based on the modification of the records, the computer system generating an alternate version of the dataset that includes the modification of the records;

the computer system storing the alternate version of the dataset in association with the dataset;

based on the alternate version being stored in association with the dataset and in response to an interaction with the central hub by a second user, the computer system initiating a sharing of the alternate version with the second user by displaying the dataset and the alternate version of the dataset as a potential selection by the second user, the second user being different from the user;

the computer system receiving from the second user a selection of the displayed dataset or the displayed alternate version of the dataset; and

based on the selection received from the second user, the computer system performing an analysis of data in the dataset or the alternate version of the dataset.

20. The computer system of claim 15, wherein the method further comprises the steps of:

the computer system displaying the cross-links between the dataset and each of the one or more datasets, and in response, receiving from the user or another user a selection of one of the displayed cross-links;

the computer system receiving from the user or the other user a modification of the cross-link whose selection was received;

the computer system storing the modification of the cross-link in association with the cross-link;

based on the modification of the cross-link being stored in association with the cross-link and in response to an interaction with the central hub by a second user, the computer system displaying (1) the modification of the cross-link instead of the cross-link and (2) cross-link(s) other than the cross-link whose selection was received as a potential selection by the second user, the second user being different from the user;

the computer system receiving from the second user a selection of the displayed modification of the cross-link or one of the other cross-link(s); and

based on the selection received from the second user, the computer system performing an analysis of data in the dataset.