专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US06745344B1 Debug and data collection mechanism utilizing a difference in database state by using consecutive snapshots of the database state 有权
标题翻译：通过使用数据库状态的连续快照，利用数据库状态差异的调试和数据收集机制
公开(公告)号：US06745344B1
公开(公告)日：2004-06-01
申请号：US09717161
申请日：2000-11-20
申请人： Vikram Joshi , Alex Tsukerman , Shari Yamaguchi
发明人： Vikram Joshi , Alex Tsukerman , Shari Yamaguchi
IPC分类号： G06F1100
CPC分类号： G06F11/3636 , G06F2201/80 , G06F2201/84 , Y10S707/99953 , Y10S707/99954
摘要： A method and apparatus for debugging a software program is provided. In one example, a method includes preserving consecutive snapshots of a group of shared memory structures that contain data and control information of the software, such as a database system. A first snapshot may be taken immediately prior to the occurrence of an error, and a second snapshot taken after the occurrence of the error. The consecutive snapshots are compared to each other to determine what memory structures and data are affected by the error.
摘要翻译：提供了一种用于调试软件程序的方法和装置。在一个示例中，一种方法包括保存包含诸如数据库系统的软件的数据和控制信息的一组共享存储器结构的连续快照。在发生错误之前可以立即采取第一个快照，并且在发生错误之后拍摄第二个快照。将连续的快照相互比较，以确定哪些内存结构和数据受到错误的影响。

2. 发明授权

US06671826B1 Fast database state dumps to file for deferred analysis of a database 有权
标题翻译：快速数据库状态转储到文件以进行数据库的延迟分析
公开(公告)号：US06671826B1
公开(公告)日：2003-12-30
申请号：US09717162
申请日：2000-11-20
申请人： Vikram Joshi , Alex Tsukerman , Shari Yamaguchi
发明人： Vikram Joshi , Alex Tsukerman , Shari Yamaguchi
IPC分类号： G06F1100
CPC分类号： G06F11/3636 , G06F11/1438 , Y10S707/99942
摘要： In one embodiment, the method of debugging a software program comprises preserving a memory state of a portion of the software program, such as a database system. The memory state is preserved when a failure event is detected in the software program. The preserved memory state portion of the software program is extracted and stored in a storage medium for deferred analysis. Normal database operations are resumed as soon as the memory state is preserved. The deferred analysis is performed by starting a new database instance corresponding to the preserved memory state portion and using the new database instance to extract information for high-level debugging of the software program. Thus, where downtime of a software program must be kept to a minimum, the present invention provides techniques for performing quick diagnostics of the software program.
摘要翻译：在一个实施例中，调试软件程序的方法包括保存诸如数据库系统的软件程序的一部分的存储器状态。当在软件程序中检测到故障事件时，存储器状态被保留。提取软件程序的保存的存储器状态部分并将其存储在用于延迟分析的存储介质中。一旦保存了内存状态，恢复正常的数据库操作。通过启动对应于保留的存储器状态部分的新数据库实例并使用新的数据库实例来提取用于软件程序的高级调试的信息来执行延迟分析。因此，在软件程序的停机时间必须最小化的情况下，本发明提供了用于执行软件程序的快速诊断的技术。

3. 发明授权

