Patents by Inventor Charles M Bender

Charles M Bender 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).

  • System and method for selecting rows from dimensional databases having temporal dimention
    Patent number: 6233573
    Abstract: A system and method selects rows from a fact table in a dimensional database containing a fact table, a time dimension table and other dimension tables. The other dimension tables each contain rows containing a time invariant attribute to identify an item described by the row, an effective time attribute for the row, and other attributes. If an attribute for an item changes, a new row is added to the dimension table containing the time-invariant attribute for the item and current attributes for the item, without deleting or overwriting any existing rows for that item. Such dimension tables can be selected or used to create other tables using one or more time attributes of the dimension tables. The tables created can be selected or used to create still other tables using one or more time attributes of those tables.
    Type: Grant
    Filed: December 13, 1999
    Date of Patent: May 15, 2001
    Assignee: Amazon.com, Inc.
    Inventors: John Bair, Charles M Bender
  • System and method for selecting rows from dimensional databases
    Patent number: 6003024
    Abstract: A system and method selects rows from a fact table in a dimensional database containing a fact table, a time dimension table and other dimension tables. The other dimension tables each contain rows containing a time invariant attribute to identify an item described by the row, an effective time attribute for the row, and other attributes. If an attribute for an item changes, a new row is added to the dimension table containing the time-invariant attribute for the item and current attributes for the item, without deleting or overwriting any existing rows for that item. Such dimension tables can be selected or used to create other tables using one or more time attributes of the dimension tables. The tables created can be selected or used to create still other tables using one or more time attributes of those tables.
    Type: Grant
    Filed: November 5, 1997
    Date of Patent: December 14, 1999
    Assignee: Amazon. com
    Inventors: John Bair, Charles M Bender