Patent Document ID: 10095766
Application ID: 14921982

Base Claim:
1. An automated data warehouse star schema system that automatically refines a template warehouse star schema for a source database, the automated data warehouse schema system comprising: a non-transitory storage device having embodied therein one or more routines operable to automatically refine the template warehouse star schema for the source database; and one or more processors coupled to the non-transitory storage device and operable to execute the one or more routines, wherein the one or more routines include: an input gathering module, which when executed by the one or more processors, automatically compares a customized source database with a baseline template warehouse to gather a custom information comprising i) a data type or a length of custom columns, ii) frequently used expressions on custom columns, iii) custom entities or information on constituent columns of the custom entities, iv) custom entity keys, v) relationships of custom entities with other entities, vi) relationships within custom entities, vii) a contribution of custom entities to specialized entities, viii) an update frequency of custom entities and columns, ix) a grouping of custom entity and column updates, and x) a contribution of custom entities and columns to workflows and correlated attributes, wherein the custom information is gathered based on a combination of a usage analysis technique by automatically analyzing queries on the custom source database, a data profiling technique by automatically analyzing data in the custom source database and an operational reporting environment analysis technique by automatically analyzing an underlying model and queries in operational reports; a fact determining module, which when executed by the one or more processors, automatically determines facts by determining frequently updated numeric non key custom columns and the custom entities; a dimension determining module, which when executed by the one or more processors, automatically determines dimensions by determining non-numeric custom columns and the custom entities that are infrequently updated and that are linked to the facts by foreign keys; and an automated star schema refinement module, which when executed by the one or more processors, automatically suggests at least one of (i) subsumption of a custom entity into an entity of the template warehouse star schema based on a type of mapped target of related entities, a column type of the custom entity or an update frequency of the custom entity if the custom entity is related to the entity of the template warehouse star schema, (ii) creation of new facts or dimensions for the custom entity based on a column type of the custom entity or an update frequency of the custom entity if the custom entity is a standalone entity, or (iii) creation of specialized entities or augmentation of specialized entities in the template warehouse star schema if the custom entity is related to a currency or a unit of measure to refine a template warehouse star schema for the source database.

---

Claim 7:
7. The automated data warehouse star schema system of claim 1 , wherein data in the custom source database is analyzed automatically to determine any of (i) custom entities and custom columns, (ii) if the custom columns are entity keys (iii) if the custom columns contribute to relationships between and within entities, (iv) if the custom columns contribute to workflows, or (v) if the custom columns or custom entities contribute to specialized entities.