Numerify, Inc.

Aravind Sridharan

Rahul Kapoor

Gaurav Rewari

Florian Schouten

Renu Chintalapati

Srinivas M Vedagiri

Ravishankar Muniasamy

David Shenk

Sadanand Sahasrabudhe

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

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.

Automated refinement and validation of data warehouse star schemas

Growing community of inventors

San Jose, CA, United States of America

Aravind Sridharan