{"schema_version":"1.0","canonical_url":"https://patentable.app/patents/US-9639542","patent":{"patent_number":"US-9639542","title":"Dynamic mapping of extensible datasets to relational database schemas","assignee":null,"inventors":[],"filing_date":"2014-07-23T00:00:00.000Z","publication_date":"2017-05-02T00:00:00.000Z","cpc_codes":["G06F","G06F","G06F","G06F","G06F","G06F","G06F","G06F","G06F","G16B","G16B"],"num_claims":18,"abstract":"A text file is received. The text file is arranged in an extensible format and includes a plurality of metadata lines, a header line, and a plurality of content lines. Keys are retrieved from the content lines. For each key, a data type and a number from at least one metadata table is retrieved. Using a combination of each key and the corresponding data type and number, a column title is derived. Upon verification that the derived column title does not already exist, a column for each key is generated in a content table having a dynamic structure in a relational database schema. The column has the derived column title, a column type based on the corresponding retrieved data type, and the number of generated columns determined by the corresponding retrieved number. The retrieved value is mapped into the column associated with the corresponding key."},"analysis":{"summary":null,"layman_explanation":null,"technical_analysis":null,"business_analysis":null,"faqs":null,"topics":[],"tech_cluster":null},"seo":{"title":"Dynamic mapping of extensible datasets to relational database schemas","description":"A text file is received. The text file is arranged in an extensible format and includes a plurality of metadata lines, a header line, and a plurality of content lines. Keys are retrieved from the cont","keywords":[]},"attribution":{"source":"Patentable","source_url":"https://patentable.app","canonical_url":"https://patentable.app/patents/US-9639542","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-9639542","citation_suggestion":"Patentable. \"Dynamic mapping of extensible datasets to relational database schemas\" (US-9639542). https://patentable.app/patents/US-9639542","copyright_holder":"Nomic Interactive Technology LLC"},"links":{"html":"https://patentable.app/patents/US-9639542","json":"https://patentable.app/api/llm-context/US-9639542","site":"https://patentable.app","llms_txt":"https://patentable.app/llms.txt"},"generated_at":"2026-06-06T05:40:47.562Z"}