公开(公告)号：US11934392B2

公开(公告)日：2024-03-19

申请号：US17344880

申请日：2021-06-10

申请人： Alation, Inc.

发明人： Joachim Rahmfeld ,  Jennifer Wu

IPC分类号： G06F16/00 ,  G06F16/21 ,  G06F16/242 ,  G06F16/2455 ,  G06F16/248 ,  G10L15/08 ,  G10L15/22

CPC分类号： G06F16/243 ,  G06F16/212 ,  G06F16/2455 ,  G06F16/248 ,  G10L15/08 ,  G10L15/22

摘要： A method for querying and analyzing datasets via natural language processing (NLP) with context propagation is disclosed. In one embodiment, a computer-implemented method includes receiving, by a user interface, at least one of an utterance or a structured query language statement. The method includes identifying zero or more previous data conversation steps indicated by the utterance. The method includes determining an effective schema targeted by the utterance. The method includes generating, based on the utterance and the effective schema, an intermediate structured query language statement that is representative of the utterance. The method includes generating an executable structured query language statement based on the intermediate structured query language statement and zero or more previous structured query language statements. The method includes executing the executable structured query language statement for the data query engine schema. The method includes communicating, via the user interface, a result set and metadata.

公开(公告)号：US09244952B2

公开(公告)日：2016-01-26

申请号：US14058208

申请日：2013-10-18

申请人： Venkatesh Ganti ,  Aaron Kalb ,  Feng Niu ,  Satyen Sangani

发明人： Venkatesh Ganti ,  Aaron Kalb ,  Feng Niu ,  Satyen Sangani

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30554 ,  G06F17/30292 ,  G06F17/30309 ,  G06F17/30646

摘要： Disclosed are a method, a device and/or a system of editable and searchable markup pages automatically populated through query monitoring of users of a database. In one aspect, a method includes automatically generating an editable markup page and/or a page name based on an initial query of a database using a processor and a memory, associating the generated markup page with a user of the database, and appending information to the editable markup page based on a similar query of the database by another user. The method may include permitting other users of the database to access, modify, append, and/or delete entries from the editable mark-up page.

摘要翻译： 公开了通过对数据库的用户的查询监视自动填充的可编辑和可搜索的标记页面的方法，设备和/或系统。 一方面，一种方法包括使用处理器和存储器，基于使用处理器和存储器的数据库的初始查询来自动生成可编辑标记页和/或页名，将生成的标记页与数据库的用户相关联，并将信息附加到 可编辑的标记页面基于另一个用户对数据库的类似查询。 该方法可以包括允许数据库的其他用户从可编辑标记页面访问，修改，附加和/或删除条目。

公开(公告)号：US20210103594A1

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

申请号：US17003884

申请日：2020-08-26

申请人： ALATION INC.

发明人： Sergey ASTRETSOV ,  David CRAWFORD ,  Venkatesh GANTI ,  Aaron KALB ,  Jake MAGNER ,  Minjoon PARK ,  Satyen SANGANI

IPC分类号： G06F16/2457 ,  G06F16/2453 ,  G06F16/332

摘要： A computer-implemented method and system for searching over queries, writing and performing a data query. The computer-implemented method includes analyzing the query to understand elements described in the query. Further, the computer-implemented method includes extracting aliases for expressions to identify alternate names. Furthermore, the computer-implemented method includes allowing a user to annotate the elements. Moreover, the computer-implemented method includes establishing whether the query contains content for defining a new query, and if so, then enables writing a query according to a shorthand system.

公开(公告)号：US12013850B2

公开(公告)日：2024-06-18

申请号：US17344887

申请日：2021-06-10

申请人： Alation, Inc.

发明人： Joachim Rahmfeld ,  Jennifer Wu

IPC分类号： G06F16/2452 ,  G06F16/21 ,  G06F16/242 ,  G06F16/26 ,  G06F16/28 ,  G06F40/284 ,  G06F40/30

CPC分类号： G06F16/24522 ,  G06F16/213 ,  G06F16/243 ,  G06F16/26 ,  G06F16/288 ,  G06F40/284 ,  G06F40/30

