Carlos F Ordonez

Address:

8614 Greiner Dr, Houston, TX 77080

VIN:

WAUAF78E47A072056

Make:

AUDI

Model:

A4

Year:

2007

US Patent:

20070239669, Oct 11, 2007

Filed:

Apr 5, 2007

Appl. No.:

11/696887

Inventors:

Carlos Ordonez - Houston TX, US
Michael Rote - San Diego CA, US

International Classification:

G06F 17/30

US Classification:

707002000

Abstract:

System and method for translating statements and expressions within statistical language programs into SQL. These statements include one or more input statements and have a plurality of data rows. These statements include one or more array statements, the array statements having a set of original variables. The method for translating statements and expressions within statistical language programs into SQL includes the step of defining a select statement including a subset of the original variables. The expressions include one or more assignment expressions, the assignment expressions including a set of original variables and a set of new variables affected by the assignment expressions.

US Patent:

20070239691, Oct 11, 2007

Filed:

Apr 5, 2007

Appl. No.:

11/696859

Inventors:

Carlos Ordonez - Houston TX, US
Michael Rote - San Diego CA, US

International Classification:

G06F 17/30

US Classification:

707003000

Abstract:

A system and method of evaluating an SQL recursive query having one or more base select statements and one or more recursive select statements. In one technique the query relates to a base table and has a filter condition on one or more columns from a result table returned by the query. The technique includes the steps of receiving the query to be evaluated, evaluating a base step by evaluating one or more of the base select statements, evaluating one or more recursive steps by evaluating one or more of the recursive select statements, evaluating the filter condition prior to evaluating any of the recursive steps, and returning the result of the query.