会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 72. 发明授权
    • Treemap visualizations of database time
    • 数据库时间的Treemap可视化
    • US08095514B2
    • 2012-01-10
    • US12365827
    • 2009-02-04
    • John BeresniewiczJonathan HelfmanHsiao-Te SuNancy ChenKarl DiasGraham Wood
    • John BeresniewiczJonathan HelfmanHsiao-Te SuNancy ChenKarl DiasGraham Wood
    • G06F17/30
    • G06F17/30554G06F17/30592G06F17/30961Y10S707/99945
    • Particular embodiments generally relate to displaying database time using a treemap. A set of database time values is determined for a set of dimensions. The database time values measure performance of one or more databases by the time the database takes to respond to a request. The set of database time values is correlated to a set of cells in the treemap. A size of the cell is determined based on the database time value associated with it. For example, the database time value is correlated to an area of the cell. A layout of the set of cells is determined and the treemap is displayed using the layout. For example, the largest values of database time may be shown with the largest sized cells. This makes it easier for an administrator to review and analyze the database performance across multiple dimensions and determine problem areas affecting the performance of the one or more databases.
    • 具体实施方案一般涉及使用树形图显示数据库时间。 为一组维度确定一组数据库时间值。 数据库时间值衡量数据库响应请求时所需的一个或多个数据库的性能。 数据库时间值集合与树形图中的一组单元格相关联。 基于与其相关联的数据库时间值来确定单元的大小。 例如,数据库时间值与单元的区域相关。 确定一组单元格的布局,并使用布局显示树状图。 例如,数据库时间的最大值可以用最大尺寸的单元显示。 这使管理员更容易查看和分析多个维度的数据库性能,并确定影响一个或多个数据库性能的问题区域。
    • 73. 发明申请
    • Database workload replay remapping infrastructure
    • 数据库工作负载重播重新映射基础设施
    • US20080098003A1
    • 2008-04-24
    • US11800240
    • 2007-05-03
    • Karl DiasLeonidas GalanisJonathan KleinVenkateshwaran VenkataramaniYujun Wang
    • Karl DiasLeonidas GalanisJonathan KleinVenkateshwaran VenkataramaniYujun Wang
    • G06F17/30
    • G06F16/217
    • A method and apparatus for capturing database system workload and replaying that workload in a database system is provided. According to one aspect, in order to subject a test database system to the same workload to which the production database system actually would be subjected, a database server in the production system captures and records workload that the database server receives from external entities. This captured workload is processed. Processes external to a database server in the test database system send the processed workload to that database server. As a result, the test database system is subjected to the same workload to which the production database system originally was subjected. The foregoing technique permits a database administrator to determine how the production database system will fare if the difference that is present in the test database system is introduced into the production database system.
    • 提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。 根据一个方面,为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载,生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。 处理此捕获的工作负载。 测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。 因此,测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。 如果将测试数据库系统中存在的差异引入到生产数据库系统中,则上述技术允许数据库管理员确定生产数据库系统将如何展示。
    • 75. 发明授权
    • Incremental maintenance of materialized views containing one-to-one
lossless joins
    • 增量维护包含一对一无损连接的物化视图
    • US6134543A
    • 2000-10-17
    • US109782
    • 1998-07-02
    • Andrew WitkowskiKarl Dias
    • Andrew WitkowskiKarl Dias
    • G06F17/30
    • G06F17/30306G06F17/30483Y10S707/99932Y10S707/99934Y10S707/99936
    • A method and apparatus are provided for performing incremental refreshes to materialized views defined by one-to-one lossless joins. Each base table of the materialized view is selected to be processed as the current "selected table". During the processing, if the selected table is the right table of an outer join, then selected columns of rows of the materialized view are set to NULL based on rows of the selected table that have been updated or deleted in the selected table after a prior refresh operation. Then, NULL values in selected columns of the materialized view are updated to reflect new values caused by updates and inserts into the selected table that occurred after the prior refresh operation. If the selected table is not the right table of an outer join, then rows from the materialized view are deleted based on rows of the selected table that have been updated or deleted in the selected table after the prior refresh operation. Then, rows are inserted into the materialized view based on updates and inserts into the selected table that occurred after the prior refresh operation. The incremental refresh techniques are "memoryless" in that they do not require a record of the sequence of changes that were made subsequent to the prior refresh operation. Techniques are described for performing the incremental refresh steps through the use of database commands and queries.
    • 提供了一种方法和装置,用于对由一对一无损连接定义的物化视图执行增量刷新。 选择物化视图的每个基表作为当前的“选择的表”进行处理。 在处理期间,如果所选择的表是外连接的右表,则根据所选表格中所选择的表的行在所选表格中的行之后,将物化视图的所选行列设置为NULL 刷新操作。 然后,物化视图的选定列中的NULL值将被更新,以反映由更新引入的新值,并插入到先前刷新操作之后发生的所选表中。 如果所选表格不是外连接的右表,则根据在先前刷新操作之后的所选表格中已更新或删除的所选表格的行,将删除物化视图中的行。 然后,根据在先前刷新操作之后发生的所选表格中的更新和插入,将行插入物化视图。 增量刷新技术是“无记忆”,因为它们不需要在先前刷新操作之后进行的变化序列的记录。 描述了通过使用数据库命令和查询执行增量刷新步骤的技术。