Cross-platform subselect metadata extraction

• US 7,058,620 B1
• Filed: 04/07/2000
• Issued: 06/06/2006
• Est. Priority Date: 04/07/2000
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Mandel, Richard Henry III
• Primary Examiner(s): Gaffin, Jeffrey A.
• Assistant Examiner(s): PHAM, HUNG Q
• Application Number:
  US09/545,592
• Time in Patent Office: 2,251 Days
• Field of Search: 707/1, 707/2, 707/3, 707/4, 707/5
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2438 Embedded query languages
• CPC Class Codes: G06F 16/2443 Stored procedures
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access

Abstract

A metadata extraction system executes a query against a database on a data storage device connected to a computer. Initially, the query is modified to replace one or more selected clauses with a false clause. The modified query with the false clause is executed. Metadata is retrieved from the result set obtained by executing the modified query. The metadata is used to obtain column types, which are converted to Java™ types. Then, a SQLJ iterator is generated, which has parameters for the Java™ types.

Claims

1. A method for executing a query against a database on a data storage device connected to a computer, the method comprising:

modifying the query to replace one or more selected clauses with one or more false clauses;

executing the modified query with the one or more false clauses; and

retrieving metadata from the result set obtained by executing the modified query.

2. The method of claim 1, wherein the query comprises a SELECT statement.

3. The method of claim 2, wherein the SELECT statement is not a SELECT INTO statement.

4. The method of claim 1, wherein the selected clauses comprise WHERE clauses.

5. The method of claim 1, wherein the selected clauses comprise GROUP BY clauses.

6. The method of claim 1, wherein modifying the query comprises:

generating a list of modified queries, wherein each modified query has one or more selected clauses replaced with one or more false clauses; and

executing each modified query until one executes successfully.

7. The method of claim 6, wherein a query executes successfully if it executes without an exception.

8. The method of claim 1, wherein the metadata comprises column type data for the result set.

9. The method of claim 8, further comprising converting the column type data to JAVA types.

10. The method of claim 9, further comprising generating a SQLJ iterator with parameters having the JAVA types.

11. The method of claim 1, further comprising determining whether the query requires a SQLJ iterator.

12. An apparatus for executing a query, comprising:

a computer connected a data storage device that stores a database containing data;

one or more computer programs, performed by the computer, for modifying the query to replace one or more selected clauses with one or more false clauses, executing the modified query with the one or more false clauses, and retrieving metadata from the result set obtained by executing the modified query.

13. The apparatus of claim 12, wherein the query comprises a SELECT statement.

14. The apparatus of claim 13, wherein the SELECT statement is not a SELECT INTO statement.

15. The apparatus of claim 12, wherein the selected clauses comprise WHERE clauses.

16. The apparatus of claim 12, wherein the selected clauses comprise GROUP BY clauses.

17. The apparatus of claim 12, wherein modifying the query comprises:

generating a list of modified queries, wherein each modified query has one or more selected clauses replaced with one or more false clauses; and

executing each modified query until one executes successfully.

18. The apparatus of claim 17, wherein a query executes successfully if it executes without an exception.

19. The apparatus of claim 12, wherein the metadata comprises column type data for the result set.

20. The apparatus of claim 19, further comprising converting the column type data to JAVA types.

21. The apparatus of claim 20, further comprising generating a SQLJ iterator with parameters having the JAVA types.

22. The apparatus of claim 12, further comprising determining whether the query requires a SQLJ iterator.

23. An article of manufacture comprising a computer program carrier readable by computers and embodying one or more instructions executable by the computer for executing a query against a database on a data storage device connected to the computer, comprising:

modifying the query to replace one or more selected clauses with one or more false clauses;

executing the modified query with the one or more false clauses; and

retrieving metadata from the result set obtained by executing the modified query.

24. The article of manufacture of claim 23, wherein the query comprises a SELECT statement.

25. The article of manufacture of claim 24, wherein the SELECT statement is not a SELECT INTO statement.

26. The article of manufacture of claim 23, wherein the selected clauses comprise WHERE clauses.

27. The article of manufacture of claim 23, wherein the selected clauses comprise GROUP BY clauses.

28. The article of manufacture of claim 23, wherein modifying the query comprises:

generating a list of modified queries, wherein each modified query has one or more selected clauses replaced with one or more false clauses; and

executing each modified query until one executes successfully.

29. The article of manufacture of claim 28, wherein a query executes successfully if it executes without an exception.

30. The article of manufacture of claim 23, wherein the metadata comprises column type data for the result set.

31. The article of manufacture of claim 30, further comprising converting the column type data to JAVA types.

32. The article of manufacture of claim 31, further comprising generating a SQLJ iterator with parameters having the JAVA types.

33. The article of manufacture of claim 23, further comprising determining whether the query requires a SQLJ iterator.