Patents by Inventor Allan Michael Gonsalves

Allan Michael Gonsalves has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • DATA WAREHOUSE WITH CLOUD FACT TABLE
    Publication number: 20140244573
    Abstract: A data warehouse includes plurality of master data tables, a plurality of dimension tables and a fact table. The master data tables including surrogate identifiers. The dimension tables use the surrogate identifiers to link to the master data table domains within the master data tables. The fact table stores dimension identifiers that provide links to the master data tables. A cloud storage area includes a plurality of cloud dimension tables and a cloud fact table. Each cloud dimension table stores summary characteristics. Each cloud dimension table associates a separate cloud identifier with each entry of summary characteristics. The cloud fact table stores aggregated data representing key performance indicators. The cloud fact table includes a plurality of cloud identifier columns in which cloud identifiers are stored.
    Type: Application
    Filed: January 2, 2014
    Publication date: August 28, 2014
    Inventor: Allan Michael Gonsalves
  • Smart key access and utilization to optimize data warehouse performance
    Patent number: 8793268
    Abstract: In a data warehouse, a master table includes surrogate identifiers. Each surrogate identifier (SID) uniquely identifies a master table domain within the master table. A dimension table uses the surrogate identifiers to link to the master table domains. A SID generator uses first data supplied in a user query to generate a first SID indicating location of a particular master table domain in the master table. The SID generator generates the first SID without accessing the master table.
    Type: Grant
    Filed: July 1, 2010
    Date of Patent: July 29, 2014
    Inventor: Allan Michael Gonsalves
  • Data warehouse with a domain fact table
    Patent number: 8311975
    Abstract: A data warehouse includes a plurality of master data tables. The master data tables include surrogate identifiers. Each surrogate identifier (SID) identifies a master data table domain inside a master data table from the plurality of master data tables. A plurality of dimension tables use the surrogate identifiers to link to the master data table domains within the master data tables. A fact table stores dimension identifiers (DIM IDs) that provide links to the dimension tables. A domain fact table stores aggregated data aggregated from data stored in the master data tables. The aggregated data is accessible from the domain fact table using surrogate identifiers, without using DIM IDs stored in the fact table.
    Type: Grant
    Filed: February 28, 2011
    Date of Patent: November 13, 2012
    Inventor: Allan Michael Gonsalves