Abstract: In embodiments, systems and methods may involve using a platform as disclosed herein for applications described herein where the systems and methods involve receiving a dataset in an analytic platform, the dataset including fact data and dimension data for a plurality of distinct product categories. It may also involve storing the data in a flexible hierarchy, the hierarchy allowing the temporary fixing of data along a dimension and flexible querying along other dimensions of the data. It may also involve pre-aggregating certain combinations of data to facilitate rapid querying, the pre-aggregation based on the nature of common queries. It may also involve facilitating the presentation of a cross-category view of an analytic query of the dataset. In embodiments, the temporarily fixed dimension can be rendered flexible upon an action by the user.

Abstract: In embodiments of the present invention, a method is described for reducing bias by data fusion of a household panel data and a loyalty card data. In embodiments, a method is provided for receiving a consumer panel dataset in a data fusion facility, receiving a consumer point-of-sale dataset in a data fusion facility, receiving a dimension dataset in a data fusion facility, fusing the datasets received in the data fusion facility into a new panel dataset based at least in part on an encryption key, estimating a consumer behavior using a first model based on the consumer panel dataset, estimating a consumer behavior using a second model based only on those consumers present in both the consumer panel dataset and the consumer point-of-sale dataset, and refining the first model based at least on the results of the second model.

Abstract: A technique for context-dependent annotations to database views may include receiving a query including a data selection criterion for retrieving data from a commercial data store, identifying a first view containing a first data set based on the query, displaying a result from the query to a user, and receiving annotation content from the user linked to data in the first view including view-related information to reconstruct the result as displayed to the user when the annotation content was received. The technique may also include receiving a query for a second view of the commercial data from a second user, where the second view includes at least a portion of the first data set, and presenting the second view of the commercial data to the second user, together with any of the annotation content associated with the portion of the first data set included in the second view.

Abstract: A product database describing products and attributes associated with the products is identified. Some attributes have values including words. A dictionary including the words is identified. The dictionary is partitioned into synonym classes of words. A representative word from the dictionary is selected. Replacement rules are identified, each of which replace a target word with the target word's corresponding representative. For each product in the database, the replacement rules are applied to produce a standardized product database.

Abstract: A base hierarchy of products or the like can be user-modified into a virtual hierarchy that is represented as a collection of changes to the base hierarchy rather than a new hierarchy stored in memory. The collection of changes can be used to enable user interactions such as queries, displays, and writes using the virtual hierarchy as thought it were an actual hierarchy stored in memory, with aspects of the virtual hierarchy dynamically created using a collection of procedures based on the changes and corresponding inverses. The representation of the modified hierarchy can be dynamically displayed to a user or otherwise processed in the same manner as other hierarchies and hierarchical data.

Abstract: A base hierarchy of products or the like can be user-modified into a virtual hierarchy that is represented as a collection of changes to the base hierarchy rather than a new hierarchy stored in memory. The collection of changes can be used to enable user interactions such as queries, displays, and writes using the virtual hierarchy as thought it were an actual hierarchy stored in memory, with aspects of the virtual hierarchy dynamically created using a collection of procedures based on the changes and corresponding inverses. The representation of the modified hierarchy can be dynamically displayed to a user or otherwise processed in the same manner as other hierarchies and hierarchical data.

Abstract: Disclosed herein are user interfaces and related systems and methods for selecting hierarchically arranged items in order to facilitate subsequent operations on an accumulation of such data selected from throughout a hierarchy. More specifically, a columnized user interface is disclosed that includes a final column containing an accumulation of items selected from various locations within the hierarchy. A user may interactively navigate throughout the hierarchy in one or more other columns, while selectively adding specific items from any such hierarchical locations in the final column for subsequent processing. Other tools may support grouping into favorites, recall of previous selections, or other operations to facilitate rapid creation and recreation of item groups for processing.

Abstract: Using a computer, a database comprising a field is identified. A query relating to the field is identified. Prior to processing the query, the field is dynamically altered to conform to a desired bit size. The query is processed. The results of the query are returned.

Abstract: Systems and methods are presented that may involve receiving a causal fact dataset including facts relating to items perceived to cause actions, wherein the causal fact dataset includes a data attribute that is associated with a causal fact datum. It may also involve pre-aggregating a plurality of the combinations of a plurality of causal fact data and associated data attributes in a causal bitmap. It may also involve selecting a subset of the pre-aggregated combinations based on suitability of a combination for the analytic purpose. It may also involve storing the subset of pre-aggregated combinations to facilitate querying of the subset.

