-
公开(公告)号：US08732126B2
公开(公告)日：2014-05-20
申请号：US13207763
申请日：2011-08-11
CPC分类号： G06F17/30286
摘要： 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.
摘要翻译： 提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。 根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。 处理此捕获的工作负载。 测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。 因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。 如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。
-
公开(公告)号：US08612688B2
公开(公告)日：2013-12-17
申请号：US13227381
申请日：2011-09-07
申请人： Venkateshwaran Venkataramani , George Cabrera, III , Venkatasiva Prasad Chakkabala , Mark Marchukov
发明人： Venkateshwaran Venkataramani , George Cabrera, III , Venkatasiva Prasad Chakkabala , Mark Marchukov
IPC分类号： G06F12/00
CPC分类号： G06F17/3048 , G06F12/0844 , G06F17/30132 , G06F17/3033 , G06F17/30377 , G06F17/30424 , G06F17/30457 , G06F17/30554 , G06F17/30575 , G06F17/30595 , G06F17/30876 , G06F17/30902 , G06F17/30958 , G06F2212/463 , G06F2212/60 , H04L67/2842
摘要： A distributed caching system for storing and serving information modeled as a graph that includes nodes and edges that define associations or relationships between nodes that the edges connect in the graph.
-
公开(公告)号：US08438364B2
公开(公告)日：2013-05-07
申请号：US13227385
申请日：2011-09-07
IPC分类号： G06F12/00
CPC分类号： G06F17/3048 , G06F12/0844 , G06F17/30132 , G06F17/3033 , G06F17/30377 , G06F17/30424 , G06F17/30457 , G06F17/30554 , G06F17/30575 , G06F17/30595 , G06F17/30876 , G06F17/30902 , G06F17/30958 , G06F2212/463 , G06F2212/60 , H04L67/2842
摘要： A distributed caching system for storing and serving information modeled as a graph that includes nodes and edges that define associations or relationships between nodes that the edges connect in the graph.
摘要翻译： 一种分布式缓存系统，用于存储和提供建模为图形的信息，该图包含定义图中边缘连接的节点之间的关联或关系的节点和边。
-
公开(公告)号：US20120173541A1
公开(公告)日：2012-07-05
申请号：US13227393
申请日：2011-09-07
IPC分类号： G06F17/30
CPC分类号： G06F17/3048 , G06F12/0844 , G06F17/30132 , G06F17/3033 , G06F17/30377 , G06F17/30424 , G06F17/30457 , G06F17/30554 , G06F17/30575 , G06F17/30595 , G06F17/30876 , G06F17/30902 , G06F17/30958 , G06F2212/463 , G06F2212/60 , H04L67/2842
摘要： A distributed caching system for storing and serving information modeled as a graph that includes nodes and edges that define associations or relationships between nodes that the edges connect in the graph.
摘要翻译： 一种分布式缓存系统，用于存储和提供建模为图形的信息，该图包含定义图中边缘连接的节点之间的关联或关系的节点和边。
-
公开(公告)号：US07890457B2
公开(公告)日：2011-02-15
申请号：US11800238
申请日：2007-05-03
CPC分类号： G06F17/30377
摘要： 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.
摘要翻译： 提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。 根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。 处理此捕获的工作负载。 测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。 因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。 如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。
-
公开(公告)号：US07673291B2
公开(公告)日：2010-03-02
申请号：US10775531
申请日：2004-02-09
申请人： Karl Dias , Shivani Gupta , Mark Ramacher , Uri Shaft , Venkateshwaran Venkataramani , Graham S. Wood , Juan Loaiza
发明人： Karl Dias , Shivani Gupta , Mark Ramacher , Uri Shaft , Venkateshwaran Venkataramani , Graham S. Wood , Juan Loaiza
CPC分类号： G06F17/30306 , G06F17/30371
摘要： Techniques for self-diagnosing performance problems in a database are provided. The techniques include classifying one or more performance problems in a database system. One or more values for quantifying an impact of the one or more performance problems on the database system are then determined. The quantified values are determined based on the performance of operations in the database system. A performance problem based on the one or more quantified values is then determined. A solution for the performance problem is generated and may be outputted.
摘要翻译： 提供了数据库中自我诊断性能问题的技术。 这些技术包括对数据库系统中的一个或多个性能问题进行分类。 然后确定用于量化一个或多个性能问题对数据库系统的影响的一个或多个值。 量化值基于数据库系统中的操作性能来确定。 然后确定基于一个或多个量化值的性能问题。 产生性能问题的解决方案，并可以输出。
-
7.发明授权Capturing database workload while preserving original transactional and concurrency characteristics for replay 有权捕获数据库工作负载，同时保留用于重放的原始事务和并发特性公开(公告)号：US07890458B2
公开(公告)日：2011-02-15
申请号：US11800239
申请日：2007-05-03
CPC分类号： G06F11/3414 , G06F11/3419 , G06F11/3495 , G06F11/3688 , G06F2201/805 , G06F2201/87
摘要： 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.
摘要翻译： 提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。 根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。 处理此捕获的工作负载。 测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。 因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。 如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。
-
公开(公告)号：US20080097996A1
公开(公告)日：2008-04-24
申请号：US11800238
申请日：2007-05-03
IPC分类号： G06F17/30
CPC分类号： G06F17/30377
摘要： 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.
摘要翻译： 提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。 根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。 处理此捕获的工作负载。 测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。 因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。 如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。
-
公开(公告)号：US20080097960A1
公开(公告)日：2008-04-24
申请号：US11800224
申请日：2007-05-03
IPC分类号： G06F17/30
CPC分类号： G06F17/30286
摘要： 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.
摘要翻译： 提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。 根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。 处理此捕获的工作负载。 测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。 因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。 如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。
-
公开(公告)号：US20050086242A1
公开(公告)日：2005-04-21
申请号：US10934344
申请日：2004-09-03
申请人： Gary Ngai , Mark Ramacher , Graham Wood , Connie Green , Venkateshwaran Venkataramani , Karl Dias , Benoit Dageville , Michael Feng
发明人： Gary Ngai , Mark Ramacher , Graham Wood , Connie Green , Venkateshwaran Venkataramani , Karl Dias , Benoit Dageville , Michael Feng
CPC分类号： G06F17/30289 , Y10S707/99932 , Y10S707/99945
摘要： A self-managing workload repository infrastructure (or “AWR” for Automatic workload repository) which is useful for a database server to collect and manage useful system performance statistics. The AWR runs automatically to collect performance data about the operation of the database system, and stores the data that it captures into the database. The collection process is done inside the database, and the collection process is highly efficient as data is retrieved directly from the shared memory of the database kernel. The data captured allows both system level and user level analysis to be performed without unduly impacting system performance, e.g., by eliminating or reducing the requirement to repeat the workload in order to diagnose problems. The AWR is configured to automatically capture snapshots of statistics data on a periodic basis as well as purge stale data on a periodic basis. The captured performance data includes one or more of the top N (e.g., 20 or 30) statistics for activities involving a large set of objects, time-based statistics, cumulative statistics, sampled data and metrics and other data types.
摘要翻译： 自管理工作负载存储库基础架构（或自动工作负载存储库的“AWR”），可用于数据库服务器收集和管理有用的系统性能统计信息。 AWR自动运行以收集有关数据库系统操作的性能数据，并将其捕获的数据存储到数据库中。 收集过程在数据库内完成，并且收集过程非常有效，因为直接从数据库内核的共享内存中检索数据。 捕获的数据允许执行系统级别和用户级别分析，而不会不必要地影响系统性能，例如通过消除或减少重复工作负载以便诊断问题的要求。 AWR配置为定期自动捕获统计数据的快照，并定期清除过期数据。 捕获的性能数据包括涉及大量对象，基于时间的统计，累积统计，采样数据和度量以及其他数据类型的活动的前N（例如，20或30）统计信息中的一个或多个。
-
-
-
-
-
-
-
-
-
搜索结果
28 条记录 (耗时 0.077 秒)