Test generator for database management systems

• US 6,581,052 B1
• Filed: 10/02/2000
• Issued: 06/17/2003
• Est. Priority Date: 05/14/1998
• Status: Expired due to Term

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Slutz, Donald R.
• Primary Examiner(s): Alam, Hosain T.
• Application Number:
  US09/677,684
• Time in Patent Office: 988 Days
• Field of Search: 707/2, 717/124, 717/142-144
• US Class Current: 1/1
• CPC Class Codes: G06F 11/3672 Test management
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

A test generator produces a set of database query-language statements comprised of randomly chosen elements for testing one or more database management systems on arbitrary databases. The statements are syntactically correct according to the query language, and are semantically correct according to the query language and according to the schema of the target database. A configuration file further specifies parameters of the test statements, in terms of maximum elements, weights of different elements, etc. The generated statements include predicates in which tables in a from clause are tightly joined. In addition, a dictionary of words randomly selected from text columns in a test database is maintained and used to create predicates having words that actually appear in the row data.

Claims

1. A computerized method for creating a SQL statement, the method comprising:

generating a SQL statement having a from clause, the from clause include a plurality of table names;

creating a plurality of table sets from the plurality of table names;

iterating of the plurality of table sets until one table set remains and for each iteration performing the tasks of;

selecting a first table set and a second table set from the plurality of table sets;

selecting a first table from the first table set and selecting a second table from the second table set;

selecting a first column in the first table and selecting a second column from the second table;

inserting into a where clause for the SQL statement a predicate including the first column and the second column; and

merging the first table set and the second table set.

2. The computerized method of claim 1, further comprising deleting the first table set and the second table set after merging.

3. The computerized method of claim 1, wherein the first table set and the second table set are uniformly selected.

4. The computerized method of claim 1, wherein the first table and the second table are uniformly selected.

5. The computerized method of claim 1, wherein the first column and the second column are uniformly selected.

6. The computerized method of claim 1, wherein the first column and the second column are selected based on a compatibility of a data type of the first column and a data type of the second column.

7. The computerized method of claim 1, wherein the first column and the second column are selected based on a substantial similarity between a column name of the first column and a column name of the second column.

8. The computerized method of claim 7, wherein the substantial similarity is between a prefix of the column name of the first column and a prefix of the column name of the second column.

9. The computerized method of claim 7, wherein the substantial similarity is between a suffix of the column name of the first column and a suffix of the column name of the second column.

10. A computer-readable medium having computer-executable instructions for performing a method for creating a SQL statement, the method comprising:

generating a SQL statement having a from clause, the from clause include a plurality of table names;

creating a plurality of table sets from the plurality of table names;

iterating of the plurality of table sets until one table set remains and for each iteration performing the tasks of;

selecting a first table set and a second table set from the plurality of table sets;

selecting a first table from the first table set and selecting a second table from the second table set;

selecting a first column in the first table and selecting a second column from the second table;

inserting into a where clause for the SQL statement a predicate including the first column and the second column; and

merging the first table set and the second table set.

11. The computer-readable medium of claim 10, Wherein the method further comprises deleting the first table set and the second table set after merging.

12. The computer-readable medium of claim 10, wherein the first table set and the second table set are uniformly selected.

13. The computer-readable medium of claim 10, wherein the first table and the second table are uniformly selected.

14. The computer-readable medium of claim 10, wherein the first column and the second column are uniformly selected.

15. The computer-readable medium of claim 10, wherein the first column and the second column are selected based on a compatibility of a data type of the first column and a data type of the second column.

16. The computer-readable medium of claim 10, wherein the first column and the second column are selected based on a substantial similarity between a column name of the first column and a column name of the second column.

17. The computer-readable medium of claim 10, wherein the substantial similarity is between a prefix of the column name of the first column and a prefix of the column name of the second column.

18. The computer-readable medium of claim 10, wherein the substantial similarity is between a suffix of the column name of the first column and a suffix of the column name of the second column.