Query routing of federated information systems for fast response time, load balance, availability, and reliability
    41.
    发明授权
    Query routing of federated information systems for fast response time, load balance, availability, and reliability 失效
    查询联合信息系统的路由,以实现快速响应时间,负载平衡,可用性和可靠性

    公开(公告)号:US07890496B2

    公开(公告)日:2011-02-15

    申请号:US12100651

    申请日:2008-04-10

    IPC分类号: G06F7/00

    摘要: Disclosed are embodiments of a system for optimizing query processing in a federated information system. The system may be used to identify alternative query plans in a simulated environment and to calculate cost estimates associated with the alternative query plans, based not only on database statistics and query statements, but also based on workload and processing latencies associated with specific data source and with the federated information system as a whole. In addition the calculated cost estimates may also factor in data source availability and reliability. The system may use the alternative query plans and the associated cost estimates to influence query processing in a federated information system by feeding to the federated information system query plans that allow for cost-efficient query plan-level load distribution, cost-efficient query fragment plan-level load distribution, and load distribution based upon quality of service cost constraints.

    摘要翻译: 公开了用于在联合信息系统中优化查询处理的系统的实施例。 该系统可以用于在模拟环境中识别替代查询计划,并且不仅基于数据库统计信息和查询语句,而且还基于与特定数据源相关联的工作负载和处理延迟来计算与替代查询计划相关联的成本估计,以及 联合信息系统作为一个整体。 此外,计算的成本估算也可能导致数据源的可用性和可靠性。 系统可以使用替代查询计划和相关联的成本估计来影响联合信息系统中的查询处理,通过馈送到联合信息系统查询计划,允许具有成本效益的查询计划级负载分布,成本效益的查询分段计划 - 基于服务质量成本限制的负载分布和负载分配。

    Autonomic recommendation and placement of materialized query tables for load distribution
    42.
    发明授权
    Autonomic recommendation and placement of materialized query tables for load distribution 有权
    自动推荐和放置用于负载分配的物化查询表

    公开(公告)号:US07689538B2

    公开(公告)日:2010-03-30

    申请号:US11340203

    申请日:2006-01-26

    IPC分类号: G06F7/00 G06F17/30

    摘要: A system and method of evaluating queries in distributed databases with MQTs comprises deriving MQTs; replicating the derived MQTs from a local server to at least one remote server; and distributing data and replicated derived MQTs to a plurality of other remote servers, wherein the distributing increases overall query execution efficiency. The databases may comprise heterogeneous databases. The query execution efficiency comprises observed response time at a frontend database and associated costs comprising computational central processing unit costs, input/output costs, and network communication costs. All of the associated costs comprise statistically estimated costs. The method further comprises running a MQT advisor at a frontend database, and considering the costs of at least one MQT placed at the frontend database. The method further comprises running a MQT advisor at a non-frontend database. Additionally, the increased overall query execution efficiency may consider all dependencies of all involved database instances and associated costs.

    摘要翻译: 使用MQT对分布式数据库中的查询进行评估的系统和方法包括导出MQT; 将派生的MQT从本地服务器复制到至少一个远程服务器; 以及将数据和复制的导出MQT分发到多个其他远程服务器,其中所述分发增加了整体查询执行效率。 数据库可以包括异构数据库。 查询执行效率包括在前端数据库处的观察到的响应时间和包括计算中央处理单元成本,输入/输出成本和网络通信成本的相关费用。 所有相关成本包括统计估计成本。 该方法还包括在前端数据库上运行MQT顾问,并考虑放置在前端数据库中的至少一个MQT的成本。 该方法还包括在非前端数据库上运行MQT顾问。 此外,增加的整体查询执行效率可以考虑所有相关数据库实例和相关成本的所有依赖关系。

    System and methods for invalidation to enable caching of dynamically generated content
    44.
    发明申请
    System and methods for invalidation to enable caching of dynamically generated content 有权
    无效的系统和方法,以实现动态生成内容的缓存

    公开(公告)号:US20050192995A1

    公开(公告)日:2005-09-01

    申请号:US11121825

    申请日:2005-05-04

    IPC分类号: G06F17/30 G06F17/00

    摘要: Various systems and methods are describe for determining dynamically generated content to be invalidated as a result of changes to underlying data. In one method, invalidation processing is performed using a delayed version of the database that reflects the state of the database at the beginning of a preceding processing cycle, and an update log that reflects all updates since the beginning of the preceding processing cycle. In another method, invalidation processing is performed by locking a database which is locked during processing so as to reflect the state of the database at the beginning of processing, and an update log that reflects all updates to the database since the beginning of the preceding processing cycle. In another method, invalidation processing uses the database while it is freely updated during said processing, and the update log of the database.

    摘要翻译: 描述了各种系统和方法,用于确定由于底层数据的更改导致的无效的动态生成内容。 在一种方法中,使用在前一处理周期开始时反映数据库的状态的数据库的延迟版本执行无效处理,以及从上一个处理周期开始以来反映所有更新的更新日志。 在另一种方法中,通过锁定在处理期间被锁定的数据库来执行无效处理,以便在处理开始时反映数据库的状态,以及从上一个处理开始以来反映到数据库的所有更新的更新日志 周期。 在另一种方法中,无效处理在所述处理期间自由更新数据库以及数据库的更新日志时使用该数据库。

    EVENT-TRIGGERED REASSIGNMENT OF TIME-LIMITED RESOURCES
    47.
    发明申请
    EVENT-TRIGGERED REASSIGNMENT OF TIME-LIMITED RESOURCES 审中-公开
    时间有限资源的事件触发重新配置

    公开(公告)号:US20160275425A1

    公开(公告)日:2016-09-22

    申请号:US14663697

    申请日:2015-03-20

    IPC分类号: G06Q10/06 G06Q10/08

    CPC分类号: G06Q10/06312 G06Q10/083

    摘要: Methods, systems, and computer-readable storage media for event-triggered reassignment of time-limited resources. Implementations include actions of receiving an event indicator, determining a particular demand and associated particular time-limited resources based on the event indicator, identifying, for the particular demand, one or more first candidate demands in an assignment plan, the assignment plan including a plurality of demands associated with a plurality of time-limited resources, each first candidate demand and associated time-limited resources satisfying one or more constraints defined by the particular demand and associated particular time-limited resources, determining whether at least one of the first candidate demands has not been processed, and performing an action based on a result of determining whether at least one of the first candidate demands has not been processed.

    摘要翻译: 方法,系统和计算机可读存储介质,用于事件触发的时间限制资源重新分配。 实现包括接收事件指示符的动作,基于事件指示器确定特定需求和相关联的特定时间限制资源,针对特定需求,为分配计划中的一个或多个第一候选请求识别,分配计划包括多个 与多个时间有限的资源相关联的需求,每个第一候选需求和相关联的时间有限的资源满足由特定需求和相关联的特定时间有限的资源所定义的一个或多个约束;确定第一候选需求中的至少一个 还没有被处理,并且基于确定是否还没有处理了第一候选请求中的至少一个的结果来执行动作。

    DEVICE LAYOUT OPTIMIZATION FOR SURVEILLANCE DEVICES
    48.
    发明申请
    DEVICE LAYOUT OPTIMIZATION FOR SURVEILLANCE DEVICES 有权
    监控设备的设备布局优化

    公开(公告)号:US20160240054A1

    公开(公告)日:2016-08-18

    申请号:US14624241

    申请日:2015-02-17

    IPC分类号: G08B13/196 H04N7/18

    摘要: A candidate position selector determines locations for M candidate positions along pathways within an area defining potential routes for moving objects within the area. A coverage rate calculator calculates a coverage rate for a device layout of N media capture devices among the M candidate positions, including calculating the coverage rate as a ratio of the moving objects captured by the N media capture devices in the device layout to a total number of the moving objects in the area within a defined period of time. A layout selector iteratively tests different device layouts of the N media capture devices among the M candidate positions, based on corresponding coverage rates calculated by the coverage rate calculator for each tested device layout, until a termination condition is reached and a final device layout of the tested device layouts is selected.

    摘要翻译: 候选位置选择器确定沿着定义用于在该区域内移动物体的潜在路线的区域内的路径的M个候选位置的位置。 覆盖率计算器计算M个候选位置中的N个媒体捕获设备的设备布局的覆盖率,包括计算覆盖率,作为由设备布局中的N个媒体捕获设备捕获的移动对象与总数之比 在一定时间内的区域内的移动物体。 布局选择器基于针对每个被测设备布局的覆盖率计算器计算的相应的覆盖率迭代测试N个媒体捕获设备在M个候选位置中的不同设备布局,直到达到终止条件,并且最终的设备布局 已选中测试的设备布局。

    Migration event scheduling management
    49.
    发明授权
    Migration event scheduling management 有权
    迁移事件调度管理

    公开(公告)号:US09380107B2

    公开(公告)日:2016-06-28

    申请号:US14046470

    申请日:2013-10-04

    摘要: In accordance with aspects of the disclosure, systems and methods are provided for scheduling migration events for server resources in a server cluster relative to a time interval while considering load balance constraints and data transfer constraints of the server cluster. The systems and methods may include generating one or more potential migration scheduling schemes for migration of each server resource to at least one other server resource in the server cluster within the time interval while considering the load balance constraints and the data transfer constraints of the server cluster, and generating a migration event schedule for each migration event within the time interval based on the one or more potential migration scheduling schemes generated for migration of each server resource to at least one other server resource in the server cluster.

    摘要翻译: 根据本公开的方面,提供了系统和方法,用于在考虑服务器集群的负载平衡约束和数据传输约束的同时针对时间间隔调度服务器集群中服务器资源的迁移事件。 系统和方法可以包括在考虑负载平衡约束和服务器集群的数据传输约束的情况下,在时间间隔内生成用于将服务器资源迁移到服务器集群中的至少一个其他服务器资源的一个或多个潜在的迁移调度方案 以及基于为每个服务器资源的迁移生成的一个或多个潜在的迁移调度方案在所述时间间隔内为所述服务器集群中的至少一个其他服务器资源生成用于每个迁移事件的迁移事件调度。

    Recommending content in a client-server environment
    50.
    发明授权
    Recommending content in a client-server environment 有权
    在客户端 - 服务器环境中推荐内容

    公开(公告)号:US09288285B2

    公开(公告)日:2016-03-15

    申请号:US14055565

    申请日:2013-10-16

    摘要: Techniques for recommending content to a user include identifying classified public content stored on a server appliance or a repository; identifying private content of a user stored on a client appliance or a repository, the client appliance communicably coupled to the server appliance through a network; receiving, from the user, a request for a recommendation of content; generating a representative query based on the request for the recommendation of content; determining, based on the representative query, a portion of the classified public content stored on a server appliance or the repository; determining, based on the request, a portion of the private content stored on the client appliance or the repository; and preparing, for presentation to the user, the portion of the classified public content based on the representative query and the portion of the private content based on the request for the recommendation of content.

    摘要翻译: 用于向用户推荐内容的技术包括识别存储在服务器设备或存储库上的分类的公共内容; 识别存储在客户端设备或存储库上的用户的私人内容,所述客户端设备通过网络可通信地耦合到所述服务器设备; 从用户接收对内容推荐的请求; 根据对内容推荐的请求生成代表性查询; 基于代表性查询确定存储在服务器设备或存储库上的分类的公共内容的一部分; 基于所述请求确定存储在所述客户端设备或所述存储库上的所述私人内容的一部分; 以及基于所述内容的推荐请求,基于所述代表性查询和所述私人内容的所述部分来准备所述分类的公共内容的一部分。