专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US11120019B2 Adapting a relational query to accommodate hierarchical data 有权
公开(公告)号：US11120019B2
公开(公告)日：2021-09-14
申请号：US16402224
申请日：2019-05-02
申请人： International Business Machines Corporation
发明人： Suavi A. Demir
IPC分类号： G06F16/2453 , G06F16/28 , G06F16/22 , G06F16/2452
摘要： A method, system and computer program product for processing hierarchical data is provided. A method for processing hierarchical data in a relational database includes receiving an input parameter in an initial query for querying an array in a hierarchical data object stored in a table of a relational database, and transforming the initial query into a transformed query configured to place all elements of the array into a different table and to apply a sub-query against the table for the input parameter. Once transformed, predicate evaluation logic of a relational engine of the relational database is applied to the transformed query that is then mapped to the initial query. Finally, responsive to receiving a subsequent instance of the initial query, the mapping is referred to in order to replace the initial query with the transformed query and to subsequently apply the predicate evaluation logic to the transformed query.

2. 发明申请

US20190258630A1 ADAPTING A RELATIONAL QUERY TO ACCOMMODATE HIERARCHICAL DATA 审中-公开
公开(公告)号：US20190258630A1
公开(公告)日：2019-08-22
申请号：US16402224
申请日：2019-05-02
申请人： International Business Machines Corporation
发明人： Suavi A. Demir
IPC分类号： G06F16/2453 , G06F16/2452 , G06F16/28 , G06F16/22
摘要： A method, system and computer program product for processing hierarchical data is provided. A method for processing hierarchical data in a relational database includes receiving an input parameter in an initial query for querying an array in a hierarchical data object stored in a table of a relational database, and transforming the initial query into a transformed query configured to place all elements of the array into a different table and to apply a sub-query against the table for the input parameter. Once transformed, predicate evaluation logic of a relational engine of the relational database is applied to the transformed query that is then mapped to the initial query. Finally, responsive to receiving a subsequent instance of the initial query, the mapping is referred to in order to replace the initial query with the transformed query and to subsequently apply the predicate evaluation logic to the transformed query.

3. 发明申请

US20170220635A1 ADAPTING A RELATIONAL QUERY TO ACCOMMODATE HIERARCHICAL DATA 审中-公开
公开(公告)号：US20170220635A1
公开(公告)日：2017-08-03
申请号：US15487415
申请日：2017-04-13
申请人： International Business Machines Corporation
发明人： Suavi A. Demir
IPC分类号： G06F17/30
CPC分类号： G06F17/30448 , G06F17/30339 , G06F17/30427 , G06F17/30451 , G06F17/30589 , G06F17/30595
摘要： A method, system and computer program product for processing hierarchical data is provided. A method for processing hierarchical data in a relational database includes receiving an input parameter in an initial query for querying an array in a hierarchical data object stored in a table of a relational database, and transforming the initial query into a transformed query configured to place all elements of the array into a different table and to apply a sub-query against the table for the input parameter. Once transformed, predicate evaluation logic of a relational engine of the relational database is applied to the transformed query that is then mapped to the initial query. Finally, responsive to receiving a subsequent instance of the initial query, the mapping is referred to in order to replace the initial query with the transformed query and to subsequently apply the predicate evaluation logic to the transformed query.

4. 发明授权

US09626409B2 Adapting a relational query to accommodate hierarchical data 有权
公开(公告)号：US09626409B2
公开(公告)日：2017-04-18
申请号：US14658742
申请日：2015-03-16
申请人： International Business Machines Corporation
发明人： Suavi A. Demir
IPC分类号： G06F17/30
CPC分类号： G06F17/30448 , G06F17/30339 , G06F17/30427 , G06F17/30451 , G06F17/30589 , G06F17/30595
摘要： A method, system and computer program product for processing hierarchical data is provided. A method for processing hierarchical data in a relational database includes receiving an input parameter in an initial query for querying an array in a hierarchical data object stored in a table of a relational database, and transforming the initial query into a transformed query configured to place all elements of the array into a different table and to apply a sub-query against the table for the input parameter. Once transformed, predicate evaluation logic of a relational engine of the relational database is applied to the transformed query that is then mapped to the initial query. Finally, responsive to receiving a subsequent instance of the initial query, the mapping is referred to in order to replace the initial query with the transformed query and to subsequently apply the predicate evaluation logic to the transformed query.

5. 发明授权

