Method and apparatus for generating database queries from a meta

Details Method and apparatus for generating database queries from a meta Method and apparatus for generating database queries from a meta

1995-11-27

1997-09-02

Black, Thomas G.

395751, G06F 1730

Patent

active

056641737

ABSTRACT:
A grammar, parsing method, and associated apparatus for automatically generating test commands to test an SQL database engine interface while reducing storage requirements and improving access time for such test commands as compared with prior test tools. The test tools and methods include a grammar for concise syntactic representation of a meta-query (also referred to as meta-language statement, query pattern, or query template). The meta-query defines an statement similar to the SQL language but includes query elements and query list elements used to generate a plurality of SQL test commands to be applied to the SQL database engine under test. Test commands are generated from the meta-query to reduce storage requirements of prior test methods. Query elements are variable space holders in the meta-query and are replaced by a value appropriate to the SQL database engine under test when the meta-query is used to generate test commands. Query list elements define a list of values to be inserted in place of the query list element when generating the test commands from the meta-query.

REFERENCES:
patent: 3763474 (1973-10-01), Freeman et al.
patent: 4506326 (1985-03-01), Shaw et al.
patent: 4688195 (1987-08-01), Thompson et al.
patent: 5031124 (1991-07-01), Bosinoff et al.
patent: 5133068 (1992-07-01), Crus et al.
patent: 5197005 (1993-03-01), Shwartz et al.
patent: 5315709 (1994-05-01), Alston, Jr. et al.
patent: 5347647 (1994-09-01), Allt et al.
patent: 5386550 (1995-01-01), Hedin et al.
patent: 5519859 (1996-05-01), Grace
patent: 5528748 (1996-06-01), Wallace
patent: 5537590 (1996-07-01), Amado
patent: 5550971 (1996-08-01), Brunner et al.
patent: 5574898 (1996-11-01), Leblang et al.
Teach Yourself Web Publishing with HTML in a Week, Laura Lemay, pp. 1-6.
Microsoft Press Computer Dictionary 2.sup.nd Edition, Woodcock et al., pp. 115-116.
White et al, Test MAnager: A Regression Testing Tool, IEEE, pp. 338-347 Sep. 1993.
Paulley et al, Exploiting Uniqueness in Query Optimization, IEEE, pp. 68-79 Feb. 1994.
Stepheson et al, Imacts: An Interactive, Multiterabyte Image Archive, pp. 146-161 Sep. 1995.

Affiliated with

Also associated with

Rating

Method and apparatus for generating database queries from a meta does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and apparatus for generating database queries from a meta, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for generating database queries from a meta will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-316398