User driven business data aggregation and cross mapping framework
First Claim
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;
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;
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.
2 Assignments
0 Petitions
Accused Products
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.
79 Citations
17 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; 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; 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. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. 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; 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; 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. - View Dependent Claims (9, 10, 11, 12)
-
-
13. 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; 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; 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. - View Dependent Claims (14, 15, 16, 17)
-
Specification