Sap Se

Sap Ag

Anat Levi Segal

Paul N Weinberg

Ronen Cohen

Dave L Sullivan

Philip A Tinari

Richard T Endo

Ariel Hazi

Eugene Cherny

A method for generating and using a reusable custom-defined nestable compound data type for use as a database qualifier provides significant advantages over using traditional non-reusable structured tables of RDBM systems is described. The method and data structures of the invention may be used to define and instantiate flexible nested-record structures that reverse and better expose the relationship between parent records and private child sub-records in a database schema to provide improved referential integrity and visibility into database structure.

Method for generating and using a reusable custom-defined nestable compound data type as database qualifiers

Enables locating and merging potential data record matches. Enables locating duplicates through the definition of matching strategies. Each strategy may include transformations, matching rules and scoring thresholds to implement fuzzy matches that match closely related data records that are not exact matches. Performing a search allows for narrowing down the records to a desired set on which to apply a given matching strategy. Merging is performed on the potential duplicates thus located to consolidate data and remove duplicates. By narrowing down the records to a closely related set via a search, merging is simplified to work on a small number of closely related records, thus simplifying the process. The total matching score obtained via execution of match strategies may be utilized to determine which potential record(s) to merge for example. May utilize past user input to provide intelligent inputs for rules, tokens, weights, fields, parameters or any other past user input.

Method and apparatus for matching non-normalized data values

Growing community of inventors

Shelomi, Israel

Anat Levi Segal