Patents Assigned to Alation, Inc.
  • Patent number: 11934392
    Abstract: 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.
    Type: Grant
    Filed: June 10, 2021
    Date of Patent: March 19, 2024
    Assignee: Alation, Inc.
    Inventors: Joachim Rahmfeld, Jennifer Wu
  • Patent number: 11468072
    Abstract: 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.
    Type: Grant
    Filed: August 26, 2020
    Date of Patent: October 11, 2022
    Assignee: Alation Inc.
    Inventors: Sergey Astretsov, David Crawford, Venkatesh Ganti, Aaron Kalb, Jake Magner, Minjoon Park, Satyen Sangani
  • Patent number: 10776366
    Abstract: 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.
    Type: Grant
    Filed: May 25, 2016
    Date of Patent: September 15, 2020
    Assignee: Alation Inc.
    Inventors: Sergey Astretsov, David Crawford, Venkatesh Ganti, Aaron Kalb, Jake Magner, Minjoon Park, Satyen Sangani
  • Patent number: 9244952
    Abstract: 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.
    Type: Grant
    Filed: October 18, 2013
    Date of Patent: January 26, 2016
    Assignee: ALATION, INC.
    Inventors: Venkatesh Ganti, Aaron Kalb, Feng Niu, Satyen Sangani
  • Patent number: 8996559
    Abstract: 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.
    Type: Grant
    Filed: October 18, 2013
    Date of Patent: March 31, 2015
    Assignee: Alation, Inc.
    Inventors: Venkatesh Ganti, Aaron Kalb, Feng Niu, Satyen Sangani
  • Patent number: 8965915
    Abstract: 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.
    Type: Grant
    Filed: October 18, 2013
    Date of Patent: February 24, 2015
    Assignee: Alation, Inc.
    Inventors: Venkatesh Ganti, Aaron Kalb, Feng Niu, Satyen Sangani
  • Patent number: 8935272
    Abstract: 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.
    Type: Grant
    Filed: October 18, 2013
    Date of Patent: January 13, 2015
    Assignee: Alation, Inc.
    Inventors: Venkatesh Ganti, Aaron Kalb, Feng Niu, Satyen Sangani