公开(公告)号：US20220129506A1

公开(公告)日：2022-04-28

申请号：US17647694

申请日：2022-01-11

申请人： Google LLC

发明人： Lloyd Tabb ,  Steven Talbot ,  Michael Toy ,  Wil Gieseler ,  Colin Zima ,  Julian Hyde

IPC分类号： G06F16/9038 ,  G06F16/903 ,  G06F16/901

摘要： Embodiments of the present disclosure provide a method, system and computer program product for single view presentation of multiple query. In an embodiment of the disclosure, 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.

公开(公告)号：US11847115B2

公开(公告)日：2023-12-19

申请号：US17305387

申请日：2021-07-06

申请人： Google LLC

发明人： Lloyd Tabb ,  Steven Talbot

IPC分类号： G06F16/2453 ,  G06F16/2455

CPC分类号： G06F16/24537 ,  G06F16/24556

摘要： 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.

公开(公告)号：US20210149866A1

公开(公告)日：2021-05-20

申请号：US16690069

申请日：2019-11-20

申请人： GOOGLE LLC

发明人： Steven Talbot ,  Colin Zima

IPC分类号： G06F16/22 ,  G06F16/2457 ,  G06F16/21

摘要： Embodiments of the invention provide a novel and non-obvious method, system and computer program product for universal data index construction. In an embodiment of the invention, a universal data index construction method includes establishing a communicative coupling to a database by way of a database management system. The method additionally includes creating in an index in memory of a host computer, a union of field values in all columns of the database, with all meta-data for the columns of the database. In this regard, the index associates each of the values and each of the meta-data with a specific location in the database. The method further includes adding to the index, pair-wise field values as a co-occurrence list. Finally, the method includes issuing a query to the index without issuing a SQL WHERE statement to the database management system in order to produce a filtered query result.

公开(公告)号：US11960547B2

公开(公告)日：2024-04-16

申请号：US17647694

申请日：2022-01-11

申请人： Google LLC

发明人： Lloyd Tabb ,  Steven Talbot ,  Michael Toy ,  Wil Gieseler ,  Colin Zima ,  Julian Hyde

IPC分类号： G06F16/9038 ,  G06F16/901 ,  G06F16/903

CPC分类号： G06F16/9038 ,  G06F16/9024 ,  G06F16/90335

摘要： Embodiments of the present disclosure provide a method, system and computer program product for single view presentation of multiple query. In an embodiment of the disclosure, 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.

公开(公告)号：US20220277148A1

公开(公告)日：2022-09-01

申请号：US17663955

申请日：2022-05-18

申请人： Google LLC

发明人： Andrew Leahy ,  Steven Talbot

IPC分类号： G06F40/51 ,  G06F40/263

摘要： Implementations of the disclosure provide a method, system and computer program product for model localization. In an implementation of the disclosure, 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.

公开(公告)号：US11354518B2

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

申请号：US16824902

申请日：2020-03-20

申请人： Google LLC

发明人： Andrew Leahy ,  Steven Talbot

IPC分类号： G06F40/51 ,  G06F40/263

摘要： 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.

公开(公告)号：US12086560B2

公开(公告)日：2024-09-10

申请号：US17663955

申请日：2022-05-18

申请人： Google LLC

发明人： Andrew Leahy ,  Steven Talbot

IPC分类号： G06F40/51 ,  G06F40/263

CPC分类号： G06F40/51 ,  G06F40/263

摘要： Implementations of the disclosure provide a method, system and computer program product for model localization. In an implementation of the disclosure, 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.

公开(公告)号：US11232158B2

公开(公告)日：2022-01-25

申请号：US16666736

申请日：2019-10-29

申请人： Google LLC

发明人： Lloyd Tabb ,  Steven Talbot ,  Michael Toy ,  Wil Gieseler ,  Colin Zima ,  Julian Hyde

IPC分类号： G06F16/9038 ,  G06F16/903 ,  G06F16/901

摘要： 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.

公开(公告)号：US11080275B2

公开(公告)日：2021-08-03

申请号：US16403492

申请日：2019-05-03

申请人： Google LLC

发明人： Lloyd Tabb ,  Steven Talbot

IPC分类号： G06F16/2453 ,  G06F16/2455

摘要： 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.

公开(公告)号：US20210200791A1

公开(公告)日：2021-07-01

申请号：US16730950

申请日：2019-12-30

申请人： Google LLC

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

IPC分类号： G06F16/28 ,  G06F3/0484 ,  G06F16/25

摘要： 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.