{"schema_version":"1.0","canonical_url":"https://patentable.app/patents/US-9672246","patent":{"patent_number":"US-9672246","title":"Time-varying data retrieval","assignee":null,"inventors":[],"filing_date":"2013-09-07T00:00:00.000Z","publication_date":"2017-06-06T00:00:00.000Z","cpc_codes":["G06F","G06F","G06F"],"num_claims":16,"abstract":"Methods for determining the representation of time-dependent attributes stored in a database and extracting data according to the representation of the time-dependent attributes are described. In some cases, a time-dependent attribute may comprise a time scale varying attribute (TSV) in which a sum may be computed for any date range. In some embodiments, a time-dependent attribute may be represented as a Character Large Object (CLOB) that encodes information about the time-dependent attribute in a text string and may be accessed by table functions. Alternatively, some time-dependent attributes may also be represented as Binary Large Objects (BLOBs) that are used to populate timeslicing tables. Upon receiving a query for data pertaining to a stored time-dependent attribute, a system identifies whether the stored time-dependent attribute is represented as a CLOB or a BLOB, and generates the queried data in a manner dependent on the representation of the time-dependent attribute."},"analysis":{"summary":null,"layman_explanation":null,"technical_analysis":null,"business_analysis":null,"faqs":null,"topics":[],"tech_cluster":null},"seo":{"title":"Time-varying data retrieval","description":"Methods for determining the representation of time-dependent attributes stored in a database and extracting data according to the representation of the time-dependent attributes are described. In some","keywords":[]},"attribution":{"source":"Patentable","source_url":"https://patentable.app","canonical_url":"https://patentable.app/patents/US-9672246","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-9672246","citation_suggestion":"Patentable. \"Time-varying data retrieval\" (US-9672246). https://patentable.app/patents/US-9672246","copyright_holder":"Nomic Interactive Technology LLC"},"links":{"html":"https://patentable.app/patents/US-9672246","json":"https://patentable.app/api/llm-context/US-9672246","site":"https://patentable.app","llms_txt":"https://patentable.app/llms.txt"},"generated_at":"2026-06-06T12:04:17.993Z"}