Abstract: A first view of commercial data is presented to a first user. A data selection criterion is received from the user. A first data set is identified based on the selection criterion. Annotation content is received from the user. The annotation content and the first view of the commercial data is associated with the first data set. A query is received for a second view from a second user, in which the second view includes at least a portion of the first data set. The second view is presented to the second user, together with the annotations associated with the portion of the first data set included in the second view.

Abstract: In embodiments of the present invention improved capabilities are described for identifying a first classification scheme associated with product attributes of a first grouping of products, identifying a second classification scheme associated with product attributes of a second grouping of products, and receiving a record of data relating to an item, the classification of which is uncertain. It may also involve receiving a dictionary of attributes associated with products and assigning the item to at least one of the classification schemes based on probabilistic matching among the attributes in the classification schemes, the attributes in the dictionary of attributes and the known attributes of the item.

Abstract: A base hierarchy of products or the like can be user-modified into a virtual hierarchy that is represented as a collection of changes to the base hierarchy rather than a new hierarchy stored in memory. The collection of changes can be used to enable user interactions such as queries, displays, and writes using the virtual hierarchy as thought it were an actual hierarchy stored in memory, with aspects of the virtual hierarchy dynamically created using a collection of procedures based on the changes and corresponding inverses. The representation of the modified hierarchy can be dynamically displayed to a user or otherwise processed in the same manner as other hierarchies and hierarchical data.

Abstract: A base hierarchy of products or the like can be user-modified into a virtual hierarchy that is represented as a collection of changes to the base hierarchy rather than a new hierarchy stored in memory. The collection of changes can be used to enable user interactions such as queries, displays, and writes using the virtual hierarchy as thought it were an actual hierarchy stored in memory, with aspects of the virtual hierarchy dynamically created using a collection of procedures based on the changes and corresponding inverses. The representation of the modified hierarchy can be dynamically displayed to a user or otherwise processed in the same manner as other hierarchies and hierarchical data.

Abstract: Disclosed herein are techniques for identifying customers and their purchasing segments in advance so that advertising impressions can be correlated to the consumers that are being reached by an advertising campaign. A predetermined consumer panel may be characterized by purchasing segment and any other suitable demographics, and tracking techniques such as cookies tied to specific web properties may be used to track online activity by members of the consumer panel. In this manner, each advertising impression for one of the panel members from one of the web properties can be related to a particular purchasing segment, and effectiveness of the campaign can be evaluated based on the types of consumers that are being reached with certain advertisements.

Abstract: Disclosed herein are user interfaces and related systems and methods for selecting hierarchically arranged items in order to facilitate subsequent operations on an accumulation of such data selected from throughout a hierarchy. More specifically, a columnized user interface is disclosed that includes a final column containing an accumulation of items selected from various locations within the hierarchy. A user may interactively navigate throughout the hierarchy in one or more other columns, while selectively adding specific items from any such hierarchical locations in the final column for subsequent processing. Other tools may support grouping into favorites, recall of previous selections, or other operations to facilitate rapid creation and recreation of item groups for processing.

Abstract: Uncorrelated data from a variety of sources, such as consumer panels or retailer points of sale, are combined with maximal coverage of a universal data set for a population in a manner that permits useful inferences about behavioral propensities for the population at an individual or household level.

Abstract: In embodiments of the present invention, improved capabilities are described for perturbing non-unique values may comprise finding the non-unique values in a data table, perturbing the non-unique values to render unique values, and using the non-unique values as an identifier for a data item.

Abstract: In embodiments of the present invention, improved capabilities are described for perturbing non-unique values may comprise finding the non-unique values in a data table, perturbing the non-unique values to render unique values, and using the non-unique values as an identifier for a data item.

Abstract: Uncorrelated data from a variety of sources, such as consumer panels or retailer points of sale, are combined with maximal coverage of a universal data set for a population in a manner that permits useful inferences about behaviorial propensities for the population at an individual or household level.

Abstract: In embodiments of the present invention, improved capabilities are described for perturbing non-unique values may comprise finding the non-unique values in a data table, perturbing the non-unique values to render unique values, and using the non-unique values as an identifier for a data item.