Record management for database systems using fuzzy field matching

At least one non-transitory machine-readable storage medium that provides instructions that, when executed by at least one processor, are configurable to cause the at least one processor to perform operations comprising:

• obtaining a data stream for ingestion by a database system from a first data source different from a second data source, the second data source being associated with a plurality of existing records at the database system, the data stream comprising one or more new or updated records;
• clustering respective records of the plurality of existing records at the database system and the one or more new or updated records into clusters of related records based at least in part on an actual field value for an exact matched field of the respective record comprising a common value for the exact matched field of a respective cluster of related records and one or more respective values for one or more fuzzy matched fields of the respective record;
• identifying a distinct subset of related records to be assigned to an entity from among the respective cluster of related records using one or more fuzzy matching criteria for the one or more fuzzy matched fields of the respective cluster of related records, the distinct subset of related records including at least one new or updated record from the first data source and at least one existing record associated with the second data source, wherein query operations to identify the distinct subset are t×log(k), where t is a number of fuzzy match identifiers that is less than a number of fields per record and k is a number of distinct field values for the one or more fuzzy matched fields that is less than a total number of records;
• selecting one or more values for the one or more fuzzy matched fields from a respective record of the distinct subset of related records, resulting in one or more selected values for the one or more fuzzy matched fields;
• and
• creating a unified record for the entity corresponding to the distinct subset of related records in a data table maintaining unified profiles at the database system using the distinct subset of related records at the database system, the unified record comprising the common value for the exact matched field and the one or more selected values for the one or more fuzzy matched fields.