{"schema_version":"1.0","canonical_url":"https://patentable.app/patents/US-11514236","patent":{"patent_number":"US-11514236","title":"Indexing in a spreadsheet based data store using hybrid datatypes","assignee":null,"inventors":[],"filing_date":"2020-09-30T00:00:00.000Z","publication_date":"2022-11-29T00:00:00.000Z","cpc_codes":["G06F","G06F","G06F","G06F","G06F","G06F","G06F"],"num_claims":19,"abstract":"Aspects described relate to implementing indexing on spreadsheets and/or unstructured data stores. A first aspect comprises a system for implementing an indexing scheme to respond to a query on a spreadsheet of a workbook. The system comprises a data store, a user interface, and a processors configured to identify columns for tables in the spreadsheet, generate an index for at least one column of the identified columns, wherein the index has a hybrid datatype and equates datatypes that form the hybrid datatype, identify a formula in the query having at least one operand, at least one operator, and a key value, and identify a value in an identified column from the operand in response to the query based on the key and the corresponding index to the identified column."},"analysis":{"summary":null,"layman_explanation":null,"technical_analysis":null,"business_analysis":null,"faqs":null,"topics":[],"tech_cluster":null},"seo":{"title":"Indexing in a spreadsheet based data store using hybrid datatypes","description":"Aspects described relate to implementing indexing on spreadsheets and/or unstructured data stores. A first aspect comprises a system for implementing an indexing scheme to respond to a query on a spre","keywords":[]},"attribution":{"source":"Patentable","source_url":"https://patentable.app","canonical_url":"https://patentable.app/patents/US-11514236","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-11514236","citation_suggestion":"Patentable. \"Indexing in a spreadsheet based data store using hybrid datatypes\" (US-11514236). https://patentable.app/patents/US-11514236","copyright_holder":"Nomic Interactive Technology LLC"},"links":{"html":"https://patentable.app/patents/US-11514236","json":"https://patentable.app/api/llm-context/US-11514236","site":"https://patentable.app","llms_txt":"https://patentable.app/llms.txt"},"generated_at":"2026-05-30T21:24:22.378Z"}