Patents by Inventor Frederick J. Levine

Frederick J. Levine 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, method, and data structure for automatically generating database queries which are data model independent and cardinality independent
    Patent number: 9135296
    Abstract: Systems and methods are provided for performing a query in a distributed system. In one example, a query generation system receives an identification of data item components and associations between the data item components, wherein the data item components include a measure and a category, and wherein the identified association indicates that the measure is independent of another data item component, indicates that the measure is dependent on another data item component, or indicates that two or more data item components are correlated.
    Type: Grant
    Filed: July 29, 2014
    Date of Patent: September 15, 2015
    Assignee: SAS Institute Inc.
    Inventors: Thomas P. Weber, Frederick J. Levine, James P. Kelley
  • System, Method, and Data Structure for Automatically Generating Database Queries Which Are Data Model Independent and Cardinality Independent
    Publication number: 20150019535
    Abstract: Systems and methods are provided for performing a query in a distributed system. In one example, a query generation system receives an identification of data item components and associations between the data item components, wherein the data item components include a measure and a category, and wherein the identified association indicates that the measure is independent of another data item component, indicates that the measure is dependent on another data item component, or indicates that two or more data item components are correlated.
    Type: Application
    Filed: July 29, 2014
    Publication date: January 15, 2015
    Inventors: Thomas P. Weber, Frederick J. Levine, James P. Kelley
  • System, method, and data structure for automatically generating database queries which are data model independent and cardinality independent
    Patent number: 8825633
    Abstract: Systems and methods are provided for performing a database query. After receiving an identification of data item components and associations between the data item components, wherein the data item components include a measure and a category, a query generation system creates and executes a database query that comprises one or more Uqueries, wherein each Uquery comprises a Mx segment subquery and a U0 segment subquery. The Mx segment subquery is associated with a table that contains the measure, a table that contains columns for a calculated measure, or a correlated table, and the U0 segment subquery is associated with a table that contains the category, a table that contains columns for a calculated category, a dependent measure table, or a dependent filter table. The query generation system can generate a virtual results table by aggregating Uquery results from one Uquery with Uquery results from another Uquery.
    Type: Grant
    Filed: May 15, 2012
    Date of Patent: September 2, 2014
    Assignee: SAS Institute Inc.
    Inventors: Thomas P. Weber, Frederick J. Levine, James P. Kelley
  • System, Method, and Data Structure for Automatically Generating Database Queries which are Data Model Independent and Cardinality Independent
    Publication number: 20130311442
    Abstract: Systems and methods are provided for performing a database query. After receiving an identification of data item components and associations between the data item components, wherein the data item components include a measure and a category, a query generation system creates and executes a database query that comprises one or more Uqueries, wherein each Uquery comprises a Mx segment subquery and a U0 segment subquery. The Mx segment subquery is associated with a table that contains the measure, a table that contains columns for a calculated measure, or a correlated table, and the U0 segment subquery is associated with a table that contains the category, a table that contains columns for a calculated category, a dependent measure table, or a dependent filter table. The query generation system can generate a virtual results table by aggregating Uquery results from one Uquery with Uquery results from another Uquery.
    Type: Application
    Filed: May 15, 2012
    Publication date: November 21, 2013
    Inventors: Thomas P. Weber, Frederick J. Levine, James P. Kelley
  • Computer-implemented system and method for handling database statements
    Patent number: 7447686
    Abstract: A computer-implemented system and method for handling a database statement from a first database system. The database statement is formatted according to a language format used by the first database system. Database language difference data is accessed so that a database specific statement may be generated which is operational within a different type of database system.
    Type: Grant
    Filed: November 22, 2002
    Date of Patent: November 4, 2008
    Assignee: SAS Institute Inc.
    Inventor: Frederick J. Levine
  • Computer-implemented system and method for handling database statements
    Publication number: 20040103100
    Abstract: A computer-implemented system and method for handling a database statement from a first database system. The database statement is formatted according to a language format used by the first database system. Database language difference data is accessed so that a database specific statement may be generated which is operational within a different type of database system.
    Type: Application
    Filed: November 22, 2002
    Publication date: May 27, 2004
    Inventor: Frederick J. Levine