Generating and displaying active reports

    公开(公告)号:US10482161B2

    公开(公告)日:2019-11-19

    申请号:US14924429

    申请日:2015-10-27

    Abstract: Embodiments of the present invention enable the generation and display of active reports. Applications of the present invention include its use in embodiments of a web-based product for managing an Information Technology (IT) infrastructure although the present invention is not limited to such applications. In embodiments, an active report is an active report file comprising report data and a user interface (UI) reference to a network location of code that defines an interactive UI comprising graphical user interface (GUI) components to be rendered when displaying the report data. In embodiments, the interactive UI is defined by UI code (such as an Adobe Flash Small Web Format (SWF) file) that also defines the UI of a rich internet application (RIA). In embodiments, the UI reference may be a link designating a location to the location of the UI code on a network, such as the Internet.

    SQL execution plan verification
    2.
    发明授权

    公开(公告)号:US10229158B2

    公开(公告)日:2019-03-12

    申请号:US14251521

    申请日:2014-04-11

    Abstract: Approaches, techniques, and mechanisms are disclosed for ensuring that a database command is executed according to a query plan that has been verified to be actually optimal. Except in rare circumstances, a database server does not execute a query plan unless it is first verified by the database server. The database server receives a request to execute a database command. The database server determines an unverified plan is the best plan for satisfying the request. Rather than risk the unknown behavior of an unverified plan, the database server instead satisfies the request according to a verified plan. Subsequently—for example as part of a scheduled job—the database server executes the unverified plan to determine performance statistics. Based at least on the performance statistics, the database server determines whether or not to verify the unverified plan. Techniques for concurrent and optimistic verifications are also disclosed.

    REAL-TIME AUTOMATIC DATABASE DIAGNOSTIC MONITOR
    3.
    发明申请
    REAL-TIME AUTOMATIC DATABASE DIAGNOSTIC MONITOR 有权
    实时自动数据库诊断监控

    公开(公告)号:US20140095453A1

    公开(公告)日:2014-04-03

    申请号:US13721895

    申请日:2012-12-20

    CPC classification number: G06F11/1435 G06F11/321 G06F11/323 G06F17/30424

    Abstract: A method for obtaining data items from an unresponsive database host. The method includes receiving an indication that the database host is unresponsive, receiving, from a management server via a diagnostic connection, a first request for a first organized data item, and sending a first query, using a first interface, to a memory for the first organized data item. The method further includes receiving, from the management server via a normal connection, a second request for a second organized data item, retrieving, from memory on the database host, a first data item in response to the first query, converting the first data item into the first organized data item, and sending the first organized data item to the management server, wherein the first organized data item is analyzed to determine a source causing the database host to be unresponsive.

    Abstract translation: 一种从无响应数据库主机获取数据项的方法。 该方法包括接收数据库主机不响应的指示,从管理服务器经由诊断连接接收对第一组织数据项的第一请求,以及使用第一接口向存储器发送第一查询 首先组织的数据项。 该方法还包括从管理服务器经由正常连接接收对第二组织数据项的第二请求,从数据库主机上的存储器检索响应于第一查询的第一数据项,转换第一数据项 进入第一组织数据项,并将第一组织数据项发送到管理服务器,其中分析第一组织数据项以确定导致数据库主机无响应的源。

    Real-time automatic database diagnostic monitor
    4.
    发明授权
    Real-time automatic database diagnostic monitor 有权
    实时自动数据库诊断监视器

    公开(公告)号:US09582367B2

    公开(公告)日:2017-02-28

    申请号:US13721895

    申请日:2012-12-20

    CPC classification number: G06F11/1435 G06F11/321 G06F11/323 G06F17/30424

    Abstract: A method for obtaining data items from an unresponsive database host. The method includes receiving an indication that the database host is unresponsive, receiving, from a management server via a diagnostic connection, a first request for a first organized data item, and sending a first query, using a first interface, to a memory for the first organized data item. The method further includes receiving, from the management server via a normal connection, a second request for a second organized data item, retrieving, from memory on the database host, a first data item in response to the first query, converting the first data item into the first organized data item, and sending the first organized data item to the management server, wherein the first organized data item is analyzed to determine a source causing the database host to be unresponsive.

    Abstract translation: 一种从无响应数据库主机获取数据项的方法。 该方法包括接收数据库主机不响应的指示,从管理服务器经由诊断连接接收对第一组织数据项的第一请求,以及使用第一接口向存储器发送第一查询 首先组织的数据项。 该方法还包括从管理服务器经由正常连接接收对第二组织数据项的第二请求,从数据库主机上的存储器检索响应于第一查询的第一数据项,转换第一数据项 进入第一组织数据项,并将第一组织数据项发送到管理服务器,其中分析第一组织数据项以确定导致数据库主机无响应的源。

    COMPOSITE ACTIVE REPORTS
    5.
    发明申请
    COMPOSITE ACTIVE REPORTS 有权
    复合活动报告

    公开(公告)号:US20150006511A1

    公开(公告)日:2015-01-01

    申请号:US14040354

    申请日:2013-09-27

    CPC classification number: G06F17/30554

    Abstract: Techniques for generating and processing composite active reports are provided. An active report is a report that can be displayed and interacted with at a client device even though the client device is not connected to a database from which data for the report originates. A composite active report is an active report that includes multiple reports embedded in the same file. Each report in a composite active report may be separately compressed to allow a client device to decompress a report on demand. A composite active report may include, for each report indicated in the composite active report, executable identification data that is used to retrieve, from a remote source, an executable that is used to generate, based on report data of the report, display data, which is displayed on a computer display of a client device.

    Abstract translation: 提供了生成和处理复合主动报告的技术。 活动报告是可以在客户端设备上显示和交互的报告,即使客户端设备未连接到数据库,报表来自哪个数据。 复合主动报告是一个主动报告,其中包含嵌入在同一文件中的多个报告。 复合活动报告中的每个报告可以单独压缩,以允许客户端设备按需解压缩报告。 复合活动报告可以包括对于复合活动报告中指示的每个报告,可执行标识数据用于从远程源检索用于基于报告的报告数据生成显示数据的可执行文件, 其显示在客户端设备的计算机显示器上。

    Embedded Performance Monitoring of a DBMS
    6.
    发明申请
    Embedded Performance Monitoring of a DBMS 审中-公开
    DBMS的嵌入式性能监控

    公开(公告)号:US20150372892A1

    公开(公告)日:2015-12-24

    申请号:US14312582

    申请日:2014-06-23

    Abstract: Embedded Performance Monitoring is an “out-of-box” approach for performance monitoring of a DBMS. Performance monitoring of a DBMS is achieved through use of a browser to access the DBMS once a DBMS is installed and configured. The approach exploits a DBMS configured with the native capability to provide performance monitoring data and software via a browser. To retrieve and use the performance monitoring data from the DBMS, a browser executes software downloaded to the browser from the DBMS using web-based technologies.

    Abstract translation: 嵌入式性能监控是一种用于DBMS性能监控的“开箱即用”方法。 一旦安装和配置了DBMS,就可以通过使用浏览器访问DBMS来实现DBMS的性能监控。 该方法利用配置有本地功能的DBMS,通过浏览器提供性能监控数据和软件。 要从DBMS检索和使用性能监视数据,浏览器会使用基于Web的技术从DBMS执行从浏览器下载的软件。

    SQL EXECUTION PLAN VERIFICATION
    7.
    发明申请
    SQL EXECUTION PLAN VERIFICATION 审中-公开
    SQL执行计划验证

    公开(公告)号:US20140236921A1

    公开(公告)日:2014-08-21

    申请号:US14251521

    申请日:2014-04-11

    CPC classification number: G06F17/30469 G06F17/30463

    Abstract: Approaches, techniques, and mechanisms are disclosed for ensuring that a database command is executed according to a query plan that has been verified to be actually optimal. Except in rare circumstances, a database server does not execute a query plan unless it is first verified by the database server. The database server receives a request to execute a database command. The database server determines an unverified plan is the best plan for satisfying the request. Rather than risk the unknown behavior of an unverified plan, the database server instead satisfies the request according to a verified plan. Subsequently—for example as part of a scheduled job—the database server executes the unverified plan to determine performance statistics. Based at least on the performance statistics, the database server determines whether or not to verify the unverified plan. Techniques for concurrent and optimistic verifications are also disclosed.

    Abstract translation: 公开了方法,技术和机制,以确保根据已被验证为实际最佳的查询计划来执行数据库命令。 除非在极少数情况下,数据库服务器不执行查询计划,除非数据库服务器首先进行了验证。 数据库服务器接收执行数据库命令的请求。 数据库服务器确定未验证的计划是满足请求的最佳方案。 而不是冒险未验证的计划的未知行为,数据库服务器而是根据验证的计划满足请求。 随后 - 例如作为计划作业的一部分 - 数据库服务器执行未验证的计划以确定性能统计信息。 至少基于性能统计,数据库服务器确定是否验证未验证的计划。 还公开了并发和乐观验证的技术。

    Composite active reports
    10.
    发明授权
    Composite active reports 有权
    复合活动报告

    公开(公告)号:US09524322B2

    公开(公告)日:2016-12-20

    申请号:US14040354

    申请日:2013-09-27

    CPC classification number: G06F17/30554

    Abstract: Techniques for generating and processing composite active reports are provided. An active report is a report that can be displayed and interacted with at a client device even though the client device is not connected to a database from which data for the report originates. A composite active report is an active report that includes multiple reports embedded in the same file. Each report in a composite active report may be separately compressed to allow a client device to decompress a report on demand. A composite active report may include, for each report indicated in the composite active report, executable identification data that is used to retrieve, from a remote source, an executable that is used to generate, based on report data of the report, display data, which is displayed on a computer display of a client device.

    Abstract translation: 提供了生成和处理复合主动报告的技术。 活动报告是可以在客户端设备上显示和交互的报告,即使客户端设备未连接到数据库,报表来自哪个数据。 复合主动报告是一个主动报告,其中包含嵌入在同一文件中的多个报告。 复合活动报告中的每个报告可以单独压缩,以允许客户端设备按需解压缩报告。 复合活动报告可以包括对于复合主动报告中指示的每个报告,可执行标识数据用于从远程源检索用于基于报告的报告数据生成显示数据的可执行文件, 其显示在客户端设备的计算机显示器上。

Patent Agency Ranking