Abstract: The present invention generally is directed to a system, method and article of constructing queries from a set of query conditions. The query conditions are grouped using logical operators to generate a database query. Query conditions within a group may be connected using a logical “OR” operator and groups of query conditions may be connected using a logical “AND” operator. Once generated, the database query may be presented to a user for review.

Abstract: A method, article and apparatus for calculating a measure of similarity between names is disclosed. Generally, name elements from an inbound name may be matched to name elements in a candidate matching name. A measure of similarity for the inbound name and candidate matching name may be calculated based on the number of matching name elements, an inbound name word count, a candidate name word count, and the number of transpositions that occur in matching name elements with one another.

Abstract: A method of tracking entities for identity resolution in database systems comprises assigning each account of a plurality of accounts a unique entity belonging only to the account and in which the account is contained; keeping track of the age of each account of the plurality of accounts; and assigning an identifier to any entity as the identifier of the unique entity of the oldest account contained in the entity. This simple method of assigning identifiers to accounts and entities solves a number of identity resolution problems known in the art including: lost entity identifier problem, lost entity version problem, entity switched warm bodies/accounts problem, and account drift problem.

Abstract: A similarity measure system selects a first value and a first context related to the first value, divides the first value into a first set of substrings in an order preserving way, and processes each of these substrings through an obfuscation function to produce a first set of obfuscated substrings. The system selects a second value and a second context related to the second value, and processes the second value to produce a second set of obfuscated substrings. The system calculates a context similarity measure for the first context and the second context. The system determines a value similarity measure from the first and second set of order preserved obfuscated substrings. The system determines a closeness degree between the first value and the second value and a closeness degree based on the context similarity measure.

Abstract: Discovery and modification of data clusters such as synonyms. In one aspect, a method for clustering data includes receiving information on a system, the information manipulating one or more data attributes stored or to be stored in a database accessible by the system, where the information and manipulation does not explicitly relate to data clusters. A data cluster is automatically adjusted based on the received information, the data cluster including multiple data attributes and including at least one of the data attributes manipulated by the received information. The data cluster is adjusted dynamically and in response to the information being received.

Abstract: Method for handling requests for data stored in database tables is provided. The method includes receiving a request for data stored in a database table, the database table including non-hash and hash columns, a hash column including hash values computed based on non-hash values in at least one non-hash column, generating database queries that are executable to retrieve data stored in the database table satisfying the request, each database query using a different combination of columns in the database table, ranking the database queries based on desirability, determining whether any of the database queries only uses indexed columns, responsive to one or more of the database queries only using indexed columns, selecting a highest ranked of the one or more database queries that only uses indexed columns for execution.

Abstract: Method for handling requests for data stored in database tables is provided. The method includes receiving a request for data stored in a database table, the database table including non-hash and hash columns, a hash column including hash values computed based on non-hash values in at least one non-hash column, generating database queries that are executable to retrieve data stored in the database table satisfying the request, each database query using a different combination of columns in the database table, ranking the database queries based on desirability, determining whether any of the database queries only uses indexed columns, responsive to one or more of the database queries only using indexed columns, selecting a highest ranked of the one or more database queries that only uses indexed columns for execution.

Abstract: Discovery and modification of data clusters such as synonyms. In one aspect, a method for clustering data includes receiving information on a system, the information manipulating one or more data attributes stored or to be stored in a database accessible by the system, where the information and manipulation does not explicitly relate to data clusters. A data cluster is automatically adjusted based on the received information, the data cluster including multiple data attributes and including at least one of the data attributes manipulated by the received information. The data cluster is adjusted dynamically and in response to the information being received.

Abstract: The present invention generally is directed to a system, method and article of constructing queries from a set of query conditions. The query conditions are grouped using logical operators to generate a database query. Query conditions within a group may be connected using a logical “OR” operator and groups of query conditions may be connected using a logical “AND” operator. Once generated, the database query may be presented to a user for review.

Abstract: A method of tracking entities for identity resolution in database systems comprises assigning each account of a plurality of accounts a unique entity belonging only to the account and in which the account is contained; keeping track of the age of each account of the plurality of accounts; and assigning an identifier to any entity as the identifier of the unique entity of the oldest account contained in the entity. This simple method of assigning identifiers to accounts and entities solves a number of identity resolution problems known in the art including: lost entity identifier problem, lost entity version problem, entity switched warm bodies/accounts problem, and account drift problem.

Abstract: A method, article and apparatus for calculating a measure of similarity between names is disclosed. Generally, name elements from an inbound name may be matched to name elements in a candidate matching name. A measure of similarity for the inbound name and candidate matching name may be calculated based on the number of matching name elements, an inbound name word count, a candidate name word count, and the number of transpositions that occur in matching name elements with one another.