公开(公告)号：US20240346022A1

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

申请号：US18636874

申请日：2024-04-16

申请人： Actian Corporation

发明人： Steffen KLÄBE ,  Stephan Baumann ,  Thomas Schweser

IPC分类号： G06F16/2453 ,  G06F16/22 ,  G06F16/2452

CPC分类号： G06F16/24544 ,  G06F16/2282 ,  G06F16/24526

摘要： Aspects described herein relate to partitioning multiple data tuples stored in a database system to multiple partitions based on multiple partition keys. The multiple data tuples can be assigned to multiple partitions such that each partition of the multiple partitions includes a portion of the multiple data tuples having same values for at least one of the multiple partition keys. A set of exceptions can be generated including data tuples having a first value of at least a first one of the multiple partition keys that is the same as the same value of a first portion of data tuples assigned to a first one of the multiple partitions, and a second value of at least a second one of the multiple partition keys that is the same as the same value of a second portion of data tuples assigned to a second one of the multiple partitions.

公开(公告)号：US20240214238A1

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

申请号：US18430262

申请日：2024-02-01

申请人： Johnson Controls Tyco IP Holdings LLP

发明人： Justin J. Ploegert ,  Dominick James O'Dierno ,  Brian Scott Otto

IPC分类号： H04L12/28 ,  G05B13/02 ,  G05B13/04 ,  G05B15/02 ,  G05B17/02 ,  G05B19/042 ,  G06F9/54 ,  G06F16/21 ,  G06F16/23 ,  G06F16/2452 ,  G06F16/2457 ,  G06F16/25 ,  G06F16/27 ,  G06F16/28 ,  G06F16/901 ,  G06F21/60 ,  G06F30/13 ,  G06Q30/04 ,  G06Q50/00 ,  G06Q50/06 ,  H04L43/062 ,  H04L67/12 ,  H04L67/561

CPC分类号： H04L12/282 ,  G05B13/0265 ,  G05B13/041 ,  G05B13/047 ,  G05B15/02 ,  G05B17/02 ,  G05B19/0428 ,  G06F9/542 ,  G06F9/547 ,  G06F16/212 ,  G06F16/2358 ,  G06F16/24526 ,  G06F16/24575 ,  G06F16/258 ,  G06F16/27 ,  G06F16/288 ,  G06F16/9024 ,  G06F21/60 ,  G06F30/13 ,  G06Q30/04 ,  G06Q50/00 ,  G06Q50/06 ,  H04L12/2827 ,  H04L67/12 ,  H04L67/561 ,  G05B2219/2614 ,  G05B2219/2642 ,  H04L43/062

摘要： A building system of a building including one or more memory devices having instructions thereon, that, when executed by one or more processors, cause the one or more processors to manage a plurality of entitlements for a plurality of subscriptions of one or more buildings with a building entitlement model, receive a first request to perform a first operation for a first subscription and a second request to perform a second operation for a second subscription, and implement the first operation on first computing resources of a first zone based on the building entitlement model in response to a first determination that the first subscription has the first entitlement and implement the second operation on second computing resources of the second zone based on the building entitlement model in response to a second determination that the second subscription has the second entitlement.

公开(公告)号：US20240126748A1

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

申请号：US18345852

申请日：2023-06-30

申请人： Ab Initio Technology LLC

发明人： Jonah Egenolf ,  Marshall A. Isman ,  Ian Schechter

IPC分类号： G06F16/242 ,  G06F8/34 ,  G06F8/36 ,  G06F8/38 ,  G06F16/21 ,  G06F16/23 ,  G06F16/2452 ,  G06F16/2453 ,  G06F16/28

CPC分类号： G06F16/2423 ,  G06F8/34 ,  G06F8/36 ,  G06F8/38 ,  G06F16/211 ,  G06F16/2365 ,  G06F16/24524 ,  G06F16/24526 ,  G06F16/2453 ,  G06F16/24544 ,  G06F16/24545 ,  G06F16/288 ,  G06Q10/10

摘要： A method includes accessing a schema that specifies relationships among datasets, computations on the datasets, or transformations of the datasets, selecting a dataset from among the datasets, and identifying, from the schema, other datasets that are related to the selected dataset. Attributes of the datasets are identified, and logical data representing the identified attributes and relationships among the attributes is generated. The logical data is provided to a development environment, which provides access to portions of the logical data representing the identified attributes. A specification that specifies at least one of the identified attributes in performing an operation is received from the development environment. Based on the specification and the relationships among the identified attributes represented by the logical data, a computer program is generated to perform the operation by accessing, from storage, at least one dataset having the at least one of the attributes specified in the specification.

公开(公告)号：US11894944B2

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

申请号：US17853352

申请日：2022-06-29

申请人： Johnson Controls Tyco IP Holdings LLP

发明人： Justin J. Ploegert ,  Dominick James O′Dierno ,  Brian Scott Otto ,  Rajiv Ramanasankaran

