{"schema_version":"1.0","canonical_url":"https://patentable.app/patents/US-8478793","patent":{"patent_number":"US-8478793","title":"Virtual pair algorithm for outer join resolution","assignee":null,"inventors":[],"filing_date":"2011-03-24T00:00:00.000Z","publication_date":"2013-07-02T00:00:00.000Z","cpc_codes":["G06F","G06F"],"num_claims":13,"abstract":"A system and method for executing semijoin reductions on outer join operations are presented. Tuple lists are created based on a query. A sequence of semijoin reduction steps are performed, where each semijoin reduction step either switches one tuple list, or reduces all tuple lists at one relation. Virtual connector pairs are inserted into the tuple lists, and then all tuple lists are centralized at a common host. The join results are assembled at the common host, and negative row IDs are substituted. From the join result, the query result is retrieved by projecting to the requested attributes."},"analysis":{"summary":null,"layman_explanation":null,"technical_analysis":null,"business_analysis":null,"faqs":null,"topics":[],"tech_cluster":null},"seo":{"title":"Virtual pair algorithm for outer join resolution","description":"A system and method for executing semijoin reductions on outer join operations are presented. Tuple lists are created based on a query. A sequence of semijoin reduction steps are performed, where each","keywords":[]},"attribution":{"source":"Patentable","source_url":"https://patentable.app","canonical_url":"https://patentable.app/patents/US-8478793","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-8478793","citation_suggestion":"Patentable. \"Virtual pair algorithm for outer join resolution\" (US-8478793). https://patentable.app/patents/US-8478793","copyright_holder":"Nomic Interactive Technology LLC"},"links":{"html":"https://patentable.app/patents/US-8478793","json":"https://patentable.app/api/llm-context/US-8478793","site":"https://patentable.app","llms_txt":"https://patentable.app/llms.txt"},"generated_at":"2026-05-31T09:23:14.724Z"}