Patents by Inventor Harvard Jun-Hua Pan

Harvard Jun-Hua Pan 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).

  • Generation of star schemas from snowflake schemas containing a large number of dimensions
    Patent number: 8543535
    Abstract: An aspect of the present invention simplifies generating a star schema from a snowflake schema. In an embodiment, a user first specifies fact tables to be included in a star schema, and a synchronization tool inspects the snowflake schema to determine the dimension tables linked to the specified fact tables. The determined dimension tables are included in the star schema sought to be generated.
    Type: Grant
    Filed: February 24, 2010
    Date of Patent: September 24, 2013
    Assignee: Oracle International Corporation
    Inventors: Samir Satpathy, Alextair Dominico Mascarenhas, Harvard Jun-Hua Pan, Kenneth Khiaw Hong Eng, Ladislav Kovac
  • GENERATION OF STAR SCHEMAS FROM SNOWFLAKE SCHEMAS CONTAINING A LARGE NUMBER OF DIMENSIONS
    Publication number: 20110208692
    Abstract: An aspect of the present invention simplifies generating a star schema from a snowflake schema. In an embodiment, a user first specifies fact tables to be included in a star schema, and a synchronization tool inspects the snowflake schema to determine the dimension tables linked to the specified fact tables. The determined dimension tables are included in the star schema sought to be generated.
    Type: Application
    Filed: February 24, 2010
    Publication date: August 25, 2011
    Applicant: Oracle International Corporation
    Inventors: Samir Satpathy, Alextair Dominico Mascarenhas, Harvard Jun-Hua Pan, Kenneth Khiaw Hong Eng, Ladislav Kovac