{"schema_version":"1.0","canonical_url":"https://patentable.app/patents/US-10528538","patent":{"patent_number":"US-10528538","title":"Leveraging SQL with user defined aggregation to efficiently merge inverted indexes stored as tables","assignee":null,"inventors":[],"filing_date":"2016-09-30T00:00:00.000Z","publication_date":"2020-01-07T00:00:00.000Z","cpc_codes":["G06F","G06F","G06F","G06F"],"num_claims":22,"abstract":"Techniques are described herein for using user-defined aggregate functions for updating inverted index tables. A user-defined aggregate function is registered in a database system for updating an index table based on changes stored in a staging table. A query specifying the user-defined aggregate function may be executed in parallel to parallelize the updating of the index table."},"analysis":{"summary":null,"layman_explanation":null,"technical_analysis":null,"business_analysis":null,"faqs":null,"topics":[],"tech_cluster":null},"seo":{"title":"Leveraging SQL with user defined aggregation to efficiently merge inverted indexes stored as tables","description":"Techniques are described herein for using user-defined aggregate functions for updating inverted index tables. A user-defined aggregate function is registered in a database system for updating an inde","keywords":[]},"attribution":{"source":"Patentable","source_url":"https://patentable.app","canonical_url":"https://patentable.app/patents/US-10528538","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-10528538","citation_suggestion":"Patentable. \"Leveraging SQL with user defined aggregation to efficiently merge inverted indexes stored as tables\" (US-10528538). https://patentable.app/patents/US-10528538","copyright_holder":"Nomic Interactive Technology LLC"},"links":{"html":"https://patentable.app/patents/US-10528538","json":"https://patentable.app/api/llm-context/US-10528538","site":"https://patentable.app","llms_txt":"https://patentable.app/llms.txt"},"generated_at":"2026-05-31T06:59:28.969Z"}