-
公开(公告)号：US20220382796A1
公开(公告)日：2022-12-01
申请号：US17818328
申请日：2022-08-08
Applicant: Amazon Technologies, Inc.
Inventor： Murali Brahmadesam , Raman Mittal , Yuri Volobuev , Li-Che Hsiao , Punit Rajgaria
Abstract: Direct storage loading may be used to add data to a database. New data may be added to a database, using nodes different than a database engine to access a database. The addition of the new data may be assigned to different nodes. The nodes may obtain the data and store the data to storage locations according allocated space in the database by the database engine. The new data can then be made available for access at the database engine.
-
公开(公告)号：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.
-
公开(公告)号：US11409781B1
公开(公告)日：2022-08-09
申请号：US16588974
申请日：2019-09-30
Applicant: Amazon Technologies, Inc.
Inventor： Murali Brahmadesam , Raman Mittal , Yuri Volobuev , Li-Che Hsiao , Punit Rajgaria
Abstract: Direct storage loading may be used to add data to a database. New data may be added to a database, using nodes different than a database engine to access a database. The addition of the new data may be assigned to different nodes. The nodes may obtain the data and store the data to storage locations according allocated space in the database by the database engine. The new data can then be made available for access at the database engine.
-
公开(公告)号：US11914571B1
公开(公告)日：2024-02-27
申请号：US15926983
申请日：2018-03-20
Applicant: Amazon Technologies, Inc.
Inventor： Xiaofeng Bao , Murali Brahmadesam , Yi Ding , Niket Goel , Anurag Windlass Gupta , Kamal Kant Gupta , Changan Han , Tiffany Jianto , Tengiz Kharatishvili , Saileshwar Krishnamurthy , Bohan Liu , Saleem Mohideen , Punit Rajgaria , Joseph Andrew Tucek , Alexandre Olegovich Verbitski
IPC: G06F16/23 , G06F16/17 , G06F16/176
CPC classification number: G06F16/2315 , G06F16/1734 , G06F16/1767
Abstract: Optimistic concurrency may be implemented for multiple writers to a database. Writes to a database from different writers may succeed unless a conflict is detected at the data store for the database. For detected conflicts, a request to resolve the conflict between writes may be submitted to a primary writer, which may determine and provide a resolution of the conflict to the conflicting writers. The data store may then be updated to commit the selected write identified by the resolution of the conflict.
-
公开(公告)号：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.
-
Patent Agency Ranking
公开(公告)号：US11741144B2
公开(公告)日：2023-08-29
申请号：US17818328
申请日：2022-08-08
Applicant: Amazon Technologies, Inc.
Inventor： Murali Brahmadesam , Raman Mittal , Yuri Volobuev , Li-Che Hsiao , Punit Rajgaria
CPC classification number: G06F16/353 , G06F16/13 , G06F16/1827 , G06F16/254 , G06F16/316 , G06F16/86 , G06F16/258
Abstract: Direct storage loading may be used to add data to a database. New data may be added to a database, using nodes different than a database engine to access a database. The addition of the new data may be assigned to different nodes. The nodes may obtain the data and store the data to storage locations according allocated space in the database by the database engine. The new data can then be made available for access at the database engine.
-
公开(公告)号：US11455290B1
公开(公告)日：2022-09-27
申请号：US16915332
申请日：2020-06-29
Applicant: Amazon Technologies, Inc.
Inventor： Murali Brahmadesam , Nanda Kaushik , Changan Han , Kartikey Bhatt , Sangyong Hwang , Punit Rajgaria
Abstract: Techniques for distributed database storage utilizing split volume types for redo log records and change log records are described. A database engine sends redo log data to a first set of page storage nodes and change log data to a second set of tuple storage nodes, where the change log data is stored in an indexed manner Client access to change log data may be provided through a separate set of streaming storage servers instead of through the database engine.
-
公开(公告)号：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.
-
公开(公告)号：US11966411B1
公开(公告)日：2024-04-23
申请号：US17931281
申请日：2022-09-12
Applicant: Amazon Technologies, Inc.
Inventor： Punit Rajgaria , Murali Brahmadesam
CPC classification number: G06F16/254 , G06F16/213 , G06F16/2358
Abstract: Techniques for change data capture (CDC) log augmentation are described. In some examples, a user configures CDC log augmentation by indicating which data should be included in a CDC log, and the database, when generating a CDC log associated with this configuration, can obtain the associated data and augment the CDC log by inserting this data into it. The augmented data can include one or more fields from a record in a separate database table, where the record can be identified based on the changed record represented by the CDC log.
-
10.发明公开公开(公告)号：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.
-
-
-
-
-
-
-
-
-
Search Results
11
records
(took 0.018 seconds)
