会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 11. 发明申请
    • Cached Views
    • 缓存视图
    • US20150347410A1
    • 2015-12-03
    • US14294818
    • 2014-06-03
    • Ki Hong KimNorman MayAlexander BoehmSung Heun WiJeong Ae HanSang Il SongYongsik Yoon
    • Ki Hong KimNorman MayAlexander BoehmSung Heun WiJeong Ae HanSang Il SongYongsik Yoon
    • G06F17/30
    • G06F17/3048G06F17/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)策略的策略的实现,缓存实例可能被从存储器中移出。