Set-based bugs discovery system via SQL query

Abstract

A system for bug discovery using event reports comprises an interface and a processor. The interface is configured to receive symptom data extracted from event reports from a user system. The symptom data is stored in a symptom database. The symptom data comprises one or more symptoms each with a corresponding symptom occurrence time. The processor is configured to compose one or more SQL queries using one or more bug definitions and determine an existence of one or more bugs of the user system based at least in part on a result of querying the symptom database using the one or more SQL queries.

What is claimed is: 
     
       1. A system for bug discovery using event reports, comprising:
 an interface configured to:
 receive symptom data extracted from event reports from a user system, wherein the symptom data is stored in a symptom database, and wherein the symptom data comprises one or more symptoms each with a corresponding symptom occurrence time; a processor configured to: 
 determine an existence of one or more bugs of the user system based at least in part on a result of querying the symptom database using a bug definition, wherein the bug definition comprises a logic set operation on the symptom data, wherein the logic set operation comprises one of the following: AND, OR, XOR, MINUS, NOT, NAND, NOR or ADD. 
 
 
     
     
       2. A system as in  claim 1 , wherein the symptom data comprises one or more of the following: system events, error messages, system measurements, time stamps, system environment measurements, component status, configuration settings, policy definitions, or system behaviors. 
     
     
       3. A system as in  claim 1 , wherein each of the one or more symptoms comprises an error message with the corresponding symptom occurrence time comprising an error time extracted from the event reports from the user system. 
     
     
       4. A system as in  claim 3 , wherein the symptom data comprises one or more of the following: CPU temperature, CPU load, driver messages, device found status, timeout, and controller status. 
     
     
       5. A system as in  claim 1 , wherein the bug definition comprises a time sequence set operation on the symptom data. 
     
     
       6. A system as in  claim 1 , wherein the bug definition comprises a combination of logic set operations and time sequence set operations on the symptom data. 
     
     
       7. A system as in  claim 1 , wherein determining the existence of the one or more bugs comprises determining whether a result set of an SQL query from the symptom database is not empty. 
     
     
       8. A system as in  claim 7 , wherein determining the existence of the one or more bugs further comprises indicating the existence of the one or more bugs of the user system in the event that the result set of the SQL query is not empty. 
     
     
       9. A system as in  claim 1 , wherein the processor is further configured to compose one or more SQL queries including translating one or more bug definitions from a human-readable format to the one or more SQL queries. 
     
     
       10. A system as in  claim 9 , wherein an SQL query of the one or more SQL queries comprises selecting times of two symptoms from two tables of symptom occurrence times in the symptom database, wherein the selected times are within a certain time interval. 
     
     
       11. A system as in  claim 9 , wherein composing the one or more SQL queries comprises recursively composing an SQL query in the event the bug definition comprises a nested combination of other bug definitions. 
     
     
       12. A system as in  claim 1 , further comprising a processor configured to, in the event that the one or more bugs do exist, output a list of the one or more bugs. 
     
     
       13. A system as in  claim 1 , further comprising a processor configured to, in the event that the one or more bugs do not exist, indicate that the user system is healthy. 
     
     
       14. A system as in  claim 1 , wherein the bug definition comprises two or more symptoms that occur with a time dependency between the two or more symptoms. 
     
     
       15. A system as in  claim 1 , wherein the bug definition is a human-readable format comprising one or more of the following: XML, JSON, or a natural language. 
     
     
       16. A method for bug discovery using event reports, comprising:
 receiving symptom data extracted from event reports from a user system, wherein the symptom data is stored in a symptom database, and wherein the symptom data comprises one or more symptoms each with a corresponding symptom occurrence time; 
 determining, using a processor, an existence of one or more bugs of the user system based at least in part on a result of querying the symptom database using a bug definition, wherein the bug definition comprises a logic set operation on the symptom data, wherein the logic set operation comprises one of the following: AND, OR, XOR, MINUS, NOT, NAND, NOR or ADD. 
 
     
     
       17. A computer program product for bug discovery using event reports, the computer program product being embodied in a non-transitory computer readable storage medium and comprising computer instructions for: A receiving symptom data extracted from event reports from a user system, wherein the symptom data is stored in a symptom database, and wherein the symptom data comprises one or more symptoms each with a corresponding symptom occurrence time; determining, using a processor, an existence of one or more bugs of the user system based at least in part on a result of querying the symptom database using a bug definition, wherein the bug definition comprises a logic set operation on the symptom data, wherein the logic set operation comprises one of the following: AND, OR, XOR, MINUS, NOT, NAND, NOR or ADD.