Numerify, Inc.

Florian Schouten

Rahul Kapoor

Gaurav Rewari

Aravind Sridharan

Renu Chintalapati

David Shenk

Srinivas M Vedagiri

Ravishankar Muniasamy

Sadanand Sahasrabudhe

Ryan O'Shea

Approaches for integrating an operational reporting system with a warehouse based reporting system. The operational reporting system and the warehouse based reporting system may be offered and supported by different vendors, and so may be deployed in different clouds or as separate product installations in case of on-premise software, or these systems may be offered and supported by a single vendor, and so may be deployed in the same cloud or as part of a common product installation in case of on-premise software. The integrated system uses a common or consistent dimensional model to link related measures of the operational reporting system and the warehouse based reporting system, which allows for analysis of real time content with historical and cross subject perspective provided alongside in the same interface. The integration also facilitates trend analysis and predictive analytics in real time.

Warehouse based reporting and operational reporting integration

Automatically determining time threshold guarantees for metrics like completion time or first response time for tasks or items. A system relies on the historical tasks data with completion or first response times. The system plots a graphical representation between completion time and a percentage of tasks completed and uses sophisticated analysis of slopes at different points of the graphical representation to determine time threshold guarantees below a specified maximum completion or first response time threshold, and above a specified minimum percentage of completion. The system also compensates for a variety of factors which may be changed from the time historical data was obtained to the present time for which time threshold guarantees are being determined. In absence of historical customer data, the system makes the recommendations based on available datasets of peer customers.

System and method for determining a time threshold guarantee of a task for updating in a penalty clause of a service level agreement

An automated system for defining a star schema for a data source. The system based on automatically gathered information from the data source such as entities and columns, entity column types and lengths, entity keys, relationships between and within entities, measures, workflow and correlated attributes, specialized entities, an update frequency of entities and columns, and grouping of entity and column updates associated with the source database automatically determines facts, dimensions, dimension hierarchies, measures, workflow specific measures (if data source has workflows) and workflow correlated attribute specific measures (if data source has temporal, priority, ownership and progress tracking attributes) to come up with a star schema for the data source.

Automated definition of data warehouse star schemas

An automated system for validating and refining a template warehouse star schema for a customized data source. The system based on automatically gathered information from the data source such as custom entities and constituent columns, data type and length of custom columns, custom entity keys, relationships of custom entities with other entities, relationships within custom entities, contribution of custom entities to specialized entities, update frequency of custom entities and columns including grouping of updates, frequently used expressions on custom columns and contribution of custom entities and columns to workflow and correlated attributes automatically determines facts, dimensions, dimension hierarchies, measures, workflow specific measures (if data source has workflows) and workflow correlated attribute specific measures (if data source has temporal, priority, ownership and progress tracking workflow correlated attributes) to validate and refine the star schema of the template warehouse to accommodate customizations of the data source.

Growing community of inventors

Wayland, MA, United States of America

Florian Schouten