USING SOURCE DATA TO PREDICT AND DETECT SOFTWARE DEPLOYMENT AND SHELFWARE
First Claim
1. A method for detecting shelfware, the method comprising:
- receiving a licensing data table and an exported business data table from a business data source, wherein the licensing data table and the exported business data table include a plurality of data fields associated with a plurality of business categories;
creating a plurality of dimensions based on a common data attribute among the plurality of data fields;
structuring the received licensing data table and the received exported business data table by assigning each data field within the plurality of data fields to a dimension within the created plurality of dimensions;
populating a fact table for each of the plurality of business categories with each data field within the plurality of data fields based on each of the plurality of business categories from which each data field originated;
merging the populated fact table for each of the plurality of business categories based on a predetermined usefulness of each populated fact table when detecting shelfware;
constructing a dimensional model based on the merging the populated fact table for each of the plurality of business categories, the populated fact table for each of the plurality of business categories, and each data field within the structured licensing data table and the structured exported business data table; and
building an interpretative report to display a plurality of customer-related information based on the constructed dimensional model.
1 Assignment
0 Petitions
Accused Products
Abstract
Detecting the presence of shelfware. A licensing data table and an exported business data table are received from a business data source, wherein a plurality of data fields associated with a plurality of business categories are included. A plurality of dimensions are created based on a common data attribute among the plurality of data fields. The received licensing data table and the received exported business data table are structured by assigning each data field within the plurality of data fields to a dimension within the plurality of dimensions. A fact table for each of the plurality of business categories is populated for each of the plurality of business categories. The populated fact tables are merged based on a predetermined usefulness when detecting shelfware. A dimensional model is constructed. An interpretative report is built to display a plurality of customer-related information based on the constructed dimensional model.
-
Citations
20 Claims
-
1. A method for detecting shelfware, the method comprising:
-
receiving a licensing data table and an exported business data table from a business data source, wherein the licensing data table and the exported business data table include a plurality of data fields associated with a plurality of business categories; creating a plurality of dimensions based on a common data attribute among the plurality of data fields; structuring the received licensing data table and the received exported business data table by assigning each data field within the plurality of data fields to a dimension within the created plurality of dimensions; populating a fact table for each of the plurality of business categories with each data field within the plurality of data fields based on each of the plurality of business categories from which each data field originated; merging the populated fact table for each of the plurality of business categories based on a predetermined usefulness of each populated fact table when detecting shelfware; constructing a dimensional model based on the merging the populated fact table for each of the plurality of business categories, the populated fact table for each of the plurality of business categories, and each data field within the structured licensing data table and the structured exported business data table; and building an interpretative report to display a plurality of customer-related information based on the constructed dimensional model. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A computer system for detecting shelfware, the computer system comprising:
-
one or more processors, one or more computer-readable memories, one or more computer-readable tangible storage medium, and program instructions stored on at least one of the one or more tangible storage medium for execution by at least one of the one or more processors via at least one of the one or more memories, wherein the computer system is capable of performing a method comprising; receiving a licensing data table and an exported business data table from a business data source, wherein the licensing data table and the exported business data table include a plurality of data fields associated with a plurality of business categories; creating a plurality of dimensions based on a common data attribute among the plurality of data fields; structuring the received licensing data table and the received exported business data table by assigning each data field within the plurality of data fields to a dimension within the created plurality of dimensions; populating a fact table for each of the plurality of business categories with each data field within the plurality of data fields based on each of the plurality of business categories from which each data field originated; merging the populated fact table for each of the plurality of business categories based on a predetermined usefulness of each populated fact table when detecting shelfware; constructing a dimensional model based on the merging the populated fact table for each of the plurality of business categories, the populated fact table for each of the plurality of business categories, and each data field within the structured licensing data table and the structured exported business data table; and building an interpretative report to display a plurality of customer-related information based on the constructed dimensional model. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. A computer program product for detecting shelfware, the computer program product comprising:
-
one or more computer-readable tangible storage medium and program instructions stored on at least one of the one or more tangible storage medium, the program instructions executable by a processor, the program instructions comprising; program instructions to receive a licensing data table and an exported business data table from a business data source, wherein the licensing data table and the exported business data table include a plurality of data fields associated with a plurality of business categories; program instructions to create a plurality of dimensions based on a common data attribute among the plurality of data fields; program instructions to structure the received licensing data table and the received exported business data table by assigning each data field within the plurality of data fields to a dimension within the created plurality of dimensions; program instructions to populate a fact table for each of the plurality of business categories with each data field within the plurality of data fields based on each of the plurality of business categories from which each data field originated; program instructions to merge the populated fact table for each of the plurality of business categories based on a predetermined usefulness of each populated fact table when detecting shelfware; program instructions to construct a dimensional model based on the merging the populated fact table for each of the plurality of business categories, the populated fact table for each of the plurality of business categories, and each data field within the structured licensing data table and the structured exported business data table; and program instructions to build an interpretative report to display a plurality of customer-related information based on the constructed dimensional model. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification