{"schema_version":"1.0","canonical_url":"https://patentable.app/patents/US-9846725","patent":{"patent_number":"US-9846725","title":"SQL double counting resolver","assignee":null,"inventors":[],"filing_date":"2017-03-24T00:00:00.000Z","publication_date":"2017-12-19T00:00:00.000Z","cpc_codes":["G06F","G06F","G06F"],"num_claims":21,"abstract":"This disclosure proposes systems, methods, and apparatus that identify raw SQL queries that are likely to cause a double counting error, and if such a SQL query is identified, then convert the raw SQL query into SQL queries that account for and avoid double counting. In some embodiments, this process uses queries and subqueries that refer back to a common table expression (CTE) in order to reduce code length and increase query execution speed."},"analysis":{"summary":null,"layman_explanation":null,"technical_analysis":null,"business_analysis":null,"faqs":null,"topics":[],"tech_cluster":null},"seo":{"title":"SQL double counting resolver","description":"This disclosure proposes systems, methods, and apparatus that identify raw SQL queries that are likely to cause a double counting error, and if such a SQL query is identified, then convert the raw SQL","keywords":[]},"attribution":{"source":"Patentable","source_url":"https://patentable.app","canonical_url":"https://patentable.app/patents/US-9846725","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-9846725","citation_suggestion":"Patentable. \"SQL double counting resolver\" (US-9846725). https://patentable.app/patents/US-9846725","copyright_holder":"Nomic Interactive Technology LLC"},"links":{"html":"https://patentable.app/patents/US-9846725","json":"https://patentable.app/api/llm-context/US-9846725","site":"https://patentable.app","llms_txt":"https://patentable.app/llms.txt"},"generated_at":"2026-06-06T05:36:31.347Z"}