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

1. 发明申请

US20160140175A1 INTEGRATION OF CALCULATION MODELS INTO SQL LAYER 有权
标题翻译：将计算模型集成到SQL层中
公开(公告)号：US20160140175A1
公开(公告)日：2016-05-19
申请号：US14540792
申请日：2014-11-13
申请人： Christoph Weyerhaeuser , Tobias Mindnich , Johannes Merx , Yongsik Yoon , Sung Heun Wi , Jeong Ae Han
发明人： Christoph Weyerhaeuser , Tobias Mindnich , Johannes Merx , Yongsik Yoon , Sung Heun Wi , Jeong Ae Han
IPC分类号： G06F17/30
CPC分类号： G06F17/30463
摘要： According to an aspect, a database system for integrating calculation models into execution plans includes a first engine configured to parse a query to be applied on a database. The first engine is configured to invoke a second engine during query compilation. The second engine is configured to instantiate a calculation model based on the query, and the second engine is configured to derive a converted calculation model by converting the calculation model into a format compatible with the first engine. The first engine is configured to incorporate the converted calculation model into an execution plan during the query compilation and execute the query on the database according to execution plan.
摘要翻译：根据一方面，用于将计算模型集成到执行计划中的数据库系统包括被配置为解析要应用于数据库的查询的第一引擎。第一个引擎配置为在查询编译期间调用第二个引擎。第二引擎被配置为基于查询实例化计算模型，并且第二引擎被配置为通过将计算模型转换成与第一引擎兼容的格式来导出转换的计算模型。第一个引擎被配置为在查询编译期间将转换的计算模型合并到执行计划中，并根据执行计划对数据库执行查询。

2. 发明申请

US20150347410A1 Cached Views 审中-公开
标题翻译：缓存视图
公开(公告)号：US20150347410A1
公开(公告)日：2015-12-03
申请号：US14294818
申请日：2014-06-03
申请人： Ki Hong Kim , Norman May , Alexander Boehm , Sung Heun Wi , Jeong Ae Han , Sang Il Song , Yongsik Yoon
发明人： Ki Hong Kim , Norman May , Alexander Boehm , Sung Heun Wi , Jeong Ae Han , Sang Il Song , Yongsik Yoon
IPC分类号： G06F17/30
CPC分类号： G06F17/3048 , G06F17/30418
摘要： Embodiments relate to view caching techniques that cache for a limited time, some of the (intermediate) results of a previous query execution, in order to avoid expensive re-computation of query results. Particular embodiments may utilize a cache manager to determine whether information relevant to a subsequent user request can be satisfied by an existing cache instance or view, or whether creation of an additional cache instance is appropriate. At design time, cache defining columns of a view are defined, with user input parameters automatically being cache defining. Cache instances are created for each tuple of literals for the cache defining columns, and for each explicit or implicit group by clause. Certain embodiments may feature enhanced reuse between cache instances, in order to limit memory footprint. Over time a cache instances may be evicted from memory based upon implementation of a policy such as a Least Recently Used (LRU) strategy.
摘要翻译：实施例涉及在有限时间内高速缓存（先前的查询执行的一些（中间）结果）的视图缓存技术，以避免查询结果的昂贵的重新计算。特定实施例可以使用高速缓存管理器来确定与现有高速缓存实例或视图可以满足与后续用户请求相关的信息，或者是否适当地创建附加高速缓存实例。在设计时，定义视图的高速缓存定义列，用户输入参数自动进行缓存定义。为缓存定义列的每个文字元组创建缓存实例，并为每个显式或隐式的group by子句创建缓存实例。某些实施例可以特征在于缓存实例之间的增强的重用，以便限制存储器占用。随着时间的推移，基于诸如最近最少使用（LRU）策略的策略的实现，缓存实例可能被从存储器中移出。

3. 发明授权

US10061808B2 Cached views 有权
公开(公告)号：US10061808B2
公开(公告)日：2018-08-28
申请号：US14294818
申请日：2014-06-03
申请人： Ki Hong Kim , Norman May , Alexander Boehm , Sung Heun Wi , Jeong Ae Han , Sang Il Song , Yongsik Yoon
发明人： Ki Hong Kim , Norman May , Alexander Boehm , Sung Heun Wi , Jeong Ae Han , Sang Il Song , Yongsik Yoon
IPC分类号： G06F17/30
CPC分类号： G06F16/24552 , G06F16/2445
摘要： Embodiments relate to view caching techniques that cache for a limited time, some of the (intermediate) results of a previous query execution, in order to avoid expensive re-computation of query results. Particular embodiments may utilize a cache manager to determine whether information relevant to a subsequent user request can be satisfied by an existing cache instance or view, or whether creation of an additional cache instance is appropriate. At design time, cache defining columns of a view are defined, with user input parameters automatically being cache defining. Cache instances are created for each tuple of literals for the cache defining columns, and for each explicit or implicit group by clause. Certain embodiments may feature enhanced reuse between cache instances, in order to limit memory footprint. Over time a cache instances may be evicted from memory based upon implementation of a policy such as a Least Recently Used (LRU) strategy.

