公开(公告)号：US11797579B2

公开(公告)日：2023-10-24

申请号：US16730950

申请日：2019-12-30

Applicant: Google LLC

Inventor： Jamie Davidson ,  Colin Zima ,  Jonathan Swenson ,  Lloyd Tabb ,  Ben Porterfield ,  Steven Talbot ,  Conrad Slimmer

IPC: G06F16/28 ,  G06F16/25 ,  G06F3/04847

CPC classification number: G06F16/287 ,  G06F3/04847 ,  G06F16/252

Abstract: 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.

公开(公告)号：US20220222083A1

公开(公告)日：2022-07-14

申请号：US17145698

申请日：2021-01-11

Applicant: Google LLC

Inventor： Lloyd Tabb ,  Michael Toy ,  Aryeh Hillman ,  Steven Talbot ,  Kevin F. McCarthy

IPC: G06F9/445 ,  G06F30/20

Abstract: A method for the lightweight extension of a data model includes first loading into memory, an extension document referencing a model document in a data analytics system. The model document defines a data model and the extension document extends the data model with at least one modification to the data model. The method then includes extracting from the extension document, the modification to the data model. Finally, the method includes creating in the memory the data model from the model document combined with the modification so as to produce an extension to the data model without processing a redeclaration of a view of the data model in the extension document.

公开(公告)号：US20210334281A1

公开(公告)日：2021-10-28

申请号：US17305387

申请日：2021-07-06

Applicant: Google LLC

Inventor： Lloyd Tabb ,  Steven Talbot

IPC: G06F16/2453 ,  G06F16/2455

Abstract: A method of computing a join pattern agnostic aggregate function includes loading source code and parsing the source code to identify different database query operations. In response to the identification of an aggregate function in one of the different database query operations in which records in multiple tables are joined together in a table join, a multiplicity of primary keys are retrieved, each corresponding to a different one of the multiple tables and also an object of one of the tables referenced by the identified aggregate function. An existence of a fan out condition associated with the table join is then computed. On condition that an existence of the fan out condition is not computed a non-fan out sensitive implementation of the aggregate function is invoked with respect to the object. But, otherwise, a different, fan-out sensitive implementation of the aggregate function is invoked with respect to the object.

公开(公告)号：US20210294987A1

公开(公告)日：2021-09-23

申请号：US16824902

申请日：2020-03-20

Applicant: Google LLC

Inventor： Andrew Leahy ,  Steven Talbot

IPC: G06F40/51 ,  G06F40/263

Abstract: Embodiments of the invention provide a method, system and computer program product for model localization. In an embodiment of the invention, a method for model localization includes parsing a model to identify translatable terms, generating a seed file associating each of the translatable terms with a corresponding tag and replacing each translatable term in the model with a corresponding tag and submitting each of the translatable terms to machine translation for a target language to produce a different translation file mapping each tag from the seed file with a translated term in the target language of a corresponding one of the translatable terms. Then, the model may be deployed in a data analytics application using the different translation file to dynamically translate each translatable term into a corresponding translated term within a user interface to the data analytics application.

公开(公告)号：US20210124781A1

公开(公告)日：2021-04-29

申请号：US16666736

申请日：2019-10-29

Applicant: Google LLC

Inventor： Lloyd Tabb ,  Steven Talbot ,  Michael Toy ,  Wil Glessler ,  Colin Zima ,  Julian Hyde

IPC: G06F16/9038 ,  G06F16/903 ,  G06F16/901

Abstract: Embodiments of the present invention provide a method, system and computer program product for single view presentation of multiple query. In an embodiment of the invention, a method for single view presentation of multiple query includes directing a query against a database along a selected dimension of multiple different elements. In response, a primary result set is received. The result set is then organized into a tabular view of cells according to the selected dimension and values for the selected dimension. Thereafter, a set of nested queries may be directed for each of the elements in the selected dimension against the result set utilizing a different dimension. In response to each directed set of nested queries, a corresponding result set is thus received. Finally, each corresponding result set is inserted into a cell associated with a common one of the elements.