{"schema_version":"1.0","canonical_url":"https://patentable.app/patents/US-9721009","patent":{"patent_number":"US-9721009","title":"Primary and foreign key relationship identification with metadata analysis","assignee":null,"inventors":[],"filing_date":"2015-03-06T00:00:00.000Z","publication_date":"2017-08-01T00:00:00.000Z","cpc_codes":["G06F","G06F","G06F","G06F","G06F","G06F","G06F","G06F"],"num_claims":17,"abstract":"A method for identifying a primary key relationship using metadata of a data source is described herein. In an implementation, the method includes identifying a pair of metadata from the data source for comparison. A phonetic code of each of the pair of metadata is determined Further, the phonetic code of the pair of metadata is compared to determine a phonetic disparity score. A string sequence of the pair of metadata is compare to determine a string comparison score. Further a compliance to a predefined set of constraints are checked for the pair of metadata, and a primary key and foreign key relationship is determined based on the phonetic disparity code, string comparison code and compliance of the pair of metadata to a predefined set of constraints."},"analysis":{"summary":null,"layman_explanation":null,"technical_analysis":null,"business_analysis":null,"faqs":null,"topics":[],"tech_cluster":null},"seo":{"title":"Primary and foreign key relationship identification with metadata analysis","description":"A method for identifying a primary key relationship using metadata of a data source is described herein. In an implementation, the method includes identifying a pair of metadata from the data source f","keywords":[]},"attribution":{"source":"Patentable","source_url":"https://patentable.app","canonical_url":"https://patentable.app/patents/US-9721009","license":"CC-BY-4.0-like","license_terms":"AI-generated analysis on this page (summary, layman_explanation, technical_analysis, business_analysis, faqs) may be reused with attribution and a visible link back to the canonical URL above. Patent abstracts, claims, and bibliographic data are USPTO public domain.","required_link":"https://patentable.app/patents/US-9721009","citation_suggestion":"Patentable. \"Primary and foreign key relationship identification with metadata analysis\" (US-9721009). https://patentable.app/patents/US-9721009","copyright_holder":"Nomic Interactive Technology LLC"},"links":{"html":"https://patentable.app/patents/US-9721009","json":"https://patentable.app/api/llm-context/US-9721009","site":"https://patentable.app","llms_txt":"https://patentable.app/llms.txt"},"generated_at":"2026-06-06T10:35:10.945Z"}