Schema-less access to stored data
AssigneeTeradata US, Inc.
InventorsDANIEL ABADI, Daniel Tahara, Thaddeus Diamond
Life of this patent
Estimating the term…
Abstract
A system, a method, and a computer program product for accessing stored partially structured data using a structure-based query language. A partially-structured data is stored in a data management system using at least one key-value pair. Using the data management system, a query of data is processed. The query is generated using a structured language.
Claims27
A computer implemented method, comprising:
- storing a partially-structured data in a data management system using at least one key-value pair;
- processing, using the data management system, a query of data, wherein the query is generated using a structured language;
- generating an interface containing a plurality of columns of data, wherein each column in the plurality of columns corresponds to a key in a plurality of stored key-value pairs;
- and
- generating, using the generated interface, the query of data using the structured language;
- wherein the generated query refers to at least one column in the generated interface;
- wherein the plurality of columns includes a physical column stored in the data management system and a virtual column stored in an overflow column in the data management system, the overflow column contains at least one key-value pair having a key that is not associated with the physical column stored in the data management system;
- wherein at least one of the storing, the processing, the generating an interface, and the generating the query of data is performed using at least one processor of at least one computing system.
(canceled)
A computer program product comprising a machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:
- storing a partially-structured data in a data management system using at least one key-value pair;
- and
- processing, using the data management system, a query of data, wherein the query is generated using a structured language;
- generating an interface containing a plurality of columns of data, wherein each column in the plurality of columns corresponds to a key in a plurality of stored key-value pairs;
- and
- generating, using the generated interface, the query of data using the structured language;
- wherein the generated query refers to at least one column in the generated interface;
- wherein the plurality of columns includes a physical column stored in the data management system and a virtual column stored in an overflow column in the data management system, the overflow column contains at least one key-value pair having a key that is not associated with the physical column stored in the data management system.
A system comprising:
- at least one programmable processor;
- and
- a machine-readable medium storing instructions that, when executed by the at least one programmable processor, cause the at least one programmable processor to perform operations comprising:
- storing a partially-structured data in a data management system using at least one key-value pair;
- and
- processing, using the data management system, a query of data, wherein the query is generated using a structured language;
- generating an interface containing a plurality of columns of data, wherein each column in the plurality of columns corresponds to a key in a plurality of stored key-value pairs;
- and
- generating, using the generated interface, the query of data using the structured language;
- wherein the generated query refers to at least one column in the generated interface;
- wherein the plurality of columns includes a physical column stored in the data management system and a virtual column stored in an overflow column in the data management system, the overflow column contains at least one key-value pair having a key that is not associated with the physical column stored in the data management system.
Dependencies are inferred from the claim text.