US10282447B2 Adapting a relational query to accommodate hierarchical data 有权
公开(公告)号：US10282447B2
公开(公告)日：2019-05-07
申请号：US15487415
申请日：2017-04-13
申请人： International Business Machines Corporation
发明人： Suavi A. Demir
IPC分类号： G06F17/30
摘要： A method, system and computer program product for processing hierarchical data is provided. A method for processing hierarchical data in a relational database includes receiving an input parameter in an initial query for querying an array in a hierarchical data object stored in a table of a relational database, and transforming the initial query into a transformed query configured to place all elements of the array into a different table and to apply a sub-query against the table for the input parameter. Once transformed, predicate evaluation logic of a relational engine of the relational database is applied to the transformed query that is then mapped to the initial query. Finally, responsive to receiving a subsequent instance of the initial query, the mapping is referred to in order to replace the initial query with the transformed query and to subsequently apply the predicate evaluation logic to the transformed query.

6. 发明授权

US09626408B2 Adapting a relational query to accommodate hierarchical data 有权
公开(公告)号：US09626408B2
公开(公告)日：2017-04-18
申请号：US14299678
申请日：2014-06-09
申请人： International Business Machines Corporation
发明人： Suavi A. Demir
IPC分类号： G06F17/30
CPC分类号： G06F17/30448 , G06F17/30339 , G06F17/30427 , G06F17/30451 , G06F17/30589 , G06F17/30595
摘要： A method, system and computer program product for processing hierarchical data is provided. A method for processing hierarchical data in a relational database includes receiving an input parameter in an initial query for querying an array in a hierarchical data object stored in a table of a relational database, and transforming the initial query into a transformed query configured to place all elements of the array into a different table and to apply a sub-query against the table for the input parameter. Once transformed, predicate evaluation logic of a relational engine of the relational database is applied to the transformed query that is then mapped to the initial query. Finally, responsive to receiving a subsequent instance of the initial query, the mapping is referred to in order to replace the initial query with the transformed query and to subsequently apply the predicate evaluation logic to the transformed query.

7. 发明申请

US20150356140A1 ADAPTING A RELATIONAL QUERY TO ACCOMMODATE HIERARCHICAL DATA 有权
标题翻译：适应相关查询以适应分层数据
公开(公告)号：US20150356140A1
公开(公告)日：2015-12-10
申请号：US14299678
申请日：2014-06-09
申请人： International Business Machines Corporation
发明人： Suavi A. Demir
IPC分类号： G06F17/30
CPC分类号： G06F17/30448 , G06F17/30339 , G06F17/30427 , G06F17/30451 , G06F17/30589 , G06F17/30595
摘要： A method, system and computer program product for processing hierarchical data is provided. A method for processing hierarchical data in a relational database includes receiving an input parameter in an initial query for querying an array in a hierarchical data object stored in a table of a relational database, and transforming the initial query into a transformed query configured to place all elements of the array into a different table and to apply a sub-query against the table for the input parameter. Once transformed, predicate evaluation logic of a relational engine of the relational database is applied to the transformed query that is then mapped to the initial query. Finally, responsive to receiving a subsequent instance of the initial query, the mapping is referred to in order to replace the initial query with the transformed query and to subsequently apply the predicate evaluation logic to the transformed query.
摘要翻译：提供了一种用于处理分层数据的方法，系统和计算机程序产品。一种用于在关系数据库中处理分级数据的方法包括：在初始查询中接收输入参数，以查询存储在关系数据库的表中的分层数据对象中的数组，并将初始查询转换成经变换的查询，将数组的元素转换为不同的表，并针对输入参数对表执行子查询。一旦转换，关系数据库的关系引擎的谓词评估逻辑被应用于转换的查询，然后映射到初始查询。最后，响应于接收初始查询的后续实例，引用映射以便用转换的查询替换初始查询，并且随后将谓词评估逻辑应用于转换后的查询。

8. 发明申请

US20150356139A1 ADAPTING A RELATIONAL QUERY TO ACCOMMODATE HIERARCHICAL DATA 有权
公开(公告)号：US20150356139A1
公开(公告)日：2015-12-10
申请号：US14658742
申请日：2015-03-16
申请人： International Business Machines Corporation
发明人： Suavi A. Demir
IPC分类号： G06F17/30
CPC分类号： G06F17/30448 , G06F17/30339 , G06F17/30427 , G06F17/30451 , G06F17/30589 , G06F17/30595
摘要： A method, system and computer program product for processing hierarchical data is provided. A method for processing hierarchical data in a relational database includes receiving an input parameter in an initial query for querying an array in a hierarchical data object stored in a table of a relational database, and transforming the initial query into a transformed query configured to place all elements of the array into a different table and to apply a sub-query against the table for the input parameter. Once transformed, predicate evaluation logic of a relational engine of the relational database is applied to the transformed query that is then mapped to the initial query. Finally, responsive to receiving a subsequent instance of the initial query, the mapping is referred to in order to replace the initial query with the transformed query and to subsequently apply the predicate evaluation logic to the transformed query.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式