US06839894B1 Method and apparatus for debugging a software program using dynamic debug patches and copy on write views 有权
标题翻译：用于使用动态调试补丁调试软件程序并在写入视图上复制的方法和装置
公开(公告)号：US06839894B1
公开(公告)日：2005-01-04
申请号：US09717187
申请日：2000-11-20
申请人： Vikram Joshi , Alex Tsukerman , Shari Yamaguchi
发明人： Vikram Joshi , Alex Tsukerman , Shari Yamaguchi
IPC分类号： G06F9/44 , G06F11/36
CPC分类号： G06F11/3644
摘要： A method and apparatus for debugging a software program is provided that is non-intrusive and allows multiple persons to debug concurrently in view private sessions. In one example, a method includes preserving a memory state of a portion of a software program, such as a database system. A second software program is compiled and dynamically linked, and which when executed, would normally cause modification to targeted data in the preserved portion of the software program. The second software program is executed by making a copy of the targeted data in the preserved portion of the software program. The copy is modified to generate a modified copy of the targeted data without modifying the data that is in the preserved portion of the software program. In subsequent accesses, the user that issued that executed the second software program accesses the modified copy whenever the user would have otherwise accessed the corresponding preserved portion. The second software program is made accessible to other users of the database system by publishing in the preserved portion a corresponding symbolic name associated with the second software program. If another user accesses the second software program and executes it, then another copy of the targeted data is made for that user. As before the copy is modified to generate a modified copy of the targeted data without modifying the data that is in the preserved portion of the software program.
摘要翻译：提供了一种用于调试软件程序的方法和装置，其是非侵入式的，并且允许多个人在查看私人会话期间同时调试。在一个示例中，一种方法包括保存诸如数据库系统的软件程序的一部分的存储器状态。第二个软件程序被编译和动态链接，并且在执行时通常会对软件程序的保留部分中的目标数据进行修改。通过在软件程序的保留部分中制作目标数据的副本来执行第二软件程序。修改该副本以生成目标数据的修改副本，而不修改软件程序的保留部分中的数据。在随后的访问中，执行第二软件程序的发出的用户每当用户将以其他方式访问相应的保留部分时访问修改的副本。通过在保留部分中发布与第二软件程序相关联的相应符号名称，可以使数据库系统的其他用户访问第二软件程序。如果另一个用户访问第二个软件程序并执行它，则为该用户创建目标数据的另一个副本。如前所述，修改副本以生成目标数据的修改副本，而不修改软件程序的保留部分中的数据。

4. 发明授权

US06671825B1 Method and apparatus for debugging a software program 有权
标题翻译：用于调试软件程序的方法和装置
公开(公告)号：US06671825B1
公开(公告)日：2003-12-30
申请号：US09649310
申请日：2000-08-28
申请人： Vikram Joshi , Alex Tsukerman , Shari Yamaguchi
发明人： Vikram Joshi , Alex Tsukerman , Shari Yamaguchi
IPC分类号： G06F1100
CPC分类号： G06F11/3644
摘要： A method and apparatus for debugging a software program is provided that is non-intrusive and allows multiple persons to debug concurrently in view private sessions. In one example, a method includes preserving a memory state of a portion of a software program, such as a database system. A debug command is received that, when executed, would normally cause modification to targeted data in the preserved portion of the software program. The command is executed by making a copy of the targeted data in the preserved portion of the software program. The copy is modified to generate a modified copy of the targeted data without modifying the data that is in the preserved portion of the software program. In subsequent accesses, the user that issued the debug command accesses the modified copy whenever the user would have otherwise accessed the corresponding preserved portion.
摘要翻译：提供了一种用于调试软件程序的方法和装置，其是非侵入式的，并且允许多个人在查看私人会话期间同时调试。在一个示例中，一种方法包括保存诸如数据库系统的软件程序的一部分的存储器状态。接收到一个调试命令，当被执行时，通常会对软件程序的保留部分中的目标数据进行修改。通过在软件程序的保留部分中制作目标数据的副本来执行命令。修改该副本以生成目标数据的修改副本，而不修改软件程序的保留部分中的数据。在随后的访问中，发出调试命令的用户每当用户将以其他方式访问相应的保留部分时访问修改的副本。

5. 发明授权

US09063908B2 Rapid recovery from loss of storage device cache 有权
标题翻译：从存储设备缓存丢失中快速恢复
公开(公告)号：US09063908B2
公开(公告)日：2015-06-23
申请号：US13485557
申请日：2012-05-31
申请人： Juan R. Loaiza , Kothanda Umamageswaran , Boris Erlikhman , David Friedman , Jia Shi , Zuoyu Tao , Alex Tsukerman
发明人： Juan R. Loaiza , Kothanda Umamageswaran , Boris Erlikhman , David Friedman , Jia Shi , Zuoyu Tao , Alex Tsukerman
IPC分类号： G06F12/00 , G06F11/20 , G06F3/06 , G06F12/08
CPC分类号： G06F11/2082 , G06F3/0629 , G06F12/00 , G06F12/08 , G06F12/0802
摘要： Dirty data in a storage device is made current through rapid re-silvering, which uses a mirrored and up-to-date version of the dirty data from another storage device to recover the data. Because under rapid re-silvering cache metadata in volatile memory survives the failure of the cache, the cache metadata is used to determine which subset of data from the other storage device needs to be copied to the storage device being re-silvered. During re-silvering, cache metadata is used to determine which I/O requests from clients are requests for data that is not stale.
摘要翻译：存储设备中的脏数据通过快速重新刷新而成为最新版本，其使用来自另一存储设备的镜像和最新版本的脏数据来恢复数据。因为在快速重新刷新缓存中，缓存中的元数据可以在高速缓存的故障中幸存下来，所以使用高速缓存元数据来确定来自其他存储设备的哪个数据子集需要被复制到被重新映射的存储设备。在重新镀银期间，使用缓存元数据来确定来自客户端的哪些I / O请求是不过时的数据请求。

