Abstract: Disclosed herein are system, method, and computer program product embodiments for getting location-based data for a specific location or area. An embodiment transmits a request for a first location item at a first administrative level of a first location hierarchy to a data provider for a location. The embodiment receives the first location item. The embodiment determines a second administrative level is present in the first location hierarchy for the location. The embodiment transmits a second request for a second location item at the second administrative level to the data provider for the location. The embodiment receives the second location item. The embodiment maps the first location item and the second location item respectively to a first administrative level and a second administrative level in the second location hierarchy. The embodiment then creates a result set for the location based on the first location item and the second location item.

Abstract: A computer-implemented method for performing a data quality function includes receiving, at a data quality function process, at least one record from a source, where the record includes data, semantic annotations and data quality annotations associated with the data in the record. The semantic annotations are attributes that define the data including input format and output format and the data quality annotations are attributes that define data quality rules to be applied to the data. The data quality function process automatically maps the semantic annotations to data quality input fields and to data quality output fields. The data quality function process applies the data quality rules to the data using the data quality annotations to perform a data quality function. The data quality function process performs the data quality function on the data and outputs the data to a destination in a format defined by the data quality output fields.

Abstract: Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives a first set of address data that describes a first geographic location. The program further determines a first set of geo-location coordinates based on the first set of address data. The program also determines a second set of geo-location coordinates based on the first set of geo-location coordinates. The program further determines a second set of address data based on the second set of geo-location coordinates.

Abstract: Disclosed herein are system, method, and computer program product embodiments for providing a graphical match policy for identifying duplicative data. An embodiment operates by receiving a selection of a match rule for identifying duplicate records within a database, the match rule comprising a candidate filter and a comparison filter. One or more candidate attributes of the candidate filter and one or more comparison attributes of the comparison filter are determined. A first subset of the records within the database that satisfy the candidate filter are identified. A second subset of the records from the first subset of records that satisfy the comparison filter are identified. The second subset of records that satisfy both the candidate filter and the comparison filter are returned.

Abstract: Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives a first set of address data that describes a first geographic location. The program further determines a first set of geo-location coordinates based on the first set of address data. The program also determines a second set of geo-location coordinates based on the first set of geo-location coordinates. The program further determines a second set of address data based on the second set of geo-location coordinates.

Abstract: A computer-implemented method, system, and computer program product are described for initiating and displaying, at a user interface, an editor adapted to generate a plurality of configuration models, receiving a selection of at least one country from a plurality of countries. The method can include retrieving a data model and reference data associated with the at least one country, populate a plurality of attributes from the data model in the user interface and populating a plurality of selectable input mappings in the user interface. The method may also include populating a plurality of selectable output mappings in the user interface and generating at least one configuration model, in response to receiving at least one selection for the input mappings and at least one selection for the output mappings.

Abstract: Disclosed herein are system, method, and computer program product embodiments for getting location-based data for a specific location or area. An embodiment transmits a request for a first location item at a first administrative level of a first location hierarchy to a data provider for a location. The embodiment receives the first location item. The embodiment determines a second administrative level is present in the first location hierarchy for the location. The embodiment transmits a second request for a second location item at the second administrative level to the data provider for the location. The embodiment receives the second location item. The embodiment maps the first location item and the second location item respectively to a first administrative level and a second administrative level in the second location hierarchy. The embodiment then creates a result set for the location based on the first location item and the second location item.

Abstract: Disclosed herein are system, method, and computer program product embodiments for assignment level address cleansing based on a minimum assignment level. An embodiment operates by receiving an address from a client device at an address cleansing system. The address cleansing system then parses the address into a plurality entry fields represent different geographic region fields. The address cleansing system then compares the entry fields to reference address data to determine an assignment level of the address. The assignment level indicates the level of address validation achieved based on the comparison to the reference address data. The assignment level is then compared to a minimum assignment level. If the assignment level is equal to or greater than the minimum assignment level, the address is cleansed using the reference address data. If not, the address is not cleansed.

Abstract: Methods and systems are described for providing an editor for modifying predefined data match policies. The methods and systems can receive search requests including search criteria and obtain data records and a plurality of respective data match policies for the data records that correspond to the search criteria. The methods and systems can display a first set of data records and a second set of data records. The first set of data records may match the search criteria and the second set of data records may be identified as a partial match to one or more data match policies associated with the first set of data records. The methods and systems can receive a request to modify a data match policy corresponding to at least one of the second set of data records and generate and display a plurality of suggestions for executing the at least one request.