IPC分类号： G06F9/54 ,  H04L12/28 ,  G06F30/13 ,  G06F21/60 ,  G06F16/901 ,  G05B15/02 ,  G06F16/21 ,  G06F16/28 ,  G06F16/2452 ,  G06F16/2457 ,  G06F16/25 ,  G05B17/02 ,  G06F16/23 ,  G05B13/04 ,  G05B19/042 ,  G06F16/27 ,  G05B13/02 ,  G06Q50/00 ,  G06Q50/06 ,  G06Q30/04 ,  H04L67/12 ,  H04L67/561

CPC分类号： H04L12/2827 ,  G05B13/0265 ,  G05B13/041 ,  G05B13/047 ,  G05B15/02 ,  G05B17/02 ,  G05B19/0428 ,  G06F9/542 ,  G06F9/547 ,  G06F16/212 ,  G06F16/2358 ,  G06F16/24526 ,  G06F16/24575 ,  G06F16/258 ,  G06F16/27 ,  G06F16/288 ,  G06F16/9024 ,  G06F21/60 ,  G06F30/13 ,  G06Q30/04 ,  G06Q50/00 ,  G06Q50/06 ,  H04L67/12 ,  H04L67/561 ,  G05B2219/2614 ,  G05B2219/2642

摘要： A building system including one or more memory devices having instructions stored thereon, that, when executed by one or more processors, cause the one or more processors to receive an event from an event source, the event comprising data and a timestamp. The building system operates to identify first contextual data describing the event in a digital twin, the digital twin comprising a virtual representation of a building, enrich the event with the first contextual data, and provide the enriched event to a consuming system, the consuming system generating an output event based on the enriched event. The building system operates to identify second contextual data describing the output event in the digital twin, enrich the output event with the second contextual data, and provide the enriched output event to the consuming system or another consuming system.

公开(公告)号：US20240020308A1

公开(公告)日：2024-01-18

申请号：US18364664

申请日：2023-08-03

申请人： Intel Corporation

发明人： Maria Cecilia Aguerrebere Otegui ,  Ishwar Bhati ,  Mark Hildebrand ,  Mariano Tepper ,  Theodore Willke

IPC分类号： G06F16/245 ,  G06F16/2453 ,  G06F16/2452

CPC分类号： G06F16/24569 ,  G06F16/2453 ,  G06F16/24526

摘要： Systems, apparatuses and methods may provide for technology that conducts a traversal of a directed graph in response to a query, retrieves the plurality of vectors from a dynamic random access memory (DRAM) in accordance with the traversal of the directed graphs, wherein each vector in the plurality of vectors is compressed, decompresses the plurality of vectors, determines a similarity between the query and the decompressed plurality of vectors, and generates a response to the query based on the similarity between the query and the decompressed plurality of vectors.

公开(公告)号：US11770269B2

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

申请号：US17678260

申请日：2022-02-23

申请人： Johnson Controls Tyco IP Holdings LLP

发明人： Justin J. Ploegert ,  Dominick James O'Dierno ,  Brian Scott Otto

IPC分类号： G06F16/90 ,  H04L12/28 ,  G06F30/13 ,  G06F21/60 ,  G06F16/901 ,  G05B15/02 ,  G06F9/54 ,  G06F16/21 ,  G06F16/28 ,  G06F16/2452 ,  G06F16/2457 ,  G06F16/25 ,  G05B17/02 ,  G06F16/23 ,  G05B13/04 ,  G05B19/042 ,  G06F16/27 ,  G05B13/02 ,  G06Q50/00 ,  G06Q50/06 ,  G06Q30/04 ,  H04L67/12 ,  H04L67/561

CPC分类号： H04L12/2827 ,  G05B13/0265 ,  G05B13/041 ,  G05B13/047 ,  G05B15/02 ,  G05B17/02 ,  G05B19/0428 ,  G06F9/542 ,  G06F9/547 ,  G06F16/212 ,  G06F16/2358 ,  G06F16/24526 ,  G06F16/24575 ,  G06F16/258 ,  G06F16/27 ,  G06F16/288 ,  G06F16/9024 ,  G06F21/60 ,  G06F30/13 ,  G06Q30/04 ,  G06Q50/00 ,  G06Q50/06 ,  H04L67/12 ,  H04L67/561 ,  G05B2219/2614 ,  G05B2219/2642

摘要： A building system including one or more memory devices having instructions thereon, that, when executed by one or more processors, cause the one or more processors to receive an event from an event source, the event indicating a data value associated with the event source occurring at a particular time. The instructions cause the one or more processors to identify contextual data of a database that provides a contextual description of the event, generate an enriched event by enriching the event with the contextual data, the enriched event including the data value, the particular time, and the contextual data, and provide the enriched event to a consuming application configured to operate based on the enriched event.

公开(公告)号：US20170083588A1

公开(公告)日：2017-03-23

申请号：US15371245

申请日：2016-12-07

申请人： Microsoft Technology Licensing, LLC

发明人： Willis Lang ,  Nikhil Teletia ,  Hideaki Kimura ,  Alan D. Halverson ,  Srinath Shankar ,  Karthik Ramachandra

