Richard Martin Langston

US Patent:

8498996, Jul 30, 2013

Filed:

Nov 3, 2008

Appl. No.:

12/263760

Inventors:

Michael Stephen Whitcher - Apex NC, US
Richard Dean Langston - Cary NC, US
Howard Plemmons, Jr. - Apex NC, US

Assignee:

SAS Institute Inc. - Cary NC

International Classification:

G06F 7/00
G06F 17/30

US Classification:

707759, 707769

Abstract:

A computer-implemented method and system allows generating a query and a first fourth generation language at a native system to a non-native database which is capable of processing queries in a second fourth generation language. A query initiated by a client applicant in a first fourth generation language is analyzed to determine if it can be processed by a non-native system capable of processing queries in a second fourth generation language. Non-standard syntax representative of a function and the query that cannot be evaluated by the non-native database system is identified. If the syntax is discovered, the query is transformed through the use of formats or through an algorithm process into an equivalent query expression that can be processed by the database system.