Systems and methods for dynamically parsing json into bigquery structures
AssigneeCenturyLink Intellectual Property LLC
InventorsRobert BUSHLACK, Robert WRIGHT
Life of this patent
Estimating the term…
Abstract
Disclosed are systems and methods for a computerized, dynamic JSON framework for working with complex JSON data in BigQuery environments. By implementing a multi-stage processing pipeline that preserves structural relationships while providing simplified access methods, the disclosed framework effectively bridges the gap between document-oriented and columnar data models. The framework’s ability to handle deeply nested structures, maintain structural integrity, and provide multiple access layers provides advanced and improved mechanisms for handling complex JSON data integration operations.
Claims20
A method comprising:
- receiving a JavaScript Object Notation (JSON) document, the document comprising information related to data within a database;
- analyzing the JSON document, and determining layer and structure data;
- generating, based on the determined layer and structure data, an optimized BigQuery phrase;
- creating, based on the optimized BigQuery phrase, a set of view definitions, the view definition being at least one of a base view or flat view;
- and
- generating, based on the set of view definitions, an output query for the database, the output query being a BigQuery structure.
A non-transitory computer-readable storage medium tangibly encoded with computer-executable instructions that when executed by a processor, perform a method comprising:
- receiving a JavaScript Object Notation (JSON) document, the document comprising information related to data within a database;
- analyzing the JSON document, and determining layer and structure data;
- generating, based on the determined layer and structure data, an optimized BigQuery phrase;
- creating, based on the optimized BigQuery phrase, a set of view definitions, the view definition being at least one of a base view or flat view;
- and
- generating, based on the set of view definitions, an output query for the database, the output query being a BigQuery structure.
A system comprising:
- a processor configured to:
- receive a JavaScript Object Notation (JSON) document, the document comprising information related to data within a database;
- analyze the JSON document, and determine layer and structure data;
- generate, based on the determined layer and structure data, an optimized BigQuery phrase;
- create, based on the optimized BigQuery phrase, a set of view definitions, the view definition being at least one of a base view or flat view;
- and
- generate, based on the set of view definitions, an output query for the database, the output query being a BigQuery structure.
Dependencies are inferred from the claim text.