公开(公告)号：US12124445B2

公开(公告)日：2024-10-22

申请号：US18488932

申请日：2023-10-17

Applicant: Open Text Corporation

Inventor： Kancharla Anil Kumar ,  Syed Nasir Bellary ,  Sunil Kumar Gollapinni ,  Lokesh Kumar Nayak ,  Mohammad Sameer Pathan ,  David Humby

IPC: G06F16/2453 ,  G06F9/54 ,  G06F16/22

CPC classification number: G06F16/24537 ,  G06F9/54 ,  G06F16/2282

Abstract: Systems and methods for data reporting using a data aggregator and a data retrieval tool such as a file intelligence service. The data aggregator stores two sets of data reporting tables and designates a first one of the sets of tables as an active set and the second one of the sets as a non-active set. The active set of tables stores data corresponding to a most recently successfully completed search. The non-active set stores data retrieved by the data retrieval tool from disparate data sources according to current search. The data in the active set of tables is immediately available for use in requested reports. When the data aggregator completes the current search, it designates the non-active set of tables as the active set so that the data therein becomes available for use in requested reports.

公开(公告)号：US12067058B2

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

申请号：US17886383

申请日：2022-08-11

Applicant: Oxla sp. z o.o.

Inventor： Adam Szymański

IPC: G06F16/903 ,  G06F16/2453

CPC classification number: G06F16/90335 ,  G06F16/24537 ,  G06F16/24542 ,  G06F16/24544

Abstract: A database system generates an execution plan including multiple operators for processing a database query, for example, a join query or a group by query. The database system allocates a set of threads. Threads communicate with other threads via blocking channels. A blocking channel includes a buffer of a fixed capacity. The database system processes the database query by streaming data through operators of the execution plan. A thread sends data generated by an operator to another thread via the blocking channel if the buffer of the blocking channel has available capacity to store the data, or else the thread blocks until the buffer has capacity to store the data. Similarly, a thread receives data generated by an operator of another thread via the blocking channel if the buffer of the blocking channel has available data, or else the thread blocks until the buffer has data.

公开(公告)号：US12056113B2

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

申请号：US17488363

申请日：2021-09-29

Applicant: YAHOO ASSETS LLC

Inventor： Aaron J. Klish ,  Moiz Arafat ,  Jonathan Kilroy ,  Rishi Agarwal

IPC: G06F15/16 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2453

CPC classification number: G06F16/2365 ,  G06F16/221 ,  G06F16/24537

Abstract: The disclosed systems and methods provide a novel framework that parameterizes columns in a templated virtual semantic layer. The disclosed framework enables inter- and cross-column relationships between stored data within a SQL database to be determined and stored, and then leveraged at query time to enable an optimized search of the data within the database. The disclosed framework enables a database to be construed, modified and/or configured according to a hierarchy, and/or with types of metadata, that corresponds to the determined column relationships. This not only reduces the amount of data stored and reduces the time to process queries, but also enables a more streamlined approach for searches to be constructed and executed, which can increase the performance of the database and the operations of systems that are backed by the database.

公开(公告)号：US20240193170A1

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

申请号：US18076768

申请日：2022-12-07

Applicant: SAP SE

Inventor： Sebastien Ducaule ,  Raphael Geoffroy

IPC: G06F16/248 ,  G06F16/2453 ,  G06F16/2455

CPC classification number: G06F16/248 ,  G06F16/24537 ,  G06F16/24542 ,  G06F16/24553

Abstract: The present disclosure relates to computer-implemented methods, software, and systems for generating intelligent data reports based on data of different data source type(s). Metadata is obtained from data sources to support querying. A request is received by the compound database and from a query panel to generate a report associated with at least one data source. The request includes one or more data manipulation operations, wherein at least one of the data manipulation operations is not natively supported by a data source of the at least one data source. A query is generated based on the request. The query is split based on a number of data sources associated with the request to generate the report. The query is transformed into at least one sub-queries corresponding to each of the at least one data source and a report is generated based on their execution.

公开(公告)号：US12001428B2

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

申请号：US18047872

申请日：2022-10-19

Applicant: Snowflake Inc.

Inventor： Xinzhu Cai ,  Florian Andreas Funke

IPC: G06F16/24 ,  G06F16/22 ,  G06F16/2453

CPC classification number: G06F16/24537 ,  G06F16/2255

Abstract: Provided herein are systems and methods for handling build-side skew. For example, a method includes computing a plurality of hash values for a join operation. The join operation uses a corresponding plurality of row sets. The plurality of hash values are sampled to detect a frequent hash value. A build-side row set is partitioned using the frequent hash value to generate a partitioned build-side row set. The build-side row set is selected from the plurality of row sets. The partitioned build-side row set is distributed to a plurality of hash-join-build (HJB) instances executing at a corresponding plurality of servers.

公开(公告)号：US20240176781A1

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

申请号：US18070751

申请日：2022-11-29