摘要： A method for querying and analyzing datasets via natural language processing (NLP) that can maintain context is disclosed. According to one embodiment, a computer-implemented method includes receiving, by a user interface, at least one of an utterance or a structured query language statement. The method includes identifying zero or more previous data conversation steps indicated by the utterance. The method includes determining, based on the utterance and the zero or more previous data conversation steps, an effective schema targeted by the utterance. The method includes generating, based on the utterance and the effective schema, an intermediate structured query language statement that is representative of the utterance. The method includes generating an executable structured query language statement based on the intermediate structured query language statement. The method includes executing the executable structured query language statement for the data query engine schema. The method includes communicating a result set and metadata.

公开(公告)号：US20240184777A1

公开(公告)日：2024-06-06

申请号：US18437031

申请日：2024-02-08

申请人： Alation, Inc.

发明人： Joachim Rahmfeld ,  Jennifer Wu

IPC分类号： G06F16/242 ,  G06F16/21 ,  G06F16/2455 ,  G06F16/248 ,  G10L15/08 ,  G10L15/22

CPC分类号： G06F16/243 ,  G06F16/212 ,  G06F16/2455 ,  G06F16/248 ,  G10L15/08 ,  G10L15/22

摘要： A method for querying and analyzing datasets via natural language processing (NLP) with context propagation is disclosed. In one embodiment, a computer-implemented method includes receiving, by a user interface, at least one of an utterance or a structured query language statement. The method includes identifying zero or more previous data conversation steps indicated by the utterance. The method includes determining an effective schema targeted by the utterance. The method includes generating, based on the utterance and the effective schema, an intermediate structured query language statement that is representative of the utterance. The method includes generating an executable structured query language statement based on the intermediate structured query language statement and zero or more previous structured query language statements. The method includes executing the executable structured query language statement for the data query engine schema. The method includes communicating, via the user interface, a result set and metadata.

公开(公告)号：US11468072B2

公开(公告)日：2022-10-11

申请号：US17003884

申请日：2020-08-26

申请人： ALATION INC.

发明人： Sergey Astretsov ,  David Crawford ,  Venkatesh Ganti ,  Aaron Kalb ,  Jake Magner ,  Minjoon Park ,  Satyen Sangani

IPC分类号： G06F16/2457 ,  G06F16/2453 ,  G06F16/332

摘要： A computer-implemented method and system for searching over queries, writing and performing a data query. The computer-implemented method includes analyzing the query to understand elements described in the query. Further, the computer-implemented method includes extracting aliases for expressions to identify alternate names. Furthermore, the computer-implemented method includes allowing a user to annotate the elements. Moreover, the computer-implemented method includes establishing whether the query contains content for defining a new query, and if so, then enables writing a query according to a shorthand system.

公开(公告)号：US10776366B1

公开(公告)日：2020-09-15

申请号：US15164318

申请日：2016-05-25

申请人： ALATION INC.

发明人： Sergey Astretsov ,  David Crawford ,  Venkatesh Ganti ,  Aaron Kalb ,  Jake Magner ,  Minjoon Park ,  Satyen Sangani

IPC分类号： G06F16/2457 ,  G06F16/2453 ,  G06F16/332

摘要： A computer-implemented method and system for searching over queries, writing and performing a data query. The computer-implemented method includes analyzing the query to understand elements described in the query. Further, the computer-implemented method includes extracting aliases for expressions to identify alternate names. Furthermore, the computer-implemented method includes allowing a user to annotate the elements. Moreover, the computer-implemented method includes establishing whether the query contains content for defining a new query, and if so, then enables writing a query according to a shorthand system.

公开(公告)号：US08996559B2

公开(公告)日：2015-03-31

申请号：US14058184

申请日：2013-10-18

申请人： Venkatesh Ganti ,  Aaron Kalb ,  Feng Niu ,  Satyen Sangani

发明人： Venkatesh Ganti ,  Aaron Kalb ,  Feng Niu ,  Satyen Sangani

