Patents by Inventor Ariel Fernandez Ortega

Ariel Fernandez Ortega 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).

  • Compensating for unbalanced hierarchies when generating OLAP queries from report specifications
    Patent number: 9189535
    Abstract: Systems, methods and articles of manufacture are disclosed for generating an online analytical processing (OLAP) query against a cube. The cube may have dimensions, each dimension having a hierarchy of members. A report specification may be received against a hierarchy of the cube. An OLAP query may be generated from the report specification. The OLAP query may include projected members not having any descendant at the detail level of the hierarchy, thus producing more accurate results.
    Type: Grant
    Filed: December 1, 2009
    Date of Patent: November 17, 2015
    Assignee: International Business Machines Corporation
    Inventor: Ariel Fernandez Ortega
  • Query metadata engine
    Patent number: 8655861
    Abstract: In one example, a method comprises receiving, with a data access service, an input query from an enterprise software application, wherein the data access service is positioned between the enterprise software application and a multidimensional data source; parsing the input query into a parse tree; generating an abstract syntax tree based on the parse tree, the abstract syntax tree comprising input query elements and multidimensional expression query elements based on the input query; performing an evaluation of metadata comprised in the multidimensional expression query elements of the abstract syntax tree; restructuring the abstract syntax tree based on the evaluation of the metadata; executing a query based on the restructured abstract syntax tree on the multidimensional data source; and retrieving a query result set from the multidimensional data source comprising results that are responsive to the query based on the restructured abstract syntax tree.
    Type: Grant
    Filed: July 10, 2012
    Date of Patent: February 18, 2014
    Assignee: International Business Machines Corporation
    Inventors: Patrick Burke, Stanley L. Chauvin, David C. Cummings, Ariel Fernandez Ortega
  • Compensating for unbalanced hierarchies when generating OLAP queries from report specifications
    Patent number: 8484157
    Abstract: Systems, methods and articles of manufacture are disclosed for generating an online analytical processing (OLAP) query against a cube. The cube may have dimensions, each dimension having a hierarchy of members. A report specification may be received against a hierarchy of the cube. An OLAP query may be generated from the report specification. The OLAP query may include projected members not having any descendant at the detail level of the hierarchy, thus producing more accurate results.
    Type: Grant
    Filed: September 15, 2012
    Date of Patent: July 9, 2013
    Assignee: International Business Machines Corporation
    Inventor: Ariel Fernandez Ortega
  • QUERY METADATA ENGINE
    Publication number: 20130097114
    Abstract: In one example, a method comprises receiving, with a data access service, an input query from an enterprise software application, wherein the data access service is positioned between the enterprise software application and a multidimensional data source; parsing the input query into a parse tree; generating an abstract syntax tree based on the parse tree, the abstract syntax tree comprising input query elements and multidimensional expression query elements based on the input query; performing an evaluation of metadata comprised in the multidimensional expression query elements of the abstract syntax tree; restructuring the abstract syntax tree based on the evaluation of the metadata; executing a query based on the restructured abstract syntax tree on the multidimensional data source; and retrieving a query result set from the multidimensional data source comprising results that are responsive to the query based on the restructured abstract syntax tree.
    Type: Application
    Filed: July 10, 2012
    Publication date: April 18, 2013
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Patrick Burke, Stanley L. Chauvin, David C. Cummings, Ariel Fernandez Ortega
  • Query metadata engine
    Patent number: 8359305
    Abstract: In one example, a method comprises receiving, with a data access service, an input query from an enterprise software application, wherein the data access service is positioned between the enterprise software application and a multidimensional data source; parsing the input query into a parse tree; generating an abstract syntax tree based on the parse tree, the abstract syntax tree comprising input query elements and multidimensional expression query elements based on the input query; performing an evaluation of metadata comprised in the multidimensional expression query elements of the abstract syntax tree; restructuring the abstract syntax tree based on the evaluation of the metadata; executing a query based on the restructured abstract syntax tree on the multidimensional data source; and retrieving a query result set from the multidimensional data source comprising results that are responsive to the query based on the restructured abstract syntax tree.
    Type: Grant
    Filed: October 18, 2011
    Date of Patent: January 22, 2013
    Assignee: International Business Machines Corporation
    Inventors: Patrick Burke, Stanley L. Chauvin, David C. Cummings, Ariel Fernandez Ortega
  • COMPENSATING FOR UNBALANCED HIERARCHIES WHEN GENERATING OLAP QUERIES FROM REPORT SPECIFICATIONS
    Publication number: 20130013554
    Abstract: Systems, methods and articles of manufacture are disclosed for generating an online analytical processing (OLAP) query against a cube. The cube may have dimensions, each dimension having a hierarchy of members. A report specification may be received against a hierarchy of the cube. An OLAP query may be generated from the report specification. The OLAP query may include projected members not having any descendant at the detail level of the hierarchy, thus producing more accurate results.
    Type: Application
    Filed: September 15, 2012
    Publication date: January 10, 2013
    Applicant: International Business Machines Corporation
    Inventor: Ariel Fernandez Ortega
  • COMPENSATING FOR UNBALANCED HIERARCHIES WHEN GENERATING OLAP QUERIES FROM REPORT SPECIFICATIONS
    Publication number: 20110131173
    Abstract: Systems, methods and articles of manufacture are disclosed for generating an online analytical processing (OLAP) query against a cube. The cube may have dimensions, each dimension having a hierarchy of members. A report specification may be received against a hierarchy of the cube. An OLAP query may be generated from the report specification. The OLAP query may include projected members not having any descendant at the detail level of the hierarchy, thus producing more accurate results.
    Type: Application
    Filed: December 1, 2009
    Publication date: June 2, 2011
    Applicant: INTERNATION BUSINESS MACHINES CORPORATION
    Inventor: ARIEL FERNANDEZ ORTEGA