IPC分类号： G06F17/30

CPC分类号： G06F16/2471 ,  G06F16/2425 ,  G06F16/24526 ,  G06F16/24532 ,  G06F16/24568

摘要： Distributed query processing is often performed by a set of nodes that apply MapReduce to a data set and materialize partial results to storage, which are then aggregated to produce the query result. However, this architecture requires a preconfigured set of database nodes; can only fulfill queries that utilize MapReduce processing; and may be slowed down by materializing partial results to storage. Instead, distributed query processing can be achieved by choosing a node for various portions of the query, and generating customized code for the node that only performs the query portion that is allocated to the node. The node executes the code to perform the query portion, and rather than materializing partial results to storage, streams intermediate query results to a next selected node in the distributed query. Nodes selection may be involve matching the details of the query portion with the characteristics and capabilities of the available nodes.

公开(公告)号：US20100153430A1

公开(公告)日：2010-06-17

申请号：US12332871

申请日：2008-12-11

申请人： Vladimir Mordvinov ,  Soufiane Azizi ,  Nigel Anthony Campbell

发明人： Vladimir Mordvinov ,  Soufiane Azizi ,  Nigel Anthony Campbell

IPC分类号： G06F17/30

CPC分类号： G06F16/24526

摘要： A method receives a query containing at least a statement, and analyzes the statement to determine a query structure of elements forming the statement. The text of the statement is formatted to reflect the query structure. The formatted text is replaced with an equivalent tree of logical blocs representing the statement in a higher level. The representation of one or more of the logical blocks is shortened. A data flow tree of macro operation nodes is generated based on the logical blocks for presentation to a user.

摘要翻译： 一种方法接收至少包含一个语句的查询，并分析该语句以确定形成语句的元素的查询结构。 语句的文本格式化以反映查询结构。 格式化的文本被替换为表示较高级别的语句的逻辑组合的等效树。 一个或多个逻辑块的表示被缩短。 基于用于呈现给用户的逻辑块来生成宏操作节点的数据流树。

公开(公告)号：US20070271242A1

公开(公告)日：2007-11-22

申请号：US11750966

申请日：2007-05-18

申请人： Christopher Lindblad

发明人： Christopher Lindblad

IPC分类号： G06F17/30

CPC分类号： G06F16/83 ,  G06F16/24526

摘要： Embodiments of the present invention include storing a plurality of subtrees in a database, the plurality of subtrees representing one or more structured documents. At least one subtree has a birth timestamp indicating a time at which the at least one subtree was created. If a subtree has been obsoleted, the subtree has a death timestamp indicating a time at which the subtree was obsoleted. Embodiments further include receiving a database query comprising a query string and a query timestamp, the query timestamp indicating a historical time for which the query is to apply, and determining an intermediate result list of subtrees. The intermediate result list is filtered to generate a final result list responsive to the database query, the filtering comprising removing subtrees that do not have a birth timestamp, have a birth timestamp later than the query timestamp, or have a death timestamp earlier than the query timestamp.

摘要翻译： 本发明的实施例包括将多个子树存储在数据库中，多个子树表示一个或多个结构化文档。 至少一个子树具有指示创建至少一个子树的时间的出生时间戳。 如果子树已经过时，则子树具有指示子树被过时的时间的死亡时间戳。 实施例还包括接收包括查询字符串和查询时间戳的数据库查询，查询时间戳指示查询应用于其的历史时间，以及确定子树的中间结果列表。 过滤中间结果列表以响应于数据库查询生成最终结果列表，包括删除不具有出生时间戳的子树的过滤器具有晚于查询时间戳的出生时间戳，或者具有早于查询的死亡时间戳 时间戳。

公开(公告)号：US20050177556A1

公开(公告)日：2005-08-11

申请号：US10776895

申请日：2004-02-10

申请人： Jun Fang ,  Aakash Kambuj ,  Evgueni Zabokritski ,  Honggang Zhang ,  Peter Carlin

发明人： Jun Fang ,  Aakash Kambuj ,  Evgueni Zabokritski ,  Honggang Zhang ,  Peter Carlin

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F16/24526

摘要： The SQL Algebrizer of the present invention comprises a plurality of algorithms to “algebrize” SQL Trees to QP Algebra using an approach that is more consistent and much more efficient than typical algebrizers. More specifically, the Algebrizer of the present invention processes a SQL Tree using a reduced number of recursive depth-first passes by performing multiple operations in a single pass. Furthermore, the Algebrizer of the present invention also performs the operation of constant folding in this single, multi-operation pass so that the QP, upon receiving the QP Algebra, needs not perform this operation at all.

摘要翻译： 本发明的SQL代理器包括使用比典型的代数器更一致和更有效的方法来将“SQL树”组合到QP代数的多种算法。 更具体地说，本发明的代理者通过在单程中执行多个操作，使用减少数量的递归深度优先遍历来处理SQL树。 此外，本发明的代理还在该单次多操作遍中进行恒定折叠的操作，使得在接收到QP代数时，QP根本不需要执行该操作。