Approximate and exact unary inclusion dependency discovery

摘要: A method and apparatus for analyzing potential inclusion dependencies between columns of database tables is provided. client issues a command, e.g., SQL statement, to server. The command processed at the server without performance join. Result data that indicates any exact or approximate identified in transmitted from client. In processing values stored are converted into integer representations require fewer resources analyze. Disclosed techniques provide use an index on single table rather than defining each table, which can be impractical. Further, only one pass required identify tables.