公开(公告)号：US20240202196A1

公开(公告)日：2024-06-20

申请号：US18082308

申请日：2022-12-15

Applicant: VMware LLC

Inventor： Ajitesh Gupta

IPC: G06F16/2455 ,  G06F16/2453

CPC classification number: G06F16/24554 ,  G06F16/2454

Abstract: The current document is directed to methods and systems that generate lists of component types and quantities needed for system installations based on parameter values that characterize the system, environment, and application domain, referred to as “input values.” An implementation of a private-5G-network component-type-and-quantity-determination system is disclosed. An initial model used to generate component types and quantities is generated from information acquired from various information sources, including system vendors, designers, and/or administrators. The initial model is used to generate lists of component types and quantities on behalf of requesting entities during an initial period of system operation. Over time, as the final types and quantities of components used for particular installations are determined and reported back to the system, the system uses these reported results to refine the initial model, generate more specific models for particular types or classes of system installations and to refine the more specific models.

公开(公告)号：US20230359632A1

公开(公告)日：2023-11-09

申请号：US18311860

申请日：2023-05-03

Applicant: DISH Wireless L.L.C.

Inventor： Ian King ,  Brian Peletz ,  Steven Wilson ,  Prakash Srinivasan ,  Kevin Plunkett

IPC: G06F16/2455 ,  H04W24/02 ,  G06F16/2453

CPC classification number: G06F16/24568 ,  H04W24/02 ,  G06F16/2454 ,  G06F16/24542

Abstract: A data pipeline architecture provides for efficient and scalable data collection within a 5G wireless network. The data pipeline includes a data collection engine that receives streaming and/or query-based data. The data collection engine collects the data, amalgamates the streaming and the querly-based data into a common format, and provides the amalgamated data for delivery to a data reporting engine. The data reporting engine provides dashboards, reports, alerts or other information about the collected data. The data reporting engine may also interface with a database system for longer-term storage of collected data, report generation and/or the like.

公开(公告)号：US20180144029A1

公开(公告)日：2018-05-24

申请号：US15716345

申请日：2017-09-26

Applicant: Oracle International Corporation

Inventor： Thierry Cruanes ,  Junyi Xie ,  Yiu Woon Lau

IPC: G06F17/30

CPC classification number: G06F16/24542 ,  G06F16/2453 ,  G06F16/2454 ,  G06F16/24544 ,  G06F16/24556 ,  G06F16/2456 ,  G06F16/24568 ,  G06F16/2471

Abstract: Techniques are provided for sharing expression evaluation across a database management system and a storage layer. In an embodiment, a computer identifies, in a query execution plan compiled for a query, a plurality of target operators that includes an expression that computes a common value. A storage layer evaluates the expression that computes the common value during a table scan of stored data indicated by the expression. For at least one target operator of the plurality of target operators, the computer modifies a row input of the at least one target operator to add a column to receive an evaluation result comprising the common value from the storage layer. The query execution plan is performed by a database management system and the storage layer.

公开(公告)号：US20170344549A1

公开(公告)日：2017-11-30

申请号：US15168817

申请日：2016-05-31

Applicant: International Business Machines Corporation

Inventor： Chitwan Humad

IPC: G06F17/30

CPC classification number: G06F16/2454 ,  G06F16/245 ,  G06F16/248

Abstract: A method includes receiving, from a client device, an enhanced database query for a union operation of a first query and at least a second query, parsing the enhanced database query to identify two or more parameters controlling handling of duplicate rows in the first query and the second query, evaluating the enhanced database query utilizing the parameters to generate a result table, and providing the result table to the client device

公开(公告)号：US20070250517A1

公开(公告)日：2007-10-25

申请号：US11379503

申请日：2006-04-20

Applicant: Robert Bestgen ,  Curtis Boger ,  David Carlson ,  Robert Downer ,  Steven Hoeschen ,  Kevin Kathmann ,  Shantan Kethireddy

Inventor： Robert Bestgen ,  Curtis Boger ,  David Carlson ,  Robert Downer ,  Steven Hoeschen ,  Kevin Kathmann ,  Shantan Kethireddy

IPC: G06F7/00

CPC classification number: G06F16/24539 ,  G06F16/22 ,  G06F16/2454 ,  G06F16/24561

Abstract: A latent auxiliary database structure constructed for executing a query is automatically saved for reuse in subsequent query execution instances. The latent auxiliary database structure is not maintained concurrently with changes to records in the database tables. If a query execution strategy is subsequently invoked which uses the latent auxiliary database structure, a determination is made dynamically whether to update the previously saved latent structure from database changes recorded in one or more change logs, or to rebuild the latent structure from scratch. Where the cost of updating from the change log is deemed less than the cost of a rebuild from scratch, the previously saved latent structure is updated from the log.

