Comparison of source files

• US 20030195878A1
• Filed: 04/09/2003
• Published: 10/16/2003
• Est. Priority Date: 04/10/2002
• Status: Abandoned Application

• Current Assignee: Software Engineering GmbH
• Original Assignee: Software Engineering GmbH
• Inventors: Neumann, Ralf
• Application Number:
  US10/410,316
• Publication Number:
  US 20030195878A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409

Abstract

A method of comparing two source files containing database queries is described in which the database queries are ascertained from the two source files and in which the ascertained database queries from a first source file are compared with the ascertained database queries of a second source file. A quick and efficient analysis of different program versions is achieved by ascertaining the syntax of each database query with the help of a syntax analysis, by comparing the syntax of the database queries of the source files with one another and by presenting the results of the comparison.

Claims

1. A method of comparing a first source file with a second source file, said first and second source files each comprising one or several database queries, wherein said database queries are ascertained from said first and second source files and wherein the ascertained database queries of said first source file are compared with the ascertained database queries of said second source file, which method comprises:

performing a syntax analysis to ascertain a syntax of each of said database queries;

performing a comparison of said syntax of said database queries with one another; and

presenting the results of said comparison.

2. The method of claim 1, wherein each database query of the first source file is combined with each database query of the second source file to form combined database queries.

3. The method of claim 1, wherein said syntax of said database queries comprises syntactical elements.

4. The method of claim 3, wherein said syntactical elements are stored in categories.

5. The method of claim 2, wherein said syntax of said database queries comprises syntactical elements and wherein a comparison of the syntactical elements of the combined database queries that correspond to one another is performed.

6. The method of claim 2, wherein said syntax of said database queries comprises syntactical elements and wherein a weight is assigned to each syntactical element and wherein the weighted difference between the syntactical elements of the combined database queries is used to determine a similarity value with the help of said weights.

7. The method of claim 5, wherein a weight is assigned to each syntactical element and wherein the weighted difference between the syntactical elements of the combined database queries is used to determine a similarity value with the help of said weights.

8. The method of claim 1, wherein for each ascertained database query an identifier marking the appropriate syntax, an assignment identifier assigning the database query of the source file, and a similarity value showing the results of a comparison with another database query is stored.

9. The method of claim 2, wherein a similarity value is assigned to each combination of database queries with the help of weighted differences.

10. The method of claim 2, wherein identical combined database queries are presented as identical.

11. The method of claim 2, wherein equivalent combined database queries are presented as identical.

12. The method of claim 9, wherein similar combined database queries are presented with their similarity value.

13. The method of claim 6, wherein a threshold value is stipulated and the similarity value is measured against the threshold value and by presenting the database queries as similar or dissimilar with the help of the threshold value.

14. The method of claim 7, wherein a threshold value is stipulated and the similarity value is measured against the threshold value and by presenting the database queries as similar or dissimilar with the help of the threshold value.

15. The method of claim 9, wherein a threshold value is stipulated and the similarity value is measured against the threshold value and by presenting the database queries as similar or dissimilar with the help of the threshold value.

16. The method of claim 1, wherein the total deviation of the database queries of the first source file from the second source file is ascertained.

17. A device for comparing two source files comprising database queries, which comprises:

a reader for reading source files;

an extractor for extracting database queries from source files; and

an analyzer for analyzing the syntax of a database query and

a comparator for comparing the syntactical elements of the database queries.

18. The device of claim 17, further comprising a memory for storing the syntactical elements of the database queries.

19. The device of claim 17, further comprising a weighting system for weighting the results of the device.

20. The device of claim 17, further comprising an eliminator device for evaluating the weighted results.