Small-footprint applicative query interpreter method, system and program product

• US 7,779,020 B2
• Filed: 03/01/2002
• Issued: 08/17/2010
• Est. Priority Date: 03/01/2002
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Karlsson, Jonas S., Grust, Torsten
• Primary Examiner(s): LeRoux; Etienne P
• Assistant Examiner(s): Nguyen; Cindy
• Application Number:
  US10/090,068
• Publication Number:
  US 20030167261A1
• Time in Patent Office: 3,091 Days
• Field of Search: 707/4, 707/3, 707/103.Y, 717/106
• US Class Current: 707/760
• CPC Class Codes: A61K 31/57 substituted in position 17 beta by a chain of two carbon atoms, e.g. pregnane or progesterone
• CPC Class Codes: A61K 38/28 Insulins
• CPC Class Codes: A61K 47/34 Macromolecular compounds obtained otherwise than by reactions only involving carbon-to-carbon unsaturated bonds, e.g. polyesters, polyamino acids, polysiloxanes, polyphosphazines, copolymers of polyalkylene glycol or poloxamers A61K47/10 takes precedence
• CPC Class Codes: A61K 9/0075 for inhalation via a dry powder inhaler [DPI], e.g. comprising micronized drug mixed with lactose carrier particles
• CPC Class Codes: A61K 9/1647 Polyesters, e.g. poly(lactide-co-glycolide)
• CPC Class Codes: A61K 9/1682 Processes
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

A method system, and program product for managing a relational database in a pervasive computing environment. The system receives queries in a query language, and represents the queries in accordance with a declarative language paradigm, this may be explicit or implicit. The queries represented in a declarative language paradigm are converted (e.g., represented, translated, or cross-compiled) to an imperative language (including a data structure that is interpreted by an imperative language); and the imperative language queries are executed on the database. The queries may be explicitly converted to an intermediate declarative representative, and thereafter converted to an imperative language representation of the original queries for execution. Alternatively, the queries may be directly converted to an imperative language representation of the declarative language and the imperative language queries executed on the database.

Claims

1. A method of managing a relational database on a pervasive computing device comprising:

a. receiving queries on a pervasive computing device in SQL, the queries comprising a plurality of query terms;

b. interpreting the queries on a pervasive computing device by associating at least one declarative language function with the query terms by converting the SQL to an intermediate tree representation corresponding to the declarative language function wherein the declarative language function is implemented in a declarative language that is chosen from the group consisting of ML, LISP, and HASKELL;

c. converting the queries represented by at least one declarative language function to a plurality of JAVA statements on a pervasive computing device; and

d. executing the JAVA statements.

2. The method of claim 1, wherein the declarative language function is identified by a reference to further code such that the declarative language function is treated as data within a plurality of JAVA statements.

3. A database management system adapted to process queries in a pervasive computing environment, said pervasive computing environment comprising at least one client adapted to interact with a server over connection services, said at least one client controlled and configured to

a. receive the queries on a pervasive computing device in SQL, the queries comprising a plurality of query terms;

b. interpret the queries on a pervasive computing device by associating at least one declarative language function with the query terms wherein the declarative language function is implemented in a declarative language that is chosen from the group consisting of ML, LISP, and HASKELL;

c. convert the queries represented by the at least one declarative language function to a plurality of Java language statements on a pervasive computing device; and

d. execute the Java language statements.

4. The system of claim 3, wherein the declarative language function is identified by a reference to further code such that the declarative language function is treated as data within the plurality of Java language statements.

5. A program product comprising computer readable program code on one or more media, said program code being capable of controlling and configuring a computer system having one or more computers to perform the process of

a. receiving queries on a pervasive computing device in SQL, the queries comprising a plurality of query terms;

b. interpreting the queries on a pervasive computing device by associating at least one declarative language function with the query terms wherein the declarative language function is implemented in a declarative language that is chosen from the group consisting of ML, LISP, and HASKELL;

c. converting the queries represented by the at least one declarative language function to a plurality of Java language statements on a pervasive computing device; and

d. executing the Java language statements.

6. The program product of claim 5, wherein the declarative language function is identified by a pointer to further code such that the declarative language function is treated as data within the plurality of Java language statements.