Student Record Matching Algorithm Using Name Variations and Geography

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current systems face challenges in accurately matching high school student records with college enrollment records due to differences in data formats and privacy laws restricting the use of Social Security Numbers, leading to inefficiencies and potential mismatches.

Innovation Solution

A computer-based matching algorithm that utilizes variations in name spellings, date of birth, geographic location, and enrollment dates to match records between secondary and postsecondary institutions, while conforming to privacy laws by avoiding the use of Social Security Numbers.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If SSN is used as an identifier to match records, then matching accuracy is improved, but compliance with privacy laws deteriorates

Engineering Contradiction:
Improvematching accuracyVSAvoidprivacy law compliance
Core Design Contradiction:
Measurement precisionVSObject-affected harmful factors

Solution Approach 1:

The patent introduces an intermediary matching system that uses probabilistic algorithms and multiple data points (name variations, DOB, geographic location, enrollment dates) as mediators between secondary and postsecondary records. This intermediary approach allows matching without directly using SSN, thus maintaining privacy law compliance while achieving accurate matches through cumulative evidence from multiple sources.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent changes the matching parameters from relying solely on SSN to using a multi-parameter approach including name variations, date of birth, geographic location, and enrollment dates. By transforming the matching criteria from a single precise parameter (SSN) to multiple less precise parameters, the system maintains compliance with privacy laws while achieving comparable or superior matching accuracy through the combination of these parameters.

Inventive Principle:
Principle #35Parameter changes

2Reliability

If name variations are used for matching, then reliability of matches is improved, but complexity of matching algorithm increases

Engineering Contradiction:
Improvematching reliabilityVSAvoidalgorithm complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The patent segments the matching process into distinct modules: name variation handling, date of birth verification, geographic location matching, and enrollment date comparison. Each segment processes one type of data independently, then results are combined to form the final match determination. This segmentation reduces algorithmic complexity by breaking down the complex task into manageable, independent components.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent creates a universal matching algorithm that handles multiple types of data (names, dates, locations, enrollment information) through a single integrated system. This multi-functional approach improves reliability by cross-validating matches across multiple data types while maintaining algorithmic efficiency through a unified processing framework rather than separate specialized algorithms for each data type.

Inventive Principle:
Principle #6Universality (Multi-functionality)

3Measurement precision

If multiple data points are used for matching, then accuracy of matching is improved, but processing time increases

Engineering Contradiction:
Improvematching accuracyVSAvoidprocessing time
Core Design Contradiction:
Measurement precisionVSLoss of time

Solution Approach 1:

The patent performs preliminary actions by pre-processing and standardizing data before the actual matching process. Name variations are pre-identified and stored, geographic locations are pre-geocoded, and enrollment date ranges are pre-calculated. This preliminary preparation reduces the computational burden during the actual matching operation, allowing the system to process multiple data points accurately without excessive processing time.

Inventive Principle:
Principle #10Preliminary action

Solution Approach 2:

The patent implements a partial matching approach where matches are determined based on sufficient but not necessarily complete agreement on all data points. The system can achieve accurate matches by agreeing on a subset of critical parameters (such as DOB plus one other identifier) rather than requiring exact agreement on all parameters, thus reducing processing time while maintaining high accuracy for the most important matching cases.

Inventive Principle:
Principle #16Partial or excessive action

Data Source

PatentUS8676823B2Efficient student record matching
Publication Date: 2014.03.18 NAT STUDENT CLEARINGHOUSE
  • US8676823B2 patent drawing
  • US8676823B2 patent drawing
  • US8676823B2 patent drawing

AI summary

A system and method for efficiently and intelligently matching student enrollment records is disclosed. The method may be used, for example, to track student progress from secondary to postsecondary institutions and generate statistics about aggregate college enrollment rates to inform policy decisions. In exemplary embodiments, the matching algorithm accounts for common variations in student names and geographical distances between secondary institutions and the student's current known address to generate higher confidence matches.