public class EvidenceCollector extends Object
The collector traverses various parts of SQL statements to gather evidence about which columns belong to which tables. This is used by the InferenceEngine to make educated guesses about column sources when metadata is not available.
Evidence sources: - WHERE clause: qualified and unqualified column references - JOIN conditions: columns used in join predicates - SELECT list: columns and expressions - GROUP BY: grouped columns - ORDER BY: sort columns - INSERT statements: column lists - UPDATE statements: SET clauses
Example:
SELECT * FROM employees e WHERE e.department_id = 10 Evidence collected: - "department_id" in "employees" (from qualified WHERE reference)
| Constructor and Description |
|---|
EvidenceCollector() |
| Modifier and Type | Method and Description |
|---|---|
void |
clear()
Clear all collected evidence.
|
List<InferenceEvidence> |
collectFromSelect(TSelectSqlStatement select)
Collect evidence from a SELECT statement.
|
List<InferenceEvidence> |
getEvidence()
Get all collected evidence.
|
int |
getEvidenceCount()
Get count of collected evidence.
|
public EvidenceCollector()
public List<InferenceEvidence> collectFromSelect(TSelectSqlStatement select)
select - the SELECT statementpublic List<InferenceEvidence> getEvidence()
public void clear()
public int getEvidenceCount()