Abstract translation: 构建用于执行查询的潜在辅助数据库结构将自动保存，以便在后续查询执行实例中重用。 潜在辅助数据库结构与数据库表中记录的更改不同时维护。 如果随后调用使用潜在辅助数据库结构的查询执行策略，则动态确定是否从先前保存的潜在结构更新记录在一个或多个更改日志中的数据库更改，或从头重新构建潜在结构。 在从更改日志更新成本被认为小于从头开始重建的成本的情况下，先前保存的潜在结构将从日志中更新。

公开(公告)号：US20230394040A1

公开(公告)日：2023-12-07

申请号：US17833180

申请日：2022-06-06

Applicant: Microsoft Technology Licensing, LLC

Inventor： Manish GUPTA ,  Puneet AGRAWAL

IPC: G06F16/242 ,  G06F16/2453 ,  G06F16/28

CPC classification number: G06F16/2445 ,  G06F16/2454 ,  G06F16/285

Abstract: Aspects of the present disclosure relate to providing, based on a partial query string, a plurality of autosuggestions that are diverse in nature such that the user is more likely to see the preferred complete query terms and therefore more likely to select one of the preferred suggestions which will increase search efficiency. As described herein, such functionality relates to generating cluster groups of candidate suggestions, each cluster including sub-topics, then performing the search based on a selected cluster or sub-topic. To generate the cluster groups, systems and methods, as described herein, analyze the similarity between candidate suggestions as well as the popularity of generated sub-topics. The cluster groups and sub-topics may be displayed visually, and in certain embodiments the cluster groups are ordered vertically from top to bottom and aligned to the left side of the display, while sub-topics are ordered horizontally from left to right following the cluster label.

公开(公告)号：US20190228008A1

公开(公告)日：2019-07-25

申请号：US15579376

申请日：2017-05-09

Applicant: PING AN TECHNOLOGY (SHENZHEN) CO., LTD.

Inventor： Song HOU ,  Yeung WONG

IPC: G06F16/2453 ,  G06F16/21 ,  G06F11/34

CPC classification number: G06F16/2454 ,  G06F11/3433 ,  G06F16/217 ,  G06F16/2453

Abstract: A method of reviewing SQL includes: obtaining slow log data; extracting a SQL sentence to be reviewed and basic information matched with the SQL sentence from the slow log data; identifying and parsing the SQL sentence to obtain a parsed result; reviewing the parsed result and/or the basic information in accordance with review items in a preset review template one by one to obtain a review result; and generating a review result set according to the review result.

公开(公告)号：US20190147087A1

公开(公告)日：2019-05-16

申请号：US15814132

申请日：2017-11-15

Applicant: ServiceNow, Inc.

Inventor： Josef Mart ,  Joseph Michael Davis

IPC: G06F17/30

CPC classification number: G06F16/24537 ,  G06F16/2454 ,  G06F16/24544

Abstract: The present approach relates to improving query performance in a database context. Examples of query improvement are described in the context of certain query patterns, one or more of which may be observed in a given query. When a given query pattern is observed, changes may be made to the query at the application or database level to improve performance of the respective query. Query improvements may be performed in a manner transparent to the user.

公开(公告)号：US20190087456A1

公开(公告)日：2019-03-21

申请号：US15711378

申请日：2017-09-21

Applicant: SEMMLE LIMITED

Inventor： Aditya Sharad ,  Alexander Eyers-Taylor ,  Michael Peyton Jones

IPC: G06F17/30

CPC classification number: G06F16/2433 ,  G06F16/242 ,  G06F16/24537 ,  G06F16/2454

Abstract: Methods, systems, and apparatus, including computer programs encoded on computer storage media, for performing local distribution heuristics. One of the methods includes receiving an original expression having a conjunction comprising a context term and a disjunction of a plurality of other terms. The context term and the disjunction are evaluated according to one or more local distribution heuristics to determine that the context term is a candidate for distribution across the disjunction of the plurality of other terms. In response, a transformed expression is generated in which the candidate context term is distributed across the disjunction of the plurality of other terms.

公开(公告)号：US20170116253A1

公开(公告)日：2017-04-27

申请号：US15267118

申请日：2016-09-15

Applicant: Oracle International Corporation

Inventor： George EADON ,  Ananth RAGHAVAN ,  Ramesh KUMAR

IPC: G06F17/30

CPC classification number: G06F16/24524 ,  G06F16/2453 ,  G06F16/2454

Abstract: A method commences upon receiving a database language statement pertaining to a database comprising database objects that are accessed by computing processes. The method analyzes the database language statement to form or identify a cursor object that has dependencies on one or more referenced data objects. The cursor object is associated with a set of cursor attributes that are stored in a cursor metadata data structure. By analyzing a subsequently-received database language statement, the method determines one or more operations to operate over at least one of the data objects. Rules are applied to the cursor attributes and/or to the operations and/or to objects referenced in the cursor so as to determine whether or not to invalidate the cursor object. The cursor may be considered at a later time for possible later invalidation or revalidation based on processing of later received database language statements and/or based on a later event.