Applicant: Oracle International Corporation

Inventor： GIACOMO FABRIS ,  ALEKSEI KASHUBA ,  ALEXANDER ULRICH ,  JOSEF HAIDER ,  CHRISTIAN WIRTH

IPC: G06F16/2453 ,  G06F11/34

CPC classification number: G06F16/24542 ,  G06F11/349 ,  G06F16/24537

Abstract: Techniques are described to improve the performance of regular expression (regex) evaluation in a database management system (DBMS) by a speculative execution of a regex engine. In an embodiment, the DBMS determines properties of strings and generates descriptors for the string input data. Based on the descriptors, the regex engine validates an existing assertion for the execution logic to, at least in part, evaluate the regex pattern on the strings. Based on validating the existing assertion for selecting the execution logic, evaluating the regex pattern on the strings.

公开(公告)号：US20240152514A1

公开(公告)日：2024-05-09

申请号：US17984184

申请日：2022-11-09

Applicant: MICROSOFT TECHNOLOGY LICENSING, LLC

Inventor： Michael Henry SCHULZ ,  Anish AGARWAL ,  Shruti KASETTY ,  Patrick MOULHAUD ,  Carly LARSSON ,  Tengyu WANG

IPC: G06F16/2453

CPC classification number: G06F16/24537 ,  G06F16/24542

Abstract: The techniques disclosed herein enhance the efficiency and functionality of directory systems. This is accomplished by augmenting a primary table with an extended table for storing properties of an associated entity (e.g., a user, a company). A table serves to organize directory data and comprises rows and columns. Each row of the primary table stores an entity with each column storing an associated property. In contrast, the primary table is configured with an extended table in which each row of the extended table stores a property for an associated entity while each column stores additional information for the property such as timestamps and metadata. Storing specific properties in the extended table eliminates empty spaces in the primary table thereby reducing the volume of stored data. Moreover, by including additional data for properties, the extended table enables property-specific features such as search, synchronization, extensibility, and lifecycle management.

公开(公告)号：US20240119050A1

公开(公告)日：2024-04-11

申请号：US17963809

申请日：2022-10-11

Applicant: Microsoft Technology Licensing, LLC

Inventor： Matteo INTERLANDI ,  Apurva Sandeep Gandhi ,  Yuki Asada ,  Advitya Gemawat ,  Victor Renjie Fu ,  Lihao Zhang ,  Rathijit Sen ,  Dalitso Hansini Banda

IPC: G06F16/2453 ,  G06F16/242

CPC classification number: G06F16/24542 ,  G06F16/2448 ,  G06F16/24537

Abstract: Example aspects include techniques for query processing over deep neural network runtimes. These techniques include receiving a query including a query operator and a trainable user defined function (UDF). In addition, the techniques include determining a query representation based on the query, and determining, for performing the query in a neural network runtime, an initial neural network program based on the query representation, the initial neural network program including a differentiable operators corresponding to the query operator. and executing the neural network program in the neural network runtime over the neural network data structure to generate a query result. Further, the techniques include training the initial neural network program via the neural network runtime to determine a trained neural network program, and executing the trained neural network program in the neural network runtime to generate inference information.

公开(公告)号：US11954107B2

公开(公告)日：2024-04-09

申请号：US17893470

申请日：2022-08-23

Applicant: KABUSHIKI KAISHA TOSHIBA

Inventor： Shigeo Hirose ,  Mototaka Kanematsu

IPC: G06F16/2455 ,  G06F16/2453

CPC classification number: G06F16/2456 ,  G06F16/24537

Abstract: According to one embodiment, an information processing apparatus includes a processor. The processor is configured to receive, from a client terminal, a first query to request a result of a join operation process on first and second tables, create a second query to a first database management device based on the first query, receive the first table from the first database management device by performing a process on the second query, create a third query to a second database management device based on the first query and the first table, receive a part of a second table from the second database management device by performing a process on the third query, and transmit, to the client terminal, a response to the first query based on the part of the second table.

公开(公告)号：US20240095243A1

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

申请号：US17933212

申请日：2022-09-19

Applicant: SAP SE

Inventor： Christoph WEYERHAEUSER ,  Simon Spohrer ,  Jan Zwickel ,  Mohamed Ali Chriki ,  Feipeng Ru

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

CPC classification number: G06F16/24537 ,  G06F11/3419 ,  G06F16/244

Abstract: In one aspect, a method may include receiving a query associated with a plurality of data sources, wherein the query includes a first attribute; identifying that a query operator, which is associated with execution of the query and the first attribute, includes a first input from a first data source of the plurality of data sources and a second input from a second data source of the plurality of data sources; determining that the first attribute at the second data source corresponds to null; pruning, based on the determined null, the second input from the second data source to inhibit a select from the second data source; and in response to the pruning, performing the query operator by selecting, from the first data source, a column corresponding to the first attribute. Related systems, methods, and articles or manufacture are also disclosed.