6. 发明授权

US08458511B2 Fault isolation using code paths 有权
标题翻译：使用代码路径进行故障隔离
公开(公告)号：US08458511B2
公开(公告)日：2013-06-04
申请号：US12885323
申请日：2010-09-17
申请人： Tsz Him (Adrian) Ng , Alex Tsukerman , Kothanda Umamageswaran , Roger Hansen , Umesh Panchaksharaiah
发明人： Tsz Him (Adrian) Ng , Alex Tsukerman , Kothanda Umamageswaran , Roger Hansen , Umesh Panchaksharaiah
IPC分类号： G06F11/00
CPC分类号： G06F11/3688
摘要： Techniques are provided for isolating faults in a software program by providing at least two code paths that are capable of performing the same operation. When a fault occurs while the one of the code paths is being used to perform an operation, data that indicates the circumstances under which the fault occurred is stored. For example, a fault-recording mechanism may store data that indicates the entities that were involved in the failed operation. Because they were involved in an operation that experienced a fault, one or more of those entities may be “quarantined”. When subsequent requests arrive to perform the operation, a check may be performed to determine whether the requested operation involves any of the quarantined entities. If the requested operation involves a quarantined entity, a different code path is used to perform the operation, rather than the code path from which the entity is quarantined.
摘要翻译：提供了通过提供能够执行相同操作的至少两个代码路径来分离软件程序中的故障的技术。当代码路径中的一个正在用于执行操作时发生故障时，存储指示发生故障的情况的数据。例如，故障记录机制可以存储指示涉及故障操作的实体的数据。因为他们参与了一个经历过错的行动，所以这些实体中的一个或多个可能被“隔离”。当后续请求到达以执行操作时，可以执行检查以确定所请求的操作是否涉及任何被隔离的实体。如果请求的操作涉及隔离实体，则使用不同的代码路径来执行操作，而不是实体被隔离的代码路径。

7. 发明授权

US07873606B2 Advisor framework, systems, methods and software for implementing the same 有权
标题翻译：顾问框架，系统，方法和软件实现相同
公开(公告)号：US07873606B2
公开(公告)日：2011-01-18
申请号：US10925831
申请日：2004-08-24
申请人： Karl Dias , Alex Tsukerman , Gregory S. Smith , Leng Tan
发明人： Karl Dias , Alex Tsukerman , Gregory S. Smith , Leng Tan
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30306 , G06F17/3056
摘要： Various embodiments of the invention provide solutions that can offer a consistent framework for tools that assist in the configuration, tuning, and/or troubleshooting of a database and/or an RDBMS. Merely by way of example, one set of embodiments provides a software framework for an advisor component of a database and/or RDBMS. In accordance with some embodiments, the framework might specify a common data model for such advisor components. The data model can include, merely by way of example, a set of one or more findings (which might, in some cases, describe the result of an analysis of a circumstance in the database, RDBMS, and/or a mid-tier application used with the database) and/or a set of one or more recommendations (which might provide suggestions for addressing the circumstance). In particular embodiments. In particular embodiments, the data model might include a set of on or more rationales, which can explain the recommendations. In some cases, the software framework might include a task associated with the advisor component and/or one or more interfaces, which can include, inter alia, user interfaces and/or APIs. Other sets of embodiments can provide methods, systems and/or software programs for implementing an advisor framework.
摘要翻译：本发明的各种实施例提供可以为协助数据库和/或RDBMS的配置，调整和/或故障排除的工具提供一致的框架的解决方案。仅仅作为示例，一组实施例为数据库和/或RDBMS的顾问组件提供了软件框架。根据一些实施例，框架可以为这种顾问组件指定公共数据模型。数据模型可以仅包括一个或多个发现（在某些情况下可能描述数据库中的情境分析的结果，RDBMS和/或中间层应用程序）与数据库一起使用）和/或一组一个或多个建议（可能提供解决情况的建议）。在特定实施例中，数据模型可以包括一组或多个理由，其可以解释建议。在一些情况下，软件框架可以包括与顾问组件和/或一个或多个接口相关联的任务，其特别可以包括用户界面和/或API。其他实施例集合可以提供用于实现顾问框架的方法，系统和/或软件程序。