IPC分类号： G06F17/30

CPC分类号： G06F17/30554 ,  G06F17/30292 ,  G06F17/30309 ,  G06F17/30646

摘要： Disclosed are a method, a device and/or a system of assisted query formation, validation, and result previewing in a database having a complex schema. In one aspect, a method of a query editor includes generating a data profile which includes a set of characteristics captured at various granularities of an initial result set generated from an initial query using a processor and a memory. The method determines what a user expects in the initial result set of the initial query and/or a subsequent result set of a subsequent query based on the data profile and/or a heuristically estimated data profile. The method includes enabling the user to evaluate a semantic accuracy of the subsequent query based on the likely expectation of the user as determined through the set of characteristics of the data profile. The set of characteristics may include metadata of the initial query.

公开(公告)号：US08965915B2

公开(公告)日：2015-02-24

申请号：US14058189

申请日：2013-10-18

申请人： Venkatesh Ganti ,  Aaron Kalb ,  Feng Niu ,  Satyen Sangani

发明人： Venkatesh Ganti ,  Aaron Kalb ,  Feng Niu ,  Satyen Sangani

IPC分类号： G06F17/30

CPC分类号： G06F17/30554 ,  G06F17/30292 ,  G06F17/30309 ,  G06F17/30646

摘要： Disclosed are a method, a device and/or a system of assisted query formation, validation, and result previewing in a database having a complex schema. In one aspect, a method of a query editor includes generating a data profile which includes a set of characteristics captured at various granularities of an initial result set generated from an initial query using a processor and a memory. The method determines what a user expects in the initial result set of the initial query and/or a subsequent result set of a subsequent query based on the data profile and/or a heuristically estimated data profile. The method includes enabling the user to evaluate a semantic accuracy of the subsequent query based on the likely expectation of the user as determined through the set of characteristics of the data profile. The set of characteristics may include metadata of the initial query.

摘要翻译： 公开了具有复杂模式的数据库中的辅助查询形成，验证和结果预览的方法，设备和/或系统。 一方面，一种查询编辑器的方法包括生成数据简档，其包括使用处理器和存储器从初始查询生成的初始结果集的各种粒度捕获的一组特征。 该方法基于数​​据简档和/或启发式估计的数据简档确定初始查询的初始结果集中的用户期望值和/或后续查询的后续结果集。 该方法包括使得用户能够基于通过数据简档的特征集确定的用户的可能期望来评估后续查询的语义准确性。 该特征集可以包括初始查询的元数据。

公开(公告)号：US08935272B2

公开(公告)日：2015-01-13

申请号：US14058206

申请日：2013-10-18

申请人： Venkatesh Ganti ,  Aaron Kalb ,  Feng Niu ,  Satyen Sangani

发明人： Venkatesh Ganti ,  Aaron Kalb ,  Feng Niu ,  Satyen Sangani

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30554 ,  G06F17/30292 ,  G06F17/30309 ,  G06F17/30646

摘要： In one embodiment, a method of a curated answers system includes automatically populating a profile markup page of a user with information describing an initial query of a database that the user has generated using a processor and a memory, determining that another user of the database has submitted a similar query that is semantically proximate to the initial query of the database that the user has generated, and presenting the profile markup page of the user to the other user. The method of the curated answers system may include enabling the other user to communicate with the user through a communication channel on the profile markup page. A question of the other user may be published to the user on the profile markup page of the user, and/or other profile markup page of the other user. The question may be associated as being posted by the other user.

摘要翻译： 在一个实施例中，策展答案系统的方法包括使用描述用户使用处理器和存储器生成的数据库的初始查询的信息自动填充用户的简档标记页面，确定数据库的另一用户具有 提交了与用户已经生成的数据库的初始查询语义上接近的类似查询，并将用户的简档标记页面呈现给另一个用户。 策展答案系统的方法可以包括允许其他用户通过简档标记页面上的通信通道与用户通信。 可以在用户的​​简档标记页面和/或其他用户的其他简档标记页面上向用户发布另一用户的问题。 该问题可能会被另一个用户发布。