OVERLOADING R LANGUAGE CONSTRUCTS WITH DATABASE ENGINE CONSTRUCTS

• US 20130262520A1
• Filed: 03/29/2012
• Published: 10/03/2013
• Est. Priority Date: 03/29/2012
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: MUKHIN, Denis B., Aboyoun, Patrick, Sashikanth, Vaishnavi
• Granted Patent: US 9,418,082 B2
• Time in Patent Office: Days
• US Class Current: 707/802
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

A method, system, and computer program product for interfacing an R language client with a separate database engine environment. The method commences by interpreting an R language code fragment to identify and select R language constructs and transforming the R language constructs into queries or other database language constructs to execute within the database engine environment. The method further implements techniques for transmitting marshaled results (resulting from the execution of the database language constructs) back to the R client environment. In some situations, the marshaled results include an XML schema or DTD or another metadata description of the structure of the results. User conveniences in the form of transparent database query construction, and transparent exploitation of parallelism is achieved by determining the computation resource requirements of executable language constructs, and mapping the execution to one (or more) of, a local R client, a database engine, or a remote execution engine.

Claims

1. A computer implemented method for transparently interfacing an R client environment with a separate database engine environment, the method comprising:

receiving, at a computer, an R language code fragment from the R client environment;

interpreting the R language code fragment to identify a first group of R language constructs;

determining the computation resource requirements of at least one R language constructs selected from among the first group of R language constructs; and

mapping, to a remote execution engine, a first selected R language construct from among the first group of R language constructs in response to the determination of the computation resource requirements.

2. The method of claim 1, wherein the computation resource requirements of at least one from among the first group of R language constructs comprises at least one of, a functional mapping, a database size estimation, and a computational demand assessment.

3. The method of claim 1, further comprising a second group of R language constructs wherein operations to determine computation resource requirements of at least one from among the second group of R language constructs comprises at least one of, a functional mapping, a database size estimation, and a computational demand assessment.

4. The method of claim 1, further comprising executing the first selected R language construct on the database engine.

5. The method of claim 4, further comprising transmitting marshaled results, the marshaled results depending at least in part from the act of executing the first selected R language construct.

6. The method of claim 5, wherein the transmitted marshaled results include a metadata description.

7. The method of claim 1, further comprising:

processing a least one from among the first group of R language constructs to generate a corresponding query without executing it; and

executing the corresponding query only when the result is to be displayed in a tabular or graphical form in the R client environment.

8. A computer system for interfacing an R client environment with a separate database engine environment, comprising:

a computer processor to execute a set of program code instructions; and

a memory to hold the program code instructions, in which the program code instructions comprises program code to perform,

receiving an R language code fragment from the R client environment;

interpreting the R language code fragment to identify a first group of R language constructs;

determining the computation resource requirements of at least one R language constructs selected from among the first group of R language constructs; and

mapping, to a remote execution engine, a first selected R language construct from among the first group of R language constructs in response to the determination of the computation resource requirements.

9. The computer system of claim 8, wherein the computation resource requirements of at least one from among the first group of R language constructs comprises at least one of, a functional mapping, a database size estimation, and a computational demand assessment.

10. The computer system of claim 8, wherein the computation resource requirements of at least one from among the first group of R language constructs comprises at least one of, a functional mapping, a database size estimation, and a computational demand assessment.

11. The computer system of claim 8, further comprising executing the first selected R language construct on the database engine.

12. The computer system of claim 11, further comprising transmitting marshaled results, the marshaled results depending at least in part from an act of executing the first selected R language construct.

13. The computer system of claim 8, further comprising:

processing a least one from among the first group of R language constructs to generate a corresponding query without executing it; and

executing the corresponding query only when the result is to be displayed in a tabular or graphical form in the R client environment.

14. A computer program product embodied in a non-transitory computer readable medium, the computer readable medium having stored thereon a sequence of instructions which, when executed by a processor causes the processor to execute a process to implement interfacing an R client environment with a separate database engine environment, the process comprising:

receiving an R language code fragment from the R client environment;

interpreting the R language code fragment to identify a first group of R language constructs;

determining the computation resource requirements of at least one R language constructs selected from among the first group of R language constructs; and

mapping, to a remote execution engine, a first selected R language construct from among the first group of R language constructs in response to the determination of the computation resource requirements.

15. The computer program product of claim 14, wherein the computation resource requirements of at least one from among the first group of R language constructs comprises at least one of, a functional mapping, a database size estimation, and a computational demand assessment.

16. The computer program product of claim 14, further comprising a second group of R language constructs wherein operations to determine computation resource requirements of at least one from among the second group of R language constructs comprises at least one of, a functional mapping, a database size estimation, and a computational demand assessment.

17. The computer program product of claim 14, further comprising executing the first selected R language construct on the database engine.

18. The computer program product of claim 17, further comprising transmitting marshaled results, the marshaled results depending at least in part from an act of executing the first selected R language construct.

19. The computer program product of claim 18, wherein the transmitted marshaled results include a metadata description.

20. The computer program product of claim 18, further comprising:

processing a least one from among the first group of R language constructs to generate a corresponding query without executing it; and

executing the corresponding query only when the result is to be displayed in a tabular or graphical form in the R client environment.