-
公开(公告)号:US20240184776A1
公开(公告)日:2024-06-06
申请号:US18072806
申请日:2022-12-01
Applicant: AMADEUS S.A.S.
Inventor: Olivier AMADIEU , Yannick DEVAUX , Jean-Marie CAZORLA
CPC classification number: G06F16/2393 , G06F16/219 , G06F16/235
Abstract: A device, system and method for reducing bandwidth usage by performing provider object adjustments at an intermediation server based on historical data is provided. A computing device (e.g. an intermediation server): maintains historical provider object data representing differences between provider objects generated by a provider system/systems according to first and second standard types; receives, from a client device, a request for a provider object representing at least one item provided by a provider system; retrieves, from one or more memories, the provider object generated according to the first standard type; adjusts, the provider object, generated according to the first standard type, based on the historical provider object data, such that the adjusted provider object, includes estimates of information provided by the provider system when the provider system generates the provider objects according to the second standard type; and provides, to the client device, the adjusted provider object.
-
公开(公告)号:US11995081B2
公开(公告)日:2024-05-28
申请号:US17127845
申请日:2020-12-18
Applicant: Oracle International Corporation
Inventor: Murali Thiyagarajan , Praveen T. J. Kumar
IPC: G06F16/2453 , G06F16/23 , G06F16/248 , G06F18/214 , G06F18/24
CPC classification number: G06F16/24539 , G06F16/2358 , G06F16/2393 , G06F16/248 , G06F18/2148 , G06F18/24765
Abstract: Techniques for a database management system to predict when in the future a materialized view will be used for query rewrite. This is a followed by an approach that uses the quiet rewrite pattern prediction to determine an optimized schedule for refreshing the materialized view. The approach combines the query rewrite pattern prediction with a quiet period prediction for the materialized view and an estimated refresh duration for the materialized view to determine the optimized refresh schedule for the materialized view.
-
公开(公告)号:US20240168949A1
公开(公告)日:2024-05-23
申请号:US18426173
申请日:2024-01-29
Applicant: Oracle International Corporation
Inventor: Murali Thiyagarajan , Praveen T.J. Kumar
IPC: G06F16/2453 , G06F16/23 , G06F16/248 , G06F18/214 , G06F18/24
CPC classification number: G06F16/24539 , G06F16/2358 , G06F16/2393 , G06F16/248 , G06F18/2148 , G06F18/24765
Abstract: Techniques for a database management system to predict when in the future a materialized view will have a quiet period during which the materialized view will not be stale. This is a followed by an approach that uses the quiet period prediction to determine an optimized schedule for refreshing the materialized view. The approach combines the quiet period prediction with a query rewrite pattern prediction for the materialized view and an estimated refresh duration for the materialized view to determine the optimized refresh schedule for the materialized view.
-
公开(公告)号:US20240111762A1
公开(公告)日:2024-04-04
申请号:US18526666
申请日:2023-12-01
Applicant: Snowflake Inc.
Inventor: Subramanian Muralidhar , Benoit Dageville , Thierry Cruanes , Nileema Shingte , Saurin Shah , Torsten Grabs , Istvan Cseri
IPC: G06F16/242 , G06F3/06 , G06F9/54 , G06F16/16 , G06F16/22 , G06F16/23 , G06F16/2455 , G06F16/25
CPC classification number: G06F16/2423 , G06F3/0605 , G06F3/0644 , G06F3/0653 , G06F3/067 , G06F9/542 , G06F16/164 , G06F16/2282 , G06F16/2358 , G06F16/2393 , G06F16/24557 , G06F16/256
Abstract: Disclosed herein are systems and methods for efficiently querying external tables. In an embodiment, a database platform receives a query that is directed at least in part to external data in an external table stored on a data storage platform that is external to the database platform. The external table includes a plurality of partitions. The database platform identifies, from external-table metadata, a subset of the plurality of partitions of the external table as including data that potentially satisfies the query. The external-table metadata is stored by the database platform. The database platform identifies data that satisfies the query by scanning the identified subset of the partitions, and responds to the query at least in part with the identified data that satisfies the query.
-
公开(公告)号:US20240111761A1
公开(公告)日:2024-04-04
申请号:US18540797
申请日:2023-12-14
Inventor: Sunitha Garapati , Venu Madhav Valluri , Brent Giosta , Jennifer Pearsall , Ryan M. Kroutil
IPC: G06F16/23 , G06F3/0482 , G06F3/0484 , G06F16/2458 , G06F16/25 , G06F16/26 , G06F16/28
CPC classification number: G06F16/2393 , G06F3/0482 , G06F3/0484 , G06F16/2379 , G06F16/2465 , G06F16/252 , G06F16/254 , G06F16/26 , G06F16/287 , G06F2203/04803
Abstract: A big-data view integration platform generates integration guided user interfaces (GUIs). A first edge node ingests push-based and pull-based data from a plurality of platform services, which include legacy and non-legacy services having incompatible communication protocols. An event-based queue receives from the first edge node a plurality of queue events as indirect push-based data. A second set of queue events includes direct push-based data as received directly from a non-legacy platform service. A conformity component integrates the push-based data, the pull-based data, and the plurality of queue events into integration data having an enhanced integration format. A view integration component generates a plurality of data views from the integration data. A second edge node exposes the plurality of data views via an access services application programming interface (API). A new service execution component accesses the access services API to generate integration GUIs based on the data views.
-
公开(公告)号:US11874828B2
公开(公告)日:2024-01-16
申请号:US17466347
申请日:2021-09-03
Applicant: Amazon Technologies, Inc.
Inventor: Rohan Deshpande , Yannis Papakonstantinou , Omer Ahmed Zaki , Karthik Gurumoorthy Subramanya Bharathy , Rajib Dugar , Shivateja Reddy Ummenthala
IPC: G06F16/23 , G06F16/21 , G06F16/242
CPC classification number: G06F16/2393 , G06F16/219 , G06F16/2445
Abstract: Managed materialized views may be generated from across heterogeneous data sources. A request to create a materialized view may be received and performed by a materialized view management platform, which may obtain and generate the materialized view from different data sources and store the materialized view in a target system. Changes to the data sources may be obtained at the materialized view management platform and updates to the materialized view may be determined. The materialized view in the target system may be updated.
-
公开(公告)号:US20230401199A1
公开(公告)日:2023-12-14
申请号:US18353317
申请日:2023-07-17
Applicant: Snowflake Inc.
Inventor: Tyler Arthur Akidau , Tyler Jones , Daniel Mills , Leon Papke , Prasanna Rajaperumal , Daniel E. Sotolongo
CPC classification number: G06F16/2393 , G06F11/3419
Abstract: A method includes retrieving a plurality of materialized tables (MTs). Each of the plurality of MTs includes a lag duration and refers to a corresponding base table of a plurality of base tables. The lag duration indicates a maximum time period that a result of a prior refresh of a query on the corresponding base table can lag behind a current time instance. A plurality of time instances for the MT is determined based on the lag duration and a number of prior refreshes of the corresponding base table. A plurality of aligned time instances for the plurality of MTs is determined based on the plurality of time instances for each of the plurality of MTs. Refresh operations are scheduled for the plurality of MTs at one or more of the plurality of aligned time instances that are within the maximum time period.
-
8.
公开(公告)号:US11675779B2
公开(公告)日:2023-06-13
申请号:US17217983
申请日:2021-03-30
Applicant: TTEC Holdings, Inc.
Inventor: Paul Peloski
IPC: G06F16/00 , G06F16/23 , G06F16/245 , G06F16/22 , G06F16/2455 , G06F30/20
CPC classification number: G06F16/2393 , G06F16/2246 , G06F16/245 , G06F16/24561 , G06F30/20
Abstract: A database system supporting persistent queries, using an enhanced persistent query service and various data sources. On receiving a request to create a persistent query from a client software application, the persistent query service: creates a query virtual table; parses the persistent query; creates a plurality of intermediate virtual tables; establishes listeners for the query virtual table; creates a plurality of data source virtual tables; causes the plurality of data source virtual tables to retrieve initial data from data sources; and propagates data via intermediate virtual tables to the persistent query virtual table.
-
公开(公告)号:US20230169606A1
公开(公告)日:2023-06-01
申请号:US17457211
申请日:2021-12-01
Applicant: JPMORGAN CHASE BANK, N.A.
Inventor: Alan WATSON , Maciej LOZICZONEK , Sergei LEWIS , Mikolaj SIELUZYCKI
CPC classification number: G06Q40/12 , G06F16/2393 , G06F16/2358
Abstract: Systems and methods for data aggregation and post processing using microservices are disclosed. In accordance with embodiments, a method may include providing a data microservice; sourcing, by the data microservice, data from a data source; formatting the data into tabular data; storing the tabular data in random access memory; exposing, via an endpoint of the data microservice, the tabular data; providing a view microservice, wherein the view microservice formats received data in a predefined format; requesting, by the view microservice, the tabular data from the data microservice; formatting, by the view microservice, the tabular data in the predefined format; and exposing, by the view microservice and as an endpoint of the view microservice, the tabular data formatted in the predefined format.
-
10.
公开(公告)号:US20230161743A1
公开(公告)日:2023-05-25
申请号:US18052305
申请日:2022-11-03
Applicant: Waters Technologies Ireland Limited
Inventor: Steven M. Cohn , Christopher Carver
CPC classification number: G06F16/214 , G06F16/254 , G06F16/2393 , G16C20/80
Abstract: Exemplary embodiments provide computer-implemented methods, mediums, and apparatuses configured to upload data stored in a data storage ecosystem to a cloud-based storage service. A database in the data storage ecosystem may store results sets from an analytical chemistry system. The results sets may be stored in a first model structure implemented by a library structure. An uploader may incorporate the library structure and may include logic to use the library structure to transform the results sets from first model structure into a second model structure suitable for use in a relational data store in the cloud-based storage system. By implementing the library structure in the uploader, the uploader can be decoupled from the data storage ecosystem. This allows the uploader to function without some of the overhead used by the data ecosystem, provide faster data uploads, and to automatically generate derived information for the results sets.
-
-
-
-
-
-
-
-
-