Abstract: Disclosed herein are system, method, and computer program product embodiments for address application using address deliverability metrics. An embodiment operates by receiving an address from a client device at an address deliverability system. The address deliverability system then parses the address into a plurality entry fields represent different geographic region fields. The address deliverability system then compares the entry fields to reference address data to determine a deliverability score indicative of the deliverability of the address. The address deliverability system then utilizes the address according to instructions corresponding to the determine deliverability score.

Abstract: Disclosed herein are system, method, and computer program product embodiments for providing a graphical match policy for identifying duplicative data. An embodiment operates by receiving a selection of a match rule for identifying duplicate records within a database, the match rule comprising a candidate filter and a comparison filter. One or more candidate attributes of the candidate filter and one or more comparison attributes of the comparison filter are determined. A first subset of the records within the database that satisfy the candidate filter are identified. A second subset of the records from the first subset of records that satisfy the comparison filter are identified. The second subset of records that satisfy both the candidate filter and the comparison filter are returned.

Abstract: A cleanse engine receives address data from an application as the address data is entered into the application. The cleanse engine parses the address data as the data is received from the application. The cleanse engine performs a final address validation to validate a final address when sufficient parsed address data is available and returns the final address to the application. The cleanse engine sends the parsed address data to a search engine when insufficient parsed address data is available to perform the final address validation. When the parsed address data is sent to the search engine, the search engine queries reference data and returns a list of search results to the cleanse engine. The cleanse engine standardizes the list of search results from the search engine and sends the list of search results to the application.

Abstract: A system includes reception of a first data record, identification of one or more component elements in the first data record, application of a cleansing operation to change a first component element of the one or more component elements to a first cleansed component element, the first cleansed component element being different from the first component element, automatic determination a change significance of the change, and storage an identifier of the first cleansed component element in association with an identifier of the change significance.

Abstract: A system includes reception of name data, determination, for each of a plurality of name properties, of an associated property value based on the name data, determination of a gender classification based on the property values, and, for each property value, generation of a substitute property value based on the property associated with the property value and the gender classification.

Abstract: Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives a first set of address data that describes a first geographic location. The program further determines a first set of geo-location coordinates based on the first set of address data. The program also determines a second set of geo-location coordinates based on the first set of geo-location coordinates. The program further determines a second set of address data based on the second set of geo-location coordinates.

Abstract: A system includes identification of a group of records of a plurality of records of a database table associated with a plurality of columns, each of the plurality of records including zero or one value for each column, determination of a plurality of rules, each rule associated with one or more of the plurality of columns and for determining a record from which to select values for the associated one or more columns, evaluation of each of the plurality of rules to determine, for each rule, a record of the group of records, and determination of a first record of the group of records based on the record determined for each rule.

Abstract: A system includes reception of first address data associated with a first location, the first address data comprising first geo-coordinates, determination of a first two or more candidate cities based on the first address data, identification of a first one of the first two or more candidate cities based on the first geo-coordinates, and generation of second address data associated with the first location based on the identified first one of the first two or more candidate cities.

Abstract: Disclosed herein are system, method, and computer program product embodiments for assignment level address cleansing based on a minimum assignment level. An embodiment operates by receiving an address from a client device at an address cleansing system. The address cleansing system then parses the address into a plurality entry fields represent different geographic region fields. The address cleansing system then compares the entry fields to reference address data to determine an assignment level of the address. The assignment level indicates the level of address validation achieved based on the comparison to the reference address data. The assignment level is then compared to a minimum assignment level. If the assignment level is equal to or greater than the minimum assignment level, the address is cleansed using the reference address data. If not, the address is not cleansed.

Abstract: Disclosed herein are system, method, and computer program product embodiments for address application using address deliverability metrics. An embodiment operates by receiving an address from a client device at an address deliverability system. The address deliverability system then parses the address into a plurality entry fields represent different geographic region fields. The address deliverability system then compares the entry fields to reference address data to determine a deliverability score indicative of the deliverability of the address. The address deliverability system then utilizes the address according to instructions corresponding to the determine deliverability score.

Abstract: A system includes identification of a first one or more columns of a first database table as associated with a first entity and a first one or more columns of a second database table as associated with the first entity, mapping of the data of each row of the first one or more columns of the first database table to respective first rows of a predetermined schema associated with the entity, mapping of the data of each row of the first one or more columns of the second database table to respective second rows of the predetermined schema associated with the entity, determining of matching ones of the first rows and the second rows, and based on the matching ones of the first rows and the second rows, identification of the first one or more columns of the first database table and the first one or more columns of the second database table as a JOIN key between the first database table and the second database table.