公开(公告)号：US11775868B1

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

申请号：US17884955

申请日：2022-08-10

Applicant: Amazon Technologies, Inc.

Inventor： Sangil Song ,  Yongsik Yoon ,  Kamal Kant Gupta ,  Saileshwar Krishnamurthy ,  Stefano Stefani ,  Sudipta Sengupta ,  Jaeyun Noh

IPC: G06F7/00 ,  G06N20/00 ,  G06F16/242 ,  G06F16/2453 ,  G06N5/04

CPC classification number: G06N20/00 ,  G06F16/2433 ,  G06F16/24542 ,  G06N5/04

Abstract: Techniques for making machine learning inference calls for database query processing are described. In some embodiments, a method of making machine learning inference calls for database query processing may include generating a first batch of machine learning requests based at least on a query to be performed on data stored in a database service, wherein the query identifies a machine learning service, sending the first batch of machine learning requests to an input buffer of an asynchronous request handler, the asynchronous request handler to generate a second batch of machine learning requests based on the first batch of machine learning requests, and obtaining a plurality of machine learning responses from an output buffer of the asynchronous request handler, the machine learning responses generated by the machine learning service using a machine learning model in response to receiving the second batch of machine learning requests.

公开(公告)号：US11886439B1

公开(公告)日：2024-01-30

申请号：US16552776

申请日：2019-08-27

Applicant: Amazon Technologies, Inc.

Inventor： Sangyong Hwang ,  Aakash Ashwin Shah ,  Yongsik Yoon ,  Kamal Kant Gupta ,  Saileshwar Krishnamurthy

IPC: G06F16/2455 ,  G06F16/23 ,  G06F16/27

CPC classification number: G06F16/24568 ,  G06F16/2358 ,  G06F16/2379 ,  G06F16/24552 ,  G06F16/273

Abstract: Change data capture is performed asynchronously for direct transfer to a stream processor. When updates to a database as part of database transactions are performed, a transaction log is generated that describes the database transactions. The transaction log may be evaluated to determine indications of changes included in the database transactions. The indications of the changes may be stored in memory according to the database transactions that include the indications of the changes. When a database transaction is determined to be committed to the database, the change indications may be sent directly from the memory to the stream processor.

公开(公告)号：US11455305B1

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

申请号：US16457122

申请日：2019-06-28

Applicant: Amazon Technologies, Inc.

Inventor： Sangyong Hwang ,  Yongsik Yoon ,  Kamal Kant Gupta ,  Saileshwar Krishnamurthy

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/248 ,  G06F16/23 ,  G06F16/22

Abstract: Alternative portions of a query plan to perform a query may be selected for processing partial results of a query. A query engine may generate a plan to perform a query that includes an operation that selects between different portions of the plan according to input data. The input data may be a partial result of the query generated by the data store instead of the query engine and provided to the query engine. The input data may be an individual item of the data set that is modified to a different version within a consistent view of the data set for the query.

公开(公告)号：US11106667B1

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

申请号：US15871868

申请日：2018-01-15

Applicant: Amazon Technologies, Inc.

Inventor： Yongsik Yoon ,  Gopi Krishna Attaluri ,  Kamal Kant Gupta ,  Yingjie He ,  Saileshwar Krishnamurthy

IPC: G06F7/00 ,  G06F16/2453 ,  G06F3/06 ,  G06F16/22 ,  G06F16/23

Abstract: Transactional scans of portions of a database may be performed. When a query is received that causes a scan of a database, different portions of the database may be scanned within separate transactions. Operations applicable to perform the scan the records of the different portions of the database may be invoked once within the transactions instead of invoking the operations individually for each of the records in the different portions. Results of the query based on the scanned portions may then be provided in response to the query.

公开(公告)号：US11860869B1

公开(公告)日：2024-01-02

申请号：US16457154

申请日：2019-06-28

Applicant: Amazon Technologies, Inc.

Inventor： Sangyong Hwang ,  Justin Levandoski ,  Yongsik Yoon ,  Kamal Kant Gupta ,  Saileshwar Krishnamurthy ,  Ippokratis Pandis ,  Michail Petropoulos

IPC: G06F16/2453 ,  G06F16/23 ,  G06F16/25

CPC classification number: G06F16/24542 ,  G06F16/2379 ,  G06F16/254

Abstract: Queries to a consistent view of a data set across different types of query engines are performed. Portions of a query received at a first type of query engine that can be performed at a different type of a query engine can be identified. A consistent view of a data set stored in a common data store can be provided by the first type of query engine to the second query engine. When the different type of query engine performs the portion of the query, the different type of query engine applies the consistent view of the data set. A result for the query can be returned by the first type of query engine based on results from the different type of query engine.

公开(公告)号：US11449796B2

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

申请号：US16578060

申请日：2019-09-20

Applicant: Amazon Technologies, Inc.

Inventor： Sangil Song ,  Yongsik Yoon ,  Kamal Kant Gupta ,  Saileshwar Krishnamurthy ,  Stefano Stefani ,  Sudipta Sengupta ,  Jaeyun Noh

IPC: G06F7/00 ,  G06N20/00 ,  G06F16/242 ,  G06F16/2453 ,  G06N5/04

Abstract: Techniques for making machine learning inference calls for database query processing are described. In some embodiments, a method of making machine learning inference calls for database query processing may include generating a first batch of machine learning requests based at least on a query to be performed on data stored in a database service, wherein the query identifies a machine learning service, sending the first batch of machine learning requests to an input buffer of an asynchronous request handler, the asynchronous request handler to generate a second batch of machine learning requests based on the first batch of machine learning requests, and obtaining a plurality of machine learning responses from an output buffer of the asynchronous request handler, the machine learning responses generated by the machine learning service using a machine learning model in response to receiving the second batch of machine learning requests.

公开(公告)号：US11256695B1

公开(公告)日：2022-02-22

申请号：US15922490

申请日：2018-03-15

Applicant: Amazon Technologies, Inc.

Inventor： Yingjie He ,  Gopi Krishna Attaluri ,  Kamal Kant Gupta ,  Saileshwar Krishnamurthy ,  Yongsik Yoon

IPC: G06F16/20 ,  G06F16/2453 ,  G06F16/28 ,  G06F16/25 ,  G06F16/22

Abstract: A hybrid query engine using different query engines may be implemented to provide access to a database. A database query to a database may be received at a hybrid query engine. A plan to perform the database query may be generated that when performed by the hybrid query engine causes one query engine to perform an assigned portion of the plan by accessing data that describes the database. Another portion of the plan assigned to another query engine may be performed by the hybrid query engine to cause the other query engine to perform the other portion of the plan by accessing the same data that describes the database.