4. 发明授权

US09619514B2 Integration of optimization and execution of relational calculation models into SQL layer 有权
公开(公告)号：US09619514B2
公开(公告)日：2017-04-11
申请号：US14307092
申请日：2014-06-17
申请人： Tobias Mindnich , Jeong Ae Han , Johannes Merx , Christoph Weyerhaeuser , Yongsik Yoon , Sung Heun Wi
发明人： Tobias Mindnich , Jeong Ae Han , Johannes Merx , Christoph Weyerhaeuser , Yongsik Yoon , Sung Heun Wi
IPC分类号： G06F17/30
CPC分类号： G06F17/30442
摘要： A query is received by a database server from a remote application server. The query is associated with a calculation scenario that defines a data flow model that includes one or more nodes that each define one or more operations for execution by a calculation engine on the database server. Thereafter, the database server instantiates a runtime model of the calculation scenario based on the nodes of the instantiated calculation scenario. Subsequently, one or more of the nodes are identified as being convertible into a relational database format. These nodes are then used to form a container node. An execution plan of the runtime model of the calculation scenario including the container node is built that is executed by the database server to result in a data set which is provided by the database server to the application server.

5. 发明申请

US20150363463A1 Integration of Optimization and Execution of Relational Calculation Models into SQL Layer 有权
标题翻译：将关系计算模型的优化和执行集成到SQL层中
公开(公告)号：US20150363463A1
公开(公告)日：2015-12-17
申请号：US14307092
申请日：2014-06-17
申请人： Tobias Mindnich , Jeong Ae Han , Johannes Merx , Christoph Weyerhaeuser , Yongsik Yoon , Sung Heun Wi
发明人： Tobias Mindnich , Jeong Ae Han , Johannes Merx , Christoph Weyerhaeuser , Yongsik Yoon , Sung Heun Wi
IPC分类号： G06F17/30
CPC分类号： G06F17/30442
摘要： A query is received by a database server from a remote application server. The query is associated with a calculation scenario that defines a data flow model that includes one or more nodes that each define one or more operations for execution by a calculation engine on the database server. Thereafter, the database server instantiates a runtime model of the calculation scenario based on the nodes of the instantiated calculation scenario. Subsequently, one or more of the nodes are identified as being convertible into a relational database format. These nodes are then used to form a container node. An execution plan of the runtime model of the calculation scenario including the container node is built that is executed by the database server to result in a data set which is provided by the database server to the application server.
摘要翻译：数据库服务器从远程应用程序服务器接收到查询。该查询与定义包含一个或多个节点的数据流模型的计算方案相关联，每个节点定义一个或多个操作，以供数据库服务器上的计算引擎执行。此后，数据库服务器基于实例化计算方案的节点实例化计算方案的运行时模型。随后，一个或多个节点被识别为可转换为关系数据库格式。然后使用这些节点形成容器节点。构建包含容器节点的计算场景的运行时模型的执行计划，该运行时模型由数据库服务器执行以产生由数据库服务器向应用服务器提供的数据集。

6. 发明授权

US09846724B2 Integration of calculation models into SQL layer 有权
公开(公告)号：US09846724B2
公开(公告)日：2017-12-19
申请号：US14540792
申请日：2014-11-13
申请人： Christoph Weyerhaeuser , Tobias Mindnich , Johannes Merx , Yongsik Yoon , Sung Heun Wi , Jeong Ae Han
发明人： Christoph Weyerhaeuser , Tobias Mindnich , Johannes Merx , Yongsik Yoon , Sung Heun Wi , Jeong Ae Han
IPC分类号： G06F17/30
CPC分类号： G06F17/30463
摘要： According to an aspect, a database system for integrating calculation models into execution plans includes a first engine configured to parse a query to be applied on a database. The first engine is configured to invoke a second engine during query compilation. The second engine is configured to instantiate a calculation model based on the query, and the second engine is configured to derive a converted calculation model by converting the calculation model into a format compatible with the first engine. The first engine is configured to incorporate the converted calculation model into an execution plan during the query compilation and execute the query on the database according to execution plan.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式