{"schema_version":"1.0","canonical_url":"https://patentable.app/patents/US-9600525","patent":{"patent_number":"US-9600525","title":"Method for joining tables using a limited amount of memory","assignee":null,"inventors":[],"filing_date":"2015-11-25T00:00:00.000Z","publication_date":"2017-03-21T00:00:00.000Z","cpc_codes":["G06F","G06F","G06F","G06F"],"num_claims":11,"abstract":"Joining sets of tables on a join attribute using a predefined amount of memory. A set of tables is stored on disk storage. The largest table is a streaming table. The remaining tables form a subset of tables. For each subset table, a hash table is generated, resulting in a subset of hash tables. A group of not yet joined hash tables is determined such that the size of the tables is smaller than the amount of memory. The tables are loaded to the memory. A hash join is performed between the streaming table and the group of tables, forming a temporal joined table. If the subset includes a not yet joined table with the streaming table, a further set of tables with the not yet joined and the temporal joined table is formed. The above operations are repeated using the further set of tables as the set of tables."},"analysis":{"summary":null,"layman_explanation":null,"technical_analysis":null,"business_analysis":null,"faqs":null,"topics":[],"tech_cluster":null},"seo":{"title":"Method for joining tables using a limited amount of memory","description":"Joining sets of tables on a join attribute using a predefined amount of memory. A set of tables is stored on disk storage. The largest table is a streaming table. The remaining tables form a subset of","keywords":[]},"attribution":{"source":"Patentable","source_url":"https://patentable.app","canonical_url":"https://patentable.app/patents/US-9600525","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-9600525","citation_suggestion":"Patentable. \"Method for joining tables using a limited amount of memory\" (US-9600525). https://patentable.app/patents/US-9600525","copyright_holder":"Nomic Interactive Technology LLC"},"links":{"html":"https://patentable.app/patents/US-9600525","json":"https://patentable.app/api/llm-context/US-9600525","site":"https://patentable.app","llms_txt":"https://patentable.app/llms.txt"},"generated_at":"2026-06-06T05:46:46.081Z"}