Patents by Inventor Henry Scanzano

Henry Scanzano 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).

  • Database systems, methods and computer program products using type based selective foreign key association to represent multiple but exclusive relationships in relational databases
    Patent number: 7693845
    Abstract: Database systems, methods and/or computer program products provide for multiple but exclusive relationships between tables in a relational database. The multiple but exclusive relationship may be enforced based on a type associated with a record in a relating table. The multiple but exclusive relationship may be a one-to-many or a many-to-many relationship. A foreign key value of a record in a relating table may be selectively associated with a specific one of a plurality of related tables based on at least one attribute of the record containing the foreign key in the relating table. In particular embodiments of the present invention, the foreign key values of a record in the relating table are selectively associated with one of the plurality of related tables by defining a foreign key of records of the relating table and defining a plurality of types of foreign key associations, each of the types corresponding to a respective one of the plurality of related tables.
    Type: Grant
    Filed: August 29, 2001
    Date of Patent: April 6, 2010
    Assignee: NetTraffic, Inc.
    Inventors: Henry Scanzano, Lin Yu, Alaaeldin A. Aly, Sameh Yamany
  • Database systems, methods and computer program products using type based selective foreign key association to represent multiple but exclusive relationships in relational databases
    Publication number: 20030046272
    Abstract: Database systems, methods and/or computer program products provide for multiple but exclusive relationships between tables in a relational database. The multiple but exclusive relationship may be enforced based on a type associated with a record in a relating table. The multiple but exclusive relationship may be a one-to-many or a many-to-many relationship. A foreign key value of a record in a relating table may be selectively associated with a specific one of a plurality of related tables based on at least one attribute of the record containing the foreign key in the relating table. In particular embodiments of the present invention, the foreign key values of a record in the relating table are selectively associated with one of the plurality of related tables by defining a foreign key of records of the relating table and defining a plurality of types of foreign key associations, each of the types corresponding to a respective one of the plurality of related tables.
    Type: Application
    Filed: August 29, 2001
    Publication date: March 6, 2003
    Inventors: Henry Scanzano, Lin Yu, Alaaeldin A. Aly, Sameh Yamany