8. 发明申请

US20050097091A1 SQL tuning base 有权
标题翻译： SQL调优基础
公开(公告)号：US20050097091A1
公开(公告)日：2005-05-05
申请号：US10936468
申请日：2004-09-07
申请人： Mark Ramacher , Sreenath Bodagala , Benoit Dageville , Alex Tsukerman , Stephen Vivian , Mohamed Ziauddin
发明人： Mark Ramacher , Sreenath Bodagala , Benoit Dageville , Alex Tsukerman , Stephen Vivian , Mohamed Ziauddin
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30474 , G06F17/30306 , Y10S707/99932 , Y10S707/99934 , Y10S707/99944
摘要： A computer readable medium storing a database query language statement tuning base in a tuning base memory location is disclosed. The tuning base includes tuning information for one or more query language statements. The tuning information for each statement includes one or more tuning actions for the statement, and a signature to allow an optimizer to identify the one or more tuning actions for the statement.
摘要翻译：公开了一种在调谐基础存储器位置中存储数据库查询语言调整基座的计算机可读介质。调优基础包括一个或多个查询语言语句的调整信息。每个语句的调整信息包括语句的一个或多个调整操作，以及允许优化器识别语句的一个或多个调优操作的签名。

9. 发明申请

US20050086246A1 Database performance baselines 有权
标题翻译：数据库性能基准
公开(公告)号：US20050086246A1
公开(公告)日：2005-04-21
申请号：US10934345
申请日：2004-09-03
申请人： Graham Wood , Alex Tsukerman , Richard Sarwal , Gary Ngai , Mark Ramacher , Leng Leng Tan
发明人： Graham Wood , Alex Tsukerman , Richard Sarwal , Gary Ngai , Mark Ramacher , Leng Leng Tan
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30289 , Y10S707/99932 , Y10S707/99945
摘要： Systems and methods to define and store performance baselines. A baseline may be defined as a pair of snapshots, each snapshot containing the same set of statistics and having a timestamp value associated therewith. The present invention allows for the designation, automatically or manually, of statistics collected over a certain period of time to be stored and used for comparison. Baselines may be used, for example, to manually or automatically compare with current system performance, compare difference-difference values and set thresholds to monitor current system performance.
摘要翻译：定义和存储性能基线的系统和方法。基线可以被定义为一对快照，每个快照包含相同的一组统计信息并具有与之相关联的时间戳值。本发明允许自动或手动地指定在一段时间内收集的统计数据，并将其用于比较。可以使用基线来手动或自动与当前系统性能进行比较，比较差异差值和设置阈值以监视当前系统性能。

10. 发明授权

US06804671B1 Pluggable tablespaces for database systems 有权
标题翻译：数据库系统的可插拔表空间
公开(公告)号：US06804671B1
公开(公告)日：2004-10-12
申请号：US10353381
申请日：2003-01-28
申请人： Juan R. Loaiza , Hasan Rizvi , J. William Lee , William H. Bridge, Jr. , Jonathan D. Klein , Alex Tsukerman , Gianfranco Putzolu
发明人： Juan R. Loaiza , Hasan Rizvi , J. William Lee , William H. Bridge, Jr. , Jonathan D. Klein , Alex Tsukerman , Gianfranco Putzolu
IPC分类号： G06F1730
CPC分类号： G06F17/30952 , Y10S707/959 , Y10S707/99937 , Y10S707/99942 , Y10S707/99955
摘要： A pluggable tablespace is enabled by logically partitioning a database into a set of tablespaces and storing all of the tablespaces disk pointers in tablespace-relative format. A pluggable set of tablespaces is unplugged by generating the associated metadata, and making a binary copy of the tablespaces. The pluggable set of tablespaces is plugged into a target database by making the pluggable set accessible to the target database and incorporating the associated metadata, without patching any of the disk pointers.
摘要翻译：通过将数据库逻辑分区为一组表空间并以表空间相对格式存储所有表空间磁盘指针来启用可插入表空间。通过生成相关联的元数据并创建表空间的二进制副本，可以拔掉一组可插拔的表空间。可插入的表空间集合通过使可插入集合可访问目标数据库并结合相关联的元数据而插入到目标数据库中，而无需修补任何磁盘指针。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式