Google Inc.

Jonathan Swenson

Julian Hyde

Jamie Davidson

Colin Zima

Lloyd Tabb

Steven Talbot

Conrad Slimmer

Ben Porterfield

A method for the automatic generation of a data model from an SQL statement includes receiving a single SQL statement in a user interface to a data analytics application, parsing the single SQL statement and extracting from the SQL statement different table references. The method also includes, for each one of the table references, directing a selection of all fields available in a corresponding table and storing the available fields in a collection of fields implicated by each table referenced by the table references. Finally, the method includes generating a data model with the fields in the collection of fields and displaying a view of the data model in a user interface of the data analytics application.

Automatic generation of a data model from a structured query language (SQL) statement

A method, system and computer program product for join graph generation based upon a log of previously executed database queries includes method for generating a join graph for relational database queries. The method includes loading into memory of a computer, a log of a set of database queries previously executed against data in a database and sequentially parsing each of the queries in the log to identify different semantically characterizable components of each of the queries. The method further includes generating a join graph for each of the queries from corresponding ones of the components. Finally, the method includes selectively adding each of the generated join graphs to a set of join graphs in a data model for the data in the database.

Retroreflective join graph generation for relational database queries

Data content governance for presentation layer synchronization for a version controlled underlying data model includes defining a data model for underlying data in a database, specifying a presentation layer for the defined data model and identifying selected elements of the data model necessary to meet data requirements of the specified presentation layer. Then, the identified selected elements of the data model are serialized and both the specified presentation layer and the serialized elements are versioned in respect to the specified presentation layer. Thereafter, when the data model becomes modified, the specified presentation layer is modified to accommodate the modified data model. In response to the modification, a different selection of elements of the data model necessary to meet data requirements of the modified presentation layer are re-identified and serialized, with the modified presentation layer and the serialized re-identified different selection of elements becoming re-versioned.

Data content governance for presentation layer synchronization for a version controlled underlying data model

A method, system and computer program product for clustered join graph generation based upon a log of previously executed database queries includes loading into memory of a computer, a log of a set of database queries previously executed against data in a database of the database management system, sequentially parsing each of the queries in the log to identify different semantically characterizable components of each of the queries, generating a join graph for each of the queries from corresponding ones of the components, clustering different generated join graphs according to semantic commonalities so as to form different clusters of join graphs, each for a different semantic commonality, combining the generated join graphs for each cluster into a combined join graph for the corresponding cluster and adding each of the combined join graphs to a set of join graphs in a data model for the data in the database.

Growing community of inventors

Santa Cruz, CA, United States of America

Jonathan Swenson