Inference-Based Semantic Data Type Assignment
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Manual assignment of data types to raw data in databases is time-consuming and requires user insight to recognize complex relationships, making it inefficient for large volumes of data.
Innovation Solution
A method that infers semantic data types by determining success rates and alignment scores of features such as data length and first digit, using a two-step process with pattern matching and user feedback to refine assignments, and storing metadata for accurate classification.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If manual assignment of data types is performed, then accuracy of data type classification is improved, but time consumption and labor effort increase significantly
Solution Approach 1:
The system enables data to classify itself by automatically analyzing intrinsic patterns, statistical distributions, and semantic characteristics of the data. The inference engine processes data independently without requiring manual intervention, allowing the data to 'serve itself' in terms of classification while maintaining high accuracy through multiple scoring mechanisms and confidence thresholds.
Solution Approach 2:
The patent replaces the mechanical manual process of data type assignment with an automated inference engine that uses algorithmic analysis. Instead of human users manually examining and classifying data, the system employs computational methods including statistical distribution analysis, pattern recognition, and machine learning models to automatically determine data types, thereby eliminating time-consuming manual labor while preserving classification accuracy.
2Loss of information
If manual assignment of data types is performed, then understanding of complex relationships between data fields is improved, but productivity decreases
Solution Approach 1:
The inference engine acts as an intermediary between raw data and the final data type classification. It analyzes complex relationships between data fields by examining statistical distributions, correlations, and semantic patterns, then translates this analysis into accurate data type assignments. This intermediary process preserves the understanding of data relationships while automating the classification task to maintain high productivity.
Solution Approach 2:
The system transforms the classification problem by changing parameters from manual inspection criteria to automated statistical and semantic analysis parameters. By using multiple scoring mechanisms, confidence thresholds, and iterative refinement processes, the system captures complex data relationships through computational parameters rather than human judgment, thereby maintaining analytical depth while improving processing efficiency.
3Productivity
If automated inference is implemented, then productivity is improved, but complexity of the system increases
Solution Approach 1:
The inference system is segmented into distinct functional modules: data analysis components that examine statistical distributions, pattern recognition components that identify semantic characteristics, scoring mechanisms that evaluate multiple hypotheses, and confidence assessment modules that determine classification reliability. This segmentation manages system complexity by organizing functions into manageable, independent units that can be developed and maintained separately while working together to achieve high productivity.
Solution Approach 2:
The inference engine is designed as a universal system capable of handling multiple data types, formats, and classification scenarios through a single unified architecture. It employs general-purpose statistical analysis, pattern recognition, and machine learning techniques that can be applied across diverse data domains, thereby managing complexity through reusability and multi-functionality rather than requiring separate specialized systems for each data type.
4Measurement precision
If multiple features are analyzed for data type inference, then accuracy is improved, but computational requirements increase
Solution Approach 1:
The system implements a tiered analysis approach where it first performs partial analysis using a subset of features and scoring mechanisms to quickly eliminate unlikely data types. Only for cases where confidence is insufficient does it proceed to analyze additional features or apply more computationally intensive methods. This partial action strategy maintains high accuracy by analyzing enough features to make correct classifications while avoiding the computational overhead of analyzing all possible features in every case.
Solution Approach 2:
The inference engine performs preliminary analysis using computationally efficient statistical measures and pattern matching techniques before applying more resource-intensive analysis methods. By pre-processing data to extract key characteristics and performing initial classification attempts with simplified models, the system reduces the computational burden of subsequent detailed analysis, thereby achieving high accuracy with optimized resource utilization.
Data Source
AI summary
Embodiments associate a relevant semantic data type (e.g., date) with incoming raw data (e.g., a column of digits) which lacks metadata. Assignment of semantic data type is inferred from a plurality of features. A first step determines a first feature comprising success rate in converting the raw data into various semantic data types. Then, alignment between observed/reference distributions of other features (e.g., data first digit, data length) is determined per-semantic data type. Total scores for each semantic data type are calculated from the combined features, and used as a basis for ranking the semantic data types. The total scores may reflect a weighting of the various features. In a second step, top-ranked semantic data types may be further differentiated from one another by applying additional features. User feedback regarding accuracy of semantic data type assignment, may be incorporated into training data used to modify the feature reference distributions.


