-
公开(公告)号：US20240004860A1
公开(公告)日：2024-01-04
申请号：US17810312
申请日：2022-06-30
Applicant: Amazon Technologies, Inc.
Inventor： Gokul Soundararajan , Gopal Paliwal , Punit Rajgaria , Sanuj Basu
IPC: G06F16/23 , G06F16/22 , G06F16/242
CPC classification number: G06F16/2358 , G06F16/2433 , G06F16/2282
Abstract: Methods for negotiating parameters for maintaining, at an analytical database, a replica of a transactional table, stored at a transactional database, are disclosed. By establishing parameters of said maintenance prior to commencing, the transactional database and the analytical database may remain only loosely coupled after completing the negotiation. The parameters of the negotiation may be stored in a location that is accessible to both the transactional database and the analytical database, such that the results of the negotiation may be accessed during the process of maintaining the replica. The negotiation may include a procedure to provide portions of a change-data-capture log, associated to the transactional table, to the analytical database via a transport mechanism such that the replica may be updated, in addition to a list of agreed upon data definition language commands that may be used in the portions of the change-data-capture log.
-
公开(公告)号：US11818012B2
公开(公告)日：2023-11-14
申请号：US17810195
申请日：2022-06-30
Applicant: Amazon Technologies, Inc.
Inventor： Krishna Chaitanya Gudipati , Sanjay Wangoo , Fabian Oliver Nagel , Ippokratis Pandis , Gokul Soundararajan , Aditya Subrahmanyan , Induja Sreekanthan , Yao Xiao , Ankil Shah , Yehan Zhang , Siyi Zhang , Vaishali Ravindra Narkhede , Naresh Chainani
CPC classification number: H04L41/12 , G06F11/1464 , G06F11/1469 , G06F2201/80
Abstract: Online restore may be performed between databases with different topologies while applying a custom data distribution. A request to restore a database into a different topology of nodes may be received. A plan to move different portions of the database from a current topology to the new topology made using a general distribution scheme. The plan may be performed to move the different portions of the database into the new topology and the database made available for access using the new topology. A background process may be applied to modify the distribution of the database at the new topology to match a custom distribution scheme that was implemented at the current topology.
-
公开(公告)号：US12277138B2
公开(公告)日：2025-04-15
申请号：US17810314
申请日：2022-06-30
Applicant: Amazon Technologies, Inc.
Inventor： Ippokratis Pandis , Gokul Soundararajan , Gopal Paliwal , Punit Rajgaria , Sanuj Basu , Todd Jeffrey Green , Gaurav Saxena , Vadim Skipin , Johannes Wust , Hemanth Satyanarayana , Matthew Perry Abrams , Murali Brahmadesam
Abstract: Methods for replicating transactional tables of a transactional database to an analytical database and maintaining updates to those transactional table representations are disclosed. Snapshots of the transactional tables are provided to the analytical database via a transport mechanism, such as a data storage service or a data streaming service, and stored at the analytical database. Then, checkpoints comprising portions of a change-data-capture log that has recorded transactional changes to the transactional tables of the transactional database are provided to the analytical database via the same or different transport mechanism and used to commit those transactional changes to the snapshot representations. The snapshot representations may be used to respond to incoming analytical queries in order to provide real-time querying results.
-
公开(公告)号：US12007983B2
公开(公告)日：2024-06-11
申请号：US17810318
申请日：2022-06-30
Applicant: Amazon Technologies, Inc.
Inventor： Ippokratis Pandis , Gokul Soundararajan , Gopal Paliwal , Vadim Skipin , Sanuj Basu
CPC classification number: G06F16/2379 , G06F16/2358 , G06F16/254
Abstract: Methods for implementing insert, update, and delete events of a change-data-capture log in transactional order to a representation of a transactional table are disclosed. Insert events may be applied and committed to the representation, while delete events may be buffered and committed to a shadow table. Such buffering may allow the delete events to be applied and committed as a batch to the given representation as a later background operation, allowing for an optimized application of the change-data-capture log to the representation. Once the delete events are committed to the representation, they are removed from the shadow table. Update events may be similarly treated in which the insert event component of the update event is applied and committed to the representation while the delete event component is committed to the shadow table, before being later committed to the representation and removed from the shadow table.
-
公开(公告)号：US12093239B2
公开(公告)日：2024-09-17
申请号：US17810312
申请日：2022-06-30
Applicant: Amazon Technologies, Inc.
Inventor： Gokul Soundararajan , Gopal Paliwal , Punit Rajgaria , Sanuj Basu
IPC: G06F16/23 , G06F16/22 , G06F16/242
CPC classification number: G06F16/2358 , G06F16/2282 , G06F16/2433
Abstract: Methods for negotiating parameters for maintaining, at an analytical database, a replica of a transactional table, stored at a transactional database, are disclosed. By establishing parameters of said maintenance prior to commencing, the transactional database and the analytical database may remain only loosely coupled after completing the negotiation. The parameters of the negotiation may be stored in a location that is accessible to both the transactional database and the analytical database, such that the results of the negotiation may be accessed during the process of maintaining the replica. The negotiation may include a procedure to provide portions of a change-data-capture log, associated to the transactional table, to the analytical database via a transport mechanism such that the replica may be updated, in addition to a list of agreed upon data definition language commands that may be used in the portions of the change-data-capture log.
-
Patent Agency Ranking
6.发明公开公开(公告)号：US20240004897A1
公开(公告)日：2024-01-04
申请号：US17810314
申请日：2022-06-30
Applicant: Amazon Technologies, Inc.
Inventor： Ippokratis Pandis , Gokul Soundararajan , Gopal Paliwal , Punit Rajgaria , Sanuj Basu , Todd Jeffrey Green , Gaurav Saxena , Vadim Skipin , Johannes Wust , Hemanth Satyanarayana , Matthew Perry Abrams , Murali Brahmadesam
CPC classification number: G06F16/27 , G06F16/25 , G06F16/283 , G06F16/2379
Abstract: Methods for replicating transactional tables of a transactional database to an analytical database and maintaining updates to those transactional table representations are disclosed. Snapshots of the transactional tables are provided to the analytical database via a transport mechanism, such as a data storage service or a data streaming service, and stored at the analytical database. Then, checkpoints comprising portions of a change-data-capture log that has recorded transactional changes to the transactional tables of the transactional database are provided to the analytical database via the same or different transport mechanism and used to commit those transactional changes to the snapshot representations. The snapshot representations may be used to respond to incoming analytical queries in order to provide real-time querying results.
-
7.发明公开公开(公告)号：US20240004867A1
公开(公告)日：2024-01-04
申请号：US17810318
申请日：2022-06-30
Applicant: Amazon Technologies, Inc.
Inventor： Ippokratis Pandis , Gokul Soundararajan , Gopal Paliwal , Vadim Skipin , Sanuj Basu
CPC classification number: G06F16/2379 , G06F16/254 , G06F16/2358
Abstract: Methods for implementing insert, update, and delete events of a change-data-capture log in transactional order to a representation of a transactional table are disclosed. Insert events may be applied and committed to the representation, while delete events may be buffered and committed to a shadow table. Such buffering may allow the delete events to be applied and committed as a batch to the given representation as a later background operation, allowing for an optimized application of the change-data-capture log to the representation. Once the delete events are committed to the representation, they are removed from the shadow table. Update events may be similarly treated in which the insert event component of the update event is applied and committed to the representation while the delete event component is committed to the shadow table, before being later committed to the representation and removed from the shadow table.
-
公开(公告)号：US20230171163A1
公开(公告)日：2023-06-01
申请号：US17810195
申请日：2022-06-30
Applicant: Amazon Technologies, Inc.
Inventor： Krishna Chaitanya Gudipati , Sanjay Wangoo , Fabian Oliver Nagel , Ippokratis Pandis , Gokul Soundararajan , Aditya Subrahmanyan , Induja Sreekanthan , Yao Xiao , Ankil Shah , Yehan Zhang , Siyi Zhang , Vaishali Ravindra Narkhede , Naresh Chainani
CPC classification number: H04L41/12 , G06F11/1469 , G06F11/1464 , G06F2201/80
Abstract: Online restore may be performed between databases with different topologies while applying a custom data distribution. A request to restore a database into a different topology of nodes may be received. A plan to move different portions of the database from a current topology to the new topology made using a general distribution scheme. The plan may be performed to move the different portions of the database into the new topology and the database made available for access using the new topology. A background process may be applied to modify the distribution of the database at the new topology to match a custom distribution scheme that was implemented at the current topology.
-
公开(公告)号：US11636124B1
公开(公告)日：2023-04-25
申请号：US17105201
申请日：2020-11-25
Applicant: Amazon Technologies, Inc.
Inventor： Balakrishnan Narayanaswamy , Gokul Soundararajan , Jiayuan Chen , Yannis Papakonstantinou , Vuk Ercegovac , George Constantin Caragea , Sriram Krishnamurthy , Nikolaos Koulouris
IPC: G06F16/00 , G06F16/2458 , G06F16/2453 , G06K9/62 , G06N20/00 , G06F16/28
Abstract: A database system may include a machine learning model which may be used to perform various data analytics for data stored in the database system. In response to a request to invoke the machine learning model to generate a prediction from data stored in the database system, the database system may perform one or more optimization operations, as part of a query plan, to prepare the data to make it suitable for use by the machine learning model.
-
公开(公告)号：US11657069B1
公开(公告)日：2023-05-23
申请号：US17105214
申请日：2020-11-25
Applicant: Amazon Technologies, Inc.
Inventor： Balakrishnan Narayanaswamy , Gokul Soundararajan , Jiayuan Chen , Yannis Papakonstantinou , Vuk Ercegovac , George Constantin Caragea , Sriram Krishnamurthy , Nikolaos Koulouris
IPC: G06F16/28 , G06F16/24 , G06F16/2458 , G06N20/00 , G06F16/2453 , G06F8/41
CPC classification number: G06F16/283 , G06F8/447 , G06F16/2465 , G06F16/2471 , G06F16/24535 , G06F16/24542 , G06N20/00
Abstract: A database system may use a machine learning model creation system to create a machine learning model from data stored in the database system responsive to a request from a client. The database system may obtain an executable version of the machine learning model, based on an uncompiled hardware agnostic version of the machine learning model, according to the hardware configuration of one or more computing resources selected by the database system to perform requests to the database system that invoke the machine learning model to generate predictions.
-
-
-
-
-
-
-
-
-
Search Results
10
records
(took 0.022 seconds)
