International Business Machines Corporation

Informatica Corporation

Jivox Corporation

Diaz Nesamoney

Jameison Bear Martin

Weipeng Paul Yan

Fayyaz Ahmad Younas

Maurice Mate Radalj

Sanjeev K Gupta

Mohan Sankaran

Sankaran Suresh

Nasrollah Jazayeri

Vaikom B Krishnan

M S Zamanian

Parth S Chandra

Martin Lewis Handwerker

Girish Pancha

Pinaki Mukhopadhyay

Sanjay Dahiya

Jeffrey B Taylor

Mon Wong

Kiumarse Zamanian

An intent score is assigned to users who are viewing online ads. Users define a bid-range and adjust pricing within the range at an individual user level, based on an intent score that is derived from user activity. An advertiser typically defines a bid range. If the user then interacts with ads or visits the advertiser's website then, based on user actions, the bid price is revised. This process of bid price revision is continuous and results in increased or decreased bid prices for individual users. All participating users and their intent scores are periodically uploaded to RTB platforms where they are used to purchase ad impressions. This increases the likelihood of winning bids for more valuable users with better precision without raising bid prices for entire segments of users.

Scoring users based on intent for online advertising

An advertising system delivers video ads into hypertext documents, where these ads provide enhanced user interactivity features selected and configured by advertisers or other ad sponsors. The system also provides sophisticated tracking and real time reporting of viewer interactivity with the video ads and their enhanced features.

Method and apparatus to deliver video advertisements with enhanced user interactivity

A method for providing a real time view of heterogeneous enterprise data of operational systems includes capturing streams of operational events in real time, combining the events with contextual data, and materializing a resulting view. The resulting view includes a dynamically defined view of the stream of events and provides visibility into a current state of the operational system. A view snapshot is continuously incrementally updated by a view maintenance engine as a stream of rows. The views are used to evaluate a business rule. An alert is fired when a business rule holds true. To enable the view in a view engine, a SQL string characterizing the view is parsed into a parse tree, which is normalized to form a query graph. The query graph is then optimized to obtain a query plan, which is compiled into an operator graph. Queries are executed based upon the operator graph.

Method for providing a real time view of heterogeneous enterprise data

A method for performing real-time analytics using a business rules engine on real time heterogeneous materialized data views is disclosed. The method comprises processing of rows produced by views corresponding to events. The rows are processed according to business rules by a view engine. Views with conditions equivalent to rule conditions are subscribed to by a rule engine, which outputs action messages corresponding to the rule condition. Where the rule condition is satisfied, a statement to that effect is sent, with any available reportlets, to an alert engine. The alert engine handles alert states corresponding to the action statement, saves any corresponding reportlets, and generates a message to fire an alert to a notification engine. The notification engine formats the alert and sends the alert by a selected medium, such as email, a webservice call, or another network protocol.

Method for performing real-time analytics using a business rules engine on real-time heterogeneous materialized data views

A transformation description language (TDL) for specifying how data is to be manipulated in a data warehousing application. The TDL is comprised of a source for storing raw data, one or more transformation objects for processing the raw data according to predefined instructions, and a target for storing the processed data. A mapping is used for directing the data flow between the I/O ports corresponding to the source, the plurality of transformation objects, and the target. The mapping specifies the connectivity between the source, transformation, and target objects as well as the order of these connections. There are a number of different transformations which can be performed to manipulate the data. Some such transformations include: an aggregator transformation, an expression transformation, a filter transformation, a lookup transformation, a query transformation, a sequence transformation, a stored procedure transformation, and an update strategy transformation.

Apparatus and method for performing data transformations in data warehousing

A method and system for accessing and sharing metadata amongst a number of data marts through the use of object referencing. A global repository is created. Shared folders containing metadata is contained in the global repository. Any number of data marts can be linked to the global repository. Stored within the folders of the linked data marts are references pointing to certain metadata stored in the shared folders of the global repository. Multiple data marts can reference the same metadata in the global repository. Thereby, the same metadata can be accessed, used, and shared by multiple users across different data marts, provided that they have been granted the proper authority. New metadata can be promoted from a linked data mart into the global repository so that it can be shared, and updates to shared metadata can be automatically propagated to all users referencing that metadata.

Method and apparatus for sharing metadata between multiple data marts

A method for updating a target table of a data mart in response to changes made by a transaction to data stored in a source table of an operational database. Data that was changed in the source table by the transaction is stored in a dynamic image table of a change capture database. Data that was not changed in the source table by the transaction, but which is nevertheless required to be mapped to the target table, is stored in a static image table of the change capture database. The change capture database also contains relevant information regarding the transaction. Once the dynamic and static image tables are properly staged, the changes are propagated from the change capture database to the target tables of the data marts. In other words, data is extracted from the change capture database and subsequently transformed and loaded, thereby minimizing the impact to the operational database. Thereupon, the tables of the change capture database are truncated to discard data which is now no longer needed.

Apparatus and method for capturing and propagating changes from an

Apparatus and method for performing data transformations in data

A method of performing incremental aggregation of dynamically increasing database data sets. An embodiment of the present invention operates within a data mart or data warehouse to aggregate data stored within an operational database corresponding to newly received data to provide current information. Initially, a computer server creates an intermediate file which is initialized by the server with an aggregate data set. The aggregate data set consists of data values and count values that each correspond to specific group identifiers. The computer determines if any group identifiers within a new set of inputs data are identical to any group identifiers stored within the intermediate file. If an inputted group identifier matches a stored group identifier, the inputted data value is aggregated with the stored data value and the count value corresponding to the specific stored group identifier is incremented by one. If an inputted group identifier does not match any of the stored group identifiers, the inputted group identifier and corresponding data value are stored within the intermediate file and a count value of one is appended to that specific group identifier. Once all the group identifiers within the new set of input data have been determined, the computer stores all the changes that were made to the intermediate file into the aggregate data set.

Growing community of inventors

Atherton, CA, United States of America

